public static void MostRecentRentedCars() { Console.Clear(); string conString = "Data Source=DESKTOP-MJA5A7T;Initial Catalog=Car Rent;Integrated Security=True"; SqlConnection con = new SqlConnection(conString); con.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter("select * from Reservations", con); DataTable dt = new DataTable(); dataAdapter.Fill(dt); DataTable newTable = new DataTable(); newTable.Columns.Add("CarID"); newTable.Columns.Add("StartDate"); newTable.Columns.Add("EndDate"); newTable.Columns.Add("Location"); //order by endDate dt = OrderBy.OrderByEndDateDesc(dt); //add into the tabel just the days from the past foreach (DataRow row in dt.Rows) { if (DateTime.Parse(row["EndDate"].ToString()) < DateTime.Now) { newTable.ImportRow(row); } } int width = Console.WindowWidth; width = width / 4; Write.WriteProgress("CarID", 1, 1); Write.WriteProgress("StartDate", width, 1); Write.WriteProgress("EndDate", 2 * width, 1); Write.WriteProgress("Location", 3 * width, 1); int r = 3; foreach (DataRow row in newTable.Rows) { Write.WriteProgress(row["CarID"].ToString(), 1, r); Write.WriteProgress(row["StartDate"].ToString(), width, r); Write.WriteProgress(row["EndDate"].ToString(), 2 * width, r); Write.WriteProgress(row["Location"].ToString(), 3 * width, r); r++; //display just the first cars(20) from the table if (r == 23) { break; } } }
public static void ListRents() { Console.Clear(); string conString = "Data Source=DESKTOP-MJA5A7T;Initial Catalog=Car Rent;Integrated Security=True"; SqlConnection con = new SqlConnection(conString); con.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter("select Plate, CostumerID, StartDate, EndDate, Reservations.Location from Reservations join Cars on Reservations.CarID = Cars.CarID", con); DataTable dt = new DataTable(); dataAdapter.Fill(dt); DisplayListRents(dt); int column = 0; int prevColumn = 0; while (true) { column = int.Parse(Console.ReadLine()); if (column == prevColumn) { switch (column) { case 1: dt = OrderBy.OrderByCustomerIdDesc(dt); break; case 2: dt = OrderBy.OrderByPlateDesc(dt); break; case 3: dt = OrderBy.OrderByStartDateDesc(dt); break; case 4: dt = OrderBy.OrderByEndDateDesc(dt); break; case 5: dt = OrderBy.OrderByLocationDesc(dt); break; } } else { switch (column) { case 1: dt = OrderBy.OrderByCustomerId(dt); break; case 2: dt = OrderBy.OrderByPlate(dt); break; case 3: dt = OrderBy.OrderByStartDate(dt); break; case 4: dt = OrderBy.OrderByEndDate(dt); break; case 5: dt = OrderBy.OrderByLocation(dt); break; default: dt = OrderBy.OrderByCustomerId(dt); break; } } prevColumn = column; DisplayListRents(dt); } }