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; }