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));
}
