public ActionResult Overview(FinancialSummaryOverviewModel model)
 {
     model.Load(db, Permissions);
     if (User.IsInRole("RegionReadOnly"))
     {
         model.RegionId = db.Users.Where(f => f.UserName == User.Identity.Name).Select(f => f.RegionId).SingleOrDefault();
     }
     return(View("Overview", model));
 }
 public ActionResult OverviewData(FinancialSummaryOverviewModel model)
 {
     try
     {
         var result = model.GetJqResult(db, Permissions);
         return(this.MyJsonResult(result));
     }
     catch
     {
         throw;
     }
 }
        public ActionResult OverviewExport(FinancialSummaryOverviewModel model)
        {
            db.CommandTimeout    = 180;
            model.iDisplayStart  = 0;
            model.iDisplayLength = int.MaxValue;
            var result         = model.Data(db, Permissions);
            var missingExRates = result.Where(f => f.Amount == null).ToList();

            if (missingExRates.Any())
            {
                model.Load(db, Permissions);
                if (User.IsInRole("RegionReadOnly"))
                {
                    model.RegionId = db.Users.Where(f => f.UserName == User.Identity.Name).Select(f => f.RegionId).SingleOrDefault();
                }
                foreach (var item in missingExRates.Select(f => f.MasterFundName).Distinct())
                {
                    var msg = string.Format("No exchange rate is defined for the {0} in the Master Fund {1}", model.CurId, item);
                    this.ModelState.AddModelError("", msg);
                }
                return(View("Overview", model));
            }
            return(this.Excel("output", "data", result.ToList()));
        }
        public ActionResult OverviewPreview(FinancialSummaryOverviewModel model)
        {
            var data = model.Data(db, Permissions);

            return(View(model));
        }