@{

Page.Title = "Add a Scripture";

Layout = "~/_Layout.cshtml";

Validation.RequireField("book", "You must enter a book");

Validation.RequireField("chapter", "chapter is required");

Validation.RequireField("verse", "You haven't entered a verse");

var book = "";

var chapter = "";

var verse = "";

var note = "";

DateTime thisDay = DateTime.Today;

if (IsPost && Validation.IsValid())

{

book = Request.Form["book"];

chapter = Request.Form["chapter"];

verse = Request.Form["verse"];

note = Request.Form["note"];

var db = Database.Open("ScriptureData");

var insertCommand = "INSERT INTO ScriptureTable (book, chapter, verse, note, date) VALUES(@0, @1, @2, @3, @4)";

db.Execute(insertCommand, book, chapter, verse, note, thisDay);

Response.Redirect("~/MainScripture");

}

<h2>Add a Scripture</h2>

<form method="post">

<fieldset>

<legend>Scripture Information</legend>

<p>

<label for="book">book:</label>

<input type="text" name="book" value="@Request.Form["book"]" />

@Html.ValidationMessage("book")

</p>

<p>

<label for="chapter">chapter:</label>

<input type="text" name="chapter" value="@Request.Form["chapter"]" />

@Html.ValidationMessage("chapter")

</p>

<p>

<label for="verse">verse:</label>

<input type="text" name="verse" value="@Request.Form["verse"]" />

@Html.ValidationMessage("verse")

</p>

<p>

<label for="note">note:</label>

<input type="text" name="note" value="@Request.Form["note"]" />

</p>

<p><input type="submit" name="buttonSubmit" value="Add Scripture" /></p>

<p><a href="~/MainScripture">Return to scripture listing</a></p>

</fieldset>

</form>