public ActionResult Rent(Court court, CourtReservation reservation, string selectedDate)
{
Reservation res = new Reservation();
//court
if (court.IDCourt > 0)
{
res.Court = db.Courts.Find(court.IDCourt);
res.CourtID = court.IDCourt;
}
else
{
ModelState.AddModelError("", "Teren invalid!");
return View(res.Court);
}
//date
if (selectedDate != null && selectedDate!="")
{
CultureInfo culture = new CultureInfo("ro-RO");
DateTime reservationDate = Convert.ToDateTime(selectedDate,culture);
if ((reservationDate.Year >= DateTime.Now.Year &&
reservationDate.Month >= DateTime.Now.Month &&
reservationDate.Day >= DateTime.Now.Day))
{
res.ReservationDate = reservationDate;
}
else
{
ModelState.AddModelError("", "Data invalida! Va rugam sa selectati o data din viitor!");
return View("Details", res.Court);
}
}
else
{
ModelState.AddModelError("", "Va trebui sa selectati o data!");
return View("Details", res.Court);
}
bool forToday = (res.ReservationDate.Year == DateTime.Now.Year) &&
(res.ReservationDate.Month == DateTime.Now.Month) &&
(res.ReservationDate.Day == DateTime.Now.Day);
//user
res.User = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
if (res.User == null)
{
ModelState.AddModelError("", "Utilizator necunoscut!");
return View(res.Court);
}
res.UserID = res.User.IDUser;
res.User.UserGroup = db.UserGroups.Where(u => u.IDUserGroup == res.User.UserGroupID).FirstOrDefault();
res.User.UserPasswordConfirm = res.User.UserPassword;
//Reservation hours
List<Reservation> reservations = new List<Reservation>();
if (reservation.NZeceDoispe)
{
if ((forToday && DateTime.Now.Hour < 9) || !forToday)
{
Reservation res1012 = Utilities.Clone(res);
res1012.ReservationTime = db.ReservationTimes.Where(r => r.Hours == "10-12").First();
res1012.ReservationTimeID = res1012.ReservationTime.IDReservationTime;
db.Reservations.Add(res1012);
db.Entry(res1012.Court).State = EntityState.Detached;
db.Entry(res1012.User).State = EntityState.Detached;
reservations.Add(res1012);
}
else
{
ModelState.AddModelError("", "Terenul trebuie rezervat cu minim o ora inainte de prezentare!");
return View("Details", res.Court);
}
}
if (reservation.NDoispePaispe)
{
if ((forToday && DateTime.Now.Hour < 11) || !forToday)
{
Reservation res1214 = Utilities.Clone(res);
res1214.ReservationTime = db.ReservationTimes.Where(r => r.Hours == "12-14").First();
res1214.ReservationTimeID = res1214.ReservationTime.IDReservationTime;
db.Reservations.Add(res1214);
db.Entry(res1214.Court).State = EntityState.Detached;
db.Entry(res1214.User).State = EntityState.Detached;
reservations.Add(res1214);
}
else
{
ModelState.AddModelError("", "Terenul trebuie rezervat cu minim o ora inainte de prezentare!");
return View("Details", res.Court);
}
}
if (reservation.NPaispeSaispe)
{
if ((forToday && DateTime.Now.Hour < 13) || !forToday)
{
Reservation res1416 = Utilities.Clone(res);
res1416.ReservationTime = db.ReservationTimes.Where(r => r.Hours == "14-16").First();
res1416.ReservationTimeID = res1416.ReservationTime.IDReservationTime;
db.Reservations.Add(res1416);
db.Entry(res1416.Court).State = EntityState.Detached;
db.Entry(res1416.User).State = EntityState.Detached;
reservations.Add(res1416);
}
else
{
ModelState.AddModelError("", "Terenul trebuie rezervat cu minim o ora inainte de prezentare!");
return View("Details", res.Court);
}
}
if (reservation.NSaispeOptspe)
{
if ((forToday && DateTime.Now.Hour < 15) || !forToday)
{
Reservation res1618 = Utilities.Clone(res);
res1618.ReservationTime = db.ReservationTimes.Where(r => r.Hours == "16-18").First();
res1618.ReservationTimeID = res1618.ReservationTime.IDReservationTime;
db.Reservations.Add(res1618);
db.Entry(res1618.Court).State = EntityState.Detached;
db.Entry(res1618.User).State = EntityState.Detached;
reservations.Add(res1618);
}
else
{
ModelState.AddModelError("", "Terenul trebuie rezervat cu minim o ora inainte de prezentare!");
return View("Details", res.Court);
}
}
if (reservation.NOptspeDouazeci)
{
if ((forToday && DateTime.Now.Hour < 17) || !forToday)
{
Reservation res1820 = Utilities.Clone(res);
res1820.ReservationTime = db.ReservationTimes.Where(r => r.Hours == "18-20").First();
res1820.ReservationTimeID = res1820.ReservationTime.IDReservationTime;
db.Reservations.Add(res1820);
db.Entry(res1820.Court).State = EntityState.Detached;
db.Entry(res1820.User).State = EntityState.Detached;
reservations.Add(res1820);
}
else
{
ModelState.AddModelError("", "Terenul trebuie rezervat cu minim o ora inainte de prezentare!");
return View("Details", res.Court);
}
}
if (reservation.NDouazeciDouajdoi)
{
if ((forToday && DateTime.Now.Hour < 19) || !forToday)
{
Reservation res2022 = Utilities.Clone(res);
res2022.ReservationTime = db.ReservationTimes.Where(r => r.Hours == "20-22").First();
res2022.ReservationTimeID = res2022.ReservationTime.IDReservationTime;
db.Reservations.Add(res2022);
db.Entry(res2022.Court).State = EntityState.Detached;
db.Entry(res2022.User).State = EntityState.Detached;
reservations.Add(res2022);
}
else
{
ModelState.AddModelError("", "Terenul trebuie rezervat cu minim o ora inainte de prezentare!");
return View("Details", res.Court);
}
}
try
{
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException er)
{
foreach (var validationErrors in er.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
ModelState.AddModelError(validationError.PropertyName, validationError.ErrorMessage);
}
}
return View("Details", res.Court);
}
if (reservations.Count > 0)
{
if (res.Court.EmailAddress != null)
{
StringBuilder body = new StringBuilder();
StringBuilder sms = new StringBuilder();
body.Append("Buna ziua,\n");
if (reservations.Count == 1)
{
body.Append("O noua rezervare a fost creata pe terenul " + res.Court.CourtName);
sms.Append("Rezervare noua ");
}
else
{
body.Append("Noi rezervari au fost create pe terenul " + res.Court.CourtName);
sms.Append("Rezervari noi ");
}
body.Append(" de catre "+res.User.UserEmail + ". \n");
body.Append("Rezervarea este in data de " + res.ReservationDate.ToString("dd.MM.yyyy") + " la orele: \n");
sms.Append("pe terenul " + res.Court.CourtName + " in data de " + res.ReservationDate.ToString("dd.MM.yyyy") + " la orele: ");
foreach (var item in reservations)
{
body.Append(item.ReservationTime.Hours + "\n");
sms.Append(item.ReservationTime.Hours + " ");
}
sms.Append(". Contact:" + res.User.UserEmail);
body.Append("O zi placuta");
Utilities.EmailSend(res.Court.EmailAddress, "Rezervare noua pe terenul " + res.Court.CourtName, body.ToString());
Utilities.SmsSend(res.Court.PhoneNumber, sms.ToString());
}
return View("ReservationConfirmation", reservations);
}
else
{
ModelState.AddModelError("", "Nicio ora nu a fost selectata din lista de ore pentru rezervare!");
return View("Details", res.Court);
}
}
public ActionResult Create([Bind(Include = "Address,CourtName,Length,Width,PhoneNumber,EmailAddress,SessionPrice, SportID")] Court court, HttpPostedFileBase Content1, HttpPostedFileBase Content2, HttpPostedFileBase Content3)
//,AddressStreet,AddressNumber,AddressCity,AddressCounty
{
if (ModelState.IsValid)
{
Court myCourt = new Court();
myCourt.CourtName = court.CourtName;
myCourt.Length = court.Length;
myCourt.Width = court.Width;
if (court.PhoneNumber != null)
if (IsPhoneNumber(court.PhoneNumber))
{
myCourt.PhoneNumber = court.PhoneNumber;
}
else
{
ModelState.AddModelError("PhoneNumber", "Campul Numar telefon trebuie sa respecte formatul unui numar de telefon!");
return View("Create", court);
}
myCourt.EmailAddress = court.EmailAddress;
myCourt.CreateUserID = court.CreateUserID;
myCourt.SessionPrice = court.SessionPrice;
if (Content1 != null && Content1.ContentLength > 0)
{
byte[] tempFile = new byte[Content1.ContentLength];
Content1.InputStream.Read(tempFile, 0, Content1.ContentLength);
myCourt.Content1 = tempFile;
myCourt.FileName1 = Content1.FileName;
}
if (Content2 != null && Content2.ContentLength > 0)
{
byte[] tempFile = new byte[Content2.ContentLength];
Content2.InputStream.Read(tempFile, 0, Content2.ContentLength);
myCourt.Content2 = tempFile;
myCourt.FileName2 = Content2.FileName;
}
if (Content3 != null && Content3.ContentLength > 0)
{
byte[] tempFile = new byte[Content3.ContentLength];
Content3.InputStream.Read(tempFile, 0, Content3.ContentLength);
myCourt.Content3 = tempFile;
myCourt.FileName3 = Content3.FileName;
}
Address myAdd = new Address();
myAdd.AddressStreet = court.Address.AddressStreet;
myAdd.AddressNumber = court.Address.AddressNumber;
myAdd.AddressCity = court.Address.AddressCity;
myAdd.AddressCounty = court.Address.AddressCounty;
db.Addresses.Add(myAdd);
db.SaveChanges();
myCourt.AddressID = myAdd.IDAddress;
myCourt.Address = db.Addresses.Where(a => a.IDAddress == myCourt.AddressID).FirstOrDefault();
myCourt.SportID = court.SportID;
myCourt.Sport = db.Sports.Where(s => s.IDSport == myCourt.SportID).FirstOrDefault();
myCourt.CreateUserID = db.Users.Where(u => u.UserName == HttpContext.User.Identity.Name).FirstOrDefault().IDUser;
myCourt.User = db.Users.Where(u => u.IDUser == myCourt.CreateUserID).FirstOrDefault();
myCourt.User.UserGroup = db.UserGroups.Where(u => u.IDUserGroup == myCourt.User.UserGroupID).FirstOrDefault();
myCourt.User.UserPasswordConfirm = myCourt.User.UserPassword;
if (Content1 != null && Content1.ContentLength > 0)
{
if (Content1.ContentLength > 1048576)
{
ViewBag.AddressID = new SelectList(db.Addresses, "IDAddress", "AddressStreet");
ViewBag.SportID = new SelectList(db.Sports, "IDSport", "SportName");
ViewBag.CreateUserID = new SelectList(db.Users, "IDUser", "UserName");
ModelState.AddModelError("", "Poza 1 trebuia sa aiba maxim 1MB");
return View("Create", court);
}
}
if (Content2 != null && Content2.ContentLength > 0)
{
if (Content2.ContentLength > 1048576)
{
ViewBag.AddressID = new SelectList(db.Addresses, "IDAddress", "AddressStreet");
ViewBag.SportID = new SelectList(db.Sports, "IDSport", "SportName");
ViewBag.CreateUserID = new SelectList(db.Users, "IDUser", "UserName");
ModelState.AddModelError("", "Poza 2 trebuia sa aiba maxim 1MB");
return View("Create", court);
}
}
if (Content3 != null && Content3.ContentLength > 0)
{
if (Content3.ContentLength > 1048576)
{
ViewBag.AddressID = new SelectList(db.Addresses, "IDAddress", "AddressStreet");
ViewBag.SportID = new SelectList(db.Sports, "IDSport", "SportName");
ViewBag.CreateUserID = new SelectList(db.Users, "IDUser", "UserName");
ModelState.AddModelError("", "Poza 3 trebuia sa aiba maxim 1MB");
return View("Create", court);
}
}
try
{
db.Courts.Add(myCourt);
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException er)
{
foreach (var validationErrors in er.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",validationError.PropertyName,validationError.ErrorMessage);
}
}
}
return RedirectToAction("Index");
}
ViewBag.AddressID = new SelectList(db.Addresses, "IDAddress", "AddressStreet", court.AddressID);
ViewBag.SportID = new SelectList(db.Sports, "IDSport", "SportName", court.SportID);
ViewBag.CreateUserID = new SelectList(db.Users, "IDUser", "UserName", court.CreateUserID);
return View(court);
}
