1 [TableName("ContactEntries")]
 2 [PrimaryKey("Id", autoIncrement = true)]
 3 public class ContactEntry
 4 {
 5     [PrimaryKeyColumn(AutoIncrement = true)]
 6     public int Id { get; set; }
 7 
 8     [Required]
 9     public string Name { get; set; }
10 
11     [Required]
12     [EmailAddress]
13     public string Email { get; set; }
14 
15     [SpecialDbType(SpecialDbTypes.NTEXT)]
16     [Required]
17     public string Message { get; set; }
18 
19     public DateTime Created { get; set; }
20 }

 1 @if (TempData["success"] != null)
 2 {
 3     <p>Thank you for your message!</p>
 4 }
 5 else
 6 {
 7     using (Html.BeginUmbracoForm<ContactController>("HandlePost"))
 8     {
 9         <div>
10             @Html.LabelFor(m => m.Name)
11             @Html.TextBoxFor(x => x.Name)
12             @Html.ValidationMessageFor(m => m.Name)
13         </div>
14 
15         <div>
16             @Html.LabelFor(m => m.Email)
17             @Html.TextBoxFor(x => x.Email)
18             @Html.ValidationMessageFor(m => m.Email)
19         </div>
20 
21         <div>
22             @Html.LabelFor(m => m.Message)
23             @Html.TextAreaFor(x => x.Message)
24             @Html.ValidationMessageFor(m => m.Message)
25         </div>
26 
27         <div>
28             <button type="submit">Submit</button>
29         </div>
30     }
31 }

 1 public class ContactController : SurfaceController
 2 {
 3     [ChildActionOnly]
 4     public ActionResult Render()
 5     {
 6         return PartialView("ContactEntry",new Models.ContactEntry());
 7     }
 8 
 9     [HttpPost]
10     public ActionResult HandlePost(Models.ContactEntry model)
11     {
12         if (!ModelState.IsValid)
13             return CurrentUmbracoPage();
14 
15         //add to db
16         model.Created = DateTime.Now;
17         var db = ApplicationContext.DatabaseContext.Database;
18         db.Insert(model);
19 
20         //send email, do other things…
21 
22         TempData["Success"] = true;
23         return RedirectToCurrentUmbracoPage();
24     }
25 }

 1     public class App: ApplicationEventHandler
 2     {
 3         protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
 4         {
 5             var ctx = applicationContext.DatabaseContext;
 6             var db = new DatabaseSchemaHelper(ctx.Database, applicationContext.ProfilingLogger.Logger, ctx.SqlSyntax);
 7 
 8             //Check if the DB table does NOT exist
 9             if (!db.TableExist("ContactEntries"))
10             {
11                 //Create DB table - and set overwrite to false
12                 db.CreateTable(false, typeof(ContactEntry));
13             }
14 
15         }
16     }

 1 [TableName("ContactEntries")]
 2 [PrimaryKey("Id", autoIncrement = true)]
 3 [UIOMatic("contactentries", "Contact Entries", "Contact Entry",
 4     FolderIcon = "icon-users", ItemIcon = "icon-user",
 5     SortColumn = "Created", SortOrder = "desc",
 6     RenderType = UIOMaticRenderType.List)]
 7 public class ContactEntry
 8 {
 9     [PrimaryKeyColumn(AutoIncrement = true)]
10     public int Id { get; set; }
11 
12     [Required]
13     [UIOMaticListViewField]
14     [UIOMaticField]
15     public string Name { get; set; }
16 
17     [Required]
18     [EmailAddress]
19     [UIOMaticListViewField]
20     [UIOMaticField]
21     public string Email { get; set; }
22 
23     [SpecialDbType(SpecialDbTypes.NTEXT)]
24     [Required]
25     [UIOMaticListViewField]
26     [UIOMaticField(View = UIOMatic.Constants.FieldEditors.Textarea)]
27     public string Message { get; set; }
28 
29     [UIOMaticListViewField(Config = "{’format’ : ‘{{value|relativeDate}}’}")]
30     [UIOMaticField(View = UIOMatic.Constants.FieldEditors.DateTime)]
31     public DateTime Created { get; set; }
32 }