private static void ReturnCar(ClientClass client) { Console.Clear(); List <RentClass> rentsOfClient = RentService.GetRentsOfClient(client); if (rentsOfClient.Count == 0) { Console.Clear(); Console.WriteLine("You have no rents"); return; } foreach (var i in RentService.GetRentsOfClient(client)) { Console.WriteLine("\nCar id: " + i.CurrentCar.CarId); Console.WriteLine("Car type: " + i.CurrentCar.Bodywork.Type); Console.WriteLine("Car color: " + i.CurrentCar.Bodywork.Color); } Console.Write("\nChoose car's id you want to return: "); if (UserInputInt(out int chosenCarId)) { Console.Clear(); CarClass tempCar = AutoParkService.SearchCarById(chosenCarId); if (tempCar != null && tempCar.CurrentClient == client) { RentService.RemoveRent(RentService.GetRentByCarId(chosenCarId)); Console.WriteLine($"Car with id '{chosenCarId}' was successfully returned"); return; } } Console.Clear(); Console.WriteLine("Id not found!"); }
public RentClass Search(string rentId) { string query = "SELECT * FROM rents WHERE rentId='" + rentId + "'"; RentClass rent = null; MySqlDataReader reader = GetReader(query); try { reader.Read(); rent = new RentClass(int.Parse(reader[0].ToString()), ClientService.SearchClientById(int.Parse(reader[1].ToString())), AutoParkService.SearchCarById(int.Parse(reader[2].ToString())), DateTime.Parse(reader[3].ToString()), DateTime.Parse(reader[4].ToString())); } catch (Exception e) { Console.WriteLine(e.Message); } finally { reader.Close(); } return(rent); throw new NotImplementedException(); }
public IEnumerable <RentClass> GetList() { string query = "SELECT * FROM rents"; MySqlDataReader reader = GetReader(query); while (reader.Read()) { yield return(new RentClass(int.Parse(reader[0].ToString()), ClientService.SearchClientById(int.Parse(reader[1].ToString())), AutoParkService.SearchCarById(int.Parse(reader[2].ToString())), DateTime.Parse(reader[3].ToString()), DateTime.Parse(reader[4].ToString()))); } reader.Close(); }