public BalanceSheetControl(BalanceSheetModel model)
{
InitializeComponent();
_presenter = new BalanceSheetPresenter(this, model);
this.Load += BalanceSheetControl_Load;
}
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 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 = lstLiabilities.Count > lstAssets.Count ? lstLiabilities.Count : lstAssets.Count;
List <BalanceSheetModel> reportData = new List <BalanceSheetModel>();
for (int idx = 0; idx < recordCount; idx++)
{
TrialBalanceDto objAsset = lstAssets.Count > idx ? lstAssets[idx] : null;
TrialBalanceDto objLiability = lstLiabilities.Count > idx ? lstLiabilities[idx] : null;
BalanceSheetModel objBalanceSheetModel = new BalanceSheetModel();
objBalanceSheetModel.OrgName = organizationDto.OrgName;
objBalanceSheetModel.OrgAddress = organizationDto.Address;
if (objAsset != null)
{
objBalanceSheetModel.Asset_AHCode = objAsset.Ahcode;
objBalanceSheetModel.Asset_AHName = objAsset.Accounthaedname;
objBalanceSheetModel.Asset_CrAmount = objAsset.Credit3;
objBalanceSheetModel.Asset_DrAmount = objAsset.Debit3;
}
if (objLiability != null)
{
objBalanceSheetModel.Liability_AHCode = objLiability.Ahcode;
objBalanceSheetModel.Liability_AHName = objLiability.Accounthaedname;
objBalanceSheetModel.Liability_CrAmount = objLiability.Credit3;
objBalanceSheetModel.Liability_DrAmount = objLiability.Debit3;
}
reportData.Add(objBalanceSheetModel);
}
double assetSum = reportData.Sum(l => l.Asset_DrAmount - l.Asset_CrAmount);
double liabilitySum = reportData.Sum(l => l.Liability_CrAmount - l.Liability_DrAmount);
reportData.ForEach(l => l.Liability_Sum = liabilitySum);
reportData.ForEach(l => l.Asset_Sum = assetSum);
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("~/Reports/FinancialRports/BalanceSheet.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", "BalanceSheet.pdf"));
}
private bool FilterData(BalanceSheetModel o)
{
if (FilterKonto != null && FilterName == null)
{
return(o.Konto.StartsWith(FilterKonto));
}
else if (FilterKonto == null && FilterName != null)
{
return(o.Opis.ToUpper().Contains(FilterName.ToUpper()));
}
else if (FilterKonto != null && FilterName != null)
{
return(o.Opis.ToUpper().Contains(FilterName.ToUpper()) && o.Konto.StartsWith(FilterKonto));
}
else
{
return(true);
}
}
public async Task <BalanceSheetMainReportDto> GetBalanceSheetReportAsync(BalanceSheetModel model)
{
var pageResult = await _reportManager.GetBalanceSheetReportAsync(model);
return(pageResult);
}
