private void LoadDataToWindow(TravelWarrant travelWarrant)
{
// Travel Warrant
LblIdTravelWarrant.Text = travelWarrant.Id.ToString();
LblStatus.Text = travelWarrant.WarrantStatus;
LblDateTravelWarrant.Text = travelWarrant.DateIssued.ToShortDateString();
LblTimeTravelWarrant.Text = travelWarrant.TimeIssued.ToString();
// Driver
Driver driver = driversSqlRepository.ReadById(travelWarrant.DriverId);
LblIdDriver.Text = driver.Id.ToString();
LblFirstName.Text = driver.FirstName;
LblLastName.Text = driver.LastName;
LblPhoneNumber.Text = driver.PhoneNumber;
LblDriversLicenceNumber.Text = driver.DriversLicenceNumber;
// Vehicle
Vehicle vehicle = vehiclesSqlRepository.ReadById(travelWarrant.VehicleId);
LblIdVehicle.Text = vehicle.Id.ToString();
LblMake.Text = vehicle.Make;
LblModel.Text = vehicle.Model;
LblYearOfManufacture.Text = vehicle.YearOfManufacture.ToString();
LblInitialMileage.Text = vehicle.InitialMileage.ToString();
LblAvailability.Text = vehicle.Available == true ? "Available" : "Not available";
// Fuel Cost
FuelCost fuelCost = fuelCostsSqlRepository.ReadById(travelWarrant.FuelCostId);
LblIdFuelCost.Text = fuelCost.Id.ToString();
LblDateIssuedFc.Text = fuelCost.DateIssued.ToShortDateString();
LblTimeIssuedFc.Text = fuelCost.TimeIssued.ToString();
LblPosition.Text = fuelCost.Position;
LblAmount.Text = fuelCost.Amount.ToString();
LblPrice.Text = fuelCost.Price.ToString();
// Travel Route
TravelRoute travelRoute = travelRoutesSqlRepository.ReadById(travelWarrant.TravelRouteId);
LblIdTravelRoute.Text = travelRoute.Id.ToString();
LblDateIssuedTr.Text = travelRoute.DateIssued.ToShortDateString();
LblTimeIssuedTr.Text = travelRoute.TimeIssued.ToString();
LblOrigin.Text = travelRoute.Origin;
LblDestination.Text = travelRoute.Destination;
LblKilometersTraveled.Text = travelRoute.KilometersTraveled.ToString();
LblAverageSpeed.Text = travelRoute.AverageSpeed.ToString();
LblSpentFuel.Text = travelRoute.SpentFuel.ToString();
}
private void GenerateVehicleReport()
{
Vehicle v = vehiclesSqlRepository.ReadById(vehicle.Id);
string make = v.Make;
string model = v.Model;
float currentlyTraveledKilometers = v.InitialMileage;
float averageSpeed = 0;
int counter = 0;
List <TravelWarrant> travelWarrants = travelWarrantsSqlRepository.ReadAll();
List <TravelRoute> travelRoutes = travelRoutesSqlRepository.ReadAll();
foreach (TravelWarrant travelWarrant in travelWarrants)
{
if (travelWarrant.VehicleId == v.Id)
{
TravelRoute travelRoute = travelRoutesSqlRepository.ReadById(travelWarrant.TravelRouteId);
currentlyTraveledKilometers += travelRoute.KilometersTraveled;
averageSpeed += travelRoute.AverageSpeed;
counter++;
}
}
averageSpeed /= counter;
var resourceName = Assembly.GetExecutingAssembly().GetManifestResourceNames().Where(q => q.Contains("Template.html")).FirstOrDefault();
using (Stream stream = Assembly.GetExecutingAssembly().GetManifestResourceStream(resourceName))
{
using (StreamReader reader = new StreamReader(stream))
{
StringBuilder sb = new StringBuilder();
List <Service> services = servicesSqlRepository.ReadAll();
foreach (Service service in services)
{
if (service.Vehicle.Id == v.Id)
{
sb.Append("<table>\n");
sb.Append("<tr>\n");
foreach (ServiceItem serviceItem in service.ServiceItems)
{
sb.Append("<td></br>");
sb.Append("Service item\n");
sb.Append("</br>");
sb.Append(serviceItem.Name + "\n");
sb.Append("</br>");
sb.Append(serviceItem.Price + "\n");
sb.Append("</br>");
sb.Append("</td>\n");
}
sb.Append("</tr>\n");
sb.Append("</table>\n");
}
}
string html = reader.ReadToEnd().Replace("$$MAKE$$", make).Replace("$$MODEL$$", model).Replace("$$CTK$$", currentlyTraveledKilometers.ToString()).Replace("$$AVERAGESPEED$$", averageSpeed.ToString()).Replace("$$SERVICEITEMS$$", sb.ToString());
File.WriteAllText(@"../../../DataForExport/HtmlVehicleReport.html", html);
}
}
MessageBox.Show("Success");
System.Diagnostics.Process.Start(@"C:\Development\project-adpc-vehiclemanager\DataForExport/HtmlVehicleReport.html");
}
