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