public ActionResult ExportsReports() { TrialBalanceController TBC = new TrialBalanceController(); List <TrialBalanceDto> lstRecords = TBC.GetAllTrialBalanceReport(); RefMaster rm = _dbContext.RefMasters.ToList().Find(r => r.RefMasterCode.ToUpper() == "AHTYPE"); RefValueMaster rvmAssets = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "ASSETS"); RefValueMaster rvmLiabilities = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "LIABILITIES"); List <TrialBalanceDto> lstAssets = lstRecords.FindAll(l => l.AhType == rvmAssets.RefID); List <TrialBalanceDto> lstLiabilities = lstRecords.FindAll(l => l.AhType == rvmLiabilities.RefID); var Debit1 = lstAssets.Sum(l => l.Debit3); var Credit1 = lstAssets.Sum(l => l.Credit3); var Debit2 = lstLiabilities.Sum(M => M.Debit3); var Credit2 = lstLiabilities.Sum(M => M.Credit3); BalanceSheetDto lst = new BalanceSheetDto(); lst.lstAssects = lstAssets; lst.lstLiabilities = lstLiabilities; lst.Debit1 = Debit1; lst.Credit1 = Credit1; lst.Debit2 = Debit2; lst.Credit2 = Credit2; ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/Reports/FinancialRports/BalanceSheet.rpt")); rd.SetDataSource(lst); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "BalanceSheet.pdf")); }
public ActionResult BalanceSheet() { TrialBalanceController TBC = new TrialBalanceController(); List <TrialBalanceDto> lstRecords = TBC.GetAllTrialBalanceReport(); RefMaster rm = _dbContext.RefMasters.ToList().Find(r => r.RefMasterCode.ToUpper() == "AHTYPE"); RefValueMaster rvmAssets = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "ASSETS"); RefValueMaster rvmLiabilities = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "LIABILITIES"); List <TrialBalanceDto> lstAssets = lstRecords.FindAll(l => l.AhType == rvmAssets.RefID); List <TrialBalanceDto> lstLiabilities = lstRecords.FindAll(l => l.AhType == rvmLiabilities.RefID); int RecordCount = lstRecords.Count > lstLiabilities.Count ? lstRecords.Count : lstLiabilities.Count; ViewBag.RecordCount = RecordCount; ViewBag.Assets = lstAssets; ViewBag.Liabilities = lstLiabilities; var Debit1 = lstAssets.Sum(l => l.Debit3); var Credit1 = lstAssets.Sum(l => l.Credit3); ViewBag.TotalAssetsBalance = Debit1 + Credit1; var Debit2 = lstLiabilities.Sum(M => M.Debit3); var Credit2 = lstLiabilities.Sum(M => M.Credit3); ViewBag.TotalLiabilitiesbalance = Debit2 + Credit2; return(View()); }