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);
}
