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 IncomeAndExpenditure()
{
TrialBalanceController TBC = new TrialBalanceController();
List <TrialBalanceDto> lstRecords = TBC.GetAllTrialBalanceReport_Group();
RefMaster rm = _dbContext.RefMasters.ToList().Find(r => r.RefMasterCode.ToUpper() == "AHTYPE");
RefValueMaster rvmIncomes = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "INCOME");
RefValueMaster rvmExpenditure = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "EXPENDITURE");
List <TrialBalanceDto> lstIncomes = lstRecords.FindAll(l => l.AhType == rvmIncomes.RefID);
List <TrialBalanceDto> lstExpenditure = lstRecords.FindAll(l => l.AhType == rvmExpenditure.RefID);
int RecordCount = lstRecords.Count > lstExpenditure.Count ? lstRecords.Count : lstExpenditure.Count;
ViewBag.RecordCount = RecordCount;
ViewBag.Incomes = lstIncomes;
ViewBag.Expenditure = lstExpenditure;
var Debit1 = lstIncomes.Sum(l => l.Debit3);
var Credit1 = lstIncomes.Sum(l => l.Credit3);
ViewBag.TotalIncomesBalance = Debit1 + Credit1;
var Debit2 = lstExpenditure.Sum(M => M.Debit3);
var Credit2 = lstExpenditure.Sum(M => M.Credit3);
ViewBag.TotalExpenditurebalance = Debit2 + Credit2;
return(View());
}
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());
}
