public void ShowTotalProfits() { var report = new SettlementDao(); var result = report.TotalProfits(); reportSetlementPTotal = new List <ReportSetlementPTotal>(); foreach (System.Data.DataRow rows in result.Rows) { var SettlementPTotal = new ReportSetlementPTotal() { //Profits Profits = Convert.ToDecimal(rows[0]) }; reportSetlementPTotal.Add(SettlementPTotal); } }
//Metodos del reporte public void ShowReport() { var report = new SettlementDao(); var result = report.ShowReport(); reportSetlementVault = new List <ReportSetlementVault>(); foreach (System.Data.DataRow rows in result.Rows) { var SettlementSummary = new ReportSetlementVault() { //Document,Name,LastName,AccountId,LimSaving,Amount,CurrentSaving Document = Convert.ToString(rows[0]), Name = Convert.ToString(rows[1]), LastName = Convert.ToString(rows[2]), AccountId = Convert.ToInt32(rows[3]), LimSaving = Convert.ToDecimal(rows[4]), Amount = Convert.ToDecimal(rows[5]), CurrentSaving = Convert.ToDecimal(rows[6]) }; reportSetlementVault.Add(SettlementSummary); } }