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