New.cshtml

@section Scripts {
    <script src="~/Scripts/jquery.validate.min.js"></script>
    <script src="~/Scripts/jquery.validate.unobtrusive.min.js"></script>
}

@{
    WebSecurity.RequireAuthenticatedUser();

    Page.Title = "New Gallery";

    Validation.RequireField("name", "You must specify a gallery name.");
    
    if (IsPost && Validation.IsValid()) 
    {
        var galleryName = Request["Name"];
        
        var db = Database.Open("PhotoGallery");
        var nameExists = db.QueryValue("SELECT COUNT(*) FROM Galleries WHERE LOWER(Name) = LOWER(@0)", galleryName) > 0;
        if (nameExists) 
        {
            ModelState.AddError("Name", "A gallery with the supplied name already exists.");
        } 
        else
        {
            //Create Gallery
            db.Execute("INSERT INTO Galleries (Name) VALUES (@0)", galleryName);
            // And redirect
            Response.Redirect(Href("View", db.GetLastInsertId()));
        }
    }
}

<h1>New Gallery</h1>
<form method="post" action="">
    <fieldset>
        <legend>New Gallery</legend>
        <ol>
            <li>
                <label for="name">Name</label>
                <input type="text" id="name" name="name" title="Gallery name" placeholder="Gallery name" @Validation.For("name")/>
                @Html.ValidationMessage("Name")
            </li>
        </ol>
        <p class="form-actions" data-role="controlgroup" data-type="horizontal">
            <input type="submit" data-role="button" value="Create" title="Create gallery" />
            <a data-role="button" href="~/" title="Return to galleries">Cancel</a>
        </p>
    </fieldset>
</form>