コード例 #1
0
        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!");
        }
コード例 #2
0
        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();
        }
コード例 #3
0
        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();
        }