private static void ListCustomer()
{
Console.WriteLine("List Cusomers");
using (var db = new RentCDb())
{
var query = (from c in db.Customers
select c).ToArray();
int nrRows = query.Count();
string[] headers = { "CustomerID", "Name", "Birt Date" };
string[][] rows = new string[query.Length][];
int i = 0;
foreach (var item in query)
{
string[] row = new string[3];
row[0] = item.CostumerID.ToString();
row[1] = item.Name.ToString();
row[2] = item.BirthDate.Date.ToString();
rows[i] = row;
i++;
}
DrawTable.DrawMyTable(headers, query.Length, rows);
}
Console.ReadKey();
SelectOption();
}
private static void ListRents()
{
Console.WriteLine("List Rentals");
using (var db = new RentCDb())
{
var query = (from r in db.Reservations
select r).ToArray();
int nrRows = query.Count();
string[] headers = { "CarPlate", "ClientID", "Start Date", "End Date", "Location" };
string[][] rows = new string[query.Length][];
int i = 0;
foreach (var item in query)
{
string[] row = new string[5];
row[0] = item.Car.Plate;
row[1] = item.CostumerID.ToString();
row[2] = item.StartDate.Date.ToString();
row[3] = item.EndDate.ToShortDateString();
var location = db.Locations.Find(item.LocationID).Name;
row[4] = location;
rows[i] = row;
i++;
}
DrawTable.DrawMyTable(headers, query.Length, rows);
}
Console.ReadKey();
SelectOption();
}
private static void ListAvailableCars()
{
localhost.WebService1 proxy = new localhost.WebService1();
var jsonAvailableCars = proxy.AvalialbleCars();
Car[] availableCars = JsonConvert.DeserializeObject <List <Car> >(jsonAvailableCars).ToArray();
using (var db = new RentCDb())
{
int nrRows = availableCars.Length;
string[] headers = { "CarID", "Plate", "Manufacturer", "Model", "PricePerDay", "Location" };
string[][] rows = new string[availableCars.Length][];
int i = 0;
foreach (var item in availableCars)
{
string[] row = new string[5];
row[0] = item.CarID.ToString();
row[1] = item.Plate;
row[2] = item.Manufacturer;
row[3] = item.Model;
row[3] = item.PricePerDay.ToString();
row[3] = db.Locations.Find(item.LocationID).Name;
var location = db.Locations.Find(item.LocationID).Name;
row[4] = location;
rows[i] = row;
i++;
}
DrawTable.DrawMyTable(headers, availableCars.Length, rows);
SelectOption();
}
}
