public ActionResult FinancialDisplayLayout(int MenuId)
{
Menu Menu = new MenuService(_unitOfWork).Find(MenuId);
FinancialDisplayViewModel vm = new FinancialDisplayViewModel();
vm.ReportType = Menu.MenuName;
System.Web.HttpContext.Current.Session["SettingList"] = new List <FinancialDisplaySettings>();
System.Web.HttpContext.Current.Session["CurrentSetting"] = new FinancialDisplaySettings();
List <SelectListItem> DisplayType = new List <SelectListItem>();
DisplayType.Add(new SelectListItem {
Text = DisplayType_Balance, Value = DisplayType_Balance
});
DisplayType.Add(new SelectListItem {
Text = DisplayType_Summary, Value = DisplayType_Summary
});
ViewBag.DisplayType = new SelectList(DisplayType, "Value", "Text");
vm.FromDate = "01/Apr/" + DateTime.Now.Date.Year.ToString();
vm.ToDate = DateTime.Now.Date.ToString("dd/MMM/yyyy");
//FinancialDisplaySettings SettingParameter = GetParameterSettings(vm);
return(View("FinancialDisplay", vm));
}
//public FinancialDisplaySettings GetParameterSettings(FinancialDisplayViewModel vm)
//{
// var SettingList = (List<FinancialDisplaySettings>)System.Web.HttpContext.Current.Session["SettingList"];
// var SettingForReportType = (from H in SettingList where H.ReportType == vm.ReportType select H).FirstOrDefault();
// FinancialDisplaySettings FinancialDisplaySettings = new FinancialDisplaySettings();
// if (SettingForReportType == null)
// {
// FinancialDisplaySettings.ReportType = vm.ReportType;
// FinancialDisplayParameters SiteParameter = new FinancialDisplayParameters();
// SiteParameter.ParameterName = "Site";
// SiteParameter.Value = vm.SiteIds;
// SiteParameter.IsApplicable = true;
// FinancialDisplayParameters DivisionParameter = new FinancialDisplayParameters();
// DivisionParameter.ParameterName = "Division";
// DivisionParameter.Value = vm.DivisionIds;
// DivisionParameter.IsApplicable = true;
// FinancialDisplayParameters FromDateParameter = new FinancialDisplayParameters();
// FromDateParameter.ParameterName = "FromDate";
// FromDateParameter.Value = vm.FromDate;
// FromDateParameter.IsApplicable = true;
// FinancialDisplayParameters ToDateParameter = new FinancialDisplayParameters();
// ToDateParameter.ParameterName = "ToDate";
// ToDateParameter.Value = vm.ToDate;
// ToDateParameter.IsApplicable = true;
// FinancialDisplaySettings.FinancialDisplayParameters = new List<FinancialDisplayParameters>();
// FinancialDisplaySettings.FinancialDisplayParameters.Add(SiteParameter);
// FinancialDisplaySettings.FinancialDisplayParameters.Add(DivisionParameter);
// FinancialDisplaySettings.FinancialDisplayParameters.Add(FromDateParameter);
// FinancialDisplaySettings.FinancialDisplayParameters.Add(ToDateParameter);
// System.Web.HttpContext.Current.Session["CurrentSetting"] = FinancialDisplaySettings;
// //((List<FinancialDisplaySettings>)System.Web.HttpContext.Current.Session["SettingList"]).Add(FinancialDisplaySettings);
// }
// else
// {
// //var SiteSetting = (from H in SettingForReportType.FinancialDisplayParameters where H.ParameterName == "Site" select H).FirstOrDefault();
// //SiteSetting.Value = vm.SiteIds;
// //var DivisionSetting = (from H in SettingForReportType.FinancialDisplayParameters where H.ParameterName == "Division" select H).FirstOrDefault();
// //DivisionSetting.Value = vm.DivisionIds;
// //var FromDateSetting = (from H in SettingForReportType.FinancialDisplayParameters where H.ParameterName == "FromDate" select H).FirstOrDefault();
// //FromDateSetting.Value = vm.FromDate;
// //var ToDateSetting = (from H in SettingForReportType.FinancialDisplayParameters where H.ParameterName == "ToDate" select H).FirstOrDefault();
// //ToDateSetting.Value = vm.ToDate;
// FinancialDisplaySettings = SettingForReportType;
// }
// return FinancialDisplaySettings;
//}
public FinancialDisplaySettings SetCurrentParameterSettings(FinancialDisplayViewModel vm)
{
FinancialDisplaySettings FinancialDisplaySettings = new FinancialDisplaySettings();
FinancialDisplaySettings.ReportType = vm.ReportType;
FinancialDisplayParameters SiteParameter = new FinancialDisplayParameters();
SiteParameter.ParameterName = "Site";
SiteParameter.Value = vm.SiteIds;
SiteParameter.IsApplicable = true;
FinancialDisplayParameters DivisionParameter = new FinancialDisplayParameters();
DivisionParameter.ParameterName = "Division";
DivisionParameter.Value = vm.DivisionIds;
DivisionParameter.IsApplicable = true;
FinancialDisplayParameters FromDateParameter = new FinancialDisplayParameters();
FromDateParameter.ParameterName = "FromDate";
FromDateParameter.Value = vm.FromDate;
FromDateParameter.IsApplicable = true;
FinancialDisplayParameters ToDateParameter = new FinancialDisplayParameters();
ToDateParameter.ParameterName = "ToDate";
ToDateParameter.Value = vm.ToDate;
ToDateParameter.IsApplicable = true;
FinancialDisplayParameters LedgerAccountGroupParameter = new FinancialDisplayParameters();
LedgerAccountGroupParameter.ParameterName = "LedgerAccountGroup";
LedgerAccountGroupParameter.Value = vm.LedgerAccountGroup.ToString();
LedgerAccountGroupParameter.IsApplicable = true;
FinancialDisplayParameters LedgerAccountParameter = new FinancialDisplayParameters();
LedgerAccountParameter.ParameterName = "LedgerAccount";
LedgerAccountParameter.Value = vm.LedgerAccount.ToString();
LedgerAccountParameter.IsApplicable = true;
FinancialDisplaySettings.FinancialDisplayParameters = new List <FinancialDisplayParameters>();
FinancialDisplaySettings.FinancialDisplayParameters.Add(SiteParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(DivisionParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(FromDateParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(ToDateParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(LedgerAccountGroupParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(LedgerAccountParameter);
System.Web.HttpContext.Current.Session["CurrentSetting"] = FinancialDisplaySettings;
return(FinancialDisplaySettings);
}
public ActionResult FinancialDisplayLayout(int MenuId)
{
Menu Menu = new MenuService(_unitOfWork).Find(MenuId);
FinancialDisplayViewModel vm = new FinancialDisplayViewModel();
vm.ReportType = Menu.MenuName;
vm.IsIncludeZeroBalance = true;
vm.IsShowContraAccount = true;
vm.IsIncludeOpening = true;
System.Web.HttpContext.Current.Session["SettingList"] = new List <FinancialDisplaySettings>();
System.Web.HttpContext.Current.Session["CurrentSetting"] = new FinancialDisplaySettings();
List <SelectListItem> DisplayType = new List <SelectListItem>();
DisplayType.Add(new SelectListItem {
Text = DisplayType_Balance, Value = DisplayType_Balance
});
DisplayType.Add(new SelectListItem {
Text = DisplayType_Summary, Value = DisplayType_Summary
});
ViewBag.DisplayType = new SelectList(DisplayType, "Value", "Text");
List <SelectListItem> DRCR = new List <SelectListItem>();
DRCR.Add(new SelectListItem {
Text = DrCrConstants.Both, Value = DrCrConstants.Both
});
DRCR.Add(new SelectListItem {
Text = DrCrConstants.Debit, Value = DrCrConstants.Debit
});
DRCR.Add(new SelectListItem {
Text = DrCrConstants.Credit, Value = DrCrConstants.Credit
});
ViewBag.DrCrList = new SelectList(DRCR, "Value", "Text");
vm.FromDate = "01/Apr/" + DateTime.Now.Date.Year.ToString();
vm.ToDate = DateTime.Now.Date.ToString("dd/MMM/yyyy");
//FinancialDisplaySettings SettingParameter = GetParameterSettings(vm);
ReportHeaderCompanyDetail ReportHeaderCompanyDetail = new ReportHeaderCompanyDetail();
var DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var CompanyId = (int)System.Web.HttpContext.Current.Session["CompanyId"];
//ApplicationDbContext db = new ApplicationDbContext();
Company Company = db.Company.Find(CompanyId);
Division Division = db.Divisions.Find(DivisionId);
ReportHeaderCompanyDetail.CompanyName = Company.CompanyName.Replace(System.Environment.NewLine, " ");
ReportHeaderCompanyDetail.Address = Company.Address.Replace(System.Environment.NewLine, " ");
if (Company.CityId != null)
{
ReportHeaderCompanyDetail.CityName = db.City.Find(Company.CityId).CityName;
}
else
{
ReportHeaderCompanyDetail.CityName = "";
}
ReportHeaderCompanyDetail.Phone = Company.Phone;
ReportHeaderCompanyDetail.LogoBlob = Division.LogoBlob;
vm.ReportHeaderCompanyDetail = ReportHeaderCompanyDetail;
return(View("FinancialDisplay", vm));
}
public FinancialDisplaySettings SetCurrentParameterSettings(FinancialDisplayViewModel vm)
{
FinancialDisplaySettings FinancialDisplaySettings = new FinancialDisplaySettings();
FinancialDisplaySettings.ReportType = vm.ReportType;
FinancialDisplayParameters SiteParameter = new FinancialDisplayParameters();
SiteParameter.ParameterName = "Site";
SiteParameter.Value = vm.SiteIds;
SiteParameter.IsApplicable = true;
FinancialDisplayParameters DivisionParameter = new FinancialDisplayParameters();
DivisionParameter.ParameterName = "Division";
DivisionParameter.Value = vm.DivisionIds;
DivisionParameter.IsApplicable = true;
FinancialDisplayParameters FromDateParameter = new FinancialDisplayParameters();
FromDateParameter.ParameterName = "FromDate";
FromDateParameter.Value = vm.FromDate;
FromDateParameter.IsApplicable = true;
FinancialDisplayParameters ToDateParameter = new FinancialDisplayParameters();
ToDateParameter.ParameterName = "ToDate";
ToDateParameter.Value = vm.ToDate;
ToDateParameter.IsApplicable = true;
FinancialDisplayParameters CostCenterParameter = new FinancialDisplayParameters();
CostCenterParameter.ParameterName = "CostCenter";
CostCenterParameter.Value = vm.CostCenterIds;
CostCenterParameter.IsApplicable = true;
FinancialDisplayParameters DrCrParameter = new FinancialDisplayParameters();
DrCrParameter.ParameterName = "DrCr";
DrCrParameter.Value = vm.DrCr;
DrCrParameter.IsApplicable = true;
FinancialDisplayParameters IsIncludeZeroBalanceParameter = new FinancialDisplayParameters();
IsIncludeZeroBalanceParameter.ParameterName = "IsIncludeZeroBalance";
IsIncludeZeroBalanceParameter.Value = vm.IsIncludeZeroBalance.ToString();
IsIncludeZeroBalanceParameter.IsApplicable = true;
FinancialDisplayParameters IsShowContraAccountParameter = new FinancialDisplayParameters();
IsShowContraAccountParameter.ParameterName = "IsShowContraAccount";
IsShowContraAccountParameter.Value = vm.IsShowContraAccount.ToString();
IsShowContraAccountParameter.IsApplicable = true;
FinancialDisplayParameters IsIncludeOpeningParameter = new FinancialDisplayParameters();
IsIncludeOpeningParameter.ParameterName = "IsIncludeOpening";
IsIncludeOpeningParameter.Value = vm.IsIncludeOpening.ToString();
IsIncludeOpeningParameter.IsApplicable = true;
FinancialDisplayParameters IsShowDetailParameter = new FinancialDisplayParameters();
IsShowDetailParameter.ParameterName = "IsShowDetail";
IsShowDetailParameter.Value = vm.IsShowDetail.ToString();
IsShowDetailParameter.IsApplicable = true;
FinancialDisplayParameters IsFullHierarchyParameter = new FinancialDisplayParameters();
IsFullHierarchyParameter.ParameterName = "IsFullHierarchy";
IsFullHierarchyParameter.Value = vm.IsFullHierarchy.ToString();
IsFullHierarchyParameter.IsApplicable = true;
FinancialDisplayParameters LedgerAccountGroupParameter = new FinancialDisplayParameters();
LedgerAccountGroupParameter.ParameterName = "LedgerAccountGroup";
LedgerAccountGroupParameter.Value = vm.LedgerAccountGroup == null ? null : vm.LedgerAccountGroup.ToString();
LedgerAccountGroupParameter.IsApplicable = true;
FinancialDisplayParameters LedgerAccountParameter = new FinancialDisplayParameters();
LedgerAccountParameter.ParameterName = "LedgerAccount";
LedgerAccountParameter.Value = vm.LedgerAccount == null ? null : vm.LedgerAccount.ToString();
LedgerAccountParameter.IsApplicable = true;
FinancialDisplaySettings.FinancialDisplayParameters = new List <FinancialDisplayParameters>();
FinancialDisplaySettings.FinancialDisplayParameters.Add(SiteParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(DivisionParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(FromDateParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(ToDateParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(CostCenterParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(DrCrParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(IsIncludeZeroBalanceParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(IsShowContraAccountParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(IsIncludeOpeningParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(IsShowDetailParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(IsFullHierarchyParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(LedgerAccountGroupParameter);
FinancialDisplaySettings.FinancialDisplayParameters.Add(LedgerAccountParameter);
System.Web.HttpContext.Current.Session["CurrentSetting"] = FinancialDisplaySettings;
return(FinancialDisplaySettings);
}
public JsonResult FinancialDisplayFill(FinancialDisplayViewModel vm)
{
FinancialDisplaySettings SettingParameter = SetCurrentParameterSettings(vm);
if (vm.ReportType == ReportType_TrialBalance)
{
if (vm.DisplayType == DisplayType_Balance)
{
if (vm.IsShowDetail == true)
{
if (vm.IsFullHierarchy == true)
{
IEnumerable <TrialBalanceViewModel> TrialBalanceDetail = _FinancialDisplayService.GetTrialBalanceDetailWithFullHierarchy(SettingParameter);
if (TrialBalanceDetail != null)
{
JsonResult json = Json(new { Success = true, Data = TrialBalanceDetail.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
else
{
IEnumerable <TrialBalanceViewModel> TrialBalanceDetail = _FinancialDisplayService.GetTrialBalanceDetail(SettingParameter);
if (TrialBalanceDetail != null)
{
JsonResult json = Json(new { Success = true, Data = TrialBalanceDetail.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
}
else
{
IEnumerable <TrialBalanceViewModel> TrialBalance = _FinancialDisplayService.GetTrialBalance(SettingParameter);
if (TrialBalance != null)
{
JsonResult json = Json(new { Success = true, Data = TrialBalance.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
}
else if (vm.DisplayType == DisplayType_Summary)
{
if (vm.IsShowDetail == true)
{
if (vm.IsFullHierarchy == true)
{
IEnumerable <TrialBalanceSummaryViewModel> TrialBalanceSummary = _FinancialDisplayService.GetTrialBalanceDetailSummaryWithFullHierarchy(SettingParameter);
if (TrialBalanceSummary != null)
{
JsonResult json = Json(new { Success = true, Data = TrialBalanceSummary.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
else
{
IEnumerable <TrialBalanceSummaryViewModel> TrialBalanceSummary = _FinancialDisplayService.GetTrialBalanceDetailSummary(SettingParameter);
if (TrialBalanceSummary != null)
{
JsonResult json = Json(new { Success = true, Data = TrialBalanceSummary.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
}
else
{
IEnumerable <TrialBalanceSummaryViewModel> TrialBalanceSummary = _FinancialDisplayService.GetTrialBalanceSummary(SettingParameter);
if (TrialBalanceSummary != null)
{
JsonResult json = Json(new { Success = true, Data = TrialBalanceSummary.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
}
}
else if (vm.ReportType == ReportType_SubTrialBalance)
{
if (vm.DisplayType == DisplayType_Balance)
{
IEnumerable <SubTrialBalanceViewModel> SubTrialBalance = _FinancialDisplayService.GetSubTrialBalance(SettingParameter);
if (SubTrialBalance != null)
{
JsonResult json = Json(new { Success = true, Data = SubTrialBalance.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
else if (vm.DisplayType == DisplayType_Summary)
{
IEnumerable <SubTrialBalanceSummaryViewModel> SubTrialBalanceSummary = _FinancialDisplayService.GetSubTrialBalanceSummary(SettingParameter);
if (SubTrialBalanceSummary != null)
{
JsonResult json = Json(new { Success = true, Data = SubTrialBalanceSummary.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
}
else if (vm.ReportType == ReportType_Ledger)
{
if (vm.LedgerAccount != null)
{
IEnumerable <LedgerBalanceViewModel> LedgerBalance = _FinancialDisplayService.GetLedgerBalance(SettingParameter);
if (LedgerBalance != null)
{
JsonResult json = Json(new { Success = true, Data = LedgerBalance.ToList() }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
}
}
}
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
