private void LoadDataToWindow(Service service)
        {
            // Service

            LblIdService.Text = service.Id.ToString();
            LblDate.Text      = service.DateIssued.ToShortDateString();
            LblTime.Text      = service.TimeIssued.ToString();

            // Vehicle

            Vehicle vehicle = vehiclesSqlRepository.ReadById(service.Vehicle.Id);

            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";

            // Service Items

            foreach (ServiceItem serviceItem in service.ServiceItems)
            {
                ServiceItemPanel serviceItemPanel = new ServiceItemPanel(serviceItem);

                serviceItemPanel.ChBxServiceItem.Visibility = Visibility.Hidden;
                serviceItemPanel.BtnEdit.Visibility         = Visibility.Hidden;
                serviceItemPanel.BtnDelete.Visibility       = Visibility.Hidden;

                SpServiceItems.Children.Add(serviceItemPanel);
            }
        }
        private void LoadServiceItemsToStackPanel()
        {
            SpServiceItems.Children.Clear();

            ServiceItemsSqlRepository serviceItemsSqlRepository1 = new ServiceItemsSqlRepository();

            List <ServiceItem> serviceItems = serviceItemsSqlRepository1.ReadAll();

            foreach (ServiceItem serviceItem in serviceItems)
            {
                ServiceItemPanel serviceItemPanel = new ServiceItemPanel(serviceItem);

                SpServiceItems.Children.Add(serviceItemPanel);
            }
        }
        private void CreateVehicleService()
        {
            if (TbDate.Text != string.Empty && TbTime.Text != string.Empty && CbVehicles.Text != string.Empty && SpServiceItems.Children.Count > 0)
            {
                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(TbTime.Text, @"\d\d:\d\d:\d\d"))
                    {
                        decimal            totalPrice   = 0;
                        List <ServiceItem> serviceItems = new List <ServiceItem>();

                        foreach (ServiceItemPanel serviceItemPanel in SpServiceItems.Children)
                        {
                            if (serviceItemPanel.ChBxServiceItem.IsChecked == true)
                            {
                                totalPrice += decimal.Parse(serviceItemPanel.LblPrice.Text);
                            }
                        }

                        for (int i = 0; i < SpServiceItems.Children.Count; i++)
                        {
                            ServiceItemPanel serviceItemPanel = (ServiceItemPanel)SpServiceItems.Children[i];

                            if (serviceItemPanel.ChBxServiceItem.IsChecked == true)
                            {
                                int         serviceItemId = int.Parse(serviceItemPanel.LblId.Text);
                                ServiceItem serviceItem   = serviceItemsSqlRepository.ReadById(serviceItemId);
                                serviceItems.Add(serviceItem);
                            }
                        }

                        int     vehicleId = int.Parse(CbVehicles.Text.Substring(0, CbVehicles.Text.IndexOf(' ')));
                        Vehicle vehicle   = vehiclesSqlRepository.ReadById(vehicleId);

                        Service service = new Service()
                        {
                            DateIssued = date,
                            TimeIssued = time,
                            TotalPrice = totalPrice
                        };

                        bool success = servicesSqlRepository.Create(service, vehicle, serviceItems);

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