/** * 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); } }