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