public void NextBookingIdTest_TC2()
{
var actual = BookingBUS.NextId();
var expected = "B0003";
Assert.AreEqual(expected, actual);
}
private void btnAddBooking_Click(object sender, EventArgs e)
{
if (bookingRoomDetails.Count == 0)
{
MessageBox.Show("Please add booking room", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var newBooking = new BookingDTO()
{
BookingId = BookingBUS.NextId(),
EmployeeId = this.employee.EmployeeId,
Customer = new CustomerDTO()
{
CustomerId = CustomerBUS.NextId(),
Name = txtName.Text,
Address = txtAddress.Text,
Phone = txtPhone.Text,
Fax = txtFax.Text,
Telex = txtTelex.Text
},
CreatedDate = DateTime.Now,
BookingDetails = this.bookingRoomDetails
};
newBooking.BookingDetails.ForEach(b => b.Room = null);
BookingBUS.AddBooking(newBooking);
this.bookingDTOBindingSource.DataSource = BookingBUS.GetBookings();
this.ReloadGridViewRoomAndBookingDetail();
}
public void GetBookingsTest()
{
var actual = BookingBUS.GetBookings().Count;
var expected = 2;
Assert.AreEqual(expected, actual);
}
public void LoadSchedule(DTO.Booking b)
{
BookingBUS bBus = new BookingBUS();
GuestBUS gBUS = new GuestBUS();
RoomBUS rBUS = new RoomBUS();
string id = b.BookingID.ToString();
Guest g = gBUS.getGuestByID(b.GuestID);
Room r = rBUS.getRoomByID(b.RoomID);
RoomType rt = rBUS.getRoomTypeByID(r.RoomType);
schedulerControl1.ActiveViewType = DevExpress.XtraScheduler.SchedulerViewType.Month;
schedulerControl1.OptionsCustomization.AllowInplaceEditor = DevExpress.XtraScheduler.UsedAppointmentType.None;
String roomID = b.RoomID;
String name = g.FullName.Trim();
DateTime checkin = b.CheckIn;
DateTime checkout = b.CheckOut;
Appointment app = schedulerStorage1.CreateAppointment(AppointmentType.Normal);
DateTime start = checkin;
DateTime end = checkout;
app.Start = start;
app.End = end;
app.AllDay = false;
app.LabelKey = 3;
app.StatusKey = 1;
app.Subject = "Room " + roomID + " - " + name;
app.SetId(id);
schedulerStorage1.Appointments.Add(app);
}
public void GetBookingsByContainsIdTest()
{
var actual = BookingBUS.GetBookingsByContainsId("1").Count;
var expected = 1;
Assert.AreEqual(expected, actual);
}
public MainForm(EmployeeDTO employee)
{
this.InitializeComponent();
this.employee = employee;
this.comboBoxRoomType.DropDownStyle = ComboBoxStyle.DropDownList;
this.comboBoxRoomType.Items.AddRange(new object[] { "None", TypeOfRoom.A, TypeOfRoom.B, TypeOfRoom.C, TypeOfRoom.D });
this.bookingDTOBindingSource.DataSource = BookingBUS.GetBookings();
this.checkInDTOBindingSource.DataSource = CheckInBUS.GetCheckIns();
this.ReloadGridViewRoomAndBookingDetail();
}
public void setInfo()
{
DateTime date = new DateTime(2018, 10, 30);
bBUS = new BookingBUS();
List <DTO.Booking> list = bBUS.getList(date);
foreach (DTO.Booking b in list)
{
loadInfo(b);
}
}
private void dgvBookingList_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (MessageBox.Show("Make a check in?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
string selectedBookingId = this.dgvBookingList.Rows[e.RowIndex].Cells[0].Value.ToString();
CheckInBUS.AddCheckInBaseOnBooking(selectedBookingId);
this.bookingDTOBindingSource.DataSource = BookingBUS.GetBookings();
this.checkInDTOBindingSource.DataSource = CheckInBUS.GetCheckIns();
}
public void setSchedule()
{
DateTime date = DateTime.Now;
bBUS = new BookingBUS();
List <DTO.Booking> list = bBUS.getList(date);
foreach (DTO.Booking b in list)
{
LoadSchedule(b);
}
//schedulerControl1.DayView.TimeRulers.Clear();
schedulerControl1.DayView.TimeSlots.Add(new TimeSlot(TimeSpan.FromHours(10), "5 hours"));
schedulerControl1.DayView.TimeScale = TimeSpan.FromHours(10);
//schedulerStorage1.Appointments.Mappings
schedulerControl1.DayView.DayCount = 3;
schedulerControl1.Views.DayView.AppointmentDisplayOptions.StartTimeVisibility = DevExpress.XtraScheduler.AppointmentTimeVisibility.Never;
schedulerControl1.Views.DayView.AppointmentDisplayOptions.EndTimeVisibility = DevExpress.XtraScheduler.AppointmentTimeVisibility.Never;
}
void LoadGrid()
{
BookingBUS b = new BookingBUS();
DateTime d = DateTime.Now;
DataTable dt = b.getBookingbyDate(d);
MessageBox.Show(dt.Rows.Count.ToString() + " " + d.ToString("M/d/yyyy HH:mm:ss"));
gridControl1.BindingContext = this.BindingContext;
gridControl1.DataSource = dt;
gridView1.OptionsBehavior.Editable = false;
gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
//Console.WriteLine("2");
//gridView1.OptionsBehavior.EditorShowMode += gridControl1.MouseDown;
//gridView1.RowCellClick += LoadBookInf(gridView1);
//colCHECKIN.
//gridControl1.DataSource = dt;
//foreach (DataRow dr in dt.Rows)
//gridView1.AddNewRow(dr);
}
private void SchedulerControl1_MouseClick(object sender, MouseEventArgs e)
{
DateTime date = DateTime.Now;
bBUS = new BookingBUS();
List <DTO.Booking> list = bBUS.getList(date);
SchedulerHitInfo hitInfo = schedulerControl1.ActiveView.ViewInfo.CalcHitInfo(e.Location, false);
if (hitInfo.HitTest == SchedulerHitTest.AppointmentContent)
{
foreach (DTO.Booking b in list)
{
foreach (Appointment myAppt in schedulerControl1.SelectedAppointments)
{
//MessageBox.Show(myAppt.Description);
loadInfo(b);
}
}
}
}
public void loadInfo(DTO.Booking b)
{
Appointment app = schedulerStorage1.CreateAppointment(AppointmentType.Normal);
BookingBUS bBus = new BookingBUS();
GuestBUS gBUS = new GuestBUS();
RoomBUS rBUS = new RoomBUS();
string id = b.BookingID.ToString();
Guest g = gBUS.getGuestByID(b.GuestID);
Room r = rBUS.getRoomByID(b.RoomID);
RoomType rt = rBUS.getRoomTypeByID(r.RoomType);
String roomID = b.RoomID;
String name = g.FullName.Trim();
int bookID = b.BookingID;
string typeID = r.RoomType;
//Console.WriteLine(g.FullName);
string guestID = b.GuestID;
int status = r.Status;
string bookType = b.BookingTypeID.Trim();
DateTime checkIn = app.Start;
DateTime checkOut = b.CheckOut;
int price = rt.Price;
editGuestInfo edit = new editGuestInfo();
edit = editGuestInfo1;
edit.guestNameTextBox.Text = name;
edit.guestIdTextBox.Text = guestID;
edit.dateOfBirth.Text = g.DOB.ToString();
edit.nationTextBox.Text = g.Nationality;
BookingInformation bookInfo = new BookingInformation();
bookInfo = bookingInformation1;
bookInfo.daysLabel.Text = bookInfo.getDays(checkIn, checkOut);
bookInfo.bookID.Text = bookID.ToString();
bookInfo.nationTB.Text = g.Nationality;
bookInfo.roomTypeComboBox.Text = typeID;
bookInfo.guestNameLabel.Text = name;
bookInfo.roomIdLabel.Text = "Room" + roomID;
if (bookType.Equals("001"))
{
bookInfo.bookingTypeCombobox.Text = "AGODA";
}
else if (bookType.Equals("002"))
{
bookInfo.bookingTypeCombobox.Text = "BOOKING";
}
else
{
bookInfo.bookingTypeCombobox.Text = "FREE";
}
//bookInfo.bookingTypeCombobox.Text
switch (status)
{
case 1:
bookInfo.statusComboBox.Text = "Reserved";
break;
case 2:
bookInfo.statusComboBox.Text = "Occupied";
break;
case 3:
bookInfo.statusComboBox.Text = "Checked-out";
break;
default:
bookInfo.statusComboBox.Text = "Available";
break;
}
bookInfo.fromDateLabel.Text = checkIn.ToString("dd.MM.yyyy");
bookInfo.toDayLabel.Text = checkOut.ToString("dd.MM.yyyy");
bookInfo.priceLabel.Text = price.ToString();
}
private void gridControl1_Click(object sender, EventArgs e)
{
bookingInformation1.Visible = true;
newBooking1.Visible = false;
if (gridView1.GetFocusedRowCellValue("bookingID") != null)
{
string id = gridView1.GetFocusedRowCellValue("bookingID").ToString();
string typeid = gridView1.GetFocusedRowCellValue("bookingTypeID").ToString();
BookingBUS bBus = new BookingBUS();
GuestBUS gBUS = new GuestBUS();
RoomBUS rBUS = new RoomBUS();
DTO.Booking b = bBus.getBookingByID(id, typeid);
Guest g = gBUS.getGuestByID(b.GuestID);
Room r = rBUS.getRoomByID(b.RoomID);
RoomType rt = rBUS.getRoomTypeByID(r.RoomType);
int bookID = b.BookingID;
string guestID = b.GuestID;
string typeID = r.RoomType;
String guestName = g.FullName.Trim();
String roomID = b.RoomID;
int status = r.Status;
string bookType = b.BookingTypeID.Trim();
DateTime checkIn = b.CheckIn;
DateTime checkOut = b.CheckOut;
int price = rt.Price;
string roomType = r.RoomType;
editGuestInfo edit = new editGuestInfo();
edit = editGuestInfo1;
edit.guestNameTextBox.Text = guestName;
edit.guestIdTextBox.Text = guestID;
edit.dateOfBirth.Text = g.DOB.ToString();
edit.nationTextBox.Text = g.Nationality;
BookingInformation bookInfo = new BookingInformation();
bookInfo = bookingInformation1;
bookInfo.daysLabel.Text = bookInfo.getDays(checkIn, checkOut);
bookInfo.bookID.Text = bookID.ToString();
bookInfo.nationTB.Text = g.Nationality;
bookInfo.roomTypeComboBox.Text = typeID;
bookInfo.guestNameLabel.Text = guestName;
bookInfo.roomIdLabel.Text = "Room" + roomID;
if (bookType.Equals("001"))
{
bookInfo.bookingTypeCombobox.Text = "AGODA";
}
else if (bookType.Equals("002"))
{
bookInfo.bookingTypeCombobox.Text = "BOOKING";
}
else
{
bookInfo.bookingTypeCombobox.Text = "FREE";
}
//bookInfo.bookingTypeCombobox.Text
switch (status)
{
case 1:
bookInfo.statusComboBox.Text = "Reserved";
break;
case 2:
bookInfo.statusComboBox.Text = "Occupied";
break;
case 3:
bookInfo.statusComboBox.Text = "Checked-out";
break;
default:
bookInfo.statusComboBox.Text = "Available";
break;
}
bookInfo.fromDateLabel.Text = checkIn.ToString("dd.MM.yyyy");
bookInfo.toDayLabel.Text = checkOut.ToString("dd.MM.yyyy");
PayBUS pBUS = new PayBUS();
bookInfo.priceLabel.Text = pBUS.getTotalPrice(b).ToString();
}
}
public static RoomBooking RoomChange(int id)
{
return(BookingBUS.RoomChange(id));
}
public static bool CheckRoomBook(int id)
{
return(BookingBUS.CheckRoomBook(id));
}
public static Customer GetCusByID(int id)
{
return(BookingBUS.GetCusByID(id));
}
public static bool UpdateBooking(Booking b)
{
return(BookingBUS.UpdateBooking(b));
}
public static int CreateCus(Customer cus)
{
return(BookingBUS.CreateCus(cus));
}
public static IEnumerable <HistoryBooking> GetHisBookByID(int id)
{
return(BookingBUS.GetHisBookByID(id));
}
public static bool CheckHisBook(int idBook, string value)
{
return(BookingBUS.CheckHisBook(idBook, value));
}
public static bool CreateHisBook(HistoryBooking hb)
{
return(BookingBUS.CreateHisBook(hb));
}
public static bool UpdateCus(Customer cus, int idBooking)
{
return(BookingBUS.UpdateCus(cus, idBooking));
}
public static bool ReadBookingNew(int id)
{
return(BookingBUS.ReadBookingNew(id));
}
public static IEnumerable <Customer> GetAllCus()
{
return(BookingBUS.GetAllCus());
}
public static bool CreateRB(RoomBooking rb)
{
return(BookingBUS.CreateRB(rb));
}
public static Booking GetBookingByToken(string token)
{
return(BookingBUS.GetBookingByToken(token));
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
this.bookingDTOBindingSource.DataSource = BookingBUS.GetBookingsByContainsId(txtSearch.Text);
}
public static IEnumerable <RoomBooking> GetRB(int id)
{
return(BookingBUS.GetRB(id));
}
private void button1_Click(object sender, EventArgs e)
{
string name = guestNameTextBox.Text;
string nal = nationTB.Text;
Guest g = new Guest(null, name, nal, DateTime.Now);
GuestBUS gBUS = new GuestBUS();
g = gBUS.insertGuest(g);
if (g != null)
{
MessageBox.Show(g.FullName + " " + g.Nationality);
}
else
{
return;
}
BookingBUS bBUS = new BookingBUS();
string roomType = roomTypeComboBox.Text;
string roomID = roomComboBox.Text;
string bookingType = bookingTypeCombobox.Text;
DateTime dateIn = dateCheckin.DateTime;
DateTime dateout = dateCheckout.DateTime;
if (bBUS.checkAvaiable(roomID, dateIn, dateout) == false)
{
MessageBox.Show("ADD BOOKING SUCCESS FAILED!! ROOM BOOKED", "CONFIRMATION",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
bool breakfast = false;
if (breakfastCheckbox.Checked == true)
{
breakfast = true;
}
string type = "003";
if (bookingType == "AGODA")
{
type = "001";
}
else if (bookingType == "Booking.com")
{
type = "002";
}
else
{
}
DTO.Booking b = new DTO.Booking(0, roomID, g.InfoID, type, nv.NhanVienID, DateTime.Now, dateIn, dateout, breakfast);
if (bBUS.InsertBooking(b))
{
MessageBox.Show("ADD BOOKING SUCCESS FULL", "CONFIRMATION",
MessageBoxButtons.OK);
}
else
{
MessageBox.Show("ADD BOOKING SUCCESS FAILED", "CONFIRMATION",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static bool UpdateRB(RoomBooking rb, string reason)
{
return(BookingBUS.UpdateRB(rb, reason));
}