public static void SetDB() { Dentist dentist1 = new Dentist { FIO = "Иванов Рудольф Исаакович", LicenseDate = 1999, Phone = "999 - 999 - 99 - 99", LicenseNumber = "ABC123", WorkingHourFrom = DateTime.Parse("8:00"), WorkingHourTo = DateTime.Parse("17:00") }; Dentist dentist2 = new Dentist { FIO = "Петров Александр Иванович", LicenseDate = 2010, Phone = "999 - 777 - 32 - 28", LicenseNumber = "DBS751", WorkingHourFrom = DateTime.Parse("10:00"), WorkingHourTo = DateTime.Parse("19:00") }; Client client1 = new Client { FIO = "Гринев Олег Вячеславович", Phone = "4839480299" }; Client client2 = new Client { FIO = "Крайний Семен Геннадьевич", Phone = "1213545667" }; Client client3 = new Client { FIO = "Незлобин Виктор Вильгельмович", Phone = "4434354579" }; Visit visit1 = new Visit { Reason = "Удаление нижних левых 6,7 зубов", Coast = 14500, Date = DateTime.Parse("Apr 02 2021") }; visit1.Dentist = dentist1; visit1.Client = client1; client1.Dentists.Add(dentist1); dentist1.Clients.Add(client1); Visit visit2 = new Visit { Reason = "Установка коронок", Coast = 20000, Date = DateTime.Parse("Apr 10 2021") }; visit2.Dentist = dentist1; visit2.Client = client2; client2.Dentists.Add(dentist1); dentist1.Clients.Add(client2); Visit visit3 = new Visit { Reason = "Чистка кармы", Coast = 1500, Date = DateTime.Parse("Apr 19 2021") }; visit3.Dentist = dentist2; visit3.Client = client3; client3.Dentists.Add(dentist2); dentist2.Clients.Add(client3); Visit visit4 = new Visit { Reason = "Пломбирование", Coast = 3500, Date = DateTime.Parse("Mar 04 2021") }; visit4.Dentist = dentist2; visit4.Client = client3; client3.Dentists.Add(dentist2); dentist2.Clients.Add(client3); Visit visit5 = new Visit { Reason = "Пытка", Coast = 50000, Date = DateTime.Parse("Feb 16 2021") }; visit5.Dentist = dentist2; visit5.Client = client1; client1.Dentists.Add(dentist2); dentist2.Clients.Add(client1); Visit visit6 = new Visit { Reason = "Очень важная причина", Coast = 10000, Date = DateTime.Parse("May 02 2021") }; visit6.Dentist = dentist2; visit6.Client = client2; client2.Dentists.Add(dentist2); dentist2.Clients.Add(client2); context.Add(dentist1); context.Add(dentist2); context.Add(client1); context.Add(client2); context.Add(client3); context.SaveChanges(); context.Add(visit1); context.Add(visit2); context.Add(visit3); context.Add(visit4); context.Add(visit5); context.Add(visit6); context.SaveChanges(); }
public static async Task <string> decryptCommand(string[] commandArray) { string answer = ""; if (commandArray[0] == "1") { /*добавление дантиста*/ try { Dentist newDentist = new Dentist { FIO = commandArray[1], Phone = commandArray[2], LicenseNumber = commandArray[3], LicenseDate = int.Parse(commandArray[4]), WorkingHourFrom = DateTime.Parse(commandArray[5]), WorkingHourTo = DateTime.Parse(commandArray[6]) }; context.Add(newDentist); context.SaveChanges(); answer = "Done"; } catch { answer = "Error"; } } else if (commandArray[0] == "2") { /*удаление дантиста*/ } else if (commandArray[0] == "3") { /*добавление клиента*/ try { Client newClient = new Client { FIO = commandArray[1], Phone = commandArray[2] }; context.Add(newClient); context.SaveChanges(); answer = "Done"; } catch { answer = "Error"; } } else if (commandArray[0] == "4") { /*удаление клиента*/ Client removeClient = new Client { FIO = commandArray[1], Phone = commandArray[2] }; context.Clients.Attach(removeClient); context.Clients.Remove(removeClient); context.SaveChanges(); } else if (commandArray[0] == "5") { /*найти дантиста по ФИО*/ } else if (commandArray[0] == "6") { /*найти дантиста по лицензии*/ } else if (commandArray[0] == "7") { /*найти дантиста по ФИО клиента*/ } else if (commandArray[0] == "8") { /*найти дантиста по времени работы*/ } return(answer); }