private void ImportTravelRouteFromXml() { try { OpenFileDialog openFileDialog = new OpenFileDialog(); if (openFileDialog.ShowDialog() == true) { string filePath = openFileDialog.FileName; XmlDocument doc = new XmlDocument(); doc.Load(filePath); List <string> travelRouteData = new List <string>(); foreach (XmlNode node in doc.DocumentElement.ChildNodes) { travelRouteData.Add(node.InnerText); } DateTime dateIssued = DateTime.Parse(travelRouteData[0]); TimeSpan timeIssued = TimeSpan.Parse(travelRouteData[1]); string origin = travelRouteData[2]; string destination = travelRouteData[3]; float kilometersTraveled = float.Parse(travelRouteData[4]); float averageSpeed = float.Parse(travelRouteData[5]); float spentFuel = float.Parse(travelRouteData[6]); TravelRoute travelRoute = new TravelRoute(dateIssued, timeIssued, origin, destination, kilometersTraveled, averageSpeed, spentFuel); bool success = travelRoutesSqlRepository.Create(travelRoute); if (success) { MessageBox.Show("Success"); } else { MessageBox.Show("Fail"); } LoadTravelRoutesToStackPanel(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void CreateTravelRoute() { if (TbDate.Text != string.Empty && TbTime.Text != string.Empty && TbOrigin.Text != string.Empty && TbDestination.Text != string.Empty && TbKilometersTraveled.Text != string.Empty && TbAverageSpeed.Text != string.Empty && TbSpentFuel.Text != string.Empty) { if (DateTime.TryParse(TbDate.Text, out DateTime date) && TimeSpan.TryParse(TbTime.Text, out TimeSpan time) && float.TryParse(TbKilometersTraveled.Text, out float kilometersTraveled) && float.TryParse(TbAverageSpeed.Text, out float averageSpeed) && float.TryParse(TbSpentFuel.Text, out float spentFuel)) { 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")) { TravelRoute createdTravelRoute = new TravelRoute() { DateIssued = date, TimeIssued = time, Origin = TbOrigin.Text, Destination = TbDestination.Text, KilometersTraveled = kilometersTraveled, AverageSpeed = averageSpeed, SpentFuel = spentFuel }; bool success = travelRoutesSqlRepository.Create(createdTravelRoute); 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("Kilometers traveled, average speed and spent fuel must be numbers\nDate format must be: \"MM/dd/yyyy\"\nTime format must be: \"HH:MM:ss\""); } } else { MessageBox.Show("All input fields are required"); } }