public bool commitDelete(int _id)
{
alertDataContext objAlertDC = new alertDataContext();
using (objAlertDC)
{
var objDelAlert = objAlertDC.Alerts.Single(x => x.Id == _id);
objAlertDC.Alerts.DeleteOnSubmit(objDelAlert);
objAlertDC.SubmitChanges();
return true;
}
}
public bool commitUpdate(int _id, string _Title, string _Message)
{
alertDataContext objAlertDC = new alertDataContext();
using (objAlertDC)
{
var objUpAlert = objAlertDC.Alerts.Single(x => x.Id == _id);
objUpAlert.Title = _Title;
objUpAlert.Message = _Message;
objAlertDC.SubmitChanges();
return true;
}
}
public bool commitInsert(string _Title, string _Message, DateTime _date)
{
alertDataContext objAlertDC = new alertDataContext();
using (objAlertDC)
{
Alert objNewAlert = new Alert();
objNewAlert.Title = _Title;
objNewAlert.Message = _Message;
objNewAlert.Date = _date;
objAlertDC.Alerts.InsertOnSubmit(objNewAlert);
objAlertDC.SubmitChanges();
return true;
}
}