private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
VehiclesSqlRepository vehiclesSqlRepository = new VehiclesSqlRepository();
vehiclesSqlRepository.UpdateVehicleAvailability(travelWarrant.VehicleId, true);
bool success = travelWarrantsSqlRepository.Delete(travelWarrant.Id);
if (success)
{
MessageBox.Show("Success");
}
else
{
MessageBox.Show("Fail");
}
}
private void UpdateTravelWarrant()
{
if (CbStatus.Text != string.Empty && TbDate.Text != string.Empty && TbTime.Text != string.Empty && CbDrivers.Text != string.Empty && CbVehicles.Text != string.Empty)
{
if (DateTime.TryParse(TbDate.Text, out DateTime date) && (TimeSpan.TryParse(TbTime.Text, out TimeSpan time)))
{
if ((Regex.IsMatch(TbDate.Text, @"\d\d/\d\d/\d\d\d\d") || Regex.IsMatch(TbDate.Text, @"\d/\d\d/\d\d\d\d")) && Regex.IsMatch(TbTime.Text, @"\d\d:\d\d:\d\d"))
{
int driverId = int.Parse(CbDrivers.Text.Substring(0, CbDrivers.Text.IndexOf(' ')));
int vehicleId = int.Parse(CbVehicles.Text.Substring(0, CbVehicles.Text.IndexOf(' ')));
int fuelCostId = 0;
int travelRouteId = 0;
foreach (FuelCostPanel fuelCostPanel in SpFuelCosts.Children)
{
if (fuelCostPanel.RbFcSelect.IsChecked == true)
{
fuelCostId = int.Parse(fuelCostPanel.LblId.Text);
}
}
foreach (TravelRoutePanel travelRoutePanel in SpTravelRoutes.Children)
{
if (travelRoutePanel.RbTrSelect.IsChecked == true)
{
travelRouteId = int.Parse(travelRoutePanel.LblId.Text);
}
}
TravelWarrant updatedTravelWarrant = new TravelWarrant
{
Id = travelWarrant.Id,
WarrantStatus = CbStatus.Text,
DateIssued = date,
TimeIssued = time,
DriverId = driverId,
VehicleId = vehicleId,
FuelCostId = fuelCostId,
TravelRouteId = travelRouteId
};
int oldVehicleId = travelWarrant.VehicleId;
vehiclesSqlRepository.UpdateVehicleAvailability(oldVehicleId, true);
vehiclesSqlRepository.UpdateVehicleAvailability(vehicleId, false);
bool success = travelWarrantsSqlRepository.Update(updatedTravelWarrant);
if (success)
{
MessageBox.Show("Success");
Close();
}
else
{
MessageBox.Show("Fail");
}
}
else
{
MessageBox.Show("Date format must be: \"MM/dd/yyyy\"\nTime format must be: \"HH:MM:ss\"");
}
}
else
{
MessageBox.Show("Date format must be: \"MM/dd/yyyy\"\nTime format must be: \"HH:MM:ss\"");
}
}
else
{
MessageBox.Show("All input fields are required");
}
}