/// <summary> /// Richard Carroll /// Created: 3/1/19 /// /// Takes a Vehicle argument and uses it for parameters /// in a stored procedure for Inserting a GuestVehicle /// and calls the Stored Procedure /// Returns the number of rows affected. /// </summary> public int InsertGuestVehicle(GuestVehicle vehicle) { int rowsAffected = 0; var conn = DBConnection.GetDbConnection(); var cmdText = "sp_insert_guest_vehicle"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@GuestID", vehicle.GuestID); cmd.Parameters.AddWithValue("@Make", vehicle.Make); cmd.Parameters.AddWithValue("@Model", vehicle.Model); cmd.Parameters.AddWithValue("@PlateNumber", vehicle.PlateNumber); cmd.Parameters.AddWithValue("@Color", vehicle.Color); cmd.Parameters.AddWithValue("@ParkingLocation", vehicle.ParkingLocation); try { conn.Open(); rowsAffected = cmd.ExecuteNonQuery(); } catch (Exception) { throw; } return(rowsAffected); }
public void TestUpdateVehicleInvalidMakeBlank() { //I am assuming that during an update, the first(old) //vehicle will be valid, as it was taken from the //database and before that, inserted through this //same validation. guestVehicle = new GuestVehicle() { GuestID = 100001, Make = "Ford", Model = "Focus", PlateNumber = "789 ACE", Color = "Silver", ParkingLocation = "Over thar, yonder" }; newGuestVehicle = new GuestVehicle() { GuestID = 100001, Make = "", Model = "Caravan", PlateNumber = "123 ABC", Color = "White", ParkingLocation = "Out Back" }; guestVehicleManager.UpdateGuestVehicle(guestVehicle, newGuestVehicle); }
public int UpdateGuestVehicle(GuestVehicle oldVehicle, GuestVehicle vehicle) { int result = 0; VMGuestVehicle oldVMVehicle = new VMGuestVehicle() { GuestID = oldVehicle.GuestID, Make = oldVehicle.Make, Model = oldVehicle.Model, PlateNumber = oldVehicle.PlateNumber, Color = oldVehicle.Color, ParkingLocation = oldVehicle.ParkingLocation }; VMGuestVehicle newVMVehicle = new VMGuestVehicle() { GuestID = vehicle.GuestID, Make = vehicle.Make, Model = vehicle.Model, PlateNumber = vehicle.PlateNumber, Color = vehicle.Color, ParkingLocation = vehicle.ParkingLocation }; for (int i = 0; i < vehicles.Count; i++) { VMGuestVehicle currentVehicle = vehicles[i]; if (currentVehicle.Equals(oldVMVehicle)) { vehicles[i] = newVMVehicle; ++result; } } return(result); }
/// <summary author="Richard Carroll" created="2019/03/08"> /// Takes two Vehicle arguments and passes them to the /// Data Access Layer which attempts to update the Vehicle. /// Returns the result. /// </summary> public bool UpdateGuestVehicle(GuestVehicle oldVehicle, GuestVehicle vehicle) { bool result = false; try { if (vehicle.isValid()) { if (oldVehicle.isValid()) { result = 1 == _guestVehicleAccessor.UpdateGuestVehicle(oldVehicle, vehicle); } else { throw new ArgumentException("Data for this Vehicle is Invalid: \n" + oldVehicle.ToString()); } } else { throw new ArgumentException("Data for this Vehicle is Invalid: \n" + vehicle.ToString()); } } catch (Exception ex) { ExceptionLogManager.getInstance().LogException(ex); throw ex; } return(result); }
public void TestCreateGuestVehicleInvalidMakeNull() { guestVehicle = new GuestVehicle() { GuestID = 100001, Make = null, Model = "Caravan", PlateNumber = "123 ABC", Color = "White", ParkingLocation = "Out Back" }; guestVehicleManager.CreateGuestVehicle(guestVehicle); }
public void TestCreateGuestVehicleInvalidParkingLocationLength() { guestVehicle = new GuestVehicle() { GuestID = 100001, Make = "Ford", Model = "Caravan", PlateNumber = "123 ABC", Color = "White", ParkingLocation = createString(51) }; guestVehicleManager.CreateGuestVehicle(guestVehicle); }
public void TestCreateGuestVehicleInvalidPlateNumberBlank() { guestVehicle = new GuestVehicle() { GuestID = 100001, Make = "Ford", Model = "Caravan", PlateNumber = "", Color = "White", ParkingLocation = "Out Back" }; guestVehicleManager.CreateGuestVehicle(guestVehicle); }
public void TestCreateGuestVehicleInvalidModelLength() { guestVehicle = new GuestVehicle() { GuestID = 100001, Make = "Ford", Model = createString(31), PlateNumber = "123 ABC", Color = "White", ParkingLocation = "Out Back" }; guestVehicleManager.CreateGuestVehicle(guestVehicle); }
public int InsertGuestVehicle(GuestVehicle vehicle) { int result = 0; vehicles.Add(new VMGuestVehicle() { GuestID = vehicle.GuestID, Make = vehicle.Make, Model = vehicle.Model, PlateNumber = vehicle.PlateNumber, Color = vehicle.Color, ParkingLocation = vehicle.ParkingLocation }); ++result; return(result); }
public void TestCreateGuestVehicleValidInput() { guestVehicle = new GuestVehicle() { GuestID = 100001, Make = "Honda", Model = "Caravan", PlateNumber = "123 ABC", Color = "White", ParkingLocation = "Out Back" }; guestVehicleManager.CreateGuestVehicle(guestVehicle); retrievedVehicles = guestVehicleAccessor.SelectAllGuestVehicles(); Assert.IsNotNull(retrievedVehicles.Find(v => v.GuestID == guestVehicle.GuestID && v.Make == guestVehicle.Make && v.Model == guestVehicle.Model && v.PlateNumber == guestVehicle.PlateNumber && v.Color == guestVehicle.Color && v.ParkingLocation == guestVehicle.ParkingLocation)); }
public void TestUpdateVehicleInvalidParkingLocationLength() { guestVehicle = new GuestVehicle() { GuestID = 100001, Make = "Ford", Model = "Focus", PlateNumber = "789 ACE", Color = "Silver", ParkingLocation = "Over thar, yonder" }; newGuestVehicle = new GuestVehicle() { GuestID = 100001, Make = "Ford", Model = "Focus", PlateNumber = createString(11), Color = "White", ParkingLocation = "Out Back" }; guestVehicleManager.UpdateGuestVehicle(guestVehicle, newGuestVehicle); }
public void TestUpdateVehicleInvalidMakeNull() { guestVehicle = new GuestVehicle() { GuestID = 100001, Make = "Ford", Model = "Focus", PlateNumber = "789 ACE", Color = "Silver", ParkingLocation = "Over thar, yonder" }; newGuestVehicle = new GuestVehicle() { GuestID = 100001, Make = null, Model = "Caravan", PlateNumber = "123 ABC", Color = "White", ParkingLocation = "Out Back" }; guestVehicleManager.UpdateGuestVehicle(guestVehicle, newGuestVehicle); }
/// <summary> /// Richard Carroll /// Created: 3/8/19 /// /// The Secondary Constructor. Used for both Read and Update /// Functionality. /// </summary> public GuestVehicleDetail(VMGuestVehicle vehicle, bool editable) { InitializeComponent(); _isEditable = editable; _vmGuestVehicle = vehicle; _guestVehicle = new GuestVehicle() { GuestID = vehicle.GuestID, Make = vehicle.Make, Model = vehicle.Model, PlateNumber = vehicle.PlateNumber, Color = vehicle.Color, ParkingLocation = vehicle.ParkingLocation }; if (_isEditable) { setupEditable(); } else { setupReadOnly(); } populateFields(); }
/// <summary> /// Richard Carroll /// Created: 3/8/19 /// /// Runs the validation method before attempting to update a vehicle /// in the Database, and returns the result. /// </summary> private void BtnUpdate_Click(object sender, RoutedEventArgs e) { if (cboGuestID.SelectedIndex != -1) { _newGuestVehicle = new GuestVehicle { GuestID = _guests[cboGuestID.SelectedIndex].GuestID, Make = txtMake.Text, Model = txtModel.Text, PlateNumber = txtPlateNum.Text, Color = txtColor.Text, ParkingLocation = txtParkingLocation.Text }; } else { MessageBox.Show("Please select a guest."); } if (validateFields()) { try { if (_guestVehicleManager.UpdateGuestVehicle(_guestVehicle, _newGuestVehicle)) { MessageBox.Show("Successfully Updated Guest Vehicle"); clearFields(); this.DialogResult = true; this.Close(); } } catch (Exception ex) { MessageBox.Show("Failed to Update Guest Vehicle: \n" + ex.Message); } } }