static void updateMini(MiniVehicle mini, int vID) { try { mini.validateEntry(); SqlCommand cmd = new SqlCommand("UPDATE Vehicle SET fuelType = @fuelType, vehicleMake =@vehicleMake , vehicleType=@vehicleType , noOfKiloMeters =@noOfKM WHERE vehicleID = @vehicleID;" + "UPDATE Mini SET seatingCapacity = @seatCap WHERE vehicleID = @vehicleID;" + "UPDATE Bill SET billAmount = @billAmount WHERE vehicleID = @vehicleID;", con); cmd.Parameters.AddWithValue("@vehicleID", vID); cmd.Parameters.AddWithValue("@fuelType", mini.getFuelType()); cmd.Parameters.AddWithValue("@vehicleMake", mini.getVehicleMake()); cmd.Parameters.AddWithValue("@vehicleType", mini.getVehicleType()); cmd.Parameters.AddWithValue("@noOfKM", mini.getNoOfKiloMeters()); cmd.Parameters.AddWithValue("@seatCap", mini.getSeatingCapacity()); cmd.Parameters.AddWithValue("@billAmount", mini.calculateBill()); con.Open(); if (cmd.ExecuteNonQuery() != 0) { Console.WriteLine("\nThe Vehicle updated successfully."); } else { throw new Exception(); } } catch (Exception e) { Console.WriteLine("\nVehicle details not updated."); Console.WriteLine(e.Message); } finally { con.Close(); } }
static void addToDBMini(MiniVehicle mini) { try { mini.validateEntry(); SqlCommand cmd = new SqlCommand("INSERT INTO Vehicle VALUES (@fuelType, @vehicleMake, @vehicleType, @noOfKM);" + "INSERT INTO Mini VALUES(IDENT_CURRENT('Vehicle'), @seatCap);" + "INSERT INTO Bill(vehicleID, billAmount) VALUES(IDENT_CURRENT('Vehicle'), @billAmount);", con); cmd.Parameters.AddWithValue("@fuelType", mini.getFuelType()); cmd.Parameters.AddWithValue("@vehicleMake", mini.getVehicleMake()); cmd.Parameters.AddWithValue("@vehicleType", mini.getVehicleType()); cmd.Parameters.AddWithValue("@noOfKM", mini.getNoOfKiloMeters()); cmd.Parameters.AddWithValue("@seatCap", mini.getSeatingCapacity()); cmd.Parameters.AddWithValue("@billAmount", mini.calculateBill()); con.Open(); if (cmd.ExecuteNonQuery() != 0) { Console.WriteLine("\nThe Vehicle added successfully."); } else { throw new Exception(); } } catch (Exception e) { Console.WriteLine("\nVehicle Not Added."); Console.WriteLine(e.Message); } finally { con.Close(); } }