private void LoadTravelRoutesToStackPanel() { SpTravelRoutes.Children.Clear(); List <TravelRoute> travelRoutes = travelRoutesSqlRepository.ReadAll(); foreach (TravelRoute travelRoute in travelRoutes) { TravelRoutePanel travelRoutePanel = new TravelRoutePanel(travelRoute); SpTravelRoutes.Children.Add(travelRoutePanel); } }
private XmlWriter WriteTravelRoutes(XmlWriter xmlWriter) { List <TravelRoute> travelRoutes = travelRoutesSqlRepository.ReadAll(); xmlWriter.WriteStartElement("TravelRoutes"); foreach (TravelRoute travelRoute in travelRoutes) { xmlWriter.WriteStartElement("TravelRoute"); xmlWriter.WriteAttributeString("Id", travelRoute.Id.ToString()); xmlWriter.WriteStartElement("DateIssued"); xmlWriter.WriteString(travelRoute.DateIssued.ToShortDateString()); xmlWriter.WriteEndElement(); xmlWriter.WriteStartElement("TimeIssued"); xmlWriter.WriteString(travelRoute.TimeIssued.ToString()); xmlWriter.WriteEndElement(); xmlWriter.WriteStartElement("Origin"); xmlWriter.WriteString(travelRoute.Origin); xmlWriter.WriteEndElement(); xmlWriter.WriteStartElement("Destination"); xmlWriter.WriteString(travelRoute.Destination); xmlWriter.WriteEndElement(); xmlWriter.WriteStartElement("KilometersTraveled"); xmlWriter.WriteString(travelRoute.KilometersTraveled.ToString()); xmlWriter.WriteEndElement(); xmlWriter.WriteStartElement("AverageSpeed"); xmlWriter.WriteString(travelRoute.AverageSpeed.ToString()); xmlWriter.WriteEndElement(); xmlWriter.WriteStartElement("SpentFuel"); xmlWriter.WriteString(travelRoute.SpentFuel.ToString()); xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); return(xmlWriter); }
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"); }