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