public virtual JsonResult FilterCountrys(PorfolioStatusModel ModelRisksModel)
{
var ListCountrys = ClientGenericRepositoty.GetCountrysFilterCode(Lang, ModelRisksModel.CountryDepartment).OrderBy(x => x.Name).ToList();
return(new JsonResult()
{
Data = ListCountrys
});
}
public virtual JsonResult FilterDivision(PorfolioStatusModel ModelRisksModel)
{
var ListDivision = ClientGenericRepositoty.GetDivisionFilterCode(Lang, ModelRisksModel.DepartmentSector).OrderBy(x => x.Name).ToList();
return(new JsonResult()
{
Data = ListDivision
});
}
public virtual ActionResult Index(string OperationNumber, string Report)
{
PorfolioStatusModel PorfolioModel = new PorfolioStatusModel();
PorfolioModel.OperationId = ClientGenericRepositoty.GetOperationIDForOperationNumber(OperationNumber);
ViewBag.ReportSelected = Report;
if (string.Compare(Report, DashReportsCodes.PMR.GetStringValue(), true) == 0)
{
ViewBag.ReportType = Localization.GetText("PMR");
}
else if (string.Compare(Report, DashReportsCodes.SupervisionPlan.GetStringValue(), true) == 0)
{
ViewBag.ReportType = Localization.GetText("Supervision Plan");
}
else if (string.Compare(Report, DashReportsCodes.Risks.GetStringValue(), true) == 0)
{
ViewBag.ReportType = Localization.GetText("Risks");
}
else if (string.Compare(Report, DashReportsCodes.Clauses.GetStringValue(), true) == 0)
{
ViewBag.ReportType = Localization.GetText("Clauses");
}
else if (string.Compare(Report, DashReportsCodes.Visualization.GetStringValue(), true) == 0)
{
ViewBag.ReportType = Localization.GetText("Visualization");
}
else if (string.Compare(Report, DashReportsCodes.DisbursementProjections.GetStringValue(), true) == 0)
{
ViewBag.ReportType = Localization.GetText("Disbursement Projections");
}
else
{
ViewBag.ReportType = string.Empty;
}
if (string.Compare(Report, DashReportsCodes.DisbursementProjections.GetStringValue(), true) == 0)
{
LoadCommonData();
LoadDisbursementProjectionsData();
ViewBag.AdditionalParameters = true;
}
else
{
LoadCommonData();
ViewBag.AdditionalParameters = false;
}
return(View(PorfolioModel));
}
public virtual ActionResult GenerateReport(PorfolioStatusModel ModelPorfolio, string Report)
{
string UrlDinamicDashBoardReport = string.Empty;
if (ModelPorfolio.Format == string.Empty || string.IsNullOrEmpty(ModelPorfolio.Format))
{
string Header = ConfigurationManager.AppSettings["ParamHeaderDashboardReport"].ToString();
UrlDinamicDashBoardReport = ReportBuilder.GetReportPreffix(AddReportSelected(Report, ModelPorfolio.TypeGroupping["Groupping"]));
UrlDinamicDashBoardReport += GetUrlReport(ModelPorfolio, Report, ModelPorfolio.TypeGroupping["Groupping"]);
return(Content(UrlDinamicDashBoardReport + Header));
}
else
{
UrlDinamicDashBoardReport += ReportBuilder.GetReportPreffix(AddReportSelected(Report, ModelPorfolio.TypeGroupping["Groupping"]));
UrlDinamicDashBoardReport += GetUrlReport(ModelPorfolio, Report, ModelPorfolio.TypeGroupping["Groupping"]) + "&rs:Format=" + ModelPorfolio.Format;
ModelPorfolio.Format = string.Empty;
return(Content(UrlDinamicDashBoardReport));
}
}
public string GetUrlReport(PorfolioStatusModel ModelPorfolio, string Report, string Groupping)
{
var DashUrl = string.Empty;
var ListCountryDepartments = ClientGenericRepositoty.GetCountryDepartments(Lang);
var ListCountry = ClientGenericRepositoty.GetCountries(Lang).OrderBy(x => x.Name).ToList();
var ListSectorDepartment = ClientGenericRepositoty.GetSectorDepartment(Lang);
var ListDivision = ClientGenericRepositoty.GetDivisions(Lang);
if (ModelPorfolio.CountryDepartment.Count == 0 && ModelPorfolio.Country.Count == 0)
{
DashUrl += "&ReportFilterCountryDepartment=-ALL COUNTRY DEPARTMENT";
DashUrl += "&ReportFilterCountry=-ALL COUNTRY";
}
else if (ModelPorfolio.CountryDepartment.Count > 0 && ModelPorfolio.Country.Count > 0)
{
foreach (var item in ModelPorfolio.CountryDepartment)
{
DashUrl += "&ReportFilterCountryDepartment=" + item.ToString();
}
foreach (var item in ModelPorfolio.Country)
{
DashUrl += "&ReportFilterCountry=" + item;
}
}
else if (ModelPorfolio.CountryDepartment.Count == 0 && ModelPorfolio.Country.Count > 0)
{
foreach (var item in ModelPorfolio.Country)
{
DashUrl += "&ReportFilterCountry=" + item;
}
var ListCountryDepartment = ClientGenericRepositoty.GetCountryDepartmentByCountryCode(Lang, ModelPorfolio.Country);
foreach (var item in ListCountryDepartment)
{
DashUrl += "&ReportFilterCountryDepartment=" + item.ToString();
}
}
else if (ModelPorfolio.CountryDepartment.Count > 0 && ModelPorfolio.Country.Count == 0)
{
foreach (var item in ModelPorfolio.CountryDepartment)
{
DashUrl += "&ReportFilterCountryDepartment=" + item.ToString();
}
DashUrl += "&ReportFilterCountry=-ALL COUNTRY";
}
if (ModelPorfolio.DepartmentSector.Count == 0 && ModelPorfolio.Division.Count == 0)
{
DashUrl += "&ReportFilterDepartmentSector=-ALL DEPARTMENT SECTOR";
DashUrl += "&ReportFilterDivision=-ALL DIVISION";
}
else if (ModelPorfolio.DepartmentSector.Count > 0 && ModelPorfolio.Division.Count > 0)
{
foreach (var item in ModelPorfolio.DepartmentSector)
{
DashUrl += "&ReportFilterDepartmentSector=" + item;
}
foreach (var item in ModelPorfolio.Division)
{
DashUrl += "&ReportFilterDivision=" + item;
}
}
else if (ModelPorfolio.DepartmentSector.Count == 0 && ModelPorfolio.Division.Count > 0)
{
foreach (var item in ModelPorfolio.Division)
{
DashUrl += "&ReportFilterDivision=" + item;
}
var ListDepartmentSector = ClientGenericRepositoty.GetDepartmentByDivisionCode(Lang, ModelPorfolio.Division);
foreach (var item in ListDepartmentSector)
{
DashUrl += "&ReportFilterDepartmentSector=" + item.ToString();
}
}
else if (ModelPorfolio.DepartmentSector.Count > 0 && ModelPorfolio.Division.Count == 0)
{
foreach (var item in ModelPorfolio.DepartmentSector)
{
DashUrl += "&ReportFilterDepartmentSector=" + item;
}
var ListDivisionCode = ClientGenericRepositoty.GetDivisionFilterCode(Lang, ModelPorfolio.DepartmentSector);
DashUrl += "&ReportFilterDivision=-ALL DIVISION";
}
if (Report == DashReportsCodes.DisbursementProjections.GetStringValue())
{
if (ModelPorfolio.LendingInstrument.Count > 0)
{
foreach (var item in ModelPorfolio.LendingInstrument)
{
DashUrl += "&ReportParameterLendingInstrument=" + item;
}
}
else
{
DashUrl += "&ReportParameterLendingInstrument=-ALL LENDING INSTRUMENT";
}
if (ModelPorfolio.Funds.Count > 0)
{
foreach (var item in ModelPorfolio.Funds)
{
DashUrl += "&ReportParameterFund=" + item;
}
}
else
{
DashUrl += "&ReportParameterFund=-ALL FUNDS";
}
DashUrl += "&ReportParameterYear=" + ModelPorfolio.Year;
}
return(DashUrl);
}
