public ActionResult Rent(int id, DateTime DateFrom, DateTime DateTo)
{
var car = _context.carModels.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(HttpNotFound());
}
CarRentViewModels carRentViewModel = new CarRentViewModels();
carRentViewModel.car = car;
carRentViewModel.dateFrom = DateFrom;
carRentViewModel.dateTo = DateTo;
carRentViewModel.days = Math.Ceiling((DateTo - DateFrom).TotalDays);
carRentViewModel.TotalPrice = car.PricePerDay * carRentViewModel.days;
carRentViewModel.PaymentMethod = new List <SelectListItem>();
carRentViewModel.PaymentMethod.Add(new SelectListItem {
Text = "Opłata przy odbiorze", Value = "1"
});
carRentViewModel.PaymentMethod.Add(new SelectListItem {
Text = "Płatność online", Value = "2"
});
return(View(carRentViewModel));
}
ConfirmRent( /*int id, DateTime DateFrom, DateTime DateTo, double TotalPrice, string userId, int paymentMethod*/
CarRentViewModels rentModel)
{
//string dT = rentModel.dateTo.ToString("yyyyddMMHHmmss");
//string dF = rentModel.dateFrom.ToString("yyyyddMMHHmmss");
string dT = rentModel.YearTo + rentModel.MonthTo.PadLeft(2, '0') + rentModel.DayTo.PadLeft(2, '0') +
rentModel.HourTo.PadLeft(2, '0') + rentModel.MinuteTo.PadLeft(2, '0') +
rentModel.SecundTo.PadLeft(2, '0');
string dF = rentModel.YearFrom + rentModel.MonthFrom.PadLeft(2, '0') + rentModel.DayFrom.PadLeft(2, '0') +
rentModel.HourFrom.PadLeft(2, '0') + rentModel.MinuteFrom.PadLeft(2, '0') +
rentModel.SecundFrom.PadLeft(2, '0');
if (rentModel.ChoosenPaymentMethod == 1)
{
string query = String.Format(@"INSERT INTO bookingmodels VALUES (null,'{0}','{1}','{2}',{3},{4},5,1,{0})", rentModel.car.Id, rentModel.userId, dF, dT, rentModel.TotalPrice);
//INSERT INTO rentalisv2.bookingmodels VALUES (null,'20171010080000','20171020080000',300,'asdasdas-eeq123-dxczcc.ad',2);
MySqlConnection conn = new MySqlConnection("SERVER=localhost;DATABASE=rentalisv2;UID=root;PASSWORD=;");
try
{
using (MySqlCommand cmdDatabase = new MySqlCommand(query, conn))
{
conn.Open();
cmdDatabase.ExecuteNonQuery();
return(View("CorrectlyRented", rentModel));
}
}
catch
{
return(HttpNotFound());
}
}
else if (rentModel.ChoosenPaymentMethod == 2)
{
string query = String.Format(@"INSERT INTO bookingmodels VALUES (null,'{0}','{1}','{2}',{3},{4},1,2,{0})", rentModel.car.Id, rentModel.userId, dF, dT, rentModel.TotalPrice);
//INSERT INTO rentalisv2.bookingmodels VALUES (null,'20171010080000','20171020080000',300,'asdasdas-eeq123-dxczcc.ad',2);
MySqlConnection conn = new MySqlConnection("SERVER=localhost;DATABASE=rentalisv2;UID=root;PASSWORD=;");
try
{
using (MySqlCommand cmdDatabase = new MySqlCommand(query, conn))
{
conn.Open();
cmdDatabase.ExecuteNonQuery();
return(View("CorrectlyRented", rentModel));
}
}
catch
{
return(HttpNotFound());
}
}
else
{
return(HttpNotFound());
}
}
