// Isnuomoto dviracio ir nuomininko paieska pagal dviracio ID public void SearchByBikeID(bool bikeIDExist, int bikeID) { if (bikeIDExist) { List <Bicycle> bikes = SqlQueries.SelectBikesWithClient(); List <Client> clients = SqlQueries.SelectClients(); Console.CursorVisible = false; Console.Clear(); var result = (from b in bikes join cl in clients on b.ClientNumber equals cl.PersonalNumber select new { b.BikeID, b.Brand, b.Model, cl.PersonalNumber, cl.Name, cl.Surename }).Where(b => b.BikeID == bikeID); foreach (var bike in result) { Console.WriteLine($"Dviratis: {bike.Brand} {bike.Model}\nNuomininkas: {bike.Name} {bike.Surename} " + $"(a.k. {bike.PersonalNumber})"); } Console.ReadKey(); } }
// Isnuomotos transporto priemones ir nuomininko paieska pagal automobilio numeri public void SearchByCar(bool carNumExist, string vehNumber) { if (carNumExist) { List<Car> cars = SqlQueries.SelectCarsWithClient(); List<Client> clients = SqlQueries.SelectClients(); Console.Clear(); var result = (from c in cars join cl in clients on c.ClientNumber equals cl.PersonalNumber select new { c.VehNumber, c.Brand, c.Model, cl.PersonalNumber, cl.Name, cl.Surename }).Where(c => c.VehNumber == vehNumber).OrderBy(c => c.Brand); foreach (var car in result) { Console.WriteLine($"Automobilis: {car.Brand} {car.Model}\nNuomininkas: {car.Name} {car.Surename} " + $"(a.k. {car.PersonalNumber})"); } Console.ReadKey(); } }
// Isnuomoto motociklo paieska pagal motociklo numeri public void SearchByMoto(bool motoNumExist, string vehNumber) { if (motoNumExist) { Console.CursorVisible = false; List <Motorcycle> motos = SqlQueries.SelectMotorcyclesWithClient(); List <Client> clients = SqlQueries.SelectClients(); Console.Clear(); var result = (from m in motos join cl in clients on m.ClientNumber equals cl.PersonalNumber select new { m.VehNumber, m.Brand, m.Model, cl.PersonalNumber, cl.Name, cl.Surename }).Where(m => m.VehNumber == vehNumber); foreach (var moto in result) { Console.WriteLine($"Motociklas: {moto.Brand} {moto.Model}\nNuomininkas: {moto.Name} {moto.Surename} " + $"(a.k. {moto.PersonalNumber})"); } Console.ReadKey(); } }
// Kliento duomenu isvedimas i ekrana public void ClientData() { List <Client> clients = SqlQueries.SelectClients(); Console.Clear(); Console.WriteLine("AK"); Console.SetCursorPosition(15, 0); Console.WriteLine("Vardas"); Console.SetCursorPosition(30, 0); Console.WriteLine("Pavarde"); Console.SetCursorPosition(50, 0); Console.WriteLine("Gimimo data"); Console.SetCursorPosition(70, 0); Console.WriteLine("Adresas"); Console.SetCursorPosition(90, 0); Console.WriteLine("Miestas"); Console.SetCursorPosition(110, 0); var result = clients.Select(cl => cl).OrderBy(cl => cl.Name).ThenBy(cl => cl.Surename); foreach (var client in result) { Console.SetCursorPosition(0, y); Console.WriteLine(client.PersonalNumber); Console.SetCursorPosition(15, y); Console.WriteLine(client.Name); Console.SetCursorPosition(30, y); Console.WriteLine(client.Surename); Console.SetCursorPosition(50, y); Console.WriteLine(client.DateOfBirth); Console.SetCursorPosition(70, y); Console.WriteLine(client.Address); Console.SetCursorPosition(90, y); Console.WriteLine(client.City); Console.SetCursorPosition(110, y); y++; } Console.ReadKey(); // Atstatoma y reiksme y = 2; }
// 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)); }