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