public ActionResult Indicator2() { AppDropDownsService ServiceDDL = new AppDropDownsService(); IEnumerable <ProgramAreaList> ProgramArea = ServiceDDL.GetProgramAreaList(); IEnumerable <ProposalStatusList> ProposalStatus = ServiceDDL.GetProposalStatusList(); IEnumerable <GrantTypeList> GrantType = ServiceDDL.GetGrantTypeList(); IEnumerable <CompetitionCodeList> CompletionCode = ServiceDDL.GetCompetitionCodeList(); IEnumerable <ProposalStatusList> Status = ServiceDDL.GetProposalStatusList(); IEnumerable <RegionList> Region = ServiceDDL.GetRegionList(); IEnumerable <IndicatorLabelContentCategory> IndicatorCategoryList = ServiceDDL.IndicatorLabelContentCategoryList(); ViewData["ProgramArea"] = ProgramArea; ViewData["ProposalStatus"] = ProposalStatus; ViewData["GrantType"] = GrantType; ViewData["CompletionCode"] = CompletionCode; ViewData["Status"] = Status; ViewData["Region"] = Region; ViewData["IndicatorCategoryList"] = IndicatorCategoryList; ViewData["results"] = null; return(View()); }
public ActionResult Indicator(FinReportFilter frepf, int?ID, List <String> Area, List <String> gtype, List <String> compete, List <String> status, List <String> oblast, List <String> period, List <String> amount, List <String> location) { AppDropDownsService ServiceDDL = new AppDropDownsService(); IEnumerable <ProgramAreaList> ProgramArea = ServiceDDL.GetProgramAreaList(); IEnumerable <ProposalStatusList> ProposalStatus = ServiceDDL.GetProposalStatusList(); IEnumerable <GrantTypeList> GrantType = ServiceDDL.GetGrantTypeList(); IEnumerable <CompetitionCodeList> CompletionCode = ServiceDDL.GetCompetitionCodeList(); IEnumerable <ProposalStatusList> Status = ServiceDDL.GetProposalStatusList(); IEnumerable <RegionList> Region = ServiceDDL.GetRegionList(); ViewData["ProgramArea"] = ProgramArea; ViewData["ProposalStatus"] = ProposalStatus; ViewData["GrantType"] = GrantType; ViewData["CompletionCode"] = CompletionCode; ViewData["Status"] = Status; ViewData["Region"] = Region; if (frepf != null) { LReportsRepository rep = new LReportsRepository(); // IQueryable<Project> prj = rep.GetResults(frepf); IQueryable <Project> prj = rep.GetResults2(frepf, ID, Area, gtype, compete, status, oblast, period, amount, location); List <Project> prjList = prj.ToList(); if (prj != null) { // List<LabelByCount> test = rep.IndicatorByBaseline(prj, 2); ViewData["report31"] = rep.IndicatorByBaseline(prj); ViewData["report32"] = rep.IndicatorByBenchmark(prj); ViewData["report33"] = rep.IndicatorByFinal(prj); ViewData["prj"] = prj; } return(View(frepf)); } else { return(View()); } }
public ActionResult Index() { AppDropDownsService ServiceDDL = new AppDropDownsService(); IEnumerable <ProgramAreaList> ProgramArea = ServiceDDL.GetProgramAreaList(); IEnumerable <ProposalStatusList> ProposalStatus = ServiceDDL.GetProposalStatusList(); ViewData["ProgramArea"] = ProgramArea; ViewData["ProposalStatus"] = ProposalStatus; return(View()); }
// // GET: /Filter2/ public ActionResult Index() { AppDropDownsService ServiceDDL = new AppDropDownsService(); IEnumerable <ProgramAreaList> ProgramArea = ServiceDDL.GetProgramAreaList(); IEnumerable <ProposalStatusList> ProposalStatus = ServiceDDL.GetProposalStatusList(); IEnumerable <GrantTypeList> GrantType = ServiceDDL.GetGrantTypeList(); IEnumerable <CompetitionCodeList> CompletionCode = ServiceDDL.GetCompetitionCodeList(); IEnumerable <ProposalStatusList> Status = ServiceDDL.GetProposalStatusList(); IEnumerable <RegionList> Region = ServiceDDL.GetRegionList(); IEnumerable <ProjLocationList> PrLoc = ServiceDDL.GetProjectLocationList(); ViewData["ProgramArea"] = ProgramArea; ViewData["ProposalStatus"] = ProposalStatus; ViewData["GrantType"] = GrantType; ViewData["CompletionCode"] = CompletionCode; ViewData["Status"] = Status; ViewData["Region"] = Region; ViewData["ProjLoc"] = PrLoc; return(View()); }
public ActionResult BudgetAnalysis() { AppDropDownsService ServiceDDL = new AppDropDownsService(); ViewData["CompletionCode"] = ServiceDDL.GetCompetitionCodeList(); ViewData["ProgramArea"] = ServiceDDL.GetProgramAreaList(); ViewData["GrantType"] = ServiceDDL.GetGrantTypeList(); ViewData["Status"] = ServiceDDL.GetProposalStatusList(); ViewData["results"] = null; ViewData["Region"] = ServiceDDL.GetRegionList(); return(View()); }
public ActionResult AppDropDowns() { ViewData["EventType"] = appddservice.GetEventTypeList(); ViewData["OrgLegalStatus"] = appddservice.GetLegalStatusList(); ViewData["GrantType"] = appddservice.GetGrantTypeList(); ViewData["ProgramArea"] = appddservice.GetProgramAreaList(); ViewData["CompetitionCode"] = appddservice.GetCompetitionCodeList(); ViewData["ProposalStatus"] = appddservice.GetProposalStatusList(); ViewData["SSPRoles"] = staffservice.GetALLSSPRoles(); ViewData["Regions"] = appddservice.GetRegionList(); ViewData["GetBudgetCatList"] = appddservice.GetCatList(); ViewData["ProjectLocationList"] = appddservice.GetProjectLocationList(); return(View()); }
public ActionResult Indicator2(FinReportFilter frepf, int?ID, List <String> Area, List <String> gtype, List <String> compete, List <String> status, List <String> oblast, List <String> period, List <String> amount, List <String> indicatorcategory) { LReportsRepository rep = new LReportsRepository(); //IndRepHolder inp = new IndRepHolder(); // inp.Column = "Akmola obl"; // inp.Row ="ECD"; // inp.Val = 1; AppDropDownsService ServiceDDL = new AppDropDownsService(); #region drops IEnumerable <ProgramAreaList> ProgramArea = ServiceDDL.GetProgramAreaList(); IEnumerable <ProposalStatusList> ProposalStatus = ServiceDDL.GetProposalStatusList(); IEnumerable <GrantTypeList> GrantType = ServiceDDL.GetGrantTypeList(); IEnumerable <CompetitionCodeList> CompletionCode = ServiceDDL.GetCompetitionCodeList(); IEnumerable <ProposalStatusList> Status = ServiceDDL.GetProposalStatusList(); IEnumerable <RegionList> Region = ServiceDDL.GetRegionList(); IEnumerable <IndicatorLabelContentCategory> IndicatorCategoryList = ServiceDDL.IndicatorLabelContentCategoryList(); ViewData["ProgramArea"] = ProgramArea; //take only ECD and Youth. IEnumerable <ProgramAreaList> ProgramArea2 = ProgramArea.Where(s => s.ProgramAreaText == "ECD" || s.ProgramAreaText == "Youth"); ViewData["ProgramArea2"] = ProgramArea2; ViewData["ProposalStatus"] = ProposalStatus; ViewData["GrantType"] = GrantType; ViewData["CompletionCode"] = CompletionCode; ViewData["Status"] = Status; ViewData["Region"] = Region; ViewData["IndicatorCategoryList"] = IndicatorCategoryList; #endregion //if (frepf != null) //{ IQueryable <Project> prj = rep.GetResults3(frepf, ID, Area, gtype, compete, status, period, oblast, amount); //1. gets resulting project list after filtering. List <Project> prjList = prj.ToList(); ViewData["prj"] = prj; // List<IndRepHolder> zz = rep.IndicatorsByRoundArea(prj); List <IndRepHolder> zz = rep.IndicatorsByCompetitionContentCategory(prj); List <IndRepHolder> zz2 = rep.IndicatorsByRegionContentCategory(prj); ViewData["LIndRep"] = zz; ViewData["LIndRep2"] = zz2; if (prjList != null) { //2. generates/calculates VS amounts. Dictionary <IndicatorContainerType, Dictionary <IndicatorLabelContentCategory, List <IndicatorRepContainer> > > results = IndicatorReportCore( prj, frepf, Area, gtype, compete, status, oblast, period, amount, indicatorcategory); ViewData["results2"] = results; } //add List Filters. //enable Report View enabled if not null. if (frepf.isIndicator != null && frepf.isIndicator.Value == true) { frepf.isIndicator = true; } else { frepf.isIndicator = false; } if (Area != null) { frepf.IsArea = true; } if (gtype != null) { frepf.IsGrantType = true; } if (compete != null) { frepf.IsCompetitionCode = true; } if (status != null) { frepf.IsStatus = true; } if (period != null) { frepf.IsPeriod = true; } //===== return(View(frepf)); }
public ActionResult outcome(FinReportFilter frepf, int?ID, List <String> Area, List <String> gtype, List <String> compete, List <String> status, List <String> oblast, List <String> period, List <String> amount, List <String> indicatorcategory) { AppDropDownsService ServiceDDL = new AppDropDownsService(); #region drops IEnumerable <ProgramAreaList> ProgramArea = ServiceDDL.GetProgramAreaList(); IEnumerable <ProposalStatusList> ProposalStatus = ServiceDDL.GetProposalStatusList(); IEnumerable <GrantTypeList> GrantType = ServiceDDL.GetGrantTypeList(); IEnumerable <CompetitionCodeList> CompletionCode = ServiceDDL.GetCompetitionCodeList(); IEnumerable <ProposalStatusList> Status = ServiceDDL.GetProposalStatusList(); IEnumerable <RegionList> Region = ServiceDDL.GetRegionList(); IEnumerable <IndicatorLabelContentCategory> IndicatorCategoryList = ServiceDDL.IndicatorLabelContentCategoryList(); ViewData["ProgramArea"] = ProgramArea; ViewData["ProposalStatus"] = ProposalStatus; ViewData["GrantType"] = GrantType; ViewData["CompletionCode"] = CompletionCode; ViewData["Status"] = Status; ViewData["Region"] = Region; ViewData["IndicatorCategoryList"] = IndicatorCategoryList; #endregion //if (frepf != null) //{ LReportsRepository rep = new LReportsRepository(); IQueryable <Project> prj = rep.GetResults3(frepf, ID, Area, gtype, compete, status, period, oblast, amount); //1. gets resulting project list after filtering. List <Project> prjList = prj.ToList(); ViewData["prj"] = prj; //add List Filters. //enable Report View enabled if not null. if (Area != null) { frepf.IsArea = true; } if (gtype != null) { frepf.IsGrantType = true; } if (compete != null) { frepf.IsCompetitionCode = true; } if (status != null) { frepf.IsStatus = true; } if (period != null) { frepf.IsPeriod = true; } //===== return(View(frepf)); }
public ActionResult BudgetAnalysis(FinReportFilter frepf, int?ID, List <String> Area, List <String> gtype, List <String> compete, List <String> status, List <String> period, List <String> amount, List <String> oblast) { AppDropDownsService ServiceDDL = new AppDropDownsService(); ViewData["CompletionCode"] = ServiceDDL.GetCompetitionCodeList(); ViewData["ProgramArea"] = ServiceDDL.GetProgramAreaList(); ViewData["GrantType"] = ServiceDDL.GetGrantTypeList(); ViewData["Status"] = ServiceDDL.GetProposalStatusList(); ViewData["Region"] = ServiceDDL.GetRegionList(); //if (frepf != null) //{ LReportsRepository rep = new LReportsRepository(); IQueryable <Project> prj = rep.GetResults3(frepf, ID, Area, gtype, compete, status, period, oblast, amount); //1. gets resulting project list after filtering. List <Project> prjList = prj.ToList(); ViewData["prj"] = prj; if (prjList != null) { //2. generates/calculates VS amounts. if (!frepf.isListOnly.Value) { Dictionary <ContainerType, Dictionary <AmountTypes, List <VsContainer> > > results = FinReportCore(prj, frepf, Area, gtype, compete, status, period, oblast); ViewData["results2"] = results; } } //add List Filters. //enable Report View enabled if not null. if (Area != null) { frepf.IsArea = true; } if (gtype != null) { frepf.IsGrantType = true; } if (compete != null) { frepf.IsCompetitionCode = true; } if (status != null) { frepf.IsStatus = true; } if (period != null) { frepf.IsPeriod = true; } if (oblast != null) { frepf.isRegion = true; } //===== return(View(frepf)); }
public ActionResult Index(FinReportFilter frepf, int?ID, List <String> Area, List <String> gtype, List <String> compete, List <String> status, List <String> period, List <String> amount, List <String> oblast, List <String> lfIndicators) { AppDropDownsService ServiceDDL = new AppDropDownsService(); ViewData["CompletionCode"] = ServiceDDL.GetCompetitionCodeList(); ViewData["ProgramArea"] = ServiceDDL.GetProgramAreaList(); ViewData["GrantType"] = ServiceDDL.GetGrantTypeList(); ViewData["Status"] = ServiceDDL.GetProposalStatusList(); ViewData["Region"] = ServiceDDL.GetRegionList(); ViewData["BudgetCatList"] = ServiceDDL.GetCatList(); ViewData["LfIndicatorList"] = ServiceDDL.GetLfIndicatorList(); LReportsRepository rep = new LReportsRepository(); IQueryable <Project> prj = rep.GetResults3(frepf, ID, Area, gtype, compete, status, period, oblast, amount, lfIndicators); //1. gets resulting project list after filtering. List <Project> prjList = prj.ToList(); ViewData["prj"] = prj; if (prjList != null) { var query = prjList .GroupBy(g => new //GROUP BY GrantType, ProgramArea Field1, Field2 and SUM AmtRequested. { g.LFIndicator.LFIndicatorID, }) .Select(group => new VsContainer() //Select all Grouped into VersusContainer. { ProjId = group.Select(i => i.ProjectID).ToList(), Field1 = group.Key.LFIndicatorID, iAmount = prjList.Count(), dAmount = group.Select(i => i.ProjectID).Count(), Field1Title = "# of grants with " + group.Select(i => i.LFIndicator.LFIndicatorList.CodeText).FirstOrDefault() }); List <VsContainer> vsc = query.ToList(); //test. ViewData["vsc"] = vsc; } //add List Filters. //enable Report View enabled if not null. if (lfIndicators != null) { frepf.isLFIndicator = true; } if (Area != null) { frepf.IsArea = true; } if (gtype != null) { frepf.IsGrantType = true; } if (compete != null) { frepf.IsCompetitionCode = true; } if (status != null) { frepf.IsStatus = true; } if (period != null) { frepf.IsPeriod = true; } if (oblast != null) { frepf.isRegion = true; } //===== return(View(frepf)); }