public ActionResult AdminEdit(User user)
{
/*int i = 0;
* PropertyInfo[] properties = typeof(User).GetProperties();
* foreach (PropertyInfo property in properties)
* {
* property.SetValue(user, collection.GetValues(i++));
* }*/
using (HmDbContext context = new HmDbContext())
{
var contexUser = (from users in context.Users
where users.ID == user.ID
select users).FirstOrDefault();
contexUser.Username = user.Username;
contexUser.Password = user.Password;
contexUser.Name = user.Name;
contexUser.MiddleName = user.MiddleName;
contexUser.SureName = user.SureName;
contexUser.IDnum = user.IDnum;
contexUser.IsActive = user.IsActive;
contexUser.PhoneNumber = user.PhoneNumber;
contexUser.Email = user.Email;
//contextUser.IsActive = user.IsActive;
//contextUser.RetireDate = user.RetireDate;
context.SaveChanges();
}
return(Redirect("~/Admin/AdminSearch"));
}
public ActionResult AdminCreate(FormCollection collection)
{
if (Request.Form.Count == 0)
{
return(View());
}
foreach (string form in Request.Form)
{
if (Request.Form[form].Equals(null) || Request.Form[form].ToString() == "")
{
return(View());
}
}
User user = new User();
user.Username = Request.Form["username"];
user.Password = Request.Form["password"];
user.Name = Request.Form["name"];
user.MiddleName = Request.Form["midname"];
user.SureName = Request.Form["surename"];
user.IDnum = Request.Form["idnum"];
user.PhoneNumber = Request.Form["phonenumber"];
user.Email = Request.Form["email"];
user.IsActive = true;
user.Assignment = DateTime.Now;
using (HmDbContext context = new HmDbContext())
{
context.Users.Add(user);
context.SaveChanges();
}
return(View());
}
public ActionResult AdminCreateRoom(FormCollection collection)
{
if (Request.Form.Count == 0)
{
return(View());
}
foreach (string form in Request.Form)
{
if (Request.Form[form].Equals(null) || Request.Form[form].ToString() == "")
{
return(View());
}
}
Room room = new Room();
room.Capacity = int.Parse(Request.Form["capacity"]);
//room.Type.Request.Form["roomtype"];
room.AdultBedPrice = decimal.Parse(Request.Form["adultbedprice"]);
room.ChildBedPrice = decimal.Parse(Request.Form["childbedprice"]);
room.Number = Request.Form["number"];
using (HmDbContext context = new HmDbContext())
{
context.Rooms.Add(room);
context.SaveChanges();
}
return(View());
}
public ActionResult ManagerAddNewClientSave(Client client)
{
using (HmDbContext context = new HmDbContext())
{
context.Clients.Add(client);
context.SaveChanges();
}
return(RedirectToAction("ManagerSearchReservation"));
}
/*public ActionResult ManagerAddNewClient(Client client)
* {
* return View(client);
* }*/
public ActionResult ManagerSearchClient()
{
List <Client> clients = new List <Client>();
using (HmDbContext context = new HmDbContext())
{
clients = new List <Client>(context.Clients.OrderBy(x => x.FirstName).ToList());
}
return(View(clients));
}
public ActionResult AdminSearchRoom(FormCollection collection)
{
List <Room> rooms = new List <Room>();
using (HmDbContext context = new HmDbContext())
{
rooms = new List <Room>(context.Rooms.OrderBy(x => x.Occupation).ToList());
}
return(View(rooms));
}
public ActionResult AdminVerification(Admin admin)
{
using (var context = new HmDbContext())
{
bool isVerified = context.Admins.Where(a => a.Username.ToLower().Equals(admin.Username.ToLower())).First().Password == admin.Password;
if (isVerified)
{
return(RedirectToAction("AdminSearch", "Admin")); //View("~/Views/Admin/AdminSearch.cshtml");
}
}
return(View("AdminLogin"));
}
public ActionResult ManagerVerification(User manager)
{
using (var context = new HmDbContext())
{
bool isVerified = context.Users.Where(x => x.Username.ToLower().Equals(manager.Username.ToLower())).First().Password == manager.Password;
bool isActive = context.Users.Where(x => x.Username.ToLower().Equals(manager.Username.ToLower())).Where(y => y.Password == manager.Password).First().IsActive;
if (isVerified && isActive)
{
return(RedirectToAction("ManagerSearchRoom", "Manager"));
}
}
return(View("ManagerLogin"));
}
public ActionResult AdminEditFindRoomById(int id)
{
using (HmDbContext context = new HmDbContext())
{
var rooms = new List <Room>(context.Rooms.Where(r => r.ID == id).ToList());
if (rooms.Count == 1)
{
return(View(rooms.First()));
}
//else throw new InvalidOperationException("More than 1 user with the same Id found!");
}
return(Redirect("~/Admin/AdminSearchRooms"));
}
public ActionResult AdminEditFindRecordById(int id)
{
using (HmDbContext context = new HmDbContext())
{
var users = new List <User>(context.Users.Where(u => u.ID == id).ToList());
if (users.Count == 1)
{
return(View(users.First()));
}
//else throw new InvalidOperationException("More than 1 user with the same Id found!");
}
return(Redirect("~/Admin/AdminSearch"));
}
public ActionResult AdminDeleteRoom(int id)
{
using (HmDbContext context = new HmDbContext())
{
var rooms = new List <Room>(context.Rooms.Where(r => r.ID == id).ToList());
if (rooms.Count == 1)
{
context.Rooms.Remove(rooms.First());
context.SaveChanges();
}
}
return(Redirect("~/Admin/AdminSearchRoom"));
}
public ActionResult ManagerSearchReservation()
{
List <Reservation> reservations = new List <Reservation>();
using (HmDbContext context = new HmDbContext())
{
foreach (var reservation in context.Reservations.Where(x => x.DischargeDate > System.DateTime.Now))
{
context.Reservations.Remove(reservation);
}
context.SaveChanges();
reservations = new List <Reservation>(context.Reservations.OrderBy(x => x.DischargeDate).ToList());
}
return(View(reservations));
}
public ActionResult AdminDelete(int id)
{
using (HmDbContext context = new HmDbContext())
{
var users = new List <User>(context.Users.Where(u => u.ID == id).ToList());
if (users.Count == 1)
{
context.Users.Remove(users.First());
context.SaveChanges();
}
//else throw new InvalidOperationException("More than 1 user with the same Id found!");
}
return(Redirect("~/Admin/AdminSearch"));
}
public ActionResult AdminSearch(FormCollection collection)
{
List <User> users = new List <User>();
using (HmDbContext context = new HmDbContext())
{
string filterString = Request.Form["textfilter"];
if (filterString != null)
{
filterString = filterString.ToLower();
switch (Request.Form["filters"])
{
case "username":
users = new List <User>(context.Users.Where(x => x.Username.ToLower().Contains(filterString)).ToList());
break;
case "name":
users = new List <User>(context.Users.Where(x => x.Name.ToLower().Contains(filterString)).ToList());
break;
case "midname":
users = new List <User>(context.Users.Where(x => x.MiddleName.ToLower().Contains(filterString)).ToList());
break;
case "surename":
users = new List <User>(context.Users.Where(x => x.SureName.ToLower().Contains(filterString)).ToList());
break;
case "email":
users = new List <User>(context.Users.Where(x => x.Email.ToLower().Contains(filterString)).ToList());
break;
default:
users = new List <User>(context.Users.OrderBy(x => x.Name).ToList());
break;
}
}
else
{
users = new List <User>(context.Users.OrderBy(x => x.Name).ToList());
}
}
return(View(users));
}
public ActionResult AdminEditRoom(Room room)
{
using (HmDbContext context = new HmDbContext())
{
/*var contexRoom = (from rooms in context.Rooms
* where rooms.ID.Equals(rooms.ID)
* select rooms).FirstOrDefault();*/
Room contextRoom = new Room();
foreach (var rm in context.Rooms)
{
if (room.ID.Equals(rm.ID))
{
contextRoom = rm;
}
}
contextRoom.Capacity = room.Capacity;
contextRoom.AdultBedPrice = room.AdultBedPrice;
contextRoom.ChildBedPrice = room.ChildBedPrice;
contextRoom.Number = room.Number;
context.SaveChanges();
}
return(Redirect("~/Admin/AdminSearchRoom"));
}
public UserRepository(HmDbContext context)
{
this.context = context;
}
//[Route("Manager/ManagerNewReservationSave/{model}/{isForSave}")]
public ActionResult ManagerNewReservationSave(Reservation reservation)
{
bool isClientForAddition = false;
decimal total = 0;
int occupantsCount = 0;
using (HmDbContext context = new HmDbContext())
{
if (!context.Rooms.Where(x => x.Number == reservation.RoomNumber).Any())
{
return(RedirectToAction("ManagerSearchReservation"));
}
if (context.Rooms.Where(x => x.Number == reservation.RoomNumber).Where(x => x.Occupation == true).Any())
{
return(RedirectToAction("ManagerSearchReservation"));
}
if (context.Reservations.Where(x => x.RoomNumber.Equals(reservation.RoomNumber)).Count() > 1)
{
return(RedirectToAction("ManagerSearchReservation"));
}
PropertyInfo[] properties = typeof(Client).GetProperties();
List <Client> occ = new List <Client>();
foreach (Client occupant in reservation.AccomodatedClients)
{
if (occupant == null)
{
continue;
}
/*bool flag = false;
* foreach (PropertyInfo property in properties)
* {
* if (property.GetValue(occupant).Equals(null) || property.GetValue(occupant).Equals(""))
* { flag = true; break; }
* }*/
if (occupant.Email == null || occupant.Email == "")
{
continue;
}
if (occupant.Number == null || occupant.Number == "")
{
continue;
}
if (occupant.FirstName == null || occupant.FirstName == "")
{
continue;
}
if (occupant.SureName == null || occupant.SureName == "")
{
continue;
}
//if (flag) continue;
occ.Add(occupant);
occupantsCount++;
if (occupant.Adult)
{
total += context.Rooms.First(x => x.Number == reservation.RoomNumber).AdultBedPrice;
}
else
{
total += context.Rooms.First(x => x.Number == reservation.RoomNumber).ChildBedPrice;
}
}
reservation.AccomodatedClients = occ;
if (occupantsCount > context.Rooms.First(x => x.Number == reservation.RoomNumber).Capacity)
{
return(View("ManagerAddNewReservation"));
}
if (reservation.Allinclusive)
{
total += allinclusivePrice;
}
if (reservation.BreakFastIncluded)
{
total += (breakfastPrice * occupantsCount);
}
total *= decimal.Parse((reservation.DischargeDate - reservation.AccomodationDate).TotalDays.ToString());
reservation.TotalPrice = total;
/*if (isForSave)
* {*/
context.Reservations.Add(reservation);
context.Rooms.First(x => x.Number == reservation.RoomNumber).Occupation = true;
context.SaveChanges();
if (!context.Clients.Where(x => x.Email.ToLower().Equals(reservation.User.ToLower())).Any())
{
isClientForAddition = true;
}
/*}*/
}
/*if (isForSave)
* {*/
if (isClientForAddition)
{
Client client = new Client();
if (reservation.User.Contains("@"))
{
client.Email = reservation.User;
}
else
{
List <string> str = reservation.User.Split(' ').ToList();
if (str.Count == 2)
{
client.FirstName = str.First();
client.SureName = str.Last();
}
}
return(View("ManagerAddNewClient", client));
}
/*}*/
return(RedirectToAction("ManagerSearchReservation"));
}
