public IQueryable<Alert> getAlertByID(int _id)
{
alertDataContext objAlertDC = new alertDataContext();
var allAlerts = objAlertDC.Alerts.Where(x => x.Id == _id).Select(x => x);
return allAlerts;
}
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;
}
}
public IQueryable<Alert> getAlerts()
{
alertDataContext objAlertDC = new alertDataContext();
var allAlerts = objAlertDC.Alerts.Select(x => x);
return allAlerts;
}
//This function gets the most recent alert for public side
public IQueryable<Alert> getRecentAlerts()
{
alertDataContext objAlertDC = new alertDataContext();
var recentAlerts = objAlertDC.Alerts.OrderByDescending(x => x.Date).Take(1);
return recentAlerts;
}
