public bool commitDelete(int _id)
{
hospitalDataContext objContact = new hospitalDataContext();
using (objContact)
{
mic_contact objDelContact = objContact.mic_contacts.Single(x => x.Id == _id);
objContact.mic_contacts.DeleteOnSubmit(objDelContact);
objContact.SubmitChanges();
return(true);
}
}
public bool commitUpdate(int _id, string _fname, string _lname, string _email, string _city, string _province, string _subject, string _message)
{
hospitalDataContext objContact = new hospitalDataContext();
using (objContact)
{
mic_contact objUpContact = objContact.mic_contacts.Single(x => x.Id == _id);
objUpContact.fname = _fname;
objUpContact.lname = _lname;
objUpContact.email = _email;
objUpContact.city = _city;
objUpContact.province = _province;
objUpContact.subject = _subject;
objUpContact.message = _message;
objContact.mic_contacts.InsertOnSubmit(objUpContact);
objContact.SubmitChanges();
return(true);
}
}
public bool commitInsert(string _fname, string _lname, string _email, string _city, string _province, string _subject, string _message)
{
hospitalDataContext objContact = new hospitalDataContext();
using (objContact)
{
mic_contact objNewContact = new mic_contact();
objNewContact.fname = _fname;
objNewContact.lname = _lname;
objNewContact.email = _email;
objNewContact.city = _city;
objNewContact.province = _province;
objNewContact.subject = _subject;
objNewContact.message = _message;
objContact.mic_contacts.InsertOnSubmit(objNewContact);
objContact.SubmitChanges();
return(true);
}
}
