AvtoservisVika/AutoServiceVika/MainWindow.xaml.cs

using AutoServiceVika.Entites;
using AutoServiceVika.Pages;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Runtime.CompilerServices;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace AutoServiceVika
{
    /// <summary>
    /// Логика взаимодействия для MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            //ImportData();
            App.MainFrame = MainFrame;
            MainFrame.Navigate(new LoginPage());
        }
        private void ImportData()
        {
            //Клиенты
            var clientsData = File.ReadAllLines(@"C:\Users\igors\OneDrive\Рабочий стол\resurses\Импорт\Clients.txt");
            for (int i = 0; i < clientsData.Count(); i++)
            {
                var currentClient = clientsData[i].Split('\t');
                var clientForDb = new Client
                {
                    LastName = currentClient[0],
                    FirstName = currentClient[1],
                    Patronymic = currentClient[2],
                    GenderCode = currentClient[3],
                    Phone = currentClient[4],
                    Birthday = DateTime.Parse(currentClient[5]),
                    Email = currentClient[6],
                    RegistrationDate = DateTime.Parse(currentClient[7])
                };
                App.context.Client.Add(clientForDb);
                App.context.SaveChanges();
            }

            //Услуги
            var serviceData = File.ReadAllLines(@"C:\Users\igors\OneDrive\Рабочий стол\resurses\Импорт\Service.txt");
            for (int i = 0; i < serviceData.Count(); i++)
            {
                var currentService = serviceData[i].Split('\t');
                var serviceForDb = new Service
                {
                    Title = currentService[0].Trim(),
                    Image = File.ReadAllBytes(@"C:\Users\igors\OneDrive\Рабочий стол\resurses\Импорт\" + currentService[1].Trim()),
                    DurationInSeconds = int.Parse(currentService[2]),
                    Cost = decimal.Parse(currentService[3]),
                    Discount = Double.Parse(currentService[4])
                };
                App.context.Service.Add(serviceForDb);
                App.context.SaveChanges();
            }

            //Клиент услуга
            var clientServiceData = File.ReadAllLines(@"C:\Users\igors\OneDrive\Рабочий стол\resurses\Импорт\serviceclient_a_import.txt");
            for (int i = 0; i < clientServiceData.Count(); i++)
            {
                var currentClientService = clientServiceData[i].Split('\t');

                string clientTitle = currentClientService[0];
                string clientDate = currentClientService[1];
                string clientLastName = currentClientService[2];

                var clientsServiceForDB = new ClientService
                {
                    ServiceID = App.context.Service.ToList().FirstOrDefault(p => p.Title == clientTitle).ID,
                    StartTime = DateTime.Parse(clientDate),
                    ClientID = App.context.Client.ToList().FirstOrDefault(p => p.LastName == clientLastName).ID,
                };
                App.context.ClientService.Add(clientsServiceForDB);
                App.context.SaveChanges();
            }
        }

        private void btnGoBack_Click(object sender, RoutedEventArgs e)
        {
            if(MainFrame.CanGoBack)
            {
                MainFrame.GoBack();
            }
        }
    }
}