public void CheckStatusInfo(CartRent rent) { DataManager data = new DataManager(); Tools tools = new Tools(); string query1 = "(SELECT ReservStatsID FROM Reservations WHERE NOT((StartDate > convert(date,'" + rent.endDate + "',104)) or" + " (EndDate < convert(date, '" + rent.startDate + "', 104))))"; string query = "SELECT DISTINCT ReservStatsID FROM Reservations WHERE CarID = '" + rent.car.carID + "' and ReservStatsID IN "; try { using (data.databaseConnection = new SqlConnection()) { data.setDatabaseConection(); data.databaseConnection.Open(); SqlCommand getStatusInfo = new SqlCommand(query + query1, data.databaseConnection); SqlDataReader reader = getStatusInfo.ExecuteReader(); while (reader.Read()) { string sID = reader[0].ToString(); this.ID = Int32.Parse(sID); } } }catch (SqlException e) { Console.WriteLine(e.StackTrace); } }
public void readCarData(CartRent rent) { Console.Clear(); Console.WriteLine("Cart Plate:"); this.plate = Console.ReadLine(); Console.WriteLine("Car Model:"); this.model = Console.ReadLine(); Console.WriteLine("Start Date:"); rent.startDate = Console.ReadLine(); Console.WriteLine("End Date:"); rent.endDate = Console.ReadLine(); Console.WriteLine("City:"); this.location = Console.ReadLine(); }
public void availableCarList(CartRent rent) ////Need Modifications { DataManager data = new DataManager(); Tools tools = new Tools(); string query1 = "SELECT * FROM Cars WHERE Location = '" + location + "' and Plate = '" + plate + "' and Model = '" + model + "' and carID NOT IN"; string query2 = "(SELECT carID FROM Reservations WHERE NOT((StartDate > '" + tools.convertStringDate(rent.endDate).ToString("yyyy-MM-dd") + "') OR (EndDate < '" + tools.convertStringDate(rent.startDate).ToString("yyyy-MM-dd") + "')))"; using (data.databaseConnection = new SqlConnection()) { using (SqlCommand getAvailableCars = new SqlCommand()) { data.setDatabaseConection(); getAvailableCars.Connection = data.databaseConnection; getAvailableCars.CommandText = query1 + query2; Console.WriteLine(string.Format("{0}\t {1}\t {2}\t {3}\t {4}\t {5}", "Car ID", "Cart Plate", "Manufacturer", "Model", "PricePerDay", "City")); try { data.databaseConnection.Open(); SqlDataReader dataReader = getAvailableCars.ExecuteReader(); while (dataReader.Read()) { Console.WriteLine(string.Format("{0}\t |{1}\t\t |{2}\t |{3}\t |{4}\t |{5}", dataReader[0], dataReader[1], dataReader[2], dataReader[3], dataReader[4], dataReader[5])); } } catch (SqlException e) { Console.WriteLine(e); } } } }