public void ShowTotalEvent(String EventId)
{
var report = new EventsDao();
var result = report.ShowTotal(Convert.ToInt32(EventId));
ReportTotalEvents = new List <ReportTotalEvents>();
foreach (System.Data.DataRow rows in result.Rows)
{
var ReportTotal = new ReportTotalEvents()
{
Total = Convert.ToDecimal(rows[0])
};
ReportTotalEvents.Add(ReportTotal);
}
}
public void ShowBinnacle(string EventId)
{
var report = new EventsDao();
var result = report.ShowBinnacle(Convert.ToInt32(EventId));
ReportBinnacleEvent = new List <ReportBinnacleEvent>();
foreach (System.Data.DataRow rows in result.Rows)
{
var SummaryBinnacle = new ReportBinnacleEvent()
{
//Id,EventId,Description,DateBinnacle,Spending,AmountEvent
Id = Convert.ToInt32(rows[0]),
EventId = Convert.ToInt32(rows[1]),
Description = Convert.ToString(rows[2]),
DateBinnacle = Convert.ToDateTime(rows[3]),
Spending = Convert.ToString(rows[4]),
AmountEvent = Convert.ToDecimal(rows[5])
};
ReportBinnacleEvent.Add(SummaryBinnacle);
}
}
//Metodos Reporte
public void ShowReport(string EventId)
{
var report = new EventsDao();
var result = report.ShowReport(Convert.ToInt32(EventId));
ReportSettlementEvent = new List <ReportSettlementEvent>();
foreach (System.Data.DataRow rows in result.Rows)
{
var ReportSettlement = new ReportSettlementEvent()
{
//Id,EventId,Document,Name,LastName,AccountId,Profits
Id = Convert.ToInt32(rows[0]),
EventId = Convert.ToInt32(rows[1]),
Document = Convert.ToString(rows[2]),
Name = Convert.ToString(rows[3]),
LastName = Convert.ToString(rows[4]),
AccountId = Convert.ToInt32(rows[5]),
Profits = Convert.ToDecimal(rows[6])
};
ReportSettlementEvent.Add(ReportSettlement);
}
}