public ActionResult RentRoom(int billid, int roomid)
{
var bookinginfo = BookingRoomBLL.Instance.GetBookingbyID(billid);
using (var db = new QLKSWEBEntities())
{
Bill bill = new Bill()
{
CheckinDate = DateTime.Now,
BillStatus = "OPEN",
};
db.Bills.Add(bill);
if (db.SaveChanges() > 0)
{
foreach (var item in bookinginfo.BookingServices)
{
BillDetail billDetail = new BillDetail()
{
BillID = bill.BillID,
ServicesID = item.ServicesID,
RoomID = roomid,
};
db.BillDetails.Add(billDetail);
db.SaveChanges();
}
}
}
return(View());
}
public ActionResult BookRoomChose(Room room)
{
using (var db = new QLKSWEBEntities())
{
int bookingid = (int)Session["BookingID"];
Room choseroom = ManageRoomBLL.Instance.GetRoomByID(room.RoomID);
choseroom.RoomStatus = "BOOKING";
db.Entry(choseroom).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
Booking bookingvoucher = BookingRoomBLL.Instance.GetBookingbyID(bookingid);
bookingvoucher.BookingStatus = "BOOKING";
db.Entry(bookingvoucher).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
BookingRoom booking = new BookingRoom()
{
RoomID = room.RoomID,
BookingID = bookingid,
IsBooking = 1
};
db.BookingRooms.Add(booking);
if (db.SaveChanges() > 0)
{
TempData["ChoseRoomStatus"] = "BOOKSUCCES";
return(RedirectToAction("Manage-35"));
}
}
}
TempData["ChoseRoomStatus"] = "BOOKFAIL";
return(RedirectToAction("Manage-35"));
}
}
public ActionResult CancelBooking(int bookingid)
{
using (var db = new QLKSWEBEntities())
{
var booking = BookingRoomBLL.Instance.GetBookingbyID(bookingid);
booking.BookingStatus = "CANCEL";
db.SaveChanges();
var roomid = ManageRoomBLL.Instance.GetRoomIDByBookingID(bookingid);
var room = ManageRoomBLL.Instance.GetRoomByID(roomid);
room.RoomStatus = "OPEN";
db.SaveChanges();
}
return(View("Manage-19"));
}
public ActionResult BookingServWithRoom(int RoomTypeID)
{
//ViewBag.ListServ = HomeBLL.Instance.BookServWithRoom();
//var ListServ = HomeBLL.Instance.BookServWithRoom();
var ListServ = new ServicesModel();
using (var db = new QLKSWEBEntities())
{
ListServ.Services = db
.Services
.Where(x => x.IsBookWithRoom == 1 && x.IsAvailable == 0)
.ToList <Service>();
}
TempData["RoomTypeID"] = RoomTypeID;
return(View(ListServ));
}
public ActionResult Paid(Bill model)
{
var account = ManageBLL.Instance.GetUserByUserName(User.Identity.Name);
using (var db = new QLKSWEBEntities())
{
var details = db.BillDetails.Where(x => x.BillID == model.BillID).FirstOrDefault();
var room = db.Rooms.Where(x => x.RoomID == details.RoomID).FirstOrDefault();
room.RoomStatus = "OPEN";
db.SaveChanges();
Bill bill = db.Bills.Where(x => x.BillID == model.BillID).FirstOrDefault();
bill.BillStatus = "PAID";
bill.Total = model.Total;
bill.CheckoutDate = DateTime.Now;
bill.DateModify = DateTime.Now;
db.SaveChanges();
}
return(RedirectToAction("Manage-23"));
}
public ActionResult RentRoom(int bookingid, int roomid)
{
var bookinginfo = BookingRoomBLL.Instance.GetBookingbyID(bookingid);
var user = ManageBLL.Instance.GetUserByUserName(User.Identity.Name);
using (var db = new QLKSWEBEntities())
{
Bill bill = new Bill()
{
CheckinDate = DateTime.Now,
BillStatus = "OPEN",
CreatedUserID = user.AccountID,
DateCreated = DateTime.Now
};
db.Bills.Add(bill);
if (db.SaveChanges() > 0)
{
var room = db.Rooms.Find(roomid);
room.RoomStatus = "RENTED";
db.SaveChanges();
var booking = db.Bookings.Find(bookingid);
booking.BookingStatus = "DONE";
db.SaveChanges();
foreach (var item in bookinginfo.BookingServices)
{
BillDetail billDetail = new BillDetail()
{
BillID = bill.BillID,
ServicesID = item.ServicesID,
RoomID = roomid,
Quantity = 1,
TotalSerivcesPrices = item.Service.ServicesPrices
};
db.BillDetails.Add(billDetail);
db.SaveChanges();
}
return(RedirectToAction("Manage-19"));
}
return(RedirectToAction("Manage-19"));
}
}
public ActionResult CreateRoom(Room model)
{
var user = ManageBLL.Instance.GetUserByUserName(User.Identity.Name);
using (var db = new QLKSWEBEntities())
{
Room room = new Room()
{
RoomName = model.RoomName,
RoomStatus = "OPEN",
MinQuantity = model.MinQuantity,
MaxQuantity = model.MaxQuantity,
RoomTypeID = model.RoomTypeID,
DateCreated = DateTime.Now,
CreatedUserID = user.AccountID
};
db.Rooms.Add(room);
db.SaveChanges();
}
return(RedirectToAction("Manage-19"));
}
public ActionResult ApproveRequest(int RequestID, int mode)
{
var room = ManageRoomBLL.Instance.GetRoomByRequestID(RequestID);
using (var db = new QLKSWEBEntities())
{
var request = db.Requests.Find(RequestID);
var result = RequestBLL.Instance.ApproveRequest(RequestID);
if (result != null)
{
var equip = db.Equipments.Find(request.EquipmentID);
equip.EquipStatus = 1;
if (mode == 1) // Bảo trì phòng cùng thiết bị
{
room.RoomStatus = "MAINTENANCE";
}
db.SaveChanges();
return(RedirectToAction("Manage-47"));
}
return(RedirectToAction("Manage-47"));
}
}
public ActionResult BookRoomChose(Room room)
{
using (var db = new QLKSWEBEntities())
{
int bookingid = (int)Session["BookingID"];
Room choseroom = ManageRoomBLL.Instance.GetRoomByID(room.RoomID);
choseroom.RoomStatus = "BOOKING";
db.Entry(choseroom).State = EntityState.Modified;
// ở cái đoạn này viết vậy là nó chỉ update đúng 1 bảng Room thôi đúng không?
// đúng rồi, nó chỉ affect Room thôi
// nhưng sao tui bị lỗi này nhỉ, tui demo ông xem
if (db.SaveChanges() > 0)
{
//Booking bookingvoucher = BookingRoomBLL.Instance.GetBookingbyID(bookingid);
Booking bookingvoucher = db.Bookings.Find(bookingid);
bookingvoucher.BookingStatus = "BOOKING";
db.Entry(bookingvoucher).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
BookingRoom booking = new BookingRoom()
{
RoomID = room.RoomID,
BookingID = bookingid,
IsBooking = 1
};
db.BookingRooms.Add(booking);
if (db.SaveChanges() > 0)
{
TempData["ChoseRoomStatus"] = "BOOKSUCCES";
return(RedirectToAction("Manage-35"));
}
}
}
TempData["ChoseRoomStatus"] = "BOOKFAIL";
return(RedirectToAction("Manage-35"));
}
}
public ActionResult AddServtoBill(BillDetail detail)
{
using (var db = new QLKSWEBEntities())
{
var prices = db.Services.Where(x => x.ServicesID == detail.ServicesID).FirstOrDefault();
var room = db.BillDetails.Where(x => x.BillID == detail.BillID).FirstOrDefault();
BillDetail billDetail = new BillDetail()
{
ServicesID = detail.ServicesID,
BillID = detail.BillID,
Quantity = detail.Quantity,
RoomID = room.RoomID,
TotalSerivcesPrices = detail.Quantity * prices.ServicesPrices
};
db.BillDetails.Add(billDetail);
if (db.SaveChanges() > 0)
{
return(RedirectToAction("InvoiceDetail", new { id = detail.BillID }));
}
}
TempData["AddServToBillResult"] = "FAIL";
return(RedirectToAction("InvoiceDetail", new { id = detail.BillID }));
}
public ActionResult ConfirmInfo(ServicesModel serv)
{
var db = new QLKSWEBEntities();
var selectedserv = serv.Services.Where(x => x.IsSelected == true).ToList <Service>();
var Listserv = Session["AddServ"];
Session["AddServ"] = selectedserv;
if (TempData["RoomTypeID"] != null && TempData["BookingInfor"] != null)
{
var roomtypeID = TempData["RoomTypeID"];
Session["RoomTypeID"] = roomtypeID;
ViewBag.BookingInfo = TempData["BookingInfor"];
Session["BookingInfo"] = ViewBag.BookingInfo;
ViewBag.RoomType = ManageRoomBLL.Instance.GetRoomTypeByID((int)roomtypeID);
}
return(View());
}
public ActionResult BookingRoom(Customer customer)
{
var checkcustomer = BookingRoomBLL.Instance.CheckCustomerInfo(customer.Passport);
if (checkcustomer == -1)
{
using (var db = new QLKSWEBEntities())
{
Customer cus = new Customer()
{
CustomerName = customer.CustomerName,
Email = customer.Email,
Phone = customer.Phone,
Passport = customer.Passport,
BirthDay = customer.BirthDay,
CardType = customer.CardType,
CardNo = customer.CardNo,
NameOnCard = customer.NameOnCard,
ExpirationDate = customer.ExpirationDate,
};
db.Customers.Add(cus);
if (db.SaveChanges() < 0)
{
TempData["BookingResult"] = "FAIL";
return(View());
}
}
}
else if (checkcustomer == 1)
{
Customer oldcus = BookingRoomBLL.Instance.GetCustomerByPassport(customer.Passport);
using (var db = new QLKSWEBEntities())
{
oldcus.CustomerName = customer.CustomerName;
oldcus.CustomerName = customer.CustomerName;
oldcus.Email = customer.Email;
oldcus.Phone = customer.Phone;
oldcus.BirthDay = customer.BirthDay;
oldcus.CardType = customer.CardType;
oldcus.CardNo = customer.CardNo;
oldcus.NameOnCard = customer.NameOnCard;
oldcus.ExpirationDate = customer.ExpirationDate;
db.Entry(oldcus).State = EntityState.Modified;
if (db.SaveChanges() < 0)
{
TempData["BookingResult"] = "FAIL";
return(View());
}
}
}
var roomtypeid = Session["RoomTypeID"];
var bookinfo = (CheckAvailableRooms)Session["BookingInfo"];
var listServ = (List <Service>)Session["AddServ"];
Customer cusinfo = BookingRoomBLL.Instance.GetCustomerByPassport(customer.Passport);
using (var db = new QLKSWEBEntities())
{
Booking booking = new Booking()
{
BookDate = DateTime.Now,
CheckinDate = bookinfo.CheckinDate,
CheckoutDate = bookinfo.CheckoutDate,
BookingType = "ROOM",
BookingStatus = "OPEN",
RoomTypeID = (int)roomtypeid,
CustomerID = cusinfo.CustomerID,
DateCreated = DateTime.Now,
};
db.Booking.Add(booking);
if (db.SaveChanges() > 0)
{
foreach (var item in listServ)
{
BookingService bookserv = new BookingService()
{
BookingID = booking.BookingID,
ServicesID = item.ServicesID,
};
db.BookingServices.Add(bookserv);
if (db.SaveChanges() < 0)
{
TempData["BookingResult"] = "FAIL";
return(View());
}
}
Session.Clear();
TempData["BookingResult"] = "SUCCESS";
return(View());
}
TempData["BookingResult"] = "FAIL";
return(View());
}
}
