public bool Delete(ContactViewModel cvm) { try { using (Data.DBContext db = new Data.DBContext()) { Contact record = (from x in db.Contacts where x.Id == cvm.Id select x).FirstOrDefault(); db.Contacts.DeleteOnSubmit(record); db.SubmitChanges(); } } catch (Exception) { return(false); } return(true); }
public bool Update(ContactViewModel cvm) { try { using (Data.DBContext db = new Data.DBContext()) { Contact record = (from x in db.Contacts where x.Id == cvm.Id select x).FirstOrDefault(); record.FirstName = cvm.FirstName; record.LastName = cvm.LastName; record.EmailAddress = cvm.EmailAddress; record.Message = cvm.Message; record.LastUpdated = DateTime.Now; db.SubmitChanges(); } } catch (Exception) { return(false); } return(true); }
public int?Create(ContactViewModel cvm) { int?id = null; using (Data.DBContext db = new Data.DBContext()) { Contact record = new Contact { FirstName = cvm.FirstName, LastName = cvm.LastName, EmailAddress = cvm.EmailAddress, Message = cvm.Message, Created = DateTime.Now, LastUpdated = null }; db.Contacts.InsertOnSubmit(record); db.SubmitChanges(); id = record.Id; } return(id); }