public async Task<ActionResult> Contacts_Destroy(int ContactID) { using (var contactsDB = new ContactContext()) { var contact = contactsDB.Contacts .Where(c => c.ContactID == ContactID).First(); contactsDB.Contacts.Remove(contact); await contactsDB.SaveChangesAsync(); } return Json(ContactID); }
public async Task<ActionResult> Contacts_Create(Contact model) { using (var contactsDB = new ContactContext()) { var contact = new Contact { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Company = model.Company, PhoneNumber = model.PhoneNumber, SubmittedDate = DateTime.UtcNow, }; contactsDB.Contacts.Add(contact); await contactsDB.SaveChangesAsync(); } return Json(model); }
public async Task<ActionResult> Contacts_Update(Contact models) { using (var contactsDB = new ContactContext()) { var update = contactsDB.Contacts .Where(c => c.ContactID == models.ContactID) .SingleOrDefault(); if (update != null) { update.FirstName = models.FirstName; update.LastName = models.LastName; update.Email = models.Email; update.Company = models.Company; update.PhoneNumber = models.PhoneNumber; await contactsDB.SaveChangesAsync(); } return Json(update); } }
public async Task<ActionResult> Contacts_Read() { using (var contactsDB = new ContactContext()) { var result = await contactsDB.Contacts .Select(c => new ContactVM { ContactID = c.ContactID, FirstName = c.FirstName, LastName = c.LastName, Email = c.Email, Company = c.Company, PhoneNumber = c.PhoneNumber, SubmittedDate = c.SubmittedDate, }) .OrderByDescending(c => c.SubmittedDate) .ToListAsync(); return Json(result, JsonRequestBehavior.AllowGet); } }
public ContactFormResultsHub() { db = new ContactContext(); }