private static void FilterPrice(CarManager carManager, BrandManager brandManager, ColorManager colorManager)
{
var result = carManager.GetByDailyPrice(10000, 15000);
if (result.Success == true)
{
Console.WriteLine("\n---Rent A Car--- \t\t Filter: Price[10000-15000]\n");
Console.WriteLine("Car Id\tBrand\t\tColor\t\tModel\t\tPrice\tDescription");
Console.WriteLine("------\t-----\t\t-----\t\t-----\t\t-----\t-----------");
foreach (Car car in result.Data)
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}\t{5}",
car.CarId,
brandManager.GetById(car.BrandId).Data.BrandName,
colorManager.GetById(car.ColorId).Data.ColorName,
car.ModelYear,
car.DailyPrice,
car.Description);
}
}
else
{
Console.WriteLine(result.Message);
}
}
private static void CarTest()
{
CarManager carManager = new CarManager(new EfCarDal());
foreach (var car in carManager.GetAll().Data)
{
Console.WriteLine("Araba Adı: {0} - Özellik: {1}", car.CarName, car.Description);
}
Console.WriteLine("--------------------------------------------------");
Console.WriteLine(carManager.GetCarsById(2).Data.CarName);
Console.WriteLine("--------------------------------------------------");
foreach (var car in carManager.GetCarsByBrandId(2).Data)
{
Console.WriteLine("Araba Adı: {0} - Özellik: {1}", car.CarName, car.Description);
}
Console.WriteLine("--------------------------------------------------");
foreach (var car in carManager.GetByDailyPrice(500, 800).Data)
{
Console.WriteLine("Araba Adı: {0} - Özellik: {1}", car.CarName, car.Description);
}
Console.WriteLine("--------------------------------------------------");
foreach (var car in carManager.GetCarsByColorId(3).Data)
{
Console.WriteLine("Araba Adı: {0} - Özellik: {1}", car.CarName, car.Description);
}
Console.WriteLine("---------------------A R A B A EKLEME-----------------------------");
carManager.Add(new Car {
BrandId = 2, ColorId = 2, CarName = "M", ModelYear = 2010, DailyPrice = 500, Description = "Benzin+Otomatik"
});
foreach (var car in carManager.GetAll().Data)
{
Console.WriteLine("Araba Adı: {0} - Özellik: {1}", car.CarName, car.Description);
}
}
static void Main(string[] args)
{
Car car1 = new Car()
{
CarId = 4,
BrandId = 3,
ColorId = 2,
Name = "Renoult Megane",
ModelYear = 2021,
DailyPrice = 350,
Description = "Hatasız boyasız!"
};
CarManager carManager = new CarManager(new EfCarDal());
//carManager.Add(car1);
foreach (var car in carManager.GetByDailyPrice(250, 500))
{
Console.Write("Car Class " + car.CarClass + " ");
Console.Write("Model Year " + car.ModelYear + " ");
Console.Write("Color ID " + car.ColorId + " ");
Console.Write("Name " + car.Name + " ");
Console.Write("Description " + car.Description + " ");
Console.WriteLine("Daily Price " + car.DailyPrice + " ");
}
}
private static void GetCarsByDailyPriceTest(int min, int max)
{
CarManager carManager = new CarManager(new EfCarDal());
var result = carManager.GetByDailyPrice(min, max);
List <Car> carsByDailyPrice = result.Data;
if (result.Success == true)
{
Console.WriteLine("Car whose DailyPrice is greater than {0} and less than {1}", min, max);
string str = new string('_', 180);
Console.WriteLine(str + "\n\n" + "\tId\t\tBrandId\t\tColorId\t\tModelYear\tDailyPrice\tDescription\t");
foreach (var car in carsByDailyPrice)
{
Console.WriteLine("\t{0}\t\t{1}\t\t{2}\t\t{3}\t\t{4}\t\t{5}\t",
car.Id, car.BrandId, car.ColorId,
car.ModelYear, car.DailyPrice, car.Description);
}
Console.WriteLine(str + "\n");
}
else
{
Console.WriteLine(result.Message);
}
}
private static void CarsDailyPrice(CarManager carManager)
{
foreach (var car in carManager.GetByDailyPrice(2, 400).Data)
{
Console.WriteLine(car.Description + " DailyPrice: " + car.DailyPrice);
}
}
private static void GetByDailyPrice(CarManager carManager)
{
foreach (var car in carManager.GetByDailyPrice(100, 130).Data)
{
Console.WriteLine(car.BrandId + " " + car.DailyPrice);
}
}
private static void GetByDailyPrice(CarManager carManager)
{
foreach (var car in carManager.GetByDailyPrice(150, 260).Data)
{
Console.WriteLine(car.Description);
}
}
static void getByDailyPrice(CarManager carManager)
{
decimal dailyMin, dailyMax;
Console.WriteLine("Enter Min Daily Price:");
dailyMin = decimal.Parse(Console.ReadLine());
Console.WriteLine("Enter Max Daily Price:");
dailyMax = decimal.Parse(Console.ReadLine());
Console.WriteLine("\n");
Console.WriteLine("CarID BrandID ColorID Description DailyPrice");
//foreach (var item in carManager.GetByDailyPrice(dailyMin, dailyMax).Data)
var result = carManager.GetByDailyPrice(dailyMin, dailyMax);
if (result.Success)
{
foreach (var item in result.Data)
{
Console.WriteLine(item.CarId + "\t " + item.BrandId + "\t " + item.ColorId + "\t " + item.Description + "\t\t " + item.DailyPrice);
}
Console.WriteLine("\n\nFiltered by min {0} and max {1} Daily Price", dailyMin, dailyMax);
}
else
{
Console.WriteLine(result.Message);
}
}
private static void GetByDailyPrice(CarManager carManager)
{
foreach (var car in carManager.GetByDailyPrice(57000, 100000).Data)
{
Console.WriteLine("{0} {1} {2} {3} {4}", car.Id, car.BrandId, car.ColorId, car.DailyPrice, car.Description);
}
}
private static void GetCarsByDailyPrice()
{
CarManager carManager = new CarManager(new EfCarDal());
var result = carManager.GetByDailyPrice(100, 200);
if (result.Success == true)
{
Console.WriteLine("\n#################### Belirtilen fiyat aralığındaki araçlar ####################\n");
foreach (var car in result.Data)
{
Console.WriteLine("Aracın Model Yılı: " + car.ModelYear + "\n" +
"Araç Marka ve Modeli: " + car.CarName + "\n" +
"Aracın Günlük Ücreti: " + car.DailyPrice + " TL\n" +
"--------------------------------------------------------\n"
);
}
}
else
{
Console.WriteLine(result.Message + "\n");
}
}
static void Main(string[] args)
{
// ***** Car Class manager ******
CarManager car1 = new CarManager(new EfCarDal());
car1.Add(new Car
{
CarId = 30,
BrandId = 20,
ColorId = 10,
ModelYear = new DateTime(2010, 2, 2),
DailyPrice = 20000,
Description = "test"
});
foreach (var car in car1.GetAll())
{
Console.WriteLine("Car ID : " + car.CarId);
Console.WriteLine("BrandId : " + car.BrandId);
Console.WriteLine("Color ID : " + car.ColorId);
Console.WriteLine("Model year : " + car.ModelYear);
Console.WriteLine("Daily Price : " + car.DailyPrice);
Console.WriteLine("Description : " + car.Description);
}
foreach (var car in car1.GetAllByBrandId(5))
{
Console.WriteLine("BrandId : " + car.BrandId);
}
foreach (var car in car1.GetByDailyPrice(20, 50))
{
Console.WriteLine("Daily Price : " + car.DailyPrice);
}
// ***** Color Class manager ******
ColorManager color1 = new ColorManager(new EfColorDal());
color1.Add(new Color {
ColorId = 88, ColorName = "Mavi"
});
foreach (var color in color1.GetAll())
{
Console.WriteLine("Color ID : " + color.ColorId);
Console.WriteLine("Color Name : " + color.ColorName);
}
// ***** Brand Class manager ******
BrandManager brand1 = new BrandManager(new EfBrandDal());
brand1.Add(new Brand {
BrandId = 50, BrandName = "Toyota"
});
foreach (var brand in brand1.GetAll())
{
Console.WriteLine("Brand ID : " + brand.BrandId);
Console.WriteLine("Brand Name : " + brand.BrandName);
}
}
static void Main(string[] args)
{
CarManager carManager = new CarManager(new EfCarDal());
foreach (var car in carManager.GetByDailyPrice(1000, 1500))
{
Console.WriteLine(car.DailyPrice);
}
}
private static void MinPrice()
{
CarManager carManager = new CarManager(new EfCarDal());
foreach (var car in carManager.GetByDailyPrice(0).Data)
{
Console.WriteLine("Description: " + car.Description + " BrandId: " + car.BrandId + " ColorId: " + car.ColorId + " DailyPrice: " + car.DailyPrice + " ModelYear: " + car.ModelYear);
}
}
private static void CarTest()
{
CarManager carManager = new CarManager(new EfCarDal());
foreach (var car in carManager.GetByDailyPrice(10000, 12000).Data)
{
Console.WriteLine(car.Description);
}
}
private static void CarTest()
{
CarManager carManager = new CarManager(new EfCarDal());
foreach (var car in carManager.GetByDailyPrice(10, 1500))
{
Console.WriteLine(car.CarId);
}
}
private static void GetAllCarByDailyPrize(int t1, int t2)
{
CarManager carManager = new CarManager(new EfCarDal(), new BrandManager(new EfBrandDal()));
foreach (var car in carManager.GetByDailyPrice(t1, t2).Data)
{
Console.WriteLine(car.CarName);
}
}
private static void DailyPrice(CarManager carManager)
{
var result1 = carManager.GetByDailyPrice(110);
foreach (var car in result1.Data)
{
Console.WriteLine(car.DailyPrice);
//Console.WriteLine(car.DailyPrice + "" + car.CarName + "" + car.BrandId);
}
}
private static void GetCarByPrice(decimal min, decimal max)
{
CarManager carManager = new CarManager(new EfCarDAL());
Console.WriteLine("Girilen aralık : " + min + "-" + max);
foreach (var items in carManager.GetByDailyPrice(min, max).Data)
{
// Console.WriteLine("Araba adı :{0} - Fiyatı : {1}"+items.Description,items.DailyPrice);
Console.WriteLine(items.Description + " - " + items.DailyPrice);
}
}
private static void getCarByDailyPrice(CarManager carManager)
{
foreach (var car in carManager.GetByDailyPrice(30, 100).Data)
{
Console.WriteLine("\n\n----Kiralık Araba Bilgileri----\n");
Console.WriteLine("Araba ID: " + car.Id + "\nAraba Model ID: " + car.BrandId +
"\nAraba Renk ID: " + car.ColorId + "\nAraba Model Yıl:" + car.ModelYear +
"\nAraba Günlük Kira: " + car.DailyPrice + "\nAraba Açıklama: " + car.Description);
}
}
private static void CarGetByDailyPriceTest(CarManager carManager)
{
var result = carManager.GetByDailyPrice(0, 500);
if (result.Success == true)
{
foreach (var car in result.Data)
{
Console.WriteLine(car.CarName);
}
}
}
private static void CarDailyPriceTest()
{
CarManager carManager = new CarManager(new EfCarDal());
var result = carManager.GetByDailyPrice(500, 1000);
if (result.Success == true)
{
foreach (var car in result.Data)
{
Console.WriteLine(car.DailyPrice);
}
}
}
private static void CarTest()
{
CarManager carManager = new CarManager(new EfCarDal());
foreach (var car in carManager.GetByDailyPrice(750).Data)
{
Console.WriteLine(car.Description);
}
Console.WriteLine("-------------------");
foreach (var product in carManager.GetCarDetails().Data)
{
Console.WriteLine(product.CarName + "/" + product.BrandName);
}
}
static void Main(string[] args)
{
CarManager carManager = new CarManager(new EfCarDal());
BrandManager brandManager = new BrandManager(new EfBrandDal());
ColorManager colorManager = new ColorManager(new EfColorDal());
CarList(carManager, brandManager, colorManager);
//AddedTest(carManager, brandManager, colorManager);
//DeletedTest(carManager, brandManager, colorManager);
//UpdatedTest(carManager, brandManager, colorManager);
Console.WriteLine("Id'si 1 olan araç bilgileri..");
Console.WriteLine("Id - - BrandId - ColorId - ModelYear - DailyPrice - Description");
foreach (var car in carManager.GetByCarsId(1))
{
Console.WriteLine(car.CarId + "\t" + car.BrandId + "\t" + car.ColorId + "\t" + car.ModelYear + "\t" + car.DailyPrice + "\t" + car.Description);
}
Console.WriteLine("Günlük fiyatı 170 ile 100 arasındaki araçlar..");
Console.WriteLine("Id - - BrandId - ColorId - ModelYear - DailyPrice - Description");
foreach (var car in carManager.GetByDailyPrice(100, 170))
{
Console.WriteLine(car.CarId + "\t" + car.BrandId + "\t" + car.ColorId + "\t" + car.ModelYear + "\t" + car.DailyPrice + "\t" + car.Description);
}
Console.WriteLine("Model yılı 2018 olan araçlar..");
Console.WriteLine("Id - - BrandId - ColorId - ModelYear - DailyPrice - Description");
foreach (var car in carManager.GetByModelYear(2018))
{
Console.WriteLine(car.CarId + "\t" + car.BrandId + "\t" + car.ColorId + "\t" + car.ModelYear + "\t" + car.DailyPrice + "\t" + car.Description);
}
Console.WriteLine("Brand Id si 2 olan marka bilgileri..");
Console.WriteLine("BrandId - - BrandName");
Brand brand = brandManager.GetCarsByBrandId(2);
Console.WriteLine(brand.BrandId + "\t" + brand.BrandName);
Console.WriteLine("Color Id si 2 olan renk bilgileri..");
Console.WriteLine("ColorId - - ColorName");
Color color = colorManager.GetCarsByColorId(2);
Console.WriteLine(color.ColorId + "\t" + color.ColorName);
}
private static void DailyPriceTest()
{
CarManager carManager = new CarManager(new EfCarDal());
var result = carManager.GetByDailyPrice(250, 400);
if (result.Success == true)
{
foreach (var car in result.Data)
{
Console.WriteLine("Model Year:" + car.ModelYear + ", Daily Price:" + car.DailyPrice + ", Description:" + car.Description);
}
}
else
{
Console.WriteLine(result.Message);
}
}
private static void CarCrud()
{
CarManager carManager = new CarManager(new EfCarDal());
//Car car1 = new Car
//{
// /* Id = 2,*/ // identity yapıldı
// BrandId = 6,
// ColorId = 7,
// ModelYear = 1800,
// DailyPrice = 3000,
// Description = "Elektrikli",
// CarName = "Ferrai"
//};
// carManager.Add(car1);
// carManager.Delete(new Car { Id=1});
//carManager.Update(new Car { Id = 1, BrandId = 3, ColorId = 4, DailyPrice = 1800, Description = "İyi Araba", CarName = "Bugatti" ,ModelYear=1993});
Console.WriteLine("-----Car GetAll-----");
foreach (var item in carManager.GetAll())
{
Console.WriteLine("ID : " + item.Id + " BrandID : " + " " + item.BrandId + " " + "ColorID : " + " " + item.ColorId + " " + "Model Year : " + item.ModelYear + " " + "Daily Price : " + " " + item.DailyPrice + " " + "Description : " + item.Description);
}
Console.WriteLine("------Car GetById------");
var carById = carManager.GetById(1003);
Console.WriteLine("ID : " + carById.Id + " BrandID : " + " " + carById.BrandId + " " + "ColorID : " + " " + carById.ColorId + " " + "Model Year : " + carById.ModelYear + " " + "Daily Price : " + " " + carById.DailyPrice + " " + "Description : " + carById.Description);
Console.WriteLine("-----Car GetByDailyPrice----- ");
foreach (var item in carManager.GetByDailyPrice(150, 3001))
{
Console.WriteLine("ID : " + item.Id + " BrandID : " + " " + item.BrandId + " " + "ColorID : " + " " + item.ColorId + " " + "Model Year : " + item.ModelYear + " " + "Daily Price : " + " " + item.DailyPrice + " " + "Description : " + item.Description);
}
Console.WriteLine("-----Car DetailsDto----- ");
foreach (var item in carManager.GetCarDetailDtos())
{
Console.WriteLine(item.Id + " " + item.CarName + " " + item.BrandName + " " + item.ColorName + " " + item.DailyPrice);
}
}
private static void DisplayingCarsByPrice()
{
CarManager carManager = new CarManager(new EfCarDal());
var result = carManager.GetByDailyPrice(100, 600);
if (result.Success == true)
{
foreach (var car in result.Data)
{
Console.WriteLine("Car in the specified price range: {0}", car.Name);
}
}
else
{
Console.WriteLine(result.Message);
}
}
private static void FindCarForPrice(CarManager carManager, Color color, Brand brand)
{
Console.WriteLine("Minimum günlük kullanım ücretini giriniz : ");
decimal dailyPrice1 = Convert.ToDecimal(Console.ReadLine());
Console.WriteLine("Maksimum günlük kullanım ücretini giriniz : ");
decimal dailyPrice2 = Convert.ToDecimal(Console.ReadLine());
Console.WriteLine("Belirttiğiniz ücret aralığındaki arabalar : \n\tAraç Rengi\tModel\t" +
"Çıkış Yılı\tGünlük Fiyat\tAçıklama ");
var resultPrice = carManager.GetByDailyPrice(dailyPrice1, dailyPrice2);
foreach (var cars in resultPrice.Data)
{
Console.WriteLine($"{cars.CarID}\t{color.ColorName}\t{brand.BrandName}\t{cars.ModelYear}\t\t{cars.DailyPrice}\t\t{cars.Description}");
}
}
private static void DailyPriceTest(CarManager carManager, BrandManager brandManager, ColorManager colorManager)
{
var result = carManager.GetByDailyPrice(100, 165);
if (result.Success)
{
Console.WriteLine("\n\nGünlük fiyat aralığı 100 ile 165 olan arabalar: \nId\tColor Name\tBrand Name\tModel Year\tDaily Price\tDescriptions");
foreach (var car in result.Data)
{
Console.WriteLine($"{car.CarId}\t{colorManager.GetById(car.ColorId).Data.ColorName}\t\t{brandManager.GetById(car.BrandId).Data.BrandName}\t\t{car.ModelYear}\t\t{car.DailyPrice}\t\t{car.Description}");
}
}
else
{
Console.WriteLine(result.Message);
}
}
private static void CarTest()
{
CarManager carManager = new CarManager(new EfCarDal());
BrandManager brandManager = new BrandManager(new EfBrandDal());
ColorManager colorManager = new ColorManager(new EfColorDal());
foreach (var car in carManager.GetCarDetails().Data)
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}\t{5}", car.CarId, car.BrandName, car.ColorName, car.ModelYear, car.DailyPrice, car.Description);
}
Console.WriteLine("Bütün Arabalar :");
foreach (var car in carManager.GetAll().Data)
{
Console.WriteLine($"{car.CarId}\t{colorManager.GetById(car.ColorId).ColorName}\t\t{brandManager.GetById(car.BrandId).BrandName}\t\t{car.ModelYear}\t\t{car.DailyPrice}\t\t{car.Description}");
}
Console.WriteLine("Siyah Arabalar :");
foreach (var car in carManager.GetByColor(14).Data)
{
Console.WriteLine($"{car.CarId}\t{colorManager.GetById(car.ColorId).ColorName}\t\t{brandManager.GetById(car.BrandId).BrandName}\t\t{car.ModelYear}\t\t{car.DailyPrice}\t\t{car.Description}");
}
Console.WriteLine("Volvo Marka Arabalar :");
foreach (var car in carManager.GetByBrand(41).Data)
{
Console.WriteLine($"{car.CarId}\t{colorManager.GetById(car.ColorId).ColorName}\t\t{brandManager.GetById(car.BrandId).BrandName}\t\t{car.ModelYear}\t\t{car.DailyPrice}\t\t{car.Description}");
}
Console.WriteLine("Günlük Ücreti 200 - 300 TL Arası Olan Arabalar :");
foreach (var car in carManager.GetByDailyPrice(200, 300).Data)
{
Console.WriteLine($"{car.CarId}\t{colorManager.GetById(car.ColorId).ColorName}\t\t{brandManager.GetById(car.BrandId).BrandName}\t\t{car.ModelYear}\t\t{car.DailyPrice}\t\t{car.Description}");
}
carManager.Add(new Car {
CarId = 14, BrandId = 10, ColorId = 3, DailyPrice = -230, Description = ""
});
}
private static void TestGetByDailyPrice(int min, int max)
{
CarManager carManager = new CarManager(new EfCarDal());
var result = carManager.GetByDailyPrice(min, max);
int a = 0;
if (result.Success == true)
{
Console.WriteLine("-------------------------");
Console.WriteLine("Günlük Kiralama Bedeli " + min + "-" + max + " arasinda olan " + result.Data.Count + " adet arac bulundu");
foreach (var car in result.Data)
{
a = a + 1;
Console.WriteLine(a + ".ürün:" + car.ModelYear + " -" + car.Descriptions + " ---> " + car.DailyPrice + " TL");
}
Console.WriteLine("-------------------------");
Console.WriteLine(result.Message);
}
else
{
Console.WriteLine("-------------------------");
Console.WriteLine(result.Message);
}
}
