/**
* Class constructor specifying name of make (manufacturer), model and year
* of make.
* @param manufacturer
* @param model
* @param makeYear
*/
public Vehicle(String manufacturer, String model, int makeYear)
{
this.manufacturer = manufacturer;
this.model = model;
this.makeYear = makeYear;
fuelPurchase = new FuelPurchase();
}
protected Boolean validFuelPurchase; //input check
public AddFuelRecordsWindow(int vehicleID)
{
InitializeComponent();
this.F = new FuelPurchase(0, 1.0, DateTime.Now, DateTime.Now, vehicleID); //Random fuelPurchase
saveState = false; //when window constructed has not been saved yet
validFuelPurchase = true;
}
private void DeleteVehicleBtn_Click(object sender, RoutedEventArgs e)
{
IList iL = DisplayLvw.SelectedItems; //selected items from list view (vehicles)
if (iL.Count == 1) //Only proceed if theere is a single selection
{
beforeEffects();
DeleteVehiclesWindow deleteVehiclesWin = new DeleteVehiclesWindow("Standard"); //Delete vehicle verification using standard proceedure (message)
deleteVehiclesWin.ShowDialog();
if (deleteVehiclesWin.deletionVerified()) //Check that the user said Yes to the delete action!
{
//Removal of the selected vehicle
int vId = ((Vehicle)iL[0]).getVehicleID(); //Get the id
vehicles.Remove(iL[0]); //remove the object from vehicles
allServices = Service.RemoveServices(allServices, vId); //Remove the services for that vehicle id
allJournies = Journey.RemoveJournies(allJournies, vId); //Remove the journies for that vehicle id
allFuelPurchases = FuelPurchase.RemoveFuelPurchases(allFuelPurchases, vId); //Remove the fuelPurchases for that vehicle id
}
afterEffects();
}
else
{
MessageBox.Show("Select a single vehicle to delete");
}
}
protected Boolean validFuel; //input check
public EditFuelRecordsWindow(FuelPurchase fuelPurchase)
{
InitializeComponent();
this.F = fuelPurchase;
saveState = false; //when window constructed has not been saved yet
validFuel = true; //TODO code for this
displayFuel();
}
/// <summary>
/// Class constructor specifying name of Manufacturer, Model, MakeYear, RegistrationNumber, OdometerReading,
/// TankCapacity, lastServiceOdometerKm
/// </summary>
/// <param name="Manufacturer"></param>
/// <param name="Model"></param>
/// <param name="MakeYear"></param>
/// <param name="RegistrationNumber"></param>
/// <param name="OdometerReading"></param>
/// <param name="TankCapacity"></param>
/// <param name="lastServiceOdometerKm"></param>
public Vehicle(string Manufacturer, string Model, int MakeYear, string RegistrationNumber, double OdometerReading, double TankCapacity, double lastServiceOdometerKm)
{
this.Manufacturer = Manufacturer;
this.Model = Model;
this.MakeYear = MakeYear;
this.RegistrationNumber = RegistrationNumber;
this.OdometerReading = OdometerReading;
this.TankCapacity = TankCapacity;
FuelPurchase = new FuelPurchase();
Journey = new Journey();
Service = new Service(lastServiceOdometerKm);
}
//FUEL PURCHASES ADD EDIT DELETE
private void AddFuelPurchasesBtn_Click(object sender, RoutedEventArgs e)
{
beforeEffects();
AddFuelRecordsWindow addFuelWin = new AddFuelRecordsWindow(vehicleID);
addFuelWin.ShowDialog();
if (addFuelWin.getSaveState() && addFuelWin.getValidity())
{
FuelPurchase F = addFuelWin.getFuelPurchase(); // Get the new Fuel
FPurchases.Add(F); // Add to the list
allFuelPurchases.Add(F); //Add to the list of all fuel purchases
Console.WriteLine(" Fuel Purchase Added");
}
afterEffects();
}
public HistoryWindow(int vehicleID, List <Service> allServices, List <Journey> allJournies, List <FuelPurchase> allFuelPurchases)
{
InitializeComponent();
this.vehicleID = vehicleID;
this.Title = "History of Vehicle ID: " + vehicleID;
// the journeys of the car
this.allJournies = allJournies;
this.journies = Journey.FindJournies(allJournies, vehicleID);
// services of the car
this.allServices = allServices;
this.services = Service.FindServices(allServices, vehicleID);
//Fuel Purchase of the car
this.allFuelPurchases = allFuelPurchases;
this.FPurchases = FuelPurchase.FindFuelPurchases(allFuelPurchases, vehicleID);
this.DataContext = this; formatDates("{0:dd/MM/yyyy}"); performRefresh(); //Binding
}
private void UpdateFuel()
{
validFuel = true;
int amount;
double price;
try
{
amount = System.Convert.ToInt32(AmountTxt.Text);
price = System.Convert.ToDouble(PriceTxt.Text);
}
catch
{
Console.WriteLine("Error reading numeric values!");
validFuel = false; //Due to likely poor data entry
return;
}
F = new FuelPurchase(amount, price, F.getDatecreated(), DateTime.Now, F.getVehicleID()); //New fuelpurchase with all of the information!
}
private void EditFuelPurchasesBtn_Click(object sender, RoutedEventArgs e)
{
IList iL = FuelPurchasesDisplayLvw.SelectedItems; //select items (fuel purchases)
if (iL.Count == 1)
{
beforeEffects();
EditFuelRecordsWindow editFuelRecordsWin = new EditFuelRecordsWindow((FuelPurchase)iL[0]);
editFuelRecordsWin.ShowDialog();
// Check if saved or not
if (editFuelRecordsWin.getSaveState() && editFuelRecordsWin.getValidity()) //if a purchase was saved
{
FuelPurchase F = editFuelRecordsWin.getFuelPurchase(); // Get the saved purchase
FPurchases[FPurchases.IndexOf((FuelPurchase)iL[0])] = F; // Overide the fuel purchase at the editted location
allFuelPurchases[allFuelPurchases.IndexOf((FuelPurchase)iL[0])] = F; //Overide the service in all fuel purchases!
Console.WriteLine(" Fuel Edited");
}
afterEffects();
}
else
{
MessageBox.Show(" Select a single Fuel Record to edit");
}
}
/// <summary>
/// Add Fuel and Price to FuelPurchase class
/// </summary>
/// <param name="litres"></param>
/// <param name="price"></param>
public void AddFuel(double litres, double price)
{
FuelPurchase.PurchaseFuel(litres, price);
}
//Load All() Gets everything in the Sql
public static Object[] LoadAll(String conStr)
{
String p1, p2, p3, p4, p5, p6, p7;
DataTable table;
MySqlDataAdapter adapter;
MySqlCommand cmd;
try
{
//Create the connection
using (MySqlConnection con = new MySqlConnection(conStr))
{
con.Open(); //Open
//Vehicle data
List <Vehicle> vehicleData = new List <Vehicle>(); //fresco
table = new DataTable(); //new table
cmd = new MySqlCommand("SELECT * FROM `vehicles`", con); //get table command
adapter = new MySqlDataAdapter(cmd);
adapter.Fill(table); //fill table
Vehicle v;
foreach (DataRow row in table.Rows) //go through table rows
{
Object[] arr = row.ItemArray; //get row as objects
v = new Vehicle((int)arr[1], arr[3].ToString(), arr[2].ToString(), (int)arr[4], (int)arr[5], arr[6].ToString(), (int)arr[7]); //new vehicle
vehicleData.Add(v);
}
//Service Data
List <Service> serviceData = new List <Service>(); //new list
table = new DataTable(); // new table
cmd = new MySqlCommand("SELECT * FROM `services`", con); // get tabl;e command
adapter = new MySqlDataAdapter(cmd);
adapter.Fill(table); //fill the table
Service s;
foreach (DataRow row in table.Rows) //going through table rows
{
Object[] arr = row.ItemArray; // get row as obects
s = new Service((int)arr[1], (int)arr[2], (int)arr[3], (DateTime)arr[4], (DateTime)arr[5], (DateTime)arr[6]);
serviceData.Add(s);
}
//Journey Data
List <Journey> journeyData = new List <Journey>();
table = new DataTable();
cmd = new MySqlCommand("SELECT * FROM `journies`", con);
adapter = new MySqlDataAdapter(cmd);
adapter.Fill(table); //fill the table
Journey j;
foreach (DataRow row in table.Rows)
{
Object[] arr = row.ItemArray;
Boolean paid = (((int)arr[6]) == 1); //convert to boolean
j = new Journey((int)arr[2], (DateTime)arr[3], (DateTime)arr[4], (DateTime)arr[5], (int)arr[1], paid);
journeyData.Add(j);
}
//Fuel Data
List <FuelPurchase> fuelData = new List <FuelPurchase>();
table = new DataTable();
cmd = new MySqlCommand("SELECT * FROM `fuelpurchases`", con);
adapter = new MySqlDataAdapter(cmd);
adapter.Fill(table); //fill the table
FuelPurchase fp;
foreach (DataRow row in table.Rows)
{
Object[] arr = row.ItemArray;
fp = new FuelPurchase((int)arr[2], (double)arr[3], (DateTime)arr[4], (DateTime)arr[5], (int)arr[1]);
fuelData.Add(fp);
}
con.Close(); //Close
return(new Object[] { vehicleData, serviceData, journeyData, fuelData });
}
} catch (Exception mse) { Console.WriteLine(mse.ToString()); Console.WriteLine("Error SQL"); return(null); }
}
