public string AddUpdateScheduledMaintenance(ScheduledMaintenanceViewModel model)
{
db = new SR_Log_DatabaseSQLEntities();
string UserId = "";
List <tblScheduledMaintenance> setting = (from u in db.tblScheduledMaintenances
select u).ToList();
//Delete all existing schedules
if (setting.Count > 0)
{
foreach (tblScheduledMaintenance t in setting)
{
db.tblScheduledMaintenances.Remove(t);
db.SaveChanges();
}
}
using (var context = new SR_Log_DatabaseSQLEntities())
{
tblScheduledMaintenance rec = new tblScheduledMaintenance();
rec.FromDate = model.FromDate;
rec.ToDate = model.ToDate;
rec.Message = model.Message;
context.tblScheduledMaintenances.Add(rec);
context.SaveChanges();
UserId = "Scheduled Maintenance Set Successfully";
}
return(UserId);
}
public ScheduledMaintenanceViewModel GetScheduledMaintenance()
{
db = new SR_Log_DatabaseSQLEntities();
ScheduledMaintenanceViewModel rec = new ScheduledMaintenanceViewModel();
tblScheduledMaintenance tblrec = db.tblScheduledMaintenances.FirstOrDefault();
if (tblrec != null)
{
rec.FromDate = tblrec.FromDate;
rec.ToDate = tblrec.ToDate;
rec.Message = tblrec.Message;
}
return(rec);
}
