public ActionResult Update(AutomatedReportsModel model)
        {
            if (model.IsActive)
            {
            }

            return(RedirectToAction("Index", new { msg = "Automated reports were updated" }));
        }
        public ActionResult Index(string msg)
        {
            var model = new AutomatedReportsModel();

            var lastEmailSuccess = db.Globals.Where(f => f.Message == "Automated Reports Email - Success").OrderByDescending(f => f.Date).FirstOrDefault();
            var lastEmailFailure = db.Globals.Where(f => f.Message == "Automated Reports Email - Failure").OrderByDescending(f => f.Date).FirstOrDefault();

            if (lastEmailSuccess != null && lastEmailFailure != null)
            {
                if (lastEmailSuccess.Date > lastEmailFailure.Date)
                {
                    model.LastEmailDate = lastEmailSuccess.Date;
                    model.Status        = "Success";
                }
                else
                {
                    model.LastEmailDate = lastEmailFailure.Date;
                    model.Status        = "Failure";
                }
            }
            else if (lastEmailSuccess != null)
            {
                model.LastEmailDate = lastEmailSuccess.Date;
                model.Status        = "Success";
            }
            else if (lastEmailFailure != null)
            {
                model.LastEmailDate = lastEmailFailure.Date;
                model.Status        = "Failure";
            }

            if (!string.IsNullOrEmpty(msg))
            {
                ModelState.AddModelError("Success", msg);
            }

            return(View(model));
        }