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