public List <ReportModelT> GetReportsT(Models.ReportModelT model)
{
if (model.linput == null || model.rinput == null)
{
List <ReportModelT> rist = new List <ReportModelT>();
rist.Add(new ReportModelT());
rist[0].TransactionId = -1;
return(rist);
}
string dateFrom = model.linput.ToString();
dateFrom += " 00:00:01";
string dateTo = model.rinput.ToString();
dateTo += " 23:59:59";
List <ReportModelT> list = SubReportsT(dateFrom, dateTo);
//list.Add(SubReports());
dateFrom = "\'" + dateFrom + "\'";
dateTo = "\'" + dateTo + "\'";
using (MySqlConnection conn = GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from Ticket_Purchase where Purchase_Date BETWEEN " + dateFrom + " AND " + dateTo, conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new ReportModelT
{
TransactionId = Convert.ToInt32(reader["Transaction_Id"]),
CustomerId = Convert.ToInt32(reader["Customer_Id"]),
TicketId = Convert.ToInt32(reader["Ticket_Id"]),
Price = (float)reader["Price"],
ExpirationDate = Convert.ToDateTime(reader["Expiration_Date"]),
PurchaseDate = Convert.ToDateTime(reader["Purchase_Date"]),
});
}
return(list);
}
}
}
public IActionResult ReportT(Models.ReportModelT model)
{
Models.ReportContext context = HttpContext.RequestServices.GetService(typeof(Models.ReportContext)) as Models.ReportContext;
return(View(context.GetReportsT(model)));
}
