//public decimal? CalculateCostRoom(NewPaymentEN aNewPaymentEN, int IDBookingRoom, string PriceType)
//{
// if (aNewPaymentEN.aListBookingRoomUsed.Where(a => a.ID == IDBookingRoom).ToList().Count > 0)
// {
// CustomersBO aCustomersBO = new CustomersBO();
// ExtraCostBO aExtraCostBO = new ExtraCostBO();
// RoomsBO aRoomsBO = new RoomsBO();
// BookingRoomUsedEN aTemp = aNewPaymentEN.aListBookingRoomUsed.Where(a => a.ID == IDBookingRoom).ToList()[0];
// List<Customers> aListCustomers = aCustomersBO.SelectListCustomer_ByIDBookingRoom(IDBookingRoom);
// if (aListCustomers.Count >0 )
// {
// int CustomerType = Convert.ToInt32(aNewPaymentEN.CustomerType);
// decimal? CostRoom = 0;
// //if (aTemp.Cost != 0)
// //{
// // CostRoom = aTemp.Cost - Convert.ToDecimal(aExtraCostBO.Select_BySku_ByPriceType_ByNumberPeople(aTemp.RoomSku, aTemp.PriceType, aTemp.ListCustomer.Count).ExtraValue);
// //}
// //else
// //{
// CostRoom = aRoomsBO.Select_ByIDBookingRoom(IDBookingRoom).CostRef;
// //}
// string RoomSku = aTemp.RoomSku;
// decimal ExtraMoneyRoom = Convert.ToDecimal(aExtraCostBO.Select_BySku_ByPriceType_ByNumberPeople(RoomSku, PriceType, aListCustomers.Count).ExtraValue);
// return (CostRoom + ExtraMoneyRoom);
// }
// else // Neu phong k co ai thi tien =0
// {
// return 0;
// }
// }
// else
// {
// return 0;
// }
//}
public decimal? CalculateCostRoom( int IDBookingRoom, string PriceType , int CustomerType, int NumCustomer )
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
if (aBookingRoomsBO.Select_ByID(IDBookingRoom) != null)
{
CustomersBO aCustomersBO = new CustomersBO();
ExtraCostBO aExtraCostBO = new ExtraCostBO();
RoomsBO aRoomsBO = new RoomsBO();
//List<Customers> aListCustomers = aCustomersBO.SelectListCustomer_ByIDBookingRoom(IDBookingRoom);
decimal? CostRoom = 0;
CostRoom = aRoomsBO.Select_ByIDBookingRoom(IDBookingRoom).CostRef;
string RoomSku = aRoomsBO.Select_ByIDBookingRoom(IDBookingRoom).Sku;
try
{
decimal? ExtraMoneyRoom = aExtraCostBO.Select_BySku_ByPriceType_ByNumberPeople(RoomSku, PriceType, NumCustomer).ExtraValue;
return (CostRoom + ExtraMoneyRoom);
}
catch(Exception w)
{
MessageBox.Show("Trong dữ liệu giá bảng giá " + PriceType + " của phòng " + RoomSku + " chưa có giá dành cho " + NumCustomer + " người ");
return 0;
}
}
else
{
return 0;
}
}
public void LoadData()
{
try
{
CustomersBO aCustomersBO = new CustomersBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms = new BookingRooms();
RoomsBO aRoomsBO = new RoomsBO();
// Load các thông tin chung về phòng
aBookingRooms = aBookingRoomsBO.Select_ByID(this.IDBookingRooms);
if (aBookingRooms != null)
{
lblCheckIn.Text = aBookingRooms.CheckInActual.ToString("dd/MM/yyyy HH:mm");
lblCheckOut.Text = aBookingRooms.CheckOutPlan.ToString("dd/MM/yyyy HH:mm");
lblRoomSku.Text = aRoomsBO.Select_ByCodeRoom(aBookingRooms.CodeRoom, 1).Sku;
}
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = new BookingRs();
aBookingRs = aBookingRsBO.Select_ByID(this.IDBookingRs);
if (aBookingRs != null)
{
lblCustomerType.Text = CORE.CONSTANTS.SelectedCustomerType(Convert.ToInt32(aBookingRs.CustomerType)).Name;
CompaniesBO aCompaniesBO = new CompaniesBO();
lblCompany.Text = aCompaniesBO.Select_ByIDBookingRoom(this.IDBookingRooms).Name;
lblCustomer.Text = aCustomersBO.Select_ByID(aBookingRs.IDCustomer).Name;
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
lblGroup.Text = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup).Name;
lblTel.Text = aCustomersBO.Select_ByID(aBookingRs.IDCustomer).Tel;
this.IDCustomerGroup = aBookingRs.IDCustomerGroup;
}
//Load danh sách phòng còn trống
lueRooms.Properties.DataSource = this.LoadListAvailableRooms(aBookingRooms.CheckInActual, aBookingRooms.CheckOutPlan);
lueRooms.Properties.ValueMember = "RoomCode";
lueRooms.EditValue = this.IDBookingRooms;
//Load danh sách khách trong phòng
this.aListCustomersInRoom = aCustomersBO.SelectListCustomer_ByIDBookingRoom(this.IDBookingRooms);
dgvAvailableCustomers.DataSource = this.aListCustomersInRoom;
dgvAvailableCustomers.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_EditBooking.ReloadData\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public frmTsk_EditBooking(int IDBookingRoom, frmMain afrmMain)
{
InitializeComponent();
BookingRoomsBO aBookingRoomBO = new BookingRoomsBO();
this.aBookingRoom = aBookingRoomBO.Select_ByID(IDBookingRoom);
BookingRsBO aBookingRsBO = new BookingRsBO();
this.aBookingRs = aBookingRsBO.Select_ByID(this.aBookingRoom.IDBookingR);
this.afrmMain = afrmMain;
this.IsReadyInitData = false;
this.aCurrentCustomerClick = new CustomerInfoEN();
}
public void LoadData()
{
try
{
CustomersBO aCustomersBO = new CustomersBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms = new BookingRooms();
RoomsBO aRoomsBO = new RoomsBO();
aBookingRooms = aBookingRoomsBO.Select_ByID(this.IDBookingRooms);
if (aBookingRooms != null)
{
lblCheckIn.Text = aBookingRooms.CheckInActual.ToString("dd/MM/yyyy HH:mm");
lblCheckOut.Text = aBookingRooms.CheckOutPlan.ToString("dd/MM/yyyy HH:mm");
lblRoomSku.Text = aRoomsBO.Select_ByCodeRoom(aBookingRooms.CodeRoom,1).Sku;
}
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = new BookingRs();
aBookingRs = aBookingRsBO.Select_ByID(this.IDBookingRs);
if (aBookingRs != null)
{
lblCustomerType.Text = CORE.CONSTANTS.SelectedCustomerType(Convert.ToInt32(aBookingRs.CustomerType)).Name;
CompaniesBO aCompaniesBO = new CompaniesBO();
lblCompany.Text = aCompaniesBO.Select_ByIDBookingRoom(this.IDBookingRooms).Name;
lblCustomer.Text = aCustomersBO.Select_ByID(aBookingRs.IDCustomer).Name;
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
lblGroup.Text = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup).Name;
lblTel.Text = aCustomersBO.Select_ByID(aBookingRs.IDCustomer).Tel;
this.IDCustomerGroup = aBookingRs.IDCustomerGroup;
}
dgvAvaiableRooms.DataSource = this.LoadListAvailableRooms(aBookingRooms.CheckInActual, aBookingRooms.CheckOutPlan);
dgvAvaiableRooms.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_EditBooking.ReloadData\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Rooms Select_ByIDBookingRoom(int IDBookingRoom)
{
try
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aTemp = aBookingRoomsBO.Select_ByID(IDBookingRoom);
Rooms aRooms = this.Select_ByCodeRoom(aTemp.CodeRoom, 1);
return aRooms;
}
catch (Exception ex)
{
throw new Exception(string.Format("RoomBO.Select_ByIDBookingRoom :" + ex.Message.ToString()));
}
}
private bool ChangeRoom_Case1()
{
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
BookingRooms aBookingRooms = new BookingRooms();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
// Neu phong chi co 1 nguoi, va nguoi do chuyen di mat thi coi nhu checkout luon
if (this.ListCustomerInRoomBeforeChange_Case1.Count == 1)
{
aReceptionTaskBO.CheckOut(this.IDBookingRoom_Case1, dtpFrom_Case1.DateTime);
}
else if (this.ListCustomerInRoomBeforeChange_Case1.Count > 1)
{
aBookingRooms = aBookingRoomsBO.Select_ByID(this.IDBookingRoom_Case1);
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
List<BookingRoomsMembers> aListCustomer = aBookingRoomsMembersBO.Select_ByIDBookingRoom(this.IDBookingRoom_Case1);
BookingRoomsMembers aBookingRoomsMembers = aListCustomer.Where(p => p.IDCustomer == int.Parse(lueListCustomerInRoom_Case1.EditValue.ToString())).ToList()[0];
aListCustomer.Remove(aBookingRoomsMembers);
aReceptionTaskBO.CheckOutFirstRoom(this.IDBookingRoom_Case1, dtpFrom_Case1.DateTime);
aBookingRooms.CheckInActual = dtpFrom_Case1.DateTime;
aBookingRooms.CheckInPlan = dtpFrom_Case1.DateTime;
aBookingRooms.AddTimeEnd = null;
aBookingRooms.AddTimeStart = null;
aBookingRooms.TimeInUse = null;
//BookingRooms Item = new BookingRooms();
//Item.AcceptDate = aBookingRooms.AcceptDate;
//Item.AdditionalColumn1 = aBookingRooms.AdditionalColumn1;
//Item.AddTimeEnd = aBookingRooms.AddTimeEnd;
//Item.AddTimeStart = aBookingRooms.AddTimeStart;
//Item.BookingStatus = aBookingRooms.BookingStatus;
//Item.CheckInActual = aBookingRooms.CheckInActual;
//Item.CheckInPlan = aBookingRooms.CheckInPlan;
//Item.CheckOutActual = aBookingRooms.CheckOutActual;
//Item.CheckOutPlan = aBookingRooms.CheckOutPlan;
//Item.CodeRoom = aBookingRooms.CodeRoom;
//Item.Color = aBookingRooms.Color;
//Item.Cost = aBookingRooms.Cost;
//Item.CostPendingRoom = aBookingRooms.CostPendingRoom;
//Item.CostRef_Rooms = aBookingRooms.CostRef_Rooms;
//Item.Disable = aBookingRooms.Disable;
//Item.EndTime = aBookingRooms.EndTime;
//Item.IDBookingR = aBookingRooms.IDBookingR;
//Item.IndexSubPayment = aBookingRooms.IndexSubPayment;
//Item.InvoiceDate = aBookingRooms.InvoiceDate;
//Item.InvoiceNumber = aBookingRooms.InvoiceNumber;
//Item.IsAllDayEvent = aBookingRooms.IsAllDayEvent;
//Item.IsEditable = aBookingRooms.IsEditable;
//Item.IsRecurring = aBookingRooms.IsRecurring;
//Item.Note = aBookingRooms.Note;
//Item.PercentTax = aBookingRooms.PercentTax;
//Item.PriceType = aBookingRooms.PriceType;
//Item.StartTime = aBookingRooms.StartTime;
//Item.Status = aBookingRooms.Status;
//Item.TimeInUse = aBookingRooms.TimeInUse;
//Item.Type = aBookingRooms.Type;
int NewIDBookingRoom = aBookingRoomsBO.Insert(aBookingRooms);
for (int i = 0; i < aListCustomer.Count; i++)
{
aListCustomer[i].IDBookingRoom = NewIDBookingRoom;
aBookingRoomsMembersBO.Insert(aListCustomer[i]);
}
}
return true;
}
//hiennv
private void btnRemoveSelectedRooms_ButtonClick(object sender, ButtonPressedEventArgs e)
{
try
{
RoomsEN aRoomEN = new RoomsEN();
aRoomEN.Code = viewSelectedRooms.GetFocusedRowCellValue("RoomCode").ToString();
aRoomEN.Sku = viewSelectedRooms.GetFocusedRowCellValue("RoomSku").ToString();
aRoomEN.TypeDisplay = viewSelectedRooms.GetFocusedRowCellValue("RoomTypeDisplay").ToString();
aRoomEN.Bed1 = Convert.ToInt32(viewSelectedRooms.GetFocusedRowCellValue("RoomBed1"));
aRoomEN.Bed2 = Convert.ToInt32(viewSelectedRooms.GetFocusedRowCellValue("RoomBed2"));
aRoomEN.CostRef = Convert.ToDecimal(viewSelectedRooms.GetFocusedRowCellValue("RoomCostRef"));
this.aListAvaiableRooms.Insert(0, aRoomEN);
dgvAvailableRooms.DataSource = this.aListAvaiableRooms;
dgvAvailableRooms.RefreshDataSource();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
int ID = Convert.ToInt32(viewSelectedRooms.GetFocusedRowCellValue("IDBookingRooms"));
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(ID);
if (aBookingRooms != null)
{
aBookingRoomsBO.Delete(aBookingRooms.ID);
}
RoomMemberEN Temps = aCheckInRoomBookingEN.aListRoomMembers.Where(p => p.RoomSku == viewSelectedRooms.GetFocusedRowCellValue("RoomSku").ToString()).ToList()[0];
this.aCheckInRoomBookingEN.aListRoomMembers.Remove(Temps);
dgvSelectedRooms.DataSource = aCheckInRoomBookingEN.aListRoomMembers;
dgvSelectedRooms.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_CheckInGoverment_ForRoomBooking_Step1.btnRemoveSelectedRooms_ButtonClick\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void CheckOut(int IDBookingRoom)
{
try
{
RoomsBO aRoomsBO = new RoomsBO();
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
ExtraCostBO aExtraCostBO = new ExtraCostBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(IDBookingRoom);
List<BookingRoomsMembers> aListCus = aBookingRoomsMembersBO.Select_ByIDBookingRoom(IDBookingRoom);
aBookingRooms.CheckOutActual = DateTime.Now;
aBookingRooms.Status = 7;
aBookingRooms.AddTimeStart = Convert.ToDouble(aReceptionTaskBO.GetAddTimeStart(aBookingRooms.Type.GetValueOrDefault(0), aBookingRooms.CheckInActual));
aBookingRooms.AddTimeEnd = Convert.ToDouble(aReceptionTaskBO.GetAddTimeEnd(aBookingRooms.Type.GetValueOrDefault(0), aBookingRooms.CheckOutActual));
aBookingRooms.TimeInUse = Convert.ToDecimal(aReceptionTaskBO.GetTimeInUsed(aBookingRooms.CheckInActual, aBookingRooms.CheckOutActual) * 24 * 60);
Rooms aRooms = aRoomsBO.Select_ByCodeRoom(aBookingRooms.CodeRoom, 1);
if (aRooms != null)
{
if (aBookingRooms.Cost == null)
{
decimal? cost = 0;
cost = aBookingRooms.CostRef_Rooms;
aBookingRooms.Cost = cost + Convert.ToDecimal(aExtraCostBO.Select_BySku_ByPriceType_ByNumberPeople(aRooms.Sku, aBookingRooms.PriceType, aListCus.Count).ExtraValue);
}
}
aBookingRoomsBO.Update(aBookingRooms);
}
catch (Exception ex)
{
throw new Exception("AccountancyBO.CheckOut\n" + ex.ToString());
}
}
//hiennv
public bool PaymentRoom(PaymentEN aPaymentEN)
{
try
{
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(aPaymentEN.IDBookingR);
if (aBookingRs != null)
{
aBookingRs.ID = aPaymentEN.IDBookingR;
aBookingRs.PayMenthod = aPaymentEN.PayMenthod;
aBookingRs.StatusPay = 3;
aBookingRs.Status = 8;
aBookingRs.DatePay = DateTime.Now;
aBookingRs.BookingMoney = 0;
aBookingRsBO.Update(aBookingRs);
}
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms_ServicesBO aBookingRooms_ServicesBO = new BookingRooms_ServicesBO();
for (int i = 0; i < aPaymentEN.aListInfoDetailPaymentEN.Count; i++)
{
if (aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.IDBookingR == aPaymentEN.IDBookingR)
{
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.ID);
if (aBookingRooms != null)
{
aBookingRooms.ID = aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.ID;
aBookingRooms.PercentTax = aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.PercentTax;
decimal? cost = aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.Cost == null ? aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.CostRef_Rooms : aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.Cost;
aBookingRooms.Cost = cost;
aBookingRooms.Status = 8;
aBookingRooms.CheckOutActual = aPaymentEN.aListInfoDetailPaymentEN[i].CheckOut;
aBookingRooms.TimeInUse = Convert.ToDecimal(aPaymentEN.aListInfoDetailPaymentEN[i].DateInUse * 24 * 60);
aBookingRoomsBO.Update(aBookingRooms);
}
for (int j = 0; j < aPaymentEN.aListInfoDetailPaymentEN[i].aListService.Count; j++)
{
if (aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.ID == aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].IDBookingRoom)
{
BookingRooms_Services aBookingRooms_Services = aBookingRooms_ServicesBO.Select_ByID(aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].IDBookingRoomService);
if (aBookingRooms_Services != null)
{
aBookingRooms_Services.ID = aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].IDBookingRoomService;
aBookingRooms_Services.Quantity = aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].Quantity;
aBookingRooms_Services.PercentTax = aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].PercentTax;
aBookingRooms_Services.Cost = aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].Cost;
aBookingRooms_Services.Status = 8;
aBookingRooms_ServicesBO.Update(aBookingRooms_Services);
}
}
}
}
}
return true;
}
catch (Exception ex)
{
return false;
throw new Exception(string.Format("ReceptionTaskBO.PaymentRoom\n" + ex.Message));
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
try
{
if (this.ValidateData() == true)
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(this.IDBookingRooms);
aBookingRooms.CodeRoom = this.NewCodeRoom;
aBookingRooms.Cost = this.NewCostRoom;
aBookingRooms.CostRef_Rooms = this.NewCostRoom;
aBookingRoomsBO.Update(aBookingRooms);
MessageBox.Show("Chuyển phòng thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (afrmMain != null)
{
this.afrmMain.ReloadData();
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_ChangeRoom.btnUpdate_Click\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//hiennv
private void btnUnFill_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
RoomsEN aRoomEN = new RoomsEN();
aRoomEN.Sku = grvSelectedRooms.GetFocusedRowCellValue("RoomSku").ToString();
aRoomEN.Code = grvSelectedRooms.GetFocusedRowCellValue("RoomCode").ToString();
aRoomEN.TypeDisplay = Convert.ToString(grvSelectedRooms.GetFocusedRowCellValue("RoomTypeDisplay"));
aRoomEN.Bed1 = Convert.ToInt32(grvSelectedRooms.GetFocusedRowCellValue("RoomBed1"));
aRoomEN.Bed2 = Convert.ToInt32(grvSelectedRooms.GetFocusedRowCellValue("RoomBed2"));
aRoomEN.CostRef = Convert.ToDecimal(grvSelectedRooms.GetFocusedRowCellValue("RoomCostRef"));
aListAvaiableRooms.Insert(0, aRoomEN);
dgvAvailableRooms.DataSource = aListAvaiableRooms;
dgvAvailableRooms.RefreshDataSource();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
int ID = Convert.ToInt32(grvSelectedRooms.GetFocusedRowCellValue("IDBookingRooms"));
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(ID);
if (aBookingRooms != null)
{
aBookingRoomsBO.Delete(aBookingRooms.ID);
}
RoomMemberEN aRoomMemberEN = this.aCheckInRoomBookingEN.aListRoomMembers.Where(p => p.RoomSku == grvSelectedRooms.GetFocusedRowCellValue("RoomSku").ToString()).ToList()[0];
this.aCheckInRoomBookingEN.aListRoomMembers.Remove(aRoomMemberEN);
dgvSelectedRooms.DataSource = this.aCheckInRoomBookingEN.aListRoomMembers;
dgvSelectedRooms.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("Check In Step 1 - Khách lẻ - Bỏ chọn " + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ProcessChangeRoom()
{
// Vi moi khi check In luon bi tinh mac dinh 1 ngay
bool IsRootRoomChangeInDay = false;
ItemChangeRoomEN RootRoom = this.aChangeRoomEn.GetRootItemChangeRoom();
// Tinh 2 tham so can thiet cho qua trinh chuyen phong
//===================================================
if (RootRoom.GetStatusBookingRooms() == 3)
{
if (RootRoom.GetCheckInActual().Date == this.aBookingRoom.CheckInActual.Date)
{
IsRootRoomChangeInDay = true;
}
else
{
IsRootRoomChangeInDay = false;
}
}
else if (RootRoom.GetStatusBookingRooms() < 3)
{
// phòng ở trạng thái đặt
MessageBox.Show("Phòng này đang ở trạng thái đặt. Bạn muốn cho người vào phòng hãy sử dụng chức năng checkin");
return;
}
ClearRoomHasNotCustomer();
List<ItemChangeRoomEN> aaa= this.aChangeRoomEn.GetAllItemChangeRoom();
List<ItemChangeRoomEN> aListItemChangeRooms = new List<ItemChangeRoomEN>();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
// Doi phong khac ngay
if (IsRootRoomChangeInDay == false)
{
if (ckbCheckOutNow.Checked == true)
{
(new ReceptionTaskBO()).CheckOutFirstRoom(this.aBookingRoom.ID, DateTime.Now);
}
else if (ckbCheckOutNow.Checked == false)
{
(new ReceptionTaskBO()).CheckOutFirstRoom(this.aBookingRoom.ID, dtpCheckIn.DateTime);
}
aListItemChangeRooms = this.aChangeRoomEn.GetAllItemChangeRoom();
// Đổi type cua nhung bookingroom sau bookingroom dau tien
for (int i = 0; i < aListItemChangeRooms.Count; i++)
{
if (aListItemChangeRooms[i].GetTypeBookingRoom() == 2)
{
aListItemChangeRooms[i].SetTypeBookingRoom(0);
}
else if (aListItemChangeRooms[i].GetTypeBookingRoom() == 0)
{
aListItemChangeRooms[i].SetTypeBookingRoom(0);
}
else if (aListItemChangeRooms[i].GetTypeBookingRoom() == 3)
{
aListItemChangeRooms[i].SetTypeBookingRoom(1);
}
else if (aListItemChangeRooms[i].GetTypeBookingRoom() == 1)
{
aListItemChangeRooms[i].SetTypeBookingRoom(1);
}
else
{
aListItemChangeRooms[i].SetTypeBookingRoom(3);
}
(new ReceptionTaskBO()).CheckInNewRoom(aListItemChangeRooms[i]);
}
}
// Doi phong trong cung 1 ngay, phong cu khong tinh tien
else
{
BookingRooms aItem = aBookingRoomsBO.Select_ByID(this.aBookingRoom.ID);
aItem.Cost = 0;
aItem.CheckOutActual = dtpCheckOut.DateTime;
aItem.Status = 7;
aBookingRoomsBO.Update(aItem);
//va checkIn lai loat moi voi time tu lan checkIn dau tien
aListItemChangeRooms = this.aChangeRoomEn.GetAllItemChangeRoom();
for (int i = 0; i < aListItemChangeRooms.Count; i++)
{
aListItemChangeRooms[i].SetCheckInPlan(this.aBookingRoom.CheckInPlan);
aListItemChangeRooms[i].SetCheckInActual(this.aBookingRoom.CheckInActual);
aListItemChangeRooms[i].SetCheckOutActual(dtpCheckOut.DateTime);
aListItemChangeRooms[i].SetCheckOutPlan(dtpCheckOut.DateTime);
//Truong hop doi phong trong ngay, thi k tinh tien phong dau ma don het sang phong sau. Vi vay Type cung chuyen sang phong sau
aListItemChangeRooms[i].SetTypeBookingRoom(aItem.Type.GetValueOrDefault(3));
(new ReceptionTaskBO()).CheckInNewRoom(aListItemChangeRooms[i]);
}
}
//-----------------------------------------------
aListItemChangeRooms = new List<ItemChangeRoomEN>();
aListItemChangeRooms = this.aChangeRoomEn.GetAllItemChangeRoom();
BookingRooms aItem1 = new BookingRooms();
for (int i = 0; i < aListItemChangeRooms.Count; i++)
{
////---------------------------------------------------
if (aListItemChangeRooms[i].IsRoomInBookingR == true)
{
aItem1 = new BookingRooms();
aItem1 = aBookingRoomsBO.Select_ByID(aListItemChangeRooms[i].GetBookingRooms().ID);
if (IsRootRoomChangeInDay == true)
{
aItem1.Cost = 0;
}
aItem1.CheckOutActual = dtpCheckIn.DateTime;
aItem1.Status = 7;
aBookingRoomsBO.Update(aItem1);
}
}
//-----------------------------------------------
MessageBoxButtons buttons = MessageBoxButtons.OK;
// Show message box
DialogResult result = MessageBox.Show("Chuyển phòng thành công","Nhà khách chính phủ", buttons);
if (result == System.Windows.Forms.DialogResult.OK)
{
this.afrmMain.RefreshData_auc_StatusRooms(DateTime.Now);
this.Close();
}
//========================================================
}
//Ngoc
public int CheckOutFirstRoom(int IDBookingRoom, DateTime CheckOut)
{
try
{
/*Ghi chu TypeBookingRooms
*
* Type = 2: //Tính checkin sớm , không tính checkout muộn.
* Type = 0: //Không tính checkIn sớm và checkout muộn.
* Type = 3: //Tính checkin sớm và Checkout muộn
* Type = 1: //Không tính checkin sớm , tính checkout muộn
*/
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(IDBookingRoom);
if (aBookingRooms != null)
{
aBookingRooms.CheckOutActual = CheckOut;
int updateType = -1;
if (aBookingRooms.Type == 2)
{
updateType = 2;
}
else if (aBookingRooms.Type == 0)
{
updateType = 0;
}
else if (aBookingRooms.Type == 3)
{
updateType = 2;
}
else if (aBookingRooms.Type == 1)
{
updateType = 0;
}
else
{
updateType = 3;
}
aBookingRooms.Type = updateType;
aBookingRooms.Status = 7;//da checkout nhung chua thanh toan
aBookingRooms.TimeInUse = decimal.Parse(aReceptionTaskBO.GetTimeInUsed(aBookingRooms.CheckInActual, CheckOut).ToString());
aBookingRooms.AddTimeStart = aReceptionTaskBO.GetAddTimeStart(aBookingRooms.Type.GetValueOrDefault(0), aBookingRooms.CheckInActual);
aBookingRooms.AddTimeEnd = aReceptionTaskBO.GetAddTimeEnd(aBookingRooms.Type.GetValueOrDefault(0), CheckOut);
return aBookingRoomsBO.Update(aBookingRooms);
}
else
{
return 0;
}
}
catch (Exception ex)
{
return 0;
}
}
public int CheckOut(int IDBookingRoom, DateTime CheckOut)
{
try
{
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(IDBookingRoom);
if (aBookingRooms != null)
{
aBookingRooms.CheckOutActual = CheckOut;
aBookingRooms.Status = 7;//da checkout nhung chua thanh toan
aBookingRooms.TimeInUse = decimal.Parse(aReceptionTaskBO.GetTimeInUsed(aBookingRooms.CheckInActual, CheckOut).ToString());
aBookingRooms.AddTimeStart = aReceptionTaskBO.GetAddTimeStart(aBookingRooms.Type.GetValueOrDefault(0), aBookingRooms.CheckInActual);
aBookingRooms.AddTimeEnd = aReceptionTaskBO.GetAddTimeEnd(aBookingRooms.Type.GetValueOrDefault(0), CheckOut);
return aBookingRoomsBO.Update(aBookingRooms);
}
else
{
return 0;
}
}
catch (Exception ex)
{
return 0;
}
}
//Author :Hiennv
public bool CheckInForRoomAlreadyBooking(CheckInRoomBookingEN aCheckInRoomBookingEN)
{
try
{
//========================================================
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(aCheckInRoomBookingEN.IDBookingR);
if (aBookingRs != null)
{
aBookingRs.Subject = aCheckInRoomBookingEN.Subject;
aBookingRs.Level = aCheckInRoomBookingEN.Level;
aBookingRs.Description = aCheckInRoomBookingEN.Description;
aBookingRs.Note = aCheckInRoomBookingEN.Note;
aBookingRs.IDCustomerGroup = aCheckInRoomBookingEN.IDCustomerGroup;
aBookingRs.IDCustomer = aCheckInRoomBookingEN.IDCustomer;
aBookingRs.BookingMoney = aCheckInRoomBookingEN.BookingMoney;
aBookingRs.IDSystemUser = aCheckInRoomBookingEN.IDSystemUser;
aBookingRs.BookingType = aCheckInRoomBookingEN.BookingType;
aBookingRs.Status = aCheckInRoomBookingEN.Status;
aBookingRs.StatusPay = aCheckInRoomBookingEN.StatusPay;
aBookingRs.DateEdit = DateTime.Now;
//cap nhat lai bang BookingRs
aBookingRsBO.Update(aBookingRs);
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms;
BookingRoomsMembers aBookingRoomsMembers;
foreach (RoomMemberEN aRoomMemberEN in aCheckInRoomBookingEN.aListRoomMembers)
{
aBookingRooms = new BookingRooms();
aBookingRooms = aBookingRoomsBO.Select_ByID(aRoomMemberEN.IDBookingRooms);
if (aBookingRooms != null)
{
aBookingRooms.CheckInActual = aCheckInRoomBookingEN.CheckInActual;
aBookingRooms.CheckOutActual = aCheckInRoomBookingEN.CheckOutActual;
aBookingRooms.CheckOutPlan = aCheckInRoomBookingEN.CheckOutPlan;
aBookingRooms.Status = aCheckInRoomBookingEN.Status;
aBookingRoomsBO.Update(aBookingRooms);
}
else
{
aBookingRooms = new BookingRooms();
aBookingRooms.IDBookingR = aCheckInRoomBookingEN.IDBookingR;
aBookingRooms.CodeRoom = aRoomMemberEN.RoomCode;
aBookingRooms.PercentTax = 10;
aBookingRooms.CostRef_Rooms = aRoomMemberEN.RoomCostRef;
aBookingRooms.Cost = aRoomMemberEN.RoomCostRef;
aBookingRooms.CheckInPlan = aCheckInRoomBookingEN.CheckInActual;
aBookingRooms.CheckInActual = aCheckInRoomBookingEN.CheckInActual;
aBookingRooms.CheckOutPlan = aCheckInRoomBookingEN.CheckOutPlan;
aBookingRooms.CheckOutActual = aCheckInRoomBookingEN.CheckOutActual;
aBookingRooms.StartTime = aCheckInRoomBookingEN.CheckInActual;
aBookingRooms.EndTime = aCheckInRoomBookingEN.CheckOutPlan;
aBookingRooms.BookingStatus = 1;
aBookingRooms.Status = aCheckInRoomBookingEN.Status;
aBookingRooms.Status = 1;//Tính CheckIn sớm và CheckOut muộn
//add new bookingRoom
aBookingRoomsBO.Insert(aBookingRooms);
aRoomMemberEN.IDBookingRooms = aBookingRooms.ID;
}
//-----------------------------------------------------------
aBookingRoomsMembers = new BookingRoomsMembers();
aBookingRoomsMembers.IDBookingRoom = aRoomMemberEN.IDBookingRooms;
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
foreach (CustomerInfoEN aCustomerInfoEN in aRoomMemberEN.ListCustomer)
{
aBookingRoomsMembers.IDCustomer = aCustomerInfoEN.ID;
aBookingRoomsMembers.PurposeComeVietnam = aCustomerInfoEN.PurposeComeVietnam;
aBookingRoomsMembers.DateEnterCountry = aCustomerInfoEN.DateEnterCountry;
aBookingRoomsMembers.EnterGate = aCustomerInfoEN.EnterGate;
aBookingRoomsMembers.TemporaryResidenceDate = aCustomerInfoEN.TemporaryResidenceDate;
aBookingRoomsMembers.LimitDateEnterCountry = aCustomerInfoEN.LimitDateEnterCountry;
aBookingRoomsMembers.Organization = aCustomerInfoEN.Organization;
aBookingRoomsMembers.LeaveDate = aCustomerInfoEN.LeaveDate;
//add new bookingRoomMember
aBookingRoomsMembersBO.Insert(aBookingRoomsMembers);
}
}
}
return true;
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.CheckInForRoomAlreadyBooking\n" + ex.ToString());
}
}
private void btnCheckIn_Click(object sender, EventArgs e)
{
try
{
if (dtpFrom.DateTime < dtpTo.DateTime)
{
if (this.Status == 2)
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
//cap nhat bookingroom
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(this.IDBookingRoom);
//aBookingRooms.CheckInPlan = DateTime.Now;
//aBookingRooms.CheckInActual = DateTime.Now;
aBookingRooms.CheckInPlan = dtpFrom.DateTime;
aBookingRooms.CheckInActual = dtpFrom.DateTime;
aBookingRooms.CheckOutPlan = dtpTo.DateTime;
aBookingRooms.CheckOutActual = dtpTo.DateTime;
//aBookingRooms.PriceType = "G1";
aBookingRooms.Status = 3;// 3= Da check in
aBookingRoomsBO.Update(aBookingRooms);
if (this.afrmTsk_PendingCheckIn_Step1 != null)
{
this.afrmTsk_PendingCheckIn_Step1.LoadDataBookingRoom(this.Status);
if (this.afrmTsk_PendingCheckIn_Step1.afrmMain != null)
{
this.afrmTsk_PendingCheckIn_Step1.afrmMain.ReloadData();
}
}
MessageBox.Show("Thực hiện thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else if (this.Status == 5)
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
RoomsBO aRoomsBO = new RoomsBO();
AccountancyBO aAccountancyBO = new AccountancyBO();
//Check out giai doan pending
aAccountancyBO.CheckOut(this.IDBookingRoom, dtpFrom.DateTime);
//them moi mot bookingroom
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(this.IDBookingRoom);
BookingRooms aBookingRoomsAddNew = new BookingRooms();
aBookingRoomsAddNew.IDBookingR = IDBookingR;
aBookingRoomsAddNew.CodeRoom = CodeRoom;
aBookingRoomsAddNew.PercentTax = aBookingRooms.PercentTax;
aBookingRoomsAddNew.CostRef_Rooms = aRoomsBO.Select_ByCodeRoom(aBookingRooms.CodeRoom, 1).CostRef;
aBookingRoomsAddNew.Note = aBookingRooms.Note;
aBookingRoomsAddNew.CheckInPlan = dtpFrom.DateTime;
aBookingRoomsAddNew.CheckInActual = dtpFrom.DateTime;
aBookingRoomsAddNew.CheckOutPlan = dtpTo.DateTime;
aBookingRoomsAddNew.CheckOutActual = dtpTo.DateTime;
aBookingRoomsAddNew.PriceType = aBookingRooms.PriceType;
aBookingRoomsAddNew.Type = 1;
aBookingRoomsAddNew.BookingStatus = aBookingRooms.BookingStatus;
aBookingRoomsAddNew.Status = 3;// 3 = Da CheckIn
aBookingRoomsAddNew.StartTime = aBookingRooms.StartTime;
aBookingRoomsAddNew.EndTime = aBookingRooms.EndTime;
aBookingRoomsAddNew.IsAllDayEvent = aBookingRooms.IsAllDayEvent;
aBookingRoomsAddNew.Color = aBookingRooms.Color;
aBookingRoomsAddNew.IsRecurring = aBookingRooms.IsRecurring;
aBookingRoomsAddNew.IsEditable = aBookingRooms.IsEditable;
aBookingRoomsAddNew.AdditionalColumn1 = aBookingRooms.AdditionalColumn1;
int ID = aBookingRoomsBO.Insert(aBookingRoomsAddNew);
if (ID > 0)
{
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
List<BookingRoomsMembers> aListBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom(this.IDBookingRoom);
BookingRoomsMembers aBookingRoomsMembers;
foreach (BookingRoomsMembers item1 in aListBookingRoomsMembers)
{
aBookingRoomsMembers = new BookingRoomsMembers();
aBookingRoomsMembers.IDBookingRoom = ID;
aBookingRoomsMembers.IDCustomer = item1.IDCustomer;
aBookingRoomsMembers.PurposeComeVietnam = item1.PurposeComeVietnam;
aBookingRoomsMembers.DateEnterCountry = item1.DateEnterCountry;
aBookingRoomsMembers.EnterGate = item1.EnterGate;
aBookingRoomsMembers.TemporaryResidenceDate = item1.TemporaryResidenceDate;
aBookingRoomsMembers.LimitDateEnterCountry = item1.LimitDateEnterCountry;
aBookingRoomsMembers.Organization = item1.Organization;
aBookingRoomsMembers.LeaveDate = item1.LeaveDate;
aBookingRoomsMembersBO.Insert(aBookingRoomsMembers);
}
}
if (this.afrmTsk_PendingCheckIn_Step1 != null)
{
this.afrmTsk_PendingCheckIn_Step1.LoadDataBookingRoom(Status);
if (this.afrmTsk_PendingCheckIn_Step1.afrmMain != null)
{
this.afrmTsk_PendingCheckIn_Step1.afrmMain.ReloadData();
}
}
MessageBox.Show("Thực hiện thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
else
{
MessageBox.Show("Ngày giờ không hợp lệ");
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_PendingCheckIn_Step2.btnCheckIn_Click\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Reload()
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
RoomsBO aRoomsBO = new RoomsBO();
BookingRoomsEN aBookingRoomsEN = new BookingRoomsEN();
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(IDBookingRoom);
aBookingRoomsEN.SetValue(aBookingRooms);
aBookingRoomsEN.ID = aBookingRooms.ID;
aBookingRoomsEN.RoomSku = aRoomsBO.Select_ByCodeRoom(aBookingRooms.CodeRoom, 1).Sku;
this.lbCurrentRoom.Text = "Phòng số : " + aBookingRoomsEN.RoomSku;
aListBookingRoom.Add(aBookingRoomsEN);
dgvRooms.DataSource = aListBookingRoom;
dgvRooms.RefreshDataSource();
ServicesBO aServicesBO = new ServicesBO();
aListService = aServicesBO.Select_ByType(2);
dgvServices.DataSource = aListService;
dgvServices.RefreshDataSource();
}
public double CaculateBooking(int IDBookingRoom, DateTime StartTime, DateTime EndTime)
{
try
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(IDBookingRoom);
if (aBookingRooms != null)
{
TimeSpan dis = EndTime.Subtract(StartTime);
double a = (dis.TotalHours) / 24;
double a1 = 0;
if (a < 1)
{
a1 = Math.Floor(a);
}
else
{
a1 = Math.Round(a);
}
double addtimeStart = 0;
double addtimeEnd = 0;
DateTime CheckIn = DateTime.Parse(StartTime.ToString("HH:mm"));
DateTime CheckOut = DateTime.Parse(EndTime.ToString("HH:mm"));
if (aBookingRooms.Type == 3)//Tính checkin sớm và Checkout muộn
{
CheckPointBO aCheckPointBO = new CheckPointBO();
List<CheckPoints> aListCheckPoint = aCheckPointBO.Select_All();
for (int i = 0; i < aListCheckPoint.Count; i++)
{
if (aListCheckPoint[i].Type == 1) // checkIn som
{
if (aListCheckPoint[i].From <= CheckIn.TimeOfDay && CheckIn.TimeOfDay <= aListCheckPoint[i].To)
{
addtimeStart = aListCheckPoint[i].AddTime;
}
}
else if (aListCheckPoint[i].Type == 2) // CheckOut muon
{
if (aListCheckPoint[i].From <= CheckOut.TimeOfDay && CheckOut.TimeOfDay <= aListCheckPoint[i].To)
{
addtimeEnd = aListCheckPoint[i].AddTime;
}
}
}
double result = a1 + addtimeEnd + addtimeStart;
if (result < 1)
{
return 1;
}
else
{
return result;
}
}
else if (aBookingRooms.Type == 0) //Không tính checkIn sớm và checkout muộn.
{
return a1;
}
else if (aBookingRooms.Type == 2) //Tính checkin sớm ,không tính checkout muộn.
{
CheckPointBO aCheckPointBO = new CheckPointBO();
List<CheckPoints> aListCheckPoint = aCheckPointBO.Select_All();
for (int i = 0; i < aListCheckPoint.Count; i++)
{
if (aListCheckPoint[i].Type == 1) // checkIn som
{
if (aListCheckPoint[i].From <= CheckIn.TimeOfDay && CheckIn.TimeOfDay <= aListCheckPoint[i].To)
{
addtimeStart = aListCheckPoint[i].AddTime;
}
}
}
return a1 + addtimeStart;
}
else if (aBookingRooms.Type == 1) //Không tính checkin sớm ,tính checkout muộn
{
CheckPointBO aCheckPointBO = new CheckPointBO();
List<CheckPoints> aListCheckPoint = aCheckPointBO.Select_All();
for (int i = 0; i < aListCheckPoint.Count; i++)
{
if (aListCheckPoint[i].Type == 2) // CheckOut muon
{
if (aListCheckPoint[i].From <= CheckOut.TimeOfDay && CheckOut.TimeOfDay <= aListCheckPoint[i].To)
{
addtimeEnd = aListCheckPoint[i].AddTime;
}
}
}
return a1 + addtimeEnd;
}
}
return 0;
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.CaculateBooking \n" + ex.ToString());
}
}