// Duomenu ivedimo meniu valdymas public void AddDataMenuSelection() { bool needToRender = true; while (needToRender) { vehicleMenuToAddData.Render(); ConsoleKeyInfo pressedChar = Console.ReadKey(true); switch (pressedChar.Key) { case ConsoleKey.D1: var checkVehNumberCar = functionsForSQL.NotMatchingVehNumber(); sqlInsert.InsertCar(checkVehNumberCar.Item1, checkVehNumberCar.Item2); break; case ConsoleKey.D2: var checkVehNumberMoto = functionsForSQL.NotMatchingVehNumber(); sqlInsert.InsertMoto(checkVehNumberMoto.Item1, checkVehNumberMoto.Item2); break; case ConsoleKey.D3: sqlInsert.InsertBike(); break; case ConsoleKey.D4: var checkClientPersonalNumber = functionsForSQL.NotMatchingPersonalNumber(); sqlInsert.InsertClient(checkClientPersonalNumber.Item1, checkClientPersonalNumber.Item2); break; case ConsoleKey.Backspace: Console.Clear(); ShowMenu(); break; case ConsoleKey.Escape: Console.Clear(); Environment.Exit(0); break; } } }
// Patikrinimas ar automobilio numeris ir asmens kodas sutampa public Tuple <bool, string, long> MatchingCarNumberAndClientNumber() { List <Car> cars = SqlQueries.SelectCars(); List <Client> clients = SqlQueries.SelectClients(); Console.Clear(); Console.CursorVisible = true; Console.WriteLine("Ivesk isnuomojamo automobilio valstybini numeri"); vehNumber = Console.ReadLine().ToUpper(); while (!lettersAndNums.IsMatch(vehNumber) || vehNumber == "") { Console.WriteLine($"\nValstybini numeri gali sudaryti tik raides ir skaitmenys!\nIvesk automobilio valstybini numeri"); vehNumber = Console.ReadLine().ToUpper(); } var prepareCheckList = cars.Select(c => c).Where(c => c.VehNumber == vehNumber && c.RentStatus == false && Convert.ToDateTime(c.TechServiceExp) >= todaysDate && Convert.ToDateTime(c.InsuranceExp) >= todaysDate).ToList(); var checkResult = prepareCheckList.Select(c => c.VehNumber).Contains(vehNumber); if (!checkResult) { Console.Clear(); Console.WriteLine("Automobilis su tokiu numeriu neegzistuoja, yra isnuomotas arba neturi galiojanciu reikalingu dokumentu!"); Console.ReadKey(); isDataCorrect = false; } else { Console.WriteLine("Ivesk kliento asmens koda, kuriam isnuomojamas automobilis"); while (!long.TryParse(Console.ReadLine(), out personalNumber)) { Console.WriteLine("\nAsmens koda sudaro tik skaitmenys! Ivesk kliento asmens koda"); } var checkResult2 = clients.Select(cl => cl.PersonalNumber).Contains(personalNumber); if (!checkResult2) { Console.Clear(); Console.WriteLine("Toks klientas neegzistuoja!\nJei nori prideti nauja klienta ivesk [Y], kitu atveju - [N]"); comfirmedAction = true; while (comfirmedAction) { choise = Console.ReadLine().ToUpper(); if (choise == "Y") { sqlInsert.InsertClient(true, personalNumber); isDataCorrect = true; comfirmedAction = false; } else if (choise == "N") { isDataCorrect = false; comfirmedAction = false; } else { Console.WriteLine("\nJei nori prideti nauja klienta ivesk [Y], kitu atveju - [N]"); } } } else { isDataCorrect = true; } } return(new Tuple <bool, string, long>(isDataCorrect, vehNumber, personalNumber)); }