public List <AccountHeadDto> GetJournalLedgers() { RefMaster rm = _dbContext.RefMasters.ToList().Find(r => r.RefMasterCode.ToUpper() == "AHTYPE"); RefValueMaster rvm = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "ASSETS"); List <AccountHead> accountheads = _dbContext.AccountHeads.ToList(); List <AccountHead> ahs = (List <AccountHead>)(from l3 in accountheads from l4 in accountheads from l5 in accountheads where l3.AHID == l4.ParentAHID && l4.AHID == l5.ParentAHID && l3.AHName.ToUpper() == "CLOSING BALANCES" && l3.AHType == rvm.RefID select l5).ToList(); var b = from ah in accountheads where !(from o in ahs select o.AHID) .Contains(ah.AHID) && ah.AHLevel > 4 select ah; List <AccountHeadDto> lstResult = new List <AccountHeadDto>(); foreach (var a in b) { lstResult.Add(new AccountHeadDto() { AHCode = a.AHCode, AHID = a.AHID, AHLevel = a.AHLevel, AHType = a.AHType, AHName = a.AHName, IsFederation = a.IsFederation, ParentAHID = a.ParentAHID.HasValue ? a.ParentAHID.Value : 0 }); } return(lstResult); }
public ActionResult IncomeAndExpenditure_Group() { ReportsDal objDal = new ReportsDal(); List <TrialBalanceDto> lstRecords = objDal.GetAllTrialBalanceReport_Group(GroupInfo.GroupID); 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("IncomeAndExpenditure")); }
public List <ReceiptTranscationDto> GetReceiptAccountHeads(bool isFederation) { RefMaster rm = _dbContext.RefMasters.ToList().Find(r => r.RefMasterCode.ToUpper() == "AHTYPE"); RefValueMaster rvm = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == Enums.AccountTypes.EXPENDITURE.ToString()); List <AccountHead> accountheads = _dbContext.AccountHeads.ToList(); var accountHeads = _dbContext.AccountHeads.ToList().FindAll(f => f.AHLevel > 4 && f.IsMemberTransaction && f.IsFederation == isFederation && f.AHType != rvm.RefID); List <ReceiptTranscationDto> accountHeadsDto = new List <ReceiptTranscationDto>(); var raps = _dbContext.ReceiptAppropriationPriorities.ToList().FindAll(f => f.StatusId == 1 && f.IsGroup != isFederation); var result = from ah in accountHeads from rap in raps where rap.AHID == ah.AHID select new { ah.AHID, ah.AHCode, ah.AHName, ah.OpeningBalance, rap.Priority }; var result2 = result.OrderBy(o => o.Priority); foreach (var Ac in result2) { accountHeadsDto.Add(new ReceiptTranscationDto() { AHID = Ac.AHID, AHCode = Ac.AHCode, AHName = Ac.AHName, OpeningBalance = Convert.ToDecimal(Ac.OpeningBalance) }); } return(accountHeadsDto); }
public AccountHeadDto GetCashInHandAccount(bool isFederation) { RefMaster rm = _dbContext.RefMasters.ToList().Find(r => r.RefMasterCode.ToUpper() == "AHTYPE"); RefValueMaster rvm = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "ASSETS"); List <AccountHead> lstAccountHeadDtos = _dbContext.AccountHeads.ToList(); #region recent oldcode /* * var ahlevel1 = lstAccountHeadDtos.FindAll(l => l.ParentAHID == 0 || l.ParentAHID == null); * var assetparent = ahlevel1.Find(l => l.AHCode.ToUpper() == "ASSETS"); * var ahlevl2 = lstAccountHeadDtos.Find(l => l.ParentAHID == assetparent.AHID && l.AHCode.ToUpper() == "CLOSING BALANCES"); * var ahlevl3 = lstAccountHeadDtos.Find(l => l.ParentAHID == ahlevl2.AHID && l.AHCode.ToUpper() == "CASH AND BANK"); * var ahlevel4 = lstAccountHeadDtos.Find(l => l.ParentAHID == ahlevl3.AHID && l.AHCode.ToUpper() == "CASH IN HAND" && isFederation); * var a = lstAccountHeadDtos.Find(l => l.ParentAHID == ahlevel4.AHID && l.AHCode.ToUpper() == "CASH IN HAND" && l.IsFederation == isFederation); */ #endregion recent oldcode var CashinhandValueFromSettings = _dbContext.SystemSettings.ToList().Find(l => l.SettingName == "GROUP_CASHINHAND"); var CashinHandAccountHead = lstAccountHeadDtos.Find(l => l.AHID == Convert.ToInt32(CashinhandValueFromSettings.SettingValue)); return(new AccountHeadDto() { AHCode = CashinHandAccountHead.AHCode, AHID = CashinHandAccountHead.AHID, AHLevel = CashinHandAccountHead.AHLevel, AHType = CashinHandAccountHead.AHType, AHName = CashinHandAccountHead.AHName, IsFederation = CashinHandAccountHead.IsFederation, ParentAHID = CashinHandAccountHead.ParentAHID.HasValue ? CashinHandAccountHead.ParentAHID.Value : 0 }); }
public ActionResult BalanceSheet_Group() { ReportsDal objDal = new ReportsDal(); List <TrialBalanceDto> lstRecords = objDal.GetAllTrialBalanceReport_Group(GroupInfo.GroupID); 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 = Credit2 - Debit2; return(View("BalanceSheet")); }
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 ExportsReports_Group() { ReportsDal objDal = new ReportsDal(); OrganizationService objIOrganizationService = new OrganizationService(); OrganizationDto organizationDto = objIOrganizationService.GetAll(); List <TrialBalanceDto> lstRecords = objDal.GetAllTrialBalanceReport_Group(GroupInfo.GroupID); 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 = lstExpenditure.Count > lstIncomes.Count ? lstExpenditure.Count : lstIncomes.Count; List <IncomeAndExpenditureModel> reportData = new List <IncomeAndExpenditureModel>(); for (int idx = 0; idx < recordCount; idx++) { TrialBalanceDto objAsset = lstIncomes.Count > idx ? lstIncomes[idx] : null; TrialBalanceDto objLiability = lstExpenditure.Count > idx ? lstExpenditure[idx] : null; IncomeAndExpenditureModel objIncomeAndExpenditureModel = new IncomeAndExpenditureModel(); objIncomeAndExpenditureModel.OrgName = organizationDto.OrgName; objIncomeAndExpenditureModel.OrgAddress = organizationDto.Address; if (objAsset != null) { objIncomeAndExpenditureModel.Income_AHCode = objAsset.Ahcode; objIncomeAndExpenditureModel.Income_AHName = objAsset.Accounthaedname; objIncomeAndExpenditureModel.Income_CrAmount = objAsset.Credit3; objIncomeAndExpenditureModel.Income_DrAmount = objAsset.Debit3; } if (objLiability != null) { objIncomeAndExpenditureModel.Expenditure_AHCode = objLiability.Ahcode; objIncomeAndExpenditureModel.Expenditure_AHName = objLiability.Accounthaedname; objIncomeAndExpenditureModel.Expenditure_CrAmount = objLiability.Credit3; objIncomeAndExpenditureModel.Expenditure_DrAmount = objLiability.Debit3; } reportData.Add(objIncomeAndExpenditureModel); } double incomeSum = reportData.Sum(l => l.Income_CrAmount - l.Income_DrAmount); double expenditureSum = reportData.Sum(l => l.Expenditure_DrAmount - l.Expenditure_CrAmount); reportData.ForEach(l => l.Expenditure_Sum = expenditureSum); reportData.ForEach(l => l.Income_Sum = incomeSum); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/Reports/FinancialRports/IncomeAndExpenditure.rpt")); rd.SetDataSource(reportData); 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", "IncomeAndExpenditure.pdf")); }
public List <AccountHeadDto> GetReceiptSavingAccountHeads(bool isFederation) { List <AccountHeadDto> lstSavingHeads = new List <AccountHeadDto>(); List <AccountHead> lstHeads = new List <AccountHead>(); RefMaster rm = _dbContext.RefMasters.ToList().Find(r => r.RefMasterCode.ToUpper() == "AHTYPE"); RefValueMaster rvm = _dbContext.RefValueMasters.ToList().Find(f => f.RefMasterID == rm.RefMasterID && f.RefCode.ToUpper() == "LIABILITIES"); var liabilities = _dbContext.AccountHeads.ToList().FindAll(f => f.AHType == rvm.RefID); var savings = liabilities.Find(l => l.AHCode.ToUpper() == "DEPOSITS"); var result = from l2 in liabilities from l3 in liabilities from l4 in liabilities where l2.AHID == l3.ParentAHID && l3.AHID == l4.ParentAHID && l4.AHLevel == 5 select l4; var result2 = from l2 in liabilities from l3 in liabilities from l4 in liabilities from l5 in liabilities where l2.AHID == l3.ParentAHID && l3.AHID == l4.ParentAHID && l4.AHID == l5.ParentAHID && l5.AHLevel == 5 select l5; lstHeads.AddRange(result); lstHeads.AddRange(result2); foreach (var item in lstHeads) { AccountHeadDto dto = new AccountHeadDto() { AHID = item.AHID, AHCode = item.AHCode, AHName = item.AHName }; lstSavingHeads.Add(dto); } return(lstSavingHeads); }