public List <MonthlyFlights> GetMonthlyFlights(string query)
{
List <MonthlyFlights> monthlyFlights = new List <MonthlyFlights>();
try
{
var conn = _dbContext.ConnectToDB();
var rdr = _dbContext.ExecuteQuery(query, conn);
while (rdr.Read())
{
var monthlyFlight = new MonthlyFlights
{
month = rdr.GetInt16(0),
count = rdr.GetInt16(1)
};
monthlyFlights.Add(monthlyFlight);
}
_dbContext.CloseConnections(rdr, conn);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(monthlyFlights);
}
public List <MonthlyFlightsOrigin> GetMonthlyFlightsOrigin()
{
List <MonthlyFlightsOrigin> monthlyFlightsOrigins = new List <MonthlyFlightsOrigin>();
try
{
var conn = _dbContext.ConnectToDB();
var rdr = _dbContext.ExecuteQuery("SELECT origin , MONTH , COUNT(origin) FROM `flights` GROUP BY origin , MONTH ORDER BY origin , month ASC", conn);
int i = 0;
int j = 0;
while (rdr.Read() && j < 3)
{
var monthlyFlightOrigin = new MonthlyFlightsOrigin();
monthlyFlightOrigin.origin = rdr.GetString(0);
var monthlyFlights = new List <MonthlyFlights>();
do
{
var monthlyFlight = new MonthlyFlights
{
month = rdr.GetInt16(1),
count = rdr.GetInt16(2)
};
monthlyFlights.Add(monthlyFlight);
i++;
} while (rdr.Read() && i < 11);
var monthlyFlight1 = new MonthlyFlights
{
month = rdr.GetInt16(1),
count = rdr.GetInt16(2)
};
monthlyFlights.Add(monthlyFlight1);
i = 0;
monthlyFlightOrigin.monthlyFlights = monthlyFlights;
monthlyFlightsOrigins.Add(monthlyFlightOrigin);
j++;
}
_dbContext.CloseConnections(rdr, conn);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(monthlyFlightsOrigins);
}
