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