private void btnDeleteBookingR_Click(object sender, EventArgs e)
{
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
BookingRooms_ServicesBO aBookingRooms_ServicesBO = new BookingRooms_ServicesBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRsBO aBookingRsBO = new BookingRsBO();
CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO();
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
BookingHsBO aBookingHsBO = new BookingHsBO();
BookingHalls_ServicesBO aBookingHalls_ServicesBO = new BookingHalls_ServicesBO();
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
MenusBO aMenusBO = new MenusBO();
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
try
{
MessageBox.Show("Chức năng này sẽ xóa tất cả các phòng và hóa đơn đặt phòng đã đặt!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (this.IDBookingH == 0)
{
DialogResult result = MessageBox.Show("Xóa tất cả các phòng đã đặt. Tiếp tục?", "Xóa phòng", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
foreach (BookingRoomUsedEN item in this.aNewPaymentEN.aListBookingRoomUsed)
{
aBookingRooms_ServicesBO.DeleteListServiceUsed(item.ID);
aBookingRoomsMembersBO.DeleteListBookingRoomsMembers(item.ID);
aBookingRoomsBO.Delete(item.ID);
}
aCustomerGroups_CustomersBO.DeleteAllCustomersFromCustomerGroup_ByIDBookingRs(this.IDBookingR);
aCustomerGroupsBO.Delete_ByID(Convert.ToInt32(this.aNewPaymentEN.IDCustomerGroup));
int ret = aBookingRsBO.Delete(this.IDBookingR);
if (ret > 0)
{
MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
DialogResult result = MessageBox.Show("Xóa tất cả các phòng và hội trường đã đặt. Tiếp tục?", "Xóa hóa đơn", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
foreach (BookingRoomUsedEN item in this.aNewPaymentEN.aListBookingRoomUsed)
{
aBookingRooms_ServicesBO.DeleteListServiceUsed(item.ID);
aBookingRoomsMembersBO.DeleteListBookingRoomsMembers(item.ID);
aBookingRoomsBO.Delete(item.ID);
}
aCustomerGroups_CustomersBO.DeleteAllCustomersFromCustomerGroup_ByIDBookingRs(this.IDBookingR);
aCustomerGroupsBO.Delete_ByID(Convert.ToInt32(this.aNewPaymentEN.IDCustomerGroup));
aBookingRsBO.Delete(this.IDBookingR);
foreach (BookingHallUsedEN item1 in this.aNewPaymentEN.aListBookingHallUsed)
{
aBookingHalls_ServicesBO.DeleteListServiceUsed(item1.ID);
aBookingHallsBO.Delete(item1.ID);
foreach (MenusEN aMenu in item1.aListMenuEN)
{
aMenusBO.Delete(aMenu.ID);
aMenus_FoodsBO.Delete_ByIDMenu(aMenu.ID);
}
}
int ret = aBookingHsBO.Delete(this.IDBookingH);
if (ret > 0)
{
MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
this.Close();
if (this.afrmMain != null)
{
this.afrmMain.ReloadData();
}
else if (this.afrmMain_Halls != null)
{
this.afrmMain_Halls.ReloadData();
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_UpdBookingHall.btnDeleteBookingRs\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDeleteCus_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (this.IsLockForm == false)
{
if (this.aNewPaymentEN.aListBookingRoomUsed.Where(a => a.ID == this.CurrentIDBookingRoom).ToList()[0].ListCustomer.Count == 1)
{
MessageBox.Show("Không thể xóa", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DialogResult result = MessageBox.Show("Xóa khách khỏi phòng. Tiếp tục?", "Xóa khách", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
int IDCustomer = Convert.ToInt32(viewCustomers.GetFocusedRowCellValue("ID"));
aBookingRoomsMembersBO.Delete(this.CurrentIDBookingRoom, IDCustomer);
MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Reload();
txtBookingRoomsCost.Text = aAccountancyBO.CalculateCostRoom(this.CurrentIDBookingRoom, cbbPriceType.Text, this.aNewPaymentEN.CustomerType.GetValueOrDefault(0), aNewPaymentEN.GetNumberCustomerInRoom(this.CurrentIDBookingRoom)).GetValueOrDefault(0).ToString();
CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO();
aCustomerGroups_CustomersBO.DeleteCustomerFromCustomerGroup_ByIDBookingRs(IDCustomer, this.IDBookingR);
}
}
}
else
{
MessageBox.Show("Không thực hiện được chức năng này do form đang chế độ khóa");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
BookingRoomsMembers aBookingRoomsMembers = new BookingRoomsMembers();
DateTime? dateTime = null;
CustomersBO aCustomersBO = new CustomersBO();
Customers aCustomers = new Customers();
//Update
if (this.IDCustomer > 0)
{
aCustomers = aCustomersBO.Select_ByID(IDCustomer);
}
else
{
aCustomers = new Customers();
}
aCustomers.Address = txtAddress.Text;
aCustomers.Birthday = String.IsNullOrEmpty(dtpBirthday.Text) ? dateTime : dtpBirthday.DateTime;
aCustomers.Citizen = Convert.ToInt32(lueCitizen.EditValue);
aCustomers.Email = txtEmail.Text;
aCustomers.Gender = lueGender.EditValue.ToString();
aCustomers.Identifier1 = txtIdentifier1.Text;
aCustomers.Identifier2 = txtIdentifier2.Text;
aCustomers.Identifier3 = txtIdentifier3.Text;
aCustomers.Name = txtNames.Text;
aCustomers.Nationality = lueNationality.EditValue.ToString();
aCustomers.Tel = txtTel.Text;
if (this.IDCustomer > 0)
{
aCustomersBO.Update(aCustomers);
}
else
{
this.IDCustomer = aCustomersBO.Insert(aCustomers);
}
/*Insert nguoi moi vao group*/
CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO();
aCustomerGroups_CustomersBO.InsertCustomerIntoCustomerGroup_ByIDBookingRs(this.IDCustomer, (new BookingRsBO()).Select_ByIDBookingRoom(this.IDBookingRoom).ID);
/*--------------------------*/
aBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom_ByIDCustomer(this.IDBookingRoom, this.IDCustomer);
if (aBookingRoomsMembers == null)
{
aBookingRoomsMembers = new BookingRoomsMembers();
aBookingRoomsMembers.IDBookingRoom = this.IDBookingRoom;
aBookingRoomsMembers.IDCustomer = this.IDCustomer;
}
aBookingRoomsMembers.DateEnterCountry = String.IsNullOrEmpty(dtpDateEnterCountry.Text) ? dateTime : dtpDateEnterCountry.DateTime;
aBookingRoomsMembers.EnterGate = txtEnterGate.Text;
aBookingRoomsMembers.LeaveDate = String.IsNullOrEmpty(dtpLeaveDate.Text) ? dateTime : dtpLeaveDate.DateTime;
aBookingRoomsMembers.LimitDateEnterCountry = String.IsNullOrEmpty(dtpLimitDateEnterCountry.Text) ? dateTime : dtpLimitDateEnterCountry.DateTime;
aBookingRoomsMembers.Organization = txtOrganization.Text;
aBookingRoomsMembers.PurposeComeVietnam = txtPurposeComeVietnam.Text;
aBookingRoomsMembers.TemporaryResidenceDate = String.IsNullOrEmpty(dtpTemporaryResidenceDate.Text) ? dateTime : dtpTemporaryResidenceDate.DateTime;
if (aBookingRoomsMembers.ID > 0)
{
aBookingRoomsMembersBO.Update(aBookingRoomsMembers);
}
else
{
aBookingRoomsMembersBO.Insert(aBookingRoomsMembers);
}
MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.afrmTsk_Payment_Step2.Reload();
// this.afrmTsk_Payment_Step2.ReloadMoneyRoom();
this.Close();
}
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);
}
}
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;
}
public int CountMemberInRoom(int IDBookingRoom)
{
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
return aBookingRoomsMembersBO.Select_ByIDBookingRoom(IDBookingRoom).Count();
}
//public frmUpd_Customers_2(frmIns_CustomerGroups_Customers afrmIns_CustomerGroups_Customers, int IDCustomer)
//{
// InitializeComponent();
// this.afrmIns_CustomerGroups_Customers = afrmIns_CustomerGroups_Customers;
// this.IDCustomer = IDCustomer;
//}
//public frmUpd_Customers_2(frmLst_Customers afrmLst_Customers, int aIDCustomer)
//{
// InitializeComponent();
// this.afrmLst_Customers = afrmLst_Customers;
// this.IDCustomer = aIDCustomer;
//}
//public frmUpd_Customers_2(frmTsk_EditBooking afrmTsk_EditBooking, int aIDCustomer)
//{
// InitializeComponent();
// this.afrmTsk_EditBooking = afrmTsk_EditBooking;
// this.IDCustomer = aIDCustomer;
//}
//public frmUpd_Customers_2(frmTsk_Payment_Step2 afrmTsk_Payment_Step2, int aIDCustomer)
//{
// InitializeComponent();
// this.afrmTsk_Payment_Step2 = afrmTsk_Payment_Step2;
// this.IDCustomer = aIDCustomer;
//}
private void frmUpdateCustomers_Load(object sender, EventArgs e)
{
try
{
dgvAvailableCustomers.DataSource = (new CustomersBO()).Select_All();
btnAdd.Enabled = false;
lueNationality.Properties.DataSource = CORE.CONSTANTS.ListCountries;//Load Country
lueNationality.Properties.DisplayMember = "Name";
lueNationality.Properties.ValueMember = "Code";
lueCitizen.Properties.DataSource = CORE.CONSTANTS.ListCitizens;//Load Citizen
lueCitizen.Properties.DisplayMember = "Name";
lueCitizen.Properties.ValueMember = "ID";
lueGender.Properties.DataSource = CORE.CONSTANTS.ListGenders;//Load Gioi tinh
lueGender.Properties.DisplayMember = "Name";
lueGender.Properties.ValueMember = "ID";
CustomersBO aCustomersBO = new CustomersBO();
// lấy IDCustomer này từ FormCustomers
if (this.IDCustomer > 0)
{
Customers aCustomer = aCustomersBO.Select_ByID(IDCustomer);
if (aCustomer != null)
{
txtNames.EditValue = aCustomer.Name;
txtIdentifier1.EditValue = aCustomer.Identifier1;
txtIdentifier2.EditValue = aCustomer.Identifier2;
txtIdentifier3.EditValue = aCustomer.Identifier3;
if (aCustomer.Birthday != null)
{
dtpBirthday.EditValue = aCustomer.Birthday;
}
if (aCustomer.Gender != null)
{
lueGender.EditValue = int.Parse(aCustomer.Gender.ToString());
}
else
{
lueGender.EditValue = CORE.CONSTANTS.SelectedGender(1).ID;
}
txtAddress.EditValue = aCustomer.Address;
if (String.IsNullOrEmpty(aCustomer.Nationality) == false)
{
lueNationality.EditValue = aCustomer.Nationality;
}
if (lueNationality.EditValue == null)
{
lueNationality.EditValue = CORE.CONSTANTS.SelectedCountry(704).Code;
}
if (aCustomer.Citizen > 0)
{
lueCitizen.EditValue = aCustomer.Citizen;
}
else
{
lueCitizen.EditValue = CORE.CONSTANTS.SelectedCitizen(2).ID;
}
//----------------------------------------------------------------
txtTel.EditValue = aCustomer.Tel;
txtEmail.EditValue = aCustomer.Email;
//----------------------------------------------------------------
CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO();
aCustomerGroups_CustomersBO.InsertCustomerIntoCustomerGroup_ByIDBookingRs(this.IDCustomer, (new BookingRsBO()).Select_ByIDBookingRoom(this.IDBookingRoom).ID);
/*--------------------------*/
BookingRoomsMembers aBookingRoomsMembers = new BookingRoomsMembers();
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
aBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom_ByIDCustomer(this.IDBookingRoom, this.IDCustomer);
if (aBookingRoomsMembers != null)
{
dtpDateEnterCountry.DateTime = aBookingRoomsMembers.DateEnterCountry.GetValueOrDefault() ;
txtEnterGate.Text = aBookingRoomsMembers.EnterGate;
dtpLeaveDate.DateTime = aBookingRoomsMembers.LeaveDate.GetValueOrDefault();
dtpLimitDateEnterCountry.DateTime = aBookingRoomsMembers.LimitDateEnterCountry.GetValueOrDefault();
txtOrganization.Text = aBookingRoomsMembers.Organization ;
txtPurposeComeVietnam.Text = aBookingRoomsMembers.PurposeComeVietnam ;
aBookingRoomsMembers.TemporaryResidenceDate = dtpTemporaryResidenceDate.DateTime ;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("frmUpdateCustomers.frmUpdateCustomers_Load\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool CheckIn(CheckInEN aCheckInEN)
{
try
{
//========================================================
BookingRs aBookingRs = new BookingRs();
aBookingRs.CreatedDate = DateTime.Now;
aBookingRs.CustomerType = aCheckInEN.CustomerType;
aBookingRs.BookingType = aCheckInEN.BookingType;
aBookingRs.Note = aCheckInEN.Note;
aBookingRs.IDCustomerGroup = aCheckInEN.IDCustomerGroup;
aBookingRs.IDCustomer = aCheckInEN.IDCustomer;
aBookingRs.IDSystemUser = aCheckInEN.IDSystemUser;
aBookingRs.PayMenthod = aCheckInEN.PayMenthod;
aBookingRs.StatusPay = aCheckInEN.StatusPay;
aBookingRs.BookingMoney = aCheckInEN.BookingMoney;
aBookingRs.ExchangeRate = aCheckInEN.ExchangeRate;
aBookingRs.Status = aCheckInEN.Status;
aBookingRs.Type = aCheckInEN.Type;
aBookingRs.Disable = aCheckInEN.Disable;
aBookingRs.Level = aCheckInEN.Level;
aBookingRs.Subject = aCheckInEN.Subject;
aBookingRs.Description = aCheckInEN.Description;
aBookingRs.DatePay = aCheckInEN.DatePay;
aBookingRs.DateEdit = aCheckInEN.DateEdit;
//add new bookingRs
BookingRsBO aBookingRsBO = new BookingRsBO();
aBookingRsBO.Insert(aBookingRs);
int IDBookingR = aBookingRs.ID;
//==========================================================
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms;
BookingRoomsMembers aBookingRoomsMembers;
for (int i = 0; i < aCheckInEN.aListRoomMembers.Count; i++)
{
aBookingRooms = new BookingRooms();
aBookingRooms.IDBookingR = IDBookingR;
aBookingRooms.CodeRoom = aCheckInEN.aListRoomMembers[i].RoomCode;
aBookingRooms.PercentTax = 10;
aBookingRooms.CostRef_Rooms = aCheckInEN.aListRoomMembers[i].RoomCostRef;
aBookingRooms.Cost = aCheckInEN.aListRoomMembers[i].RoomCostRef;
aBookingRooms.CheckInPlan = aCheckInEN.CheckInActual;
aBookingRooms.CheckInActual = aCheckInEN.CheckInActual;
aBookingRooms.CheckOutPlan = aCheckInEN.CheckOutPlan;
aBookingRooms.CheckOutActual = aCheckInEN.CheckOutActual;
aBookingRooms.StartTime = aCheckInEN.CheckInActual;
aBookingRooms.EndTime = aCheckInEN.CheckOutPlan;
aBookingRooms.BookingStatus = 1;
aBookingRooms.Type = 3; //Tính CheckIn sớm và CheckOut muộn
aBookingRooms.Status = aCheckInEN.Status;
aBookingRooms.PriceType = "G1";
//add new bookingRoom
aBookingRoomsBO.Insert(aBookingRooms);
int IDBookingRooms = aBookingRooms.ID;
aCheckInEN.aListRoomMembers[i].IDBookingRooms = IDBookingRooms;
//-----------------------------------------------------------
aBookingRoomsMembers = new BookingRoomsMembers();
aBookingRoomsMembers.IDBookingRoom = aCheckInEN.aListRoomMembers[i].IDBookingRooms;
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
for (int ii = 0; ii < aCheckInEN.aListRoomMembers[i].ListCustomer.Count; ii++)
{
aBookingRoomsMembers.IDCustomer = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].ID;
aBookingRoomsMembers.PurposeComeVietnam = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].PurposeComeVietnam;
aBookingRoomsMembers.DateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].DateEnterCountry;
aBookingRoomsMembers.EnterGate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].EnterGate;
aBookingRoomsMembers.TemporaryResidenceDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].TemporaryResidenceDate;
aBookingRoomsMembers.LimitDateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LimitDateEnterCountry;
aBookingRoomsMembers.Organization = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Organization;
aBookingRoomsMembers.LeaveDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LeaveDate;
//add new bookingRoomMember
aBookingRoomsMembersBO.Insert(aBookingRoomsMembers);
}
}
return true;
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.CheckInGoverment\n" + ex.ToString());
}
}
private void InitForm()
{
// Kiem tra xem phong dang o che do checkIn hay book phong
if (this.aBookingRoom.Status < 3)
{
dtpCheckIn.Text = aBookingRoom.CheckInPlan.ToString();
dtpCheckOut.Text = aBookingRoom.CheckOutPlan.ToString();
}
else if (this.aBookingRoom.Status == 3) // Phong da checkIn
{
dtpCheckIn.Text = DateTime.Now.ToString();
dtpCheckOut.Text = aBookingRoom.CheckOutPlan.ToString();
}
if (aBookingRs.CustomerType == 1)
{
lblCustomerType.Text = "Khách nhà nước";
}
else if (aBookingRs.CustomerType == 2)
{
lblCustomerType.Text = "Cty ngoài";
}
else if (aBookingRs.CustomerType == 3)
{
lblCustomerType.Text = "Khách lẻ";
}
else if (aBookingRs.CustomerType == 4)
{
lblCustomerType.Text = "Khách vãng lai";
}
CustomersBO aCustomersBO = new CustomersBO();
CustomerInfoEN aCustomers = new CustomerInfoEN();
aCustomers = new CustomerInfoEN (aCustomersBO.Select_ByID(aBookingRs.IDCustomer));
lblCustomer.Text = aCustomers.Name;
lblTel.Text = aCustomers.Tel;
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup);
lblGroup.Text = aCustomerGroups.Name;
CompaniesBO aCompaniesBO = new CompaniesBO();
lblCompany.Text = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany).Name;
// Fill All Customer
dgvAvailableCustomers.DataSource = ConvertListCustomer ((new CustomersBO()).Select_All());
lueRooms.Properties.DataSource = this.GetAvaiableRoom();
lueRooms.Properties.ValueMember = "Code";
lueRooms.Properties.DisplayMember = "Sku";
RoomsBO aRoomsBO = new RoomsBO();
Rooms aRooms = new Rooms();
aRooms = aRoomsBO.Select_ByCodeRoom(this.aBookingRoom.CodeRoom, 1);
lueRooms.Properties.NullText = aRooms.Sku;
lueRooms.SelectedText = aRooms.Sku;
lueRooms.EditValue = aRooms.Code;
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
List<BookingRoomsMembers> aListBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom (this.aBookingRoom.ID);
dgvSelectCustomers.DataSource = GetCustomers(aListBookingRoomsMembers);
//this.aChangeRoomEn.InsertItemChangeRooms()
}
private void ResetFormWhenTimeChange()
{
if (aBookingRs.CustomerType == 1)
{
lblCustomerType.Text = "Khách nhà nước";
}
else if (aBookingRs.CustomerType == 2)
{
lblCustomerType.Text = "Cty ngoài";
}
else if (aBookingRs.CustomerType == 3)
{
lblCustomerType.Text = "Khách lẻ";
}
else if (aBookingRs.CustomerType == 4)
{
lblCustomerType.Text = "Khách vãng lai";
}
CustomersBO aCustomersBO = new CustomersBO();
CustomerInfoEN aCustomers = new CustomerInfoEN();
aCustomers = new CustomerInfoEN (aCustomersBO.Select_ByID(aBookingRs.IDCustomer));
lblCustomer.Text = aCustomers.Name;
lblTel.Text = aCustomers.Tel;
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup);
lblGroup.Text = aCustomerGroups.Name;
CompaniesBO aCompaniesBO = new CompaniesBO();
lblCompany.Text = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany).Name;
// Fill All Customer
dgvAvailableCustomers.DataSource = ConvertListCustomer ((new CustomersBO()).Select_All());
lueRooms.Properties.DataSource = this.GetAvaiableRoom();
lueRooms.Properties.ValueMember = "Code";
lueRooms.Properties.DisplayMember = "Sku";
RoomsBO aRoomsBO = new RoomsBO();
Rooms aRooms = new Rooms();
aRooms = aRoomsBO.Select_ByCodeRoom(this.aBookingRoom.CodeRoom, 1);
lueRooms.Properties.NullText = aRooms.Sku;
lueRooms.SelectedText = aRooms.Sku;
lueRooms.EditValue = aRooms.Code;
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
List<BookingRoomsMembers> aListBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom (this.aBookingRoom.ID);
dgvSelectCustomers.DataSource = GetCustomers(aListBookingRoomsMembers);
}
private void InitData()
{
ItemChangeRoomEN aItemChangeRoomEN = new ItemChangeRoomEN();
aItemChangeRoomEN.SetBookingRooms(this.aBookingRoom);
if (aItemChangeRoomEN.GetStatusBookingRooms() < 3)
{
// Phong trang thai dat
}
else if (aItemChangeRoomEN.GetStatusBookingRooms() == 3) // Phong dang co nguoi o
{
// Thay doi thoi gian de check in
//aItemChangeRoomEN.SetCheckInActual(dtpCheckIn.DateTime);
}
aItemChangeRoomEN.IsRootRoom = true;
List<CustomerInfoEN> aListCustomer = (List<CustomerInfoEN>)this.dgvSelectCustomers.DataSource;
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
BookingRoomsMembers aBookingRoomsMembers = new BookingRoomsMembers();
for (int i = 0; i < aListCustomer.Count; i++)
{
aBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom_ByIDCustomer(this.aBookingRoom.ID, aListCustomer[i].ID);
aListCustomer[i].LeaveDate = aBookingRoomsMembers.LeaveDate;
aListCustomer[i].LimitDateEnterCountry = aBookingRoomsMembers.LimitDateEnterCountry;
aListCustomer[i].PurposeComeVietnam = aBookingRoomsMembers.PurposeComeVietnam;
aListCustomer[i].TemporaryResidenceDate = aBookingRoomsMembers.TemporaryResidenceDate;
aListCustomer[i].DateEnterCountry = aBookingRoomsMembers.DateEnterCountry;
aListCustomer[i].EnterGate = aBookingRoomsMembers.EnterGate;
}
aItemChangeRoomEN.AddCustomer(aListCustomer);
AccountancyBO aAccountancyBO = new AccountancyBO();
//aItemChangeRoomEN.SetCost(aAccountancyBO.CalculateCostRoom(lueRooms.EditValue.ToString(), this.aBookingRoom.PriceType, aBookingRs.CustomerType.GetValueOrDefault(0), aItemChangeRoomEN.GetAllCustomers().Count).GetValueOrDefault(0));
this.aCurrentRoomInfo.SetAddTimeStart(null);
this.aCurrentRoomInfo.SetAddTimeEnd(null);
this.aCurrentRoomInfo.SetTimeInUsed(null);
this.aCurrentRoomInfo.SetCheckInActual(dtpCheckIn.DateTime);
this.aCurrentRoomInfo.SetCheckInPlan(dtpCheckIn.DateTime);
this.aCurrentRoomInfo.SetCheckOutActual(dtpCheckOut.DateTime);
this.aCurrentRoomInfo.SetCheckOutPlan(dtpCheckOut.DateTime);
this.aChangeRoomEn.InsertItemChangeRooms(aItemChangeRoomEN);
this.aCurrentRoomInfo = aItemChangeRoomEN;
}
//NgocBM 24/12/2014
public bool CheckInNewRoom(ItemChangeRoomEN aItem)
{
try
{
BookingRooms aBookingRooms = new BookingRooms();
aBookingRooms = aItem.GetBookingRooms();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
int IDBookingRoom = aBookingRoomsBO.Insert(aBookingRooms);
//-----------------------------------------------------------
// Cao nhatj danh sach nguoi trong phong
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
List<CustomerInfoEN> aList = new List<CustomerInfoEN>();
aList = aItem.GetAllCustomers();
for (int i = 0; i < aList.Count; i++)
{
BookingRoomsMembers aBookingRoomsMembers = new BookingRoomsMembers();
aBookingRoomsMembers.DateEnterCountry = aList[i].DateEnterCountry;
aBookingRoomsMembers.EnterGate = aList[i].EnterGate;
aBookingRoomsMembers.LeaveDate = aList[i].LeaveDate;
aBookingRoomsMembers.LimitDateEnterCountry = aList[i].LimitDateEnterCountry;
aBookingRoomsMembers.Organization = aList[i].Organization;
aBookingRoomsMembers.PurposeComeVietnam = aList[i].PurposeComeVietnam;
aBookingRoomsMembers.TemporaryResidenceDate = aList[i].TemporaryResidenceDate;
aBookingRoomsMembers.IDBookingRoom = IDBookingRoom;
aBookingRoomsMembers.IDCustomer = aList[i].ID;
aBookingRoomsMembersBO.Insert(aBookingRoomsMembers);
}
return true;
}
catch (Exception ee)
{
return false;
}
}
//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 btnDeleteRoom_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (this.IsLockForm == false)
{
if (this.aNewPaymentEN.aListBookingRoomUsed.Count == 1)
{
MessageBox.Show("Không thể xóa", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DialogResult result = MessageBox.Show("Xóa phòng. Tiếp tục?", "Xóa phòng", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
BookingRooms_ServicesBO aBookingRooms_ServicesBO = new BookingRooms_ServicesBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
int IDDeletedBookingRoom = Convert.ToInt32(viewRooms.GetFocusedRowCellValue("ID"));
aBookingRooms_ServicesBO.DeleteListServiceUsed(IDDeletedBookingRoom);
aBookingRoomsMembersBO.DeleteListBookingRoomsMembers(IDDeletedBookingRoom);
aBookingRoomsBO.Delete(IDDeletedBookingRoom);
MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Reload();
}
}
}
else
{
MessageBox.Show("Không thực hiện được chức năng này do form đang chế độ khóa");
}
}
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());
}
}
//SelectListCustomer_ByCustomerName
//public List<Customers> SelectListCustomer_ByCustomerName(string NameCustomer)
//{
// List<vw__SearchCustomer__Companies_CustomerGroups_Customers> aListTemp = new List<vw__SearchCustomer__Companies_CustomerGroups_Customers>();
// aListTemp = aDatabaseDA.vw__SearchCustomer__Companies_CustomerGroups_Customers.Where(c => c.Customers_Name.Contains(NameCustomer)).Distinct().ToList();
// List<Customers> aListReturn = new List<Customers>();
// Customers aCustomers;
// foreach (var items in aListTemp)
// {
// aCustomers = new Customers();
// aCustomers.ID = items.Customers_ID;
// aCustomers.Name = items.Customers_Name;
// aCustomers.Identifier1 = items.Customers_Identifier1;
// aCustomers.Identifier2 = items.Customers_Identifier2;
// aCustomers.Identifier3 = items.Customers_Identifier3;
// aCustomers.Nationality = items.Customers_Nationality;
// aCustomers.Birthday = items.Customers_Birthday;
// aCustomers.Tel = items.Customers_Tel;
// aCustomers.Address = items.Customers_Address;
// aCustomers.Email = items.Customers_Email;
// aCustomers.Status = items.Customers_Status;
// aCustomers.Type = items.Customers_Type;
// aCustomers.Disable = items.Customers_Disable;
// aCustomers.Gender = items.Customers_Gender;
// aCustomers.Citizen = items.Customers_Citizen;
// aListReturn.Insert(0, aCustomers);
// }
// return aListReturn;
//}
//SelectListCustomer_ByCustomerName_ByIDCustomerGroups
//public List<Customers> SelectListCustomer_ByCustomerName_ByIDCustomerGroups(string NameCustomer,int IDCustomerGroup)
//{
// List<vw__SearchCustomer__Companies_CustomerGroups_Customers> aListTemp = new List<vw__SearchCustomer__Companies_CustomerGroups_Customers>();
// aListTemp = aDatabaseDA.vw__SearchCustomer__Companies_CustomerGroups_Customers.Where(c=>c.Customers_Name.Contains(NameCustomer)).Where(c => c.CustomerGroups_ID == IDCustomerGroup).Distinct().ToList();
// List<Customers> aListReturn = new List<Customers>();
// Customers aCustomers;
// foreach (var items in aListTemp)
// {
// aCustomers = new Customers();
// aCustomers.ID = items.Customers_ID;
// aCustomers.Name = items.Customers_Name;
// aCustomers.Identifier1 = items.Customers_Identifier1;
// aCustomers.Identifier2 = items.Customers_Identifier2;
// aCustomers.Identifier3 = items.Customers_Identifier3;
// aCustomers.Nationality = items.Customers_Nationality;
// aCustomers.Birthday = items.Customers_Birthday;
// aCustomers.Tel = items.Customers_Tel;
// aCustomers.Address = items.Customers_Address;
// aCustomers.Email = items.Customers_Email;
// aCustomers.Status = items.Customers_Status;
// aCustomers.Type = items.Customers_Type;
// aCustomers.Disable = items.Customers_Disable;
// aCustomers.Gender = items.Customers_Gender;
// aCustomers.Citizen = items.Customers_Citizen;
// aListReturn.Insert(0, aCustomers);
// }
// return aListReturn;
//}
public List<Customers> SelectListCustomer_ByListIDBookingRoom(List<int> ListIDBookingRoom)
{
try
{
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
List<int> aListIDCustomer = aBookingRoomsMembersBO.Select_ByListIDBookingRoom(ListIDBookingRoom).Select(b => b.IDCustomer).Distinct().ToList();
return this.SelectListCustomer_ByListIDCustomer(aListIDCustomer);
}
catch (Exception ex)
{
throw new Exception("CustomersBO.SelectListCustomer_ByListIDBookingRoom\n" + ex.ToString());
}
}
//Hiennv 26/11/2014 Viet lai phuong thuc checkInForRoomBooking
public bool NewCheckInForRoomBooking(CheckInEN aCheckInEN)
{
try
{
CustomersBO aCustomersBO = new CustomersBO();
List<Customers> aListCustomersTemp = aCustomersBO.Select_All();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
List<BookingRooms> aListBookingRoomTemp = aBookingRoomsBO.Select_All();
int IDBookingRooms = 0;
int IDCompany = 0;
int IDCustomerGroup = 0;
int IDCustomer = 0;
int Result = 0;
string customerType = string.Empty;
if (aCheckInEN.CustomerType == 0)
{
customerType = "Tất cả loại khác";
}
else if (aCheckInEN.CustomerType == 1)
{
customerType = "Khách nhà nước";
}
else if (aCheckInEN.CustomerType == 2)
{
customerType = "Khách đoàn";
}
else if (aCheckInEN.CustomerType == 3)
{
customerType = "Khách lẻ";
}
else if (aCheckInEN.CustomerType == 4)
{
customerType = "Khách vãng lai";
}
else if (aCheckInEN.CustomerType == 5)
{
customerType = "Khách bộ ngoại giao";
}
else
{
customerType = string.Empty;
}
#region Them moi cong ty khi cong ty chua co
if (aCheckInEN.IDCompany > 0)
{
IDCompany = aCheckInEN.IDCompany;
}
else
{
CompaniesBO aCompaniesBO = new CompaniesBO();
Companies aCompanies = new Companies();
if (aCheckInEN.NameCompany.Length > 250)
{
aCompanies.Name = aCheckInEN.NameCompany.Substring(0, 250);
}
else
{
aCompanies.Name = aCheckInEN.NameCompany;
}
aCompanies.TaxNumberCode = string.Empty;
aCompanies.Address = string.Empty;
aCompanies.Type = aCheckInEN.CustomerType;
aCompanies.Status = 1;
aCompanies.Disable = false;
IDCompany = aCompaniesBO.Insert(aCompanies);
}
#endregion
#region Them moi nhom vao trong cong ty
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CustomerGroups aCustomerGroups;
aCustomerGroups = aCustomerGroupsBO.Select_ByIDCompanyAndIDCustomerGroup(IDCompany, aCheckInEN.IDCustomerGroup);
if (aCustomerGroups == null)
{
aCustomerGroups = new CustomerGroups();
string nameGroup = "[" + customerType + "][" + aCheckInEN.NameCompany + "][" + DateTime.Now.ToString() + "]";
aCustomerGroups.IDCompany = IDCompany;
if (nameGroup.Length > 250)
{
aCustomerGroups.Name = nameGroup.Substring(0, 250);
}
else
{
aCustomerGroups.Name = nameGroup;
}
aCustomerGroups.Type = 1;
aCustomerGroups.Status = 1;
aCustomerGroups.Disable = false;
IDCustomerGroup = aCustomerGroupsBO.Insert(aCustomerGroups);
}
else
{
IDCustomerGroup = aCheckInEN.IDCustomerGroup;
}
#endregion
string subject = "[" + customerType + "][" + aCheckInEN.NameCompany + "][" + DateTime.Now.ToString() + "]";
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(aCheckInEN.IDBookingR);
if (aBookingRs != null)
{
aBookingRs.CreatedDate = DateTime.Now;
aBookingRs.CustomerType = aCheckInEN.CustomerType;
aBookingRs.BookingType = aCheckInEN.BookingType;
if (subject.Length > 250)
{
aBookingRs.Subject = subject.Substring(0, 250);
}
else
{
aBookingRs.Subject = subject;
}
aBookingRs.IDCustomerGroup = IDCustomerGroup;
aBookingRs.IDCustomer = aCheckInEN.IDCustomer;
aBookingRs.IDSystemUser = aCheckInEN.IDSystemUser;
aBookingRs.PayMenthod = aCheckInEN.PayMenthod;
aBookingRs.StatusPay = aCheckInEN.StatusPay;
aBookingRs.BookingMoney = aCheckInEN.BookingMoney;
aBookingRs.ExchangeRate = aCheckInEN.ExchangeRate;
aBookingRs.Level = 0;// de mac dinh hien tai chua dung den
aBookingRs.Note = string.Empty;
aBookingRs.Description = string.Empty;
aBookingRs.DatePay = aCheckInEN.CheckOutPlan;
aBookingRs.DateEdit = aCheckInEN.CheckInActual;
aBookingRs.Status = aCheckInEN.Status;
aBookingRs.Type = aCheckInEN.Type;
aBookingRs.Disable = aCheckInEN.Disable;
aBookingRsBO.Update(aBookingRs);
}
//==========================================================
BookingRooms aBookingRooms;
BookingRoomsMembers aBookingRoomsMembers;
for (int i = 0; i < aCheckInEN.aListRoomMembers.Count; i++)
{
List<BookingRooms> aListBookingRoom = aListBookingRoomTemp.Where(r => r.ID == aCheckInEN.aListRoomMembers[i].IDBookingRooms).ToList();
if (aListBookingRoom.Count > 0)
{
aBookingRooms = new BookingRooms();
aBookingRooms = aListBookingRoom[0];
aBookingRooms.IDBookingR = aCheckInEN.IDBookingR;
aBookingRooms.CodeRoom = aCheckInEN.aListRoomMembers[i].RoomCode;
aBookingRooms.PercentTax = 10;
aBookingRooms.CostRef_Rooms = aCheckInEN.aListRoomMembers[i].RoomCostRef;
aBookingRooms.Cost = aCheckInEN.aListRoomMembers[i].RoomCostRef;
aBookingRooms.CheckInPlan = aCheckInEN.CheckInActual;
aBookingRooms.CheckInActual = aCheckInEN.CheckInActual;
aBookingRooms.CheckOutPlan = aCheckInEN.CheckOutPlan;
aBookingRooms.CheckOutActual = aCheckInEN.CheckOutActual;
aBookingRooms.StartTime = aCheckInEN.CheckInActual;
aBookingRooms.EndTime = aCheckInEN.CheckOutPlan;
aBookingRooms.BookingStatus = 1;
aBookingRooms.Type = 3; //Tính CheckIn sớm và CheckOut muộn
aBookingRooms.Status = aCheckInEN.Status;
aBookingRooms.PriceType = "G1";
aBookingRoomsBO.Update(aBookingRooms);
IDBookingRooms = aCheckInEN.aListRoomMembers[i].IDBookingRooms;
}
else
{
aBookingRooms = new BookingRooms();
aBookingRooms.IDBookingR = aCheckInEN.IDBookingR;
aBookingRooms.CodeRoom = aCheckInEN.aListRoomMembers[i].RoomCode;
aBookingRooms.PercentTax = 10;
aBookingRooms.CostRef_Rooms = aCheckInEN.aListRoomMembers[i].RoomCostRef;
aBookingRooms.Cost = aCheckInEN.aListRoomMembers[i].RoomCostRef;
aBookingRooms.CheckInPlan = aCheckInEN.CheckInActual;
aBookingRooms.CheckInActual = aCheckInEN.CheckInActual;
aBookingRooms.CheckOutPlan = aCheckInEN.CheckOutPlan;
aBookingRooms.CheckOutActual = aCheckInEN.CheckOutActual;
aBookingRooms.StartTime = aCheckInEN.CheckInActual;
aBookingRooms.EndTime = aCheckInEN.CheckOutPlan;
aBookingRooms.BookingStatus = 1;
aBookingRooms.Type = 3; //Tính CheckIn sớm và CheckOut muộn
aBookingRooms.Status = aCheckInEN.Status;
aBookingRooms.PriceType = "G1";
//add new bookingRoom
IDBookingRooms = aBookingRoomsBO.Insert(aBookingRooms);
}
//-----------------------------------------------------------
aBookingRoomsMembers = new BookingRoomsMembers();
aBookingRoomsMembers.IDBookingRoom = IDBookingRooms;
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
for (int ii = 0; ii < aCheckInEN.aListRoomMembers[i].ListCustomer.Count; ii++)
{
Customers aCustomers;
List<Customers> aListCustomers = aListCustomersTemp.Where(c => c.ID == aCheckInEN.aListRoomMembers[i].ListCustomer[ii].ID).ToList();
if (aListCustomers.Count > 0)
{
IDCustomer = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].ID;
aCustomers = aListCustomers[0];
aCustomers.Name = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Name;
aCustomers.Identifier1 = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Identifier1;
aCustomers.Birthday = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Birthday;
aCustomers.Gender = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Gender;
aCustomers.Tel = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Tel;
aCustomers.Nationality = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Nationality;
aCustomersBO.Update(aCustomers);
}
else
{
aCustomers = new Customers();
aCustomers.Name = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Name;
aCustomers.Identifier1 = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Identifier1;
aCustomers.Birthday = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Birthday;
aCustomers.Gender = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Gender;
aCustomers.Tel = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Tel;
aCustomers.Nationality = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Nationality;
//Them moi khach hang
IDCustomer = aCustomersBO.Insert(aCustomers);
}
aBookingRoomsMembers.IDCustomer = IDCustomer;
aBookingRoomsMembers.PurposeComeVietnam = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].PurposeComeVietnam;
aBookingRoomsMembers.DateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].DateEnterCountry;
aBookingRoomsMembers.EnterGate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].EnterGate;
aBookingRoomsMembers.TemporaryResidenceDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].TemporaryResidenceDate;
aBookingRoomsMembers.LimitDateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LimitDateEnterCountry;
aBookingRoomsMembers.Organization = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Organization;
aBookingRoomsMembers.LeaveDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LeaveDate;
//add new bookingRoomMember
aBookingRoomsMembersBO.Insert(aBookingRoomsMembers);
#region them nguoi vao trong customergroup_customer
string nameCustomerGroup_customer = "[" + customerType + "][" + aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Name + "]";
CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO();
CustomerGroups_Customers aCustomerGroups_Customers = new CustomerGroups_Customers();
if (nameCustomerGroup_customer.Length > 150)
{
aCustomerGroups_Customers.Name = nameCustomerGroup_customer.Substring(0, 150);
}
else
{
aCustomerGroups_Customers.Name = nameCustomerGroup_customer;
}
aCustomerGroups_Customers.Type = 1;
aCustomerGroups_Customers.Status = 1;
aCustomerGroups_Customers.Disable = false;
aCustomerGroups_Customers.FromDate = DateTime.Now;
aCustomerGroups_Customers.ToDate = DateTime.Now;
aCustomerGroups_Customers.IDCustomer = IDCustomer;
aCustomerGroups_Customers.IDCustomerGroup = IDCustomerGroup;
aCustomerGroups_CustomersBO.Insert(aCustomerGroups_Customers);
#endregion
// dung de cap nhap lai nguoi dai dien khi dat phong
if (aCheckInEN.aListRoomMembers[i].ListCustomer[ii].PepoleRepresentative == true)
{
aBookingRsBO = new BookingRsBO();
aBookingRs = new BookingRs();
aBookingRs = aBookingRsBO.Select_ByID(aCheckInEN.IDBookingR);
if (aBookingRs != null)
{
aBookingRs.IDCustomer = IDCustomer;
Result = aBookingRsBO.Update(aBookingRs);
}
}
else
{
if (ii == (aCheckInEN.aListRoomMembers[i].ListCustomer.Count - 1))
{
if (Result == 0)
{
aBookingRsBO = new BookingRsBO();
aBookingRs = new BookingRs();
aBookingRs = aBookingRsBO.Select_ByID(aCheckInEN.IDBookingR);
if (aBookingRs != null)
{
aBookingRs.IDCustomer = IDCustomer;
aBookingRsBO.Update(aBookingRs);
}
}
}
}
}
}
return true;
}
catch (Exception ex)
{
return false;
}
}