private void btnAdd_Click(object sender, EventArgs e) { string name = txbName.Text; DateTime birthday = dtpBirthDay.Value; string address = txbAddress.Text; string phone = txbPhone.Text; string email = txbEmail.Text; string topic = txbTopic.Text; string country = txbCountry.Text; int check; if (cbCheck.Checked == true) { check = 1; } else { check = 0; } GuestDAO _guest = new GuestDAO(); if (_guest.CheckExist(name, phone)) { MessageBox.Show("Người này đã tồn tại", "Thông Báo"); } else { _guest.AddGuest(name, birthday, address, phone, topic, email, check, country); Register next = new Register(); this.Hide(); next.Show(); } }
public async Task <IActionResult> Create(int RoomID, DateTime CheckInDate, DateTime CheckOutDate, Guest guest, Payment payment, int Amount) { int guestid = GuestDAO.InsertGuest(guest); int paymentid = PaymentDAO.InsertPayment(payment); int bookingid = BookingDAO.InsertBooking(new Booking() { RoomID = RoomID, CheckInDate = CheckInDate.AddHours(14), CheckOutDate = CheckOutDate.AddHours(12).AddMinutes(5), GuestID = guestid, Amount = (int)(CheckOutDate - CheckInDate).TotalDays * RoomsDAO.GetRoomModel(RoomID).RoomType.Price, PaymentID = paymentid, }); var model = BookingDAO.GetBookingModel(bookingid); string body = await Utlities.RenderViewToStringAsync <BookingModel>(this, "~/Areas/Guests/Views/Partial/_ConfirmEmail.cshtml", model); MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(guest.Email); mail.Subject = "Congratulations on your successful booking"; mail.Body = body; mail.IsBodyHtml = true; Utlities.SendEmail(mail); return(View()); }
public ControllerClass(HotelContext db) { roomDAO = new RoomDAO(db); guestDAO = new GuestDAO(db); bookingDAO = new BookingDAO(db); dictionaryDAO = new DictionaryDAO(db); this.view = new ViewClass(dictionaryDAO.GetRoomTypes(), dictionaryDAO.GetGuestStatus()); }
public IActionResult Index() { if (!Authentication.AuthenticateByCookie(HttpContext)) { return(Redirect("/Receptionists/Authentication/Login?are=Receptionists&ctrl=Guests&act=Index")); } List <Guest> list = GuestDAO.GetAllGuests(); return(View(list)); }
public DataTable GetPersons(int id) { try { GuestDAO guestDAO = new GuestDAO(); return(guestDAO.Read(id)); } catch { throw; } }
static void Main(string[] args) { using (HotelContext dB = new HotelContext()) { RoomDAO rd = new RoomDAO(dB); GuestDAO gd = new GuestDAO(dB); BookingDAO bd = new BookingDAO(dB); DictionaryDAO d = new DictionaryDAO(dB); ControllerClass controller = new ControllerClass(dB); controller.Start(); } }
public IActionResult Create(int RoomID, DateTime CheckInDate, DateTime CheckOutDate, Guest guest, Payment payment, int Amount) { int guestid = GuestDAO.InsertGuest(guest); int paymentid = PaymentDAO.InsertPayment(payment); int bookingid = BookingDAO.InsertBooking(new Booking() { RoomID = RoomID, CheckInDate = CheckInDate.AddHours(14), CheckOutDate = CheckOutDate.AddHours(12).AddMinutes(5), GuestID = guestid, Amount = (int)(CheckOutDate - CheckInDate).TotalDays * RoomsDAO.GetRoomModel(RoomID).RoomType.Price, PaymentID = paymentid, }); return(View()); }
public IActionResult AddGuestOnCheckin(string FullName, string Gender, string IdCard, int bookingid) { if (!GuestDAO.CheckIsExistGuestByIdCard(IdCard)) { var guestid = GuestDAO.InsertGuest(new Guest() { FullName = FullName, Gender = Gender, IDCardNumber = IdCard }); var stay = StayDAO.InsertStay(new Stay() { GuestID = guestid, BookingID = bookingid, FromDate = DateTime.Now, ToDate = null }); return(Json(stay)); } else { var guestid = GuestDAO.GetGuestByIdCardNumber(IdCard).GuestID; if (!StayDAO.CheckGuestStaying(guestid)) { var stay = StayDAO.InsertStay(new Stay() { GuestID = guestid, BookingID = bookingid, FromDate = DateTime.Now, ToDate = null }); return(Json(stay)); } else { return(Json(null)); } } }
public JsonResult CreateBooking(int RoomID, DateTime CheckInDate, DateTime CheckOutDate, Guest guest, Payment payment) { int guestid = GuestDAO.InsertGuest(guest); int paymentid = PaymentDAO.InsertPayment(payment); Booking booking = new Booking(); booking.RoomID = RoomID; booking.GuestID = guestid; booking.PaymentID = paymentid; booking.CheckInDate = CheckInDate; booking.CheckOutDate = CheckOutDate; int bookingid = BookingDAO.InsertBooking(booking); return(Json(new { data = booking })); }
private void btnDelete_Click(object sender, EventArgs e) { int index = dgvData.CurrentCell.RowIndex; DataRow row = (dgvData.Rows[index].DataBoundItem as DataRowView).Row; string name = row["Name"].ToString(); string phonenumber = row["PhoneNumber"].ToString(); if (flag == 1) { InstructorDAO _instructorDAO = new InstructorDAO(); _instructorDAO.DeleteData(name, phonenumber); } else if (flag == 2) { GuestDAO _guest = new GuestDAO(); _guest.DeleteData(name, phonenumber); } else { AudienceDAO _audience = new AudienceDAO(); _audience.DeleteData(name, phonenumber); } ShowData(); }
public GuestBLL() { guestDAO = new GuestDAO(); dt = new DataTable(); }
public IActionResult UpdateGuest(Guest guest) { GuestDAO.UpdateGuest(guest); return(Json(guest.GuestID)); }