private void DuaDataBookRoomVaoTextBox(BookRoom bRoom)
{
dTimeNgayDat.Value = bRoom.dateBooking;
dTimeNgayNhan.Value = bRoom.Checkin_Date;
dTimeNgayTra.Value = bRoom.Checkout_Date;
txtSoNguoi.Text = bRoom.peopleCount.ToString();
}
public async Task <IActionResult> Edit(int id, [Bind("BookRoomId,Name,FromDate,NumberPeople,TelePhone,Address")] BookRoom bookRoom)
{
if (id != bookRoom.BookRoomId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(bookRoom);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BookRoomExists(bookRoom.BookRoomId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(bookRoom));
}
public IActionResult Index(BookRoom confirmBooking, String btnbookroom)
{
var roomName = _motelContext.RoomTypes.Where(p => p.RoomName == btnbookroom).Select(p => p.RoomName).FirstOrDefault();
var roomTypeID = _motelContext.RoomTypes.Where(p => p.RoomName == roomName).Select(x => x.ID).FirstOrDefault();
var guestID = _motelContext.Guests.Where(p => p.FirstName == confirmBooking.firstName && p.LastName == confirmBooking.lastName).Select(x => x.ID).FirstOrDefault();
var locationID = 1;
Guest g = new Guest()
{
FirstName = confirmBooking.firstName,
LastName = confirmBooking.lastName,
Address = confirmBooking.address,
PhoneNumber = confirmBooking.phoneno,
ZipCode = confirmBooking.zipcode
};
RoomReservation confirmRoomReservation = new RoomReservation()
{
RoomTypeID = roomTypeID,
GuestID = g.ID,
checkIn = confirmBooking.checkinDate,
checkOut = confirmBooking.checkoutDate,
MotelPropertiesID = locationID
};
confirmRoomReservation.Guest = g;
_motelContext.RoomReservations.Add(confirmRoomReservation);
//_motelContext.Entry(confirmRoomReservation).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_motelContext.SaveChanges();
ViewData["ReservationID"] = confirmRoomReservation.ID;
return(View(confirmRoomReservation));
}
public async Task <IActionResult> BookRoom(BookRoom bookRoom)
{
// prepare the parameters to be inserted into the query
var IDA = new SqliteParameter("ida", bookRoom.RoomID);
var usercheckinA = new SqliteParameter("checkinA", bookRoom.userCheckIn);
var usercheckoutA = new SqliteParameter("checkoutA", bookRoom.userCheckOut);
var selectedRoom = _context.Booking.FromSql("select * from [Booking] where [Booking].RoomID=@ida in"
+ "(select [Room].ID from [Room] inner join [Booking] on [Booking].RoomID = [Room].ID"
+ " where [Booking].CheckIN < @checkoutA and [Booking].CheckOut >@checkinA )", IDA, usercheckinA, usercheckoutA)
.Select(b => new Booking {
RoomID = b.ID, CustomerEmail = b.CustomerEmail, CheckIn = b.CheckIn, CheckOut = b.CheckOut, Cost = b.Cost
});
// ViewBag.RowsAffected = await _context.Database.ExecuteSqlCommandAsync("UPDATE RoomID, CustomerEmail, CheckIn, CheckOut, Cost");
// Run the query and save the results in ViewBag for passing to view
ViewBag.SelectedRooms = await selectedRoom.ToListAsync();
await _context.SaveChangesAsync();
// Save the options for both dropdown lists in ViewBag for passing to view
ViewBag.BookingList = new SelectList(_context.Room, "ID", "ID");
// invoke the view with the ViewModel object
return(View(bookRoom));
}
private void dataToTextBox(BookRoom br)
{
//lấy thông tin bookroom
txtBookRoom.Text = br.id_BookRoom;
txtCMND.Text = br.id_Customer;
txtCountKH.Text = br.peopleCount.ToString();
dTimeNgayNhan.Value = br.Checkin_Date;
dTimeNgayTra.Value = br.Checkout_Date;
dTimeDatPhong.Value = br.dateBooking;
//Lấy thông tin khách đặt phòng
foreach (Customer item in c.getListCustomer())
{
if (br.id_Customer.Equals(item.id_Customer))
{
txtHoTen.Text = item.name;
txtDiaChi.Text = item.address;
txtSoDienThoai.Text = item.phone;
dTimeNgaySinh.Value = item.birthday;
cboGioiTinh.Text = item.sex;
}
}
//lấy thông tên phòng
foreach (Room i in r.getListRoom())
{
if (br.id_Room.Equals(i.id_Room))
{
txtPhong.Text = i.RoomNumber;
cboLoaiPhong.Text = i.id_RoomStyle;
}
}
}
public ActionResult SendMail(BookRoom model)
{
if (ModelState.IsValid)
{
#region Gửi mail cho nhóm hỗ trợ
// Dùng cho người quản lý mail Book từ khách hàng (Admin)
List <ReceiverEmail> listReceiverEmailSupport = new List <ReceiverEmail>();
listReceiverEmailSupport.Add(new ReceiverEmail {
ReceiverEmailAddress = "*****@*****.**", ReceiverFullName = "Nhân Nguyễn"
});
string bodySupport = "<section bgcolor=\"#fff\" class=\"form-email-booking\" > <table align=\"center\" cellpadding=\"0\" cellspacing=\"0\" class=\"container-for-gmail-android\" width=\"100%\" style=\"border-collapse: collapse !important; min-width: 290px !important; width: 100% !important;\"> <tbody><tr> <td align=\"left\" valign=\"top\" width=\"100%\" style=\"border-collapse: collapse; font-size: 14px; color: #777777; text-align: center; line-height: 21px; background-color: #333;\" bgcolor=\"#333\"> <center> <table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" bgcolor=\"#ffffff\" style=\"border-collapse: collapse !important;\"> <tbody><tr> <td width=\"100%\" height=\"80\" valign=\"top\" style=\"text-align: center; vertical-align: middle; border-collapse: collapse; font-size: 14px; color: #777777; line-height: 21px; background-color: #333;\" align=\"center\" bgcolor=\"#333\"> <center> <table cellpadding=\"0\" cellspacing=\"0\" width=\"600\" class=\"w320\" style=\"border-collapse: collapse !important; width: 320px !important;\"> <tbody><tr> <td class=\"mobile-header-padding-left\" style=\"vertical-align: middle; border-collapse: collapse; font-size: 14px; color: #777777; text-align: center; line-height: 21px; width: 160px !important; padding: 15px 0;\" align=\"center\" valign=\"middle\"> <a href=\"http://youandweresort.naansolution.net/\"><img src=\"http://youandweresort.naansolution.net/Images/logoYouAndWeResort%20copy.png\" alt=\"logo\" style=\"max-width: 28%; outline: none; text-decoration: none; -ms-interpolation-mode: bicubic; border: none;\"></a> </td> </tr> </tbody></table> </center> </td> </tr> </tbody></table> </center> </td> </tr> <tr> <td align=\"center\" valign=\"top\" width=\"100%\" style=\"font-size: 16px;/* text-transform: uppercase; */letter-spacing: -1px;color: rgba(51, 51, 51, 0.64);border-collapse: collapse;text-align: center;line-height: 21px;background-color: #f7f7f7;padding: 5px 0;\" class=\"content-padding\" bgcolor=\"#f7f7f7\"> <center> <table cellspacing=\"0\" cellpadding=\"0\" width=\"600\" class=\"w320\" style=\"border-collapse: collapse !important;width: 600px !important;\"> <tbody><tr> <td class=\"header-lg\" style=\"border-collapse: collapse; font-size: 24px !important; color: #4d4d4d; text-align: center; line-height: normal; font-weight: 700; padding: 35px 0 5px;font-family: 'Open Sans', sans-serif !important;\" align=\"center\"> Xin chào , Admin !!! </td> </tr> <tr> <td class=\"free-text\" style=\"border-collapse: collapse; font-size: 15px; color: black; text-align: center; line-height: 21px; width: 100% !important; padding: 10px 18px 30px;\" align=\"center\"> Bạn vừa nhận được thông tin đặt phòng từ khách hàng " + model.FullName + " </td> </tr> <tr> <td class=\"w320\" style=\"border-collapse: collapse; font-size: 14px; color: #777777; text-align: center; line-height: 21px;\" align=\"center\"> <table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"border-collapse: collapse !important;\"> <tbody><tr> <td class=\"mini-container-left\" style=\"border-collapse: collapse;font-size: 14px;color: #777777;text-align: center;line-height: 21px;width: 278px !important;/* display: block !important; */padding: 0 15px 10px 0;\" align=\"center\"> <table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"border-collapse: collapse !important;\"> <tbody><tr> <td class=\"mini-block-padding\" style=\"border-collapse: collapse; font-size: 14px; color: #777777; text-align: center; line-height: 21px;\" align=\"center\"> <h5 style=\"font-size: 16px; text-transform: uppercase; letter-spacing: -1px; color: rgba(51, 51, 51, 0.64);\">Thông tin phòng</h5> <table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"border-collapse: separate !important;\"> <tbody><tr> <td class=\"mini-block\" style=\"border-collapse: collapse; font-size: 14px; color: #777777; text-align: left; line-height: 21px; border-radius: 1px; width: 253px; background-color: #ffffff; padding: 12px 15px 15px; border: 1px solid #ececec;\" align=\"left\" bgcolor=\"#ffffff\"> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Ngày đến</span><br> <p style=\"margin: 5px 0;\">" + model.ArrivalDate + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Ngày đi</span><br> <p style=\"margin: 5px 0;\">" + model.DepartureDate + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Đêm</span><br> <p style=\"margin: 5px 0;\">" + model.Nights + "</p> <span class=\"header-sm\" style=\"font-size: 16px;font-weight: 700;line-height: 1.7;color: #4d4d4d;/* text-transform: capitalize; */padding: 5px 0;\">Loại phòng</span><br> <p style=\"margin: 5px 0;\">" + model.Rooms + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Số lượng phòng</span><br> <p style=\"margin: 5px 0;\">" + model.QuantityRooms + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Người lớn</span><br> <p style=\"margin: 5px 0;\">" + model.Adults + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Trẻ em</span><br> <p style=\"margin: 5px 0;\">" + model.Children + "</p> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> <td class=\"mini-container-right\" style=\"border-collapse: collapse; font-size: 14px; color: #777777; text-align: center; line-height: 21px; width: 290px !important; display: block !important; padding: 0 15px 15px;\" align=\"center\"> <table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"border-collapse: collapse !important;\"> <tbody><tr> <td class=\"mini-block-padding\" style=\"border-collapse: collapse; font-size: 14px; color: #777777; text-align: center; line-height: 21px;\" align=\"center\"> <h5 style=\"font-size: 16px; text-transform: uppercase; letter-spacing: -1px; color: rgba(51, 51, 51, 0.64);\">Thông tin khách hàng</h5> <table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" style=\"border-collapse: separate !important;\"> <tbody><tr> <td class=\"mini-block\" style=\"border-collapse: collapse;font-size: 14px;color: #777777;text-align: left;line-height: 21px;border-radius: 1px;width: 253px;background-color: #ffffff;padding: 12px 15px 15px;border: 1px solid #ececec;\" align=\"left\" bgcolor=\"#ffffff\"> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Họ và tên</span><br> <p style=\"margin: 5px 0;\">" + model.FullName + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Email</span><br> <p style=\"margin: 5px 0;\">" + model.Email + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Địa chỉ</span><br> <p style=\"margin: 5px 0;\">" + model.Address + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Số điện thoại</span><br> <p style=\"margin: 5px 0;\">" + model.Phone + "</p> <span class=\"header-sm\" style=\"font-size: 16px; font-weight: 700; line-height: 1.7; color: #4d4d4d; text-transform: capitalize; padding: 5px 0;\">Yêu cầu từ khách hàng</span><br> <p style=\"margin: 5px 0;\">" + model.Messages + "</p> <span class=\"header-sm\" style=\"color: #fff; font-size: 16px; font-weight: 700; line-height: 1.7; text-transform: capitalize; padding: 5px 0;\">----------</span><br> <p style=\"color: #fff; margin: 5px 0;\">/-----/</p> <span class=\"header-sm\" style=\"color: #fff; font-size: 16px; font-weight: 700; line-height: 1.7; text-transform: capitalize; padding: 5px 0;\">----------</span><br> <p style=\"color: #fff; margin: 5px 0;\">/-----/</p> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </td> </tr> </tbody></table> </center> </td> </tr> <tr> <td align=\"center\" valign=\"top\" width=\"100%\" style=\"height: 100px; border-collapse: collapse; font-size: 14px; color: #777777; text-align: center; line-height: 21px; background-color: #fff;\" bgcolor=\"#fff\"> <center> <table cellspacing=\"0\" cellpadding=\"0\" width=\"600\" class=\"w320\" style=\"border-collapse: collapse !important; width: 320px !important;\"> <tbody><tr> <td style=\"text-align: center; border-collapse: collapse; font-size: 14px; color: #777777; line-height: 21px; padding: 34px 0 0;\" align=\"center\"> <strong>YOU & WE RESORT</strong><br> Phu Quoc Resort<br> All rights reserved<br><br> </td> </tr> </tbody></table> </center> </td> </tr> </tbody></table> </section>";
SendEmail.BookRoomYAW("Nhân Nguyễn", "*****@*****.**", listReceiverEmailSupport, "Mail Booking", bodySupport);
#endregion
#region Gửi mail cho khách hàng
// Dùng cho khách hàng
List <ReceiverEmail> listReceiverEmailCustomer = new List <ReceiverEmail>();
listReceiverEmailCustomer.Add(new ReceiverEmail {
ReceiverEmailAddress = model.Email, ReceiverFullName = model.FullName
});
string bodyCustomer = "Dear Ms/Mr " + model.FullName + ", <br />" + "Thank you for your booking. We would get in touch with you within 8 working hours. If you need urgent assistance, we are ready to assist at: +84 (0) 77 6257979. This is an automatic email, please do not reply to this email. <br />Regards,<br />You & We Resort ";
SendEmail.BookRoomYAW("Robot Booking", "*****@*****.**", listReceiverEmailCustomer, "Mail tự động", bodyCustomer);
#endregion
}
Response.StatusCode = (int)HttpStatusCode.OK;
return(Content("Mail sended."));
}
public int insertBookRoom(BookRoom b)
{
using (System.Data.Common.DbTransaction br = dt.Connection.BeginTransaction())
{
try
{
dt.Transaction = br;
if (CheckExist(b.id_BookRoom) != null)
{
return(0);
}
else
{
dt.BookRooms.InsertOnSubmit(b);
dt.SubmitChanges();
dt.Transaction.Commit();
return(1);
}
}
catch (Exception e)
{
dt.Transaction.Rollback();
throw new Exception("Lỗi không thêm được" + e.Message);
}
}
}
public bool FixBookRoom(BookRoom br)
{
using (System.Data.Common.DbTransaction fixBookRoom = dt.Connection.BeginTransaction())
{
try
{
dt.Transaction = fixBookRoom;
IEnumerable <BookRoom> fix = from i in dt.BookRooms
where i.id_BookRoom == br.id_BookRoom
select i;
fix.First().peopleCount = br.peopleCount;
fix.First().dateBooking = br.dateBooking;
fix.First().Checkin_Date = br.Checkin_Date;
fix.First().Checkout_Date = br.Checkout_Date;
fix.First().id_Customer = br.id_Customer;
fix.First().id_Room = br.id_Room;
dt.SubmitChanges();
dt.Transaction.Commit();
return(true);
}
catch (Exception)
{
dt.Transaction.Rollback();
throw new Exception("Lỗi không sữa được");
}
}
}
public void EmpAcceptBooking(int id, BookMv book)
{
try
{
//accept guest
var guest = _unitOfWork.Guests.GetByID(_unitOfWork.Bookings.GetByID(book.Id).GuestId);
guest.IdentityNo = book.IdentityNo;
guest.Email = book.Email;
guest.LastName = book.LastName;
guest.FirstName = book.FirstName;
guest.Phone = book.Phone;
_unitOfWork.Guests.Update(guest);
_unitOfWork.Commit();
//acceptBooking
var booking = _unitOfWork.Bookings.GetByID(book.Id);
booking.CheckOut = book.CheckOut;
booking.CheckIn = book.CheckIn;
booking.DurationStay = (int)(book.CheckOut - book.CheckIn).TotalDays;
booking.Status = BookedStatus.booked;
var amountMoney = 0;
foreach (var item in book.ListRoomIds)
{
var money = _unitOfWork.CategoryRooms
.GetByID(_unitOfWork.Rooms.GetByID(item).CategoryRoomId)
.Price;
var durationDay = booking.DurationStay;
var totalMoney = durationDay * money;
amountMoney += (int)totalMoney;
}
booking.Amount = amountMoney;
_unitOfWork.Bookings.Update(booking);
_unitOfWork.Commit();
//create booking room
foreach (var item in book.ListRoomIds)
{
var bookRoom = new BookRoom()
{
BookingId = book.Id,
RoomId = item
};
_unitOfWork.BookRooms.Insert(bookRoom);
_unitOfWork.Commit();
}
new OrderDao(_unitOfWork, _mapper).CreateOrder(booking.Id);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public ActionResult InsertCMND(InsertCMND ir)
{
try
{
if (ModelState.IsValid && TempData != null)
{
BookRoom date = SessionHelper.GetDateSession();
TempData["datein"] = date.dateRent;
TempData["dateout"] = date.datePay;
List <Room> lstroom = SessionHelper.getBookrooms();
int giatien = 0;
foreach (Room temp in lstroom)
{
giatien += temp.giatien * temp.soluong;
}
TempData["giatien"] = giatien;
String sql = "select * from KHACHHANG where CMND_PASSPORT='" + ir.idCard + "'";
if (DataUtil.ExecQueryString(sql))
{
BookRoom br = new BookRoom();
br = SessionHelper.GetDateSession();
var dt = DataUtil.ExecSqlDataTable(sql, DataUtil.connstr);
if (dt.Rows.Count > 0)
{
DataRow kh = dt.Rows[0];
RentInfo ri = new RentInfo();
ri.deposit = (int)(giatien * 20 / 100);
ri.dateRent = br.dateRent;
ri.datePay = br.datePay;
ri.idCard = kh[0].ToString();
ri.phone = kh[3].ToString();
ri.email = kh[6].ToString();
ri.nameClient = kh[1].ToString() + kh[2].ToString();
ri.birth = kh[5].ToString();
return(View("CheckInfor", ri));
}
else
{
return(View("CheckInfor"));
}
}
else
{
return(View("CheckInfor"));
}
}
else
{
return(View("InsertCMND"));
}
}
catch
{
return(RedirectToAction("Index", "Home"));
}
}
// sự kiện chọn chuyển sang text box
private void lvwDSDatPhong_SelectedIndexChanged(object sender, EventArgs e)
{
BookRoom br = null;
if (lvwDSDatPhong.SelectedItems.Count > 0)
{
br = (BookRoom)lvwDSDatPhong.SelectedItems[0].Tag;
dataToTextBox(br);
}
}
public async Task <IActionResult> Create([Bind("BookRoomId,Name,FromDate,NumberPeople,TelePhone,Address")] BookRoom bookRoom)
{
if (ModelState.IsValid)
{
_context.Add(bookRoom);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(bookRoom));
}
public string Create(BookRoom bookRoom)
{
if (bookRoom != null)
{
bookRoom.BookRoomID = Guid.NewGuid();
db.BookRooms.Add(bookRoom);
db.SaveChanges();
return(bookRoom.BookRoomID.ToString());
}
return(null);
}
public ActionResult Detail(int Id)
{
using (var db = new MyDbDataContext())
{
BookRoom detailBook = db.BookRooms.FirstOrDefault(a => a.ID == Id);
if (detailBook == null)
{
return(RedirectToAction("Index"));
}
return(View("Detail", detailBook));
}
}
public async Task MapEnrichedCommand()
{
var store = new InMemoryEventStore();
var app = new WebApplicationFactory <Program>()
.WithWebHostBuilder(
builder => builder.ConfigureServices(services => services.AddAggregateStore(_ => store))
);
var httpClient = app.CreateClient();
using var client = new RestClient(httpClient, disposeHttpClient: true).UseSerializer(
() => new SystemTextJsonSerializer(
new JsonSerializerOptions(JsonSerializerDefaults.Web).ConfigureForNodaTime(DateTimeZoneProviders.Tzdb)
)
);
var cmd = new BookRoom(
"123",
"123",
LocalDate.FromDateTime(DateTime.Now),
LocalDate.FromDateTime(DateTime.Now.AddDays(1)),
100
);
var response = await client.PostJsonAsync("/book", cmd);
response.Should().Be(HttpStatusCode.OK);
var storedEvents = await store.ReadEvents(
StreamName.For <Booking>(cmd.BookingId),
StreamReadPosition.Start,
100,
default
);
var actual = storedEvents.FirstOrDefault();
actual.Should().NotBeNull();
actual !.Payload.Should()
.BeEquivalentTo(
new BookingEvents.RoomBooked(
cmd.BookingId,
cmd.RoomId,
cmd.CheckIn,
cmd.CheckOut,
cmd.Price,
TestData.GuestId
)
);
}
public async Task <IActionResult> BookRoom(BookRoom order)
{
if (ModelState.IsValid)
{
if (order.RoomNumber != null || order.Email != null)
{
var checkIfRoomExist = _roomRepository.Find(x => x.RoomNumber == order.RoomNumber);
var customerbyId = _customerRepository.Find(x => x.EmailAddress == order.Email);
if (checkIfRoomExist == null)
{
return(BadRequest(new { message = "the room with this room number doesn't exist" }));
}
var newOrder = new BookRoom()
{
RoomNumber = order.RoomNumber,
CustomerName = order.CustomerName,
Email = order.Email,
DateBooked = DateTime.Now.ToLocalTime().ToShortDateString()
};
var updateRoom = await _roomRepository.GetRoomById(checkIfRoomExist.Id);
updateRoom.IsFree = false;
updateRoom.DateBooked = DateTime.Now.ToLocalTime().ToShortDateString();
updateRoom.Occupancy = true;
var customer = await _customerRepository.GetCustomerById(customerbyId.Id);
customer.IsCheckin = true;
_orderRepository.Create(newOrder);
await _orderRepository.Save();
var emailContent = new EmailModel()
{
To = order.Email,
Email = "*****@*****.**",
Password = "******",
Subject = "Your Uploaded Files",
Body = "Dear " + order.CustomerName + "\n\n\n You are receiving this mail because you have just booked a room at our Hotel." +
" \n\n " + "Email Address: " + order.Email + "\n" + "Room Number : " + order.RoomNumber + "\n" + "Check-in: " + customer.IsCheckin
+ "\n\n Regards. \n\n Adminstrator"
};
var send = _emailService.SendEmail(emailContent);
return(Ok(new { response = newOrder, updateRoom }));
}
return(BadRequest(new { message = "Error occurred, The information does not match" }));
}
return(BadRequest(new { message = "Please fill in required fields" }));
}
public JsonResult Delete(int Id)
{
var db = new MyDbDataContext();
BookRoom del = db.BookRooms.FirstOrDefault(a => a.ID == Id);
if (del == null)
{
return(Json(new { Result = "ERROR", Message = "Đặt phòng không tồn tại." }));
}
db.BookRooms.DeleteOnSubmit(del);
db.SubmitChanges();
return(Json(new { Result = "OK", Message = "Xóa thành công." }));
}
public ActionResult ReservationCustom(int?room)
{
if (room > 6)
{
return(RedirectToAction("Reservation"));
}
else
{
ViewBag.RoomCode = room;
var model = new BookRoom();
return(View(model));
}
}
public async Task <IActionResult> Create([FromBody] BookRoomViewModel model)
{
if (!ModelState.IsValid)
{
var errors = ModelState.Select(x => x.Value.Errors)
.Where(y => y.Count > 0)
.ToList();
return(BadRequest(errors));
}
// add customer
var foundCustomer = await _context.Customers.Where(item => item.Phone == model.Phone).FirstOrDefaultAsync();
if (foundCustomer == null)
{
foundCustomer = new Customer
{
Name = model.FullName,
Phone = model.Phone,
Email = model.Email,
CreatedAt = DateTime.Now,
Avatar = "/uploads/avatar-customer.jpg",
BookCount = 1
};
await _context.Customers.AddAsync(foundCustomer);
await _context.SaveChangesAsync();
}
// add Book Room
var bookRoom = new BookRoom
{
TypeRoomId = model.TypeRoomId,
CustomerId = foundCustomer.Id,
Status = false,
TimeBook = (int)model.TimeBook,
TimeCreated = model.TimeCreated.HasValue ? model.TimeCreated.Value : DateTime.Now,
CreatedAt = DateTime.Now,
BookRoomStatus = BookRoomStatus.Waiting
};
await _context.BookRooms.AddAsync(bookRoom);
await _context.SaveChangesAsync();
return(Ok(1));
}
private ListViewItem createItem(BookRoom i)
{
ListViewItem item;
item = new ListViewItem(i.id_BookRoom);
item.SubItems.Add(i.peopleCount.ToString());
item.SubItems.Add(i.dateBooking.ToString());
item.SubItems.Add(i.Checkin_Date.ToString());
item.SubItems.Add(i.Checkout_Date.ToString());
item.SubItems.Add(i.id_Room);
item.SubItems.Add(i.id_Customer);
item.Tag = i;
return(item);
}
public static BookRoom GetDateSession()
{
var PickupDate = HttpContext.Current.Session["PickupDate"];
var ReturnDate = HttpContext.Current.Session["ReturnDate"];
if (PickupDate == null && ReturnDate == null)
{
return(null);
}
else
{
BookRoom r = new BookRoom();
r.dateRent = (Convert.ToDateTime(PickupDate));
r.datePay = (Convert.ToDateTime(ReturnDate));
return(r);
}
}
public ActionResult Confirm(RentInfo ren)
{
try
{
if (ModelState.IsValid && TempData != null)
{
List <Room> lstroom = SessionHelper.getBookrooms();
if (DataUtil.addPhieuDat(ren, lstroom))
{
TempData["HomeIndexError"] = HomeIndexError.BookingRoomIsOk;
return(RedirectToAction("Index", "Home"));
// TempData["message"] = "Đặt phòng thành công.\nHãy liên hệ với khách sạn để xác nhận phiếu đặt và đóng phí đặt phòng!\n Thành thật cảm ơn";
}
else
{
TempData["HomeIndexError"] = HomeIndexError.BookingRoomIsFail;
return(RedirectToAction("Index", "Home"));
//TempData["message"] = "Đặt phòng thất bại , xin thử lại sau";
}
//return RedirectToAction("Index", "Home");
}
else
{
//TempData["message"] = "Thông tin nhập vào không hợp lệ!";
//return RedirectToAction("Index", "Home");
BookRoom date = SessionHelper.GetDateSession();
TempData["datein"] = date.dateRent;
TempData["dateout"] = date.datePay;
List <Room> lstroom = SessionHelper.getBookrooms();
int giatien = 0;
foreach (Room temp in lstroom)
{
giatien += temp.giatien * temp.soluong;
}
TempData["giatien"] = giatien;
ModelState.AddModelError("", "Bạn chưa nhập đủ thông tin!");
return(View("CheckInfor"));
}
}
catch
{
return(RedirectToAction("Index", "Home"));
}
}
// sữa đặt phòng
private BookRoom SuaDatPhong()
{
string room_number = txtPhong.Text;
string id_room = r.GetRoomByNumberRoom(room_number).id_Room;
BookRoom br;
br = new BookRoom()
{
id_BookRoom = txtBookRoom.Text,
peopleCount = Convert.ToInt32(txtCountKH.Text),
dateBooking = dTimeDatPhong.Value,
Checkin_Date = dTimeNgayNhan.Value,
Checkout_Date = dTimeNgayTra.Value,
id_Room = id_room,
id_Customer = txtCMND.Text,
};
return(br);
}
public IHttpActionResult Create([FromBody] BookRoom bookRoom)
{
HttpResponseDTO <string> response = new HttpResponseDTO <string>();
try
{
response.code = 0;
response.message = Constanst.SUCCESS;
response.data = bookRoomBL.Create(bookRoom);
}
catch (Exception e)
{
response.code = 500;
response.message = Constanst.FAIL;
response.data = null;
}
return(Ok(response));
}
public ActionResult Book(BookingModel model)
{
if (ModelState.IsValid)
{
var book = new BookRoom
{
Id = Guid.NewGuid(),
RoomNumber = model.RoomNumber,
Name = model.Name,
Phone = model.Phone,
Email = model.Email,
BookTime = DateTime.Now
};
BookingStartup.Dispatcher.SendCommand(book);
return(RedirectToAction("Index"));
}
return(View(model));
}
public async Task <IActionResult> updateBookRoom([FromForm] BookRoom model, int id)
{
var bookRoom = await _context.BookRooms.FindAsync(id);
if (bookRoom != null)
{
if (ModelState.IsValid)
{
bookRoom.RoomId = model.RoomId;
bookRoom.Status = true;
bookRoom.BookRoomStatus = BookRoomStatus.Booked;
await _context.SaveChangesAsync();
return(Redirect("/admin/room/book-room"));
}
}
return(BadRequest("Không tồn tại bản ghi"));
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
Room roomUp = ROOM.LayThongTinPhong(_idRoom);
roomUp.Note = txtGhiChu.Text;
var checkRoom = ROOM.CapNhatTinhTrangPhong(_idRoom, roomUp);
BookRoom bRoomUp = BOOKR.GetThongTinBookRoom(_idRoom);
bRoomUp.dateBooking = dTimeNgayDat.Value;
bRoomUp.Checkin_Date = dTimeNgayNhan.Value;
bRoomUp.Checkout_Date = dTimeNgayTra.Value;
var checkBRoom = BOOKR.SuaThongTinBookRoomCuaKH(bRoomUp, _idCustomer);
var sl = Convert.ToInt32(numUpDown.Value);
string idService = listDSDichVu.SelectedValue.ToString();
bool checkBS = false;
if (BILLS.checkIfExist(idService, _idBRoom) == null)
{
Bill_Service bs = new Bill_Service();
bs.id_BookRoom = _idBRoom;
bs.id_Service = idService;
bs.Service_Count = (int)numUpDown.Value;
BILLS.insertBillService(bs);
checkBS = true;
}
else
{
checkBS = BILLS.CapNhatSoLuong(_idBRoom, idService, sl);
checkBS = true;
}
if (checkBRoom && checkRoom && checkBS)
{
MessageBox.Show("Cập nhật thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Cập nhật không thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public ActionResult RoomHasBeenOrdered(List <Room> model)
{
try
{
if (TempData != null)
{
BookRoom date = SessionHelper.GetDateSession();
TempData["datein"] = date.dateRent;
TempData["dateout"] = date.datePay;
List <Room> lst = new List <Room>();
foreach (Room temp in model)
{
if (temp.soluong > 0)
{
lst.Add(temp);
}
}
if (lst.Count > 0)
{
TempData["ListHangPhong"] = lst;
SessionHelper.setBookrooms(lst);
return(View("Index"));
}
else
{
TempData["HomeIndexError"] = HomeIndexError.NotSelectRoomYet;
return(RedirectToAction("Index", "Home"));
}
}
else
{
TempData["HomeIndexError"] = HomeIndexError.NotSelectRoomYet;
return(RedirectToAction("Index", "Home"));
}
}
catch
{
TempData["HomeIndexError"] = HomeIndexError.NotSelectRoomYet;
return(RedirectToAction("Index", "Home"));
}
}
private void btnNhanPhong_Click(object sender, EventArgs e)
{
clsRoom Room = new clsRoom();
Room roomUp = Room.LayThongTinPhong(_idRoom);
roomUp.Note = txtGhiChu.Text;
Room.CapNhatTinhTrangPhong(_idRoom, roomUp);
DuaDataRoomVaoTextBox(Room.LayThongTinPhong(_idRoom));
clsBookRoom BookRoom = new clsBookRoom();
BookRoom bRoomUp = BookRoom.GetThongTinBookRoom(_idRoom);
bRoomUp.dateBooking = dTimeNgayDat.Value;
bRoomUp.Checkin_Date = dTimeNgayNhan.Value;
BookRoom.SuaThongTinBookRoomCuaKH(bRoomUp, _idCustomer);
clsHonLoan honLoan = new clsHonLoan();
var dsNP = honLoan.GetDSNhanPhong();
DuaDataVaoLvwDSNhanPhong(lvwDSNhanPhong, dsNP);
}
private void btnDatPhong_Click_1(object sender, EventArgs e)
{
foreach (BookRoom item in b.getListBookRoom())
{
if (txtBookRoom.Text == item.id_BookRoom)
{
MessageBox.Show("Trùng mã đặt phòng", "Thông báo");
return;
}
}
foreach (var item in jBR.getNumberRoom())
{
if (txtPhong.Text.Equals(item.sophong))
{
MessageBox.Show("Phòng đã có người đặt", "Thông báo");
return;
}
}
foreach (var item in honLoan.GetKhachHangDatPhong())
{
if (txtCMND.Text.Equals(item.cmnd))
{
MessageBox.Show("Khách hàng này đã đặt phòng", "Thông Báo");
return;
}
}
BookRoom br = createBookRoom();
Customer customer = CreateCustomer();
c.Insert(customer);
b.insertBookRoom(br);
IEnumerable <BookRoom> getBR = b.getListBookRoom();
loadRoomListView(lvwDSDatPhong, getBR);
RemoveElement();
flowLayoutPanel1.Controls.Clear();
TaoDayGhe(n);
}
