public FuelItem[] getFuelLevel()
{
dbConnection.Open();
FuelItem[] arr = new FuelItem[2];
SQLiteCommand command = new SQLiteCommand("select fueltype,volume from tank", dbConnection);
SQLiteDataReader myReader = command.ExecuteReader();
int i = 0;
while (myReader.Read())
{
string fuel=myReader["fueltype"].ToString();
arr[i] = new FuelItem(fuel, myReader.GetFloat(1));
i++;
}
dbConnection.Close();
return arr;
}
public FuelItem[] getFuelOrders()
{
dbConnection.Open();
FuelItem[] arr = new FuelItem[30];
SQLiteCommand command = new SQLiteCommand("select date, fueltype, volume,cost from fuelorders", dbConnection);
SQLiteDataReader myReader = command.ExecuteReader();
int i = 0;
while (myReader.Read())
{
DateTime date = DateTime.Parse(myReader["date"].ToString());
if (date <= DateTime.Now.AddDays(-7))
continue;
string fuel = myReader["fueltype"].ToString();
arr[i] = new FuelItem(fuel, myReader.GetFloat(2), myReader.GetFloat(3), date);
i++;
}
dbConnection.Close();
return arr;
}
public FuelItem[] getSaleData()
{
dbConnection.Open();
FuelItem[] arr = new FuelItem[7];
SQLiteCommand command = new SQLiteCommand("select * from fuelsale", dbConnection);
SQLiteDataReader myReader = command.ExecuteReader();
int i = 0;
while (myReader.Read())
{
//date,volunleaded,voldiesel,saleunleaded,salediesel
DateTime date = DateTime.Parse(myReader["date"].ToString());
if (date <= DateTime.Now.AddDays(-7))
continue;
arr[i] = new FuelItem("unleaded", myReader.GetFloat(1), myReader.GetFloat(3), date);
arr[i + 1] = new FuelItem("diesel", myReader.GetFloat(2), myReader.GetFloat(4), date);
i = i+ 2;
}
dbConnection.Close();
return arr;
}
public Tuple(int pos, FuelItem fuel)
{
this.Pos = pos;
this.Fuel = fuel;
}
