public ActionResult Details(int id, DateTime dateFrom, DateTime dateTo) { string dT = dateTo.ToString("yyyyMMddhhmmss"); string dF = dateFrom.ToString("yyyyMMddhhmmss"); var car = _context.carModels.SingleOrDefault(c => c.Id == id); if (car == null) { return(HttpNotFound()); } CarDetailsVievModels carDetailsVievModel = new CarDetailsVievModels(); carDetailsVievModel.car = car; carDetailsVievModel.DateFrom = dF; carDetailsVievModel.DateTo = dT; carDetailsVievModel.DateFromDT = dateFrom; carDetailsVievModel.DateToDT = dateTo; string query = String.Format(@"SELECT * FROM bookingmodels B WHERE carId = {0} AND ({1} >= DateTimeFrom AND {1} <=DateTimeTo) OR ({2} >= DateTimeFrom AND {2} <= DateTimeTo) ;", id.ToString(), dF, dT); MySqlConnection conn = new MySqlConnection("SERVER=localhost;DATABASE=rentalisv2;UID=root;PASSWORD=;"); try { using (MySqlCommand cmdDatabase = new MySqlCommand(query, conn)) { conn.Open(); MySqlDataReader reader = cmdDatabase.ExecuteReader(); if (reader.HasRows) { carDetailsVievModel.IsAvailible = 1; } else { //CarRentViewModels carRentViewModel = new CarRentViewModels(); //carRentViewModel.car = car; //carRentViewModel.dateFrom = dateFrom; //carRentViewModel.dateTo = dateTo; //return View("Rent", carRentViewModel); carDetailsVievModel.IsAvailible = 2; } } } catch (Exception e) { Console.WriteLine(e); throw; } return(View(carDetailsVievModel)); }
public ActionResult Details(int id) { var car = _context.carModels.SingleOrDefault(c => c.Id == id); if (car == null) { return(HttpNotFound()); } CarDetailsVievModels carDetailsVievModel = new CarDetailsVievModels(); carDetailsVievModel.car = car; return(View(carDetailsVievModel)); }