public static LINQUtil LINQHandler() { if (instanse == null) { instanse = new LINQUtil(); } return(instanse); }
static void Main(string[] args) { LINQUtil lINQUtil = LINQUtil.LINQHandler(); LINQUtil.Print("All cars select: ", lINQUtil.SelectCars()); Console.ReadKey(); LINQUtil.Print("All clients select: ", lINQUtil.SelectClients()); Console.ReadKey(); LINQUtil.Print("Select clients by name: ", lINQUtil.SelectClientsByName("Бо")); Console.ReadKey(); LINQUtil.Print("Select rent sum by client name: ", lINQUtil.SelectRentSumByClientName()); Console.ReadKey(); LINQUtil.Print("Select rents with information about cars and clients: ", lINQUtil.SelectJoinedRents()); Console.ReadKey(); Car addCar = new Car() { CarMark = "LADA", RegNum = "1234 AB-3", BodyNum = "LADA162541276", EngNum = "126754762145L", Mileage = 20000, CarPrice = 10, DayPrice = 999, DateTO = DateTime.MinValue, MechFIO = "Андрей Мельченко", CarAge = 999 }; Console.WriteLine("Insert car " + addCar.ToString()); lINQUtil.InsertCar(addCar); LINQUtil.Print("Check: ", lINQUtil.SelectCarsByMark("LADA")); Console.ReadKey(); Client updateClient = new Client() { Id = 178, ClienFIO = "Иванов Иван", ClientSex = "Male", Birthday = DateTime.Now.AddYears(-20), Adres = "Советская д. 234 кв. 5", PassNum = "HB1234568", Phone = "+375446433158" }; lINQUtil.UpdateClient(updateClient); LINQUtil.Print("Updated client: ", lINQUtil.SelectClientsByName("Иванов")); Console.ReadKey(); Rent addRent = new Rent() { RentDate = DateTime.Now, DateGet = DateTime.Now.AddDays(30), Car = addCar, Client = updateClient, RentPrice = 678, Paid = false, WorkerFIO = "Алын Малиев" }; lINQUtil.InsertRent(addRent); LINQUtil.Print("Inserted rent: ", lINQUtil.SelectRentByCarMark("LADA")); Console.ReadKey(); lINQUtil.DeleteClientByName("Иванов"); LINQUtil.Print("Delete client: ", lINQUtil.SelectClientsByName("Иванов")); Console.ReadKey(); lINQUtil.DeleteRentById(176); LINQUtil.Print("Delete rent by id 176: ", lINQUtil.SelectJoinedRents()); Console.ReadKey(); }