Creating reports and dashboards | Stimulsoft community forum

Code: Select all

public virtual ActionResult ShowPlanReport()
        {
            //List<Plan> result = Session["PlanList"]  as List<Plan>;
            List<ReportPlanFullViewModel> FinalResult = new List<ReportPlanFullViewModel>();
            var db = new anjomanEntities();
            Stimulsoft.Report.StiReport mainReport = new Stimulsoft.Report.StiReport();
            try
            {
                foreach (Plan temp in reportList)
                {
                    ReportPlanFullViewModel model = new ReportPlanFullViewModel();
                    model.PlanID = temp.ID;
                    model.Farmer = temp.Farmer;
                    model.NationalCode = temp.NationalCode;
                    model.System = temp.WaterSystem.Name;
                    model.RainArea = temp.RainArea;
                    model.DropArea = temp.DropsArea;
                    model.Mobile = temp.Mobile;
                    model.Address = temp.Address;
                    model.Village = temp.Village;
                    if (db.PlanTopograpger.Where(x => x.PlanID == temp.ID).Count() > 0)
                    {
                        model.Topograph = db.PlanTopograpger.FirstOrDefault(x => x.PlanID == temp.ID).Topographer.Name;
                        model.Topograph += " ";
                        model.Topograph = db.PlanTopograpger.FirstOrDefault(x => x.PlanID == temp.ID).Topographer.Family;
                    }
                    else
                    {
                        model.Topograph = "";
                    }
                    if (db.PlanDesignerAdvisor.Where(x => x.PlanID == temp.ID).Count() > 0)
                    {
                        model.Design = db.PlanDesignerAdvisor.FirstOrDefault(x => x.PlanID == temp.ID).Advisor.Name;
                        model.Design += " ";
                        model.Design += db.PlanDesignerAdvisor.FirstOrDefault(x => x.PlanID == temp.ID).Advisor.Family;
                    }

                    else if (db.PlanDesignerCompany.Where(x => x.PlanID == temp.ID).Count() > 0)
                    {
                        model.Design = db.PlanDesignerCompany.FirstOrDefault(x => x.PlanID == temp.ID).Company.Name;
                    }
                    else
                    {
                        model.Design = "";
                    }
                    if (db.PlanChecker.Where(x => x.PlanID == temp.ID).Count() > 0)
                    {
                        model.Checker = db.PlanChecker.FirstOrDefault(x => x.PlanID == temp.ID).Company.Name;
                    }
                    else
                    {
                        model.Checker = "";
                    }
                    if (db.PlanExecute.Where(x => x.PlanID == temp.ID).Count() > 0)
                    {
                        model.Executer = db.PlanExecute.FirstOrDefault(x => x.PlanID == temp.ID).Company.Name;
                    }
                    else if (db.PlanExeHistory.Where(x => x.PlanID == temp.ID).Count() > 0)
                    {
                        model.Executer = db.PlanExeHistory.FirstOrDefault(x => x.PlanID == temp.ID).Company.Name;
                    }
                    else
                    {
                        model.Executer = "";
                    }
                    if (db.PlanValidate.Where(x => x.PlanID == temp.ID && x.Validate == true && x.PlanExecute == true).Count() > 0)
                    {
                        model.ValidDate = ToJalali(db.PlanValidate.FirstOrDefault(x => x.PlanID == temp.ID && x.Validate == true && x.PlanExecute == true).ValidDate);
                    }
                    else
                    {
                        model.ValidDate = "";
                    }
                    model.Andikator = "";
                    model.Price = "";
                    model.TempDate = "";
                    FinalResult.Add(model);


                }
                
                mainReport.Load(Server.MapPath("~/Report/PlanReport.mrt"));
                mainReport.RegBusinessObject("plan_business", FinalResult);
                
            }
            catch(Exception c)
            {
                //
            }
            
            return Stimulsoft.Report.Mvc.StiMvcViewer.GetReportSnapshotResult(mainReport);
        }