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>
/// Richard Carroll
/// Created: 3/8/19
///
/// Opens a Detail Form for Viewing the Details of a GuestVehicle
/// </summary>
private void BtnViewDetail_Click(object sender, RoutedEventArgs e)
{
if (dgGuestVehicles.SelectedIndex != -1)
{
VMGuestVehicle vehicle = (VMGuestVehicle)dgGuestVehicles.SelectedItem;
var guestVehicleDetail = new GuestVehicleDetail(vehicle, false);
guestVehicleDetail.ShowDialog();
}
}
/// <summary>
/// Richard Carroll
/// Created: 3/8/19
///
/// Opens a Detail Form for Updating a GuestVehicle
/// </summary>
private void BtnUpdateGuestVehicle_Click(object sender, RoutedEventArgs e)
{
if (dgGuestVehicles.SelectedIndex != -1)
{
VMGuestVehicle vehicle = (VMGuestVehicle)dgGuestVehicles.SelectedItem;
var guestVehicleDetail = new GuestVehicleDetail(vehicle, true);
var result = guestVehicleDetail.ShowDialog();
if (result == true)
{
refreshGrid();
}
}
}
/// <summary>
/// Richard Carroll
/// Created: 3/8/19
///
/// Opens a Detail Form for Viewing the Details of a GuestVehicle
/// </summary>
private void DgGuestVehicles_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (dgGuestVehicles.SelectedIndex != -1)
{
VMGuestVehicle vehicle = (VMGuestVehicle)dgGuestVehicles.SelectedItem;
var guestVehicleDetail = new GuestVehicleDetail(vehicle, false);
var result = guestVehicleDetail.ShowDialog();
if (result == true)
{
refreshGrid();
}
}
}
/// <summary>
/// Richard Carroll
/// Created: 3/7/19
///
/// Requests a List of GuestVehicles from the
/// Database and returns the result.
/// </summary>
public List <VMGuestVehicle> SelectAllGuestVehicles()
{
List <VMGuestVehicle> vehicles = new List <VMGuestVehicle>();
var conn = DBConnection.GetDbConnection();
var cmdText = "sp_select_all_guest_vehicles";
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
VMGuestVehicle vehicle = new VMGuestVehicle()
{
FirstName = reader.GetString(0),
LastName = reader.GetString(1),
GuestID = reader.GetInt32(2),
Make = reader.GetString(3),
Model = reader.GetString(4),
PlateNumber = reader.GetString(5),
Color = reader.GetString(6),
ParkingLocation = reader.GetString(7)
};
vehicles.Add(vehicle);
}
}
}
catch (Exception)
{
throw;
}
return(vehicles);
}
/// <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();
}
