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);
}
}
//Load IDCompanies
public void LoadIDCompanies()
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
lueIDCompanies.Properties.DataSource = aCompaniesBO.Select_ByType(2);// [Company] Type = 2 : Công ty ngoài, 2;
lueIDCompanies.Properties.DisplayMember = "Name";
lueIDCompanies.Properties.ValueMember = "ID";
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_CheckIn_Group_Step2.LoadIDCompanies\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Load IDCompany
public void LoadIDCompanies()
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
List<Companies> aListCompanies = aCompaniesBO.Select_ByType(1);// [Company] Type = 1 : Nha nuoc, 1;
lueIDCompanies.Properties.DataSource = aListCompanies;
lueIDCompanies.Properties.DisplayMember = "Name";
lueIDCompanies.Properties.ValueMember = "ID";
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_CheckIn_Goverment_Step2.LoadIDCompanies\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
}
//hiennv
public void LoadCompany()
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
List<Companies> aListCompanies = aCompaniesBO.Select_ByType(3);// [Company] Type = 3;
lueIDCompany.Properties.DataSource = aListCompanies;
lueIDCompany.Properties.DisplayMember = "Name";
lueIDCompany.Properties.ValueMember = "ID";
if (aListCompanies.Count > 0)
{
lueIDCompany.EditValue = this.aCheckInRoomBookingEN.IDCompany;
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_CheckInCustomer_ForRoomBooking_Step2.LoadCompany\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadCompany()
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
List<Companies> aListCompanies = aCompaniesBO.Select_ByType(3);// [Company] Type = 3;
lueIDCompany.Properties.DataSource = aListCompanies;
lueIDCompany.Properties.DisplayMember = "Name";
lueIDCompany.Properties.ValueMember = "ID";
if(aListCompanies.Count > 0)
{
lueIDCompany.EditValue = aListCompanies[0].ID;
}
}
catch (Exception ex)
{
MessageBox.Show("frmAddNewBookingRs_Goverment.LoadCompany\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ReloadData()
{
try
{
dgvAvailableCompanies.DataSource = null;
List<Companies> aListCompanies = new List<Companies>();
CompaniesBO aCompaniesBO = new CompaniesBO();
if (afrmIns_CustomerGroups_Customers_Old != null)
{
aListCompanies = aCompaniesBO.Select_All();
btnAdd.Visible = false;
}
else if(this.afrmTsk_BookingHall_Goverment != null)
{
aListCompanies = aCompaniesBO.Select_ByType(Type);
btnAdd.Visible = false;
}
else if (this.afrmTsk_BookingHall_Group != null)
{
aListCompanies = aCompaniesBO.Select_ByType(Type);
btnAdd.Visible = false;
}
else if (this.afrmTsk_UpdBooking != null)
{
aListCompanies = aCompaniesBO.Select_ByType(Type);
btnAdd.Visible = false;
}
else
{
aListCompanies = aCompaniesBO.Select_All();
btnAdd.Visible = true;
}
dgvAvailableCompanies.DataSource = aListCompanies;
}
catch (Exception ex)
{
MessageBox.Show("frmLst_Companies.ReloadData\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmIns_CustomerGroups_Load(object sender, EventArgs e)
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
List<Companies> aListCompanies = aCompaniesBO.Select_All();
Companies aItem = new Companies();
aItem.Name ="[Tất cả]";
aItem.ID = 0;
aListCompanies.Add(aItem);
lueFilterCompany.Properties.DataSource = aListCompanies;
lueFilterCompany.Properties.DisplayMember = "Name";
lueFilterCompany.Properties.ValueMember = "ID";
this.IsReadyInit = true;
}
catch (Exception ex)
{
MessageBox.Show("frmIns_CustomerGroups.frmIns_CustomerGroups_Load\n" + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmUpd_CustomerGroups_Load(object sender, EventArgs e)
{
try
{
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(IDCustomerGroups_Old);
CompaniesBO aCompaniesBO = new CompaniesBO();
lueCompany.Properties.DataSource = aCompaniesBO.Select_All();
lueCompany.Properties.DisplayMember = "Name";
lueCompany.Properties.ValueMember = "ID";
lueCompany.EditValue = aCustomerGroups.IDCompany;
lblIDCustomerGroup.Text = aCustomerGroups.ID.ToString();
txtName.Text = aCustomerGroups.Name.ToString();
cboType.Text = aCustomerGroups.Type.ToString();
cboStatus.Text = aCustomerGroups.Status.ToString();
cboDisable.Text = aCustomerGroups.Disable.ToString();
}
catch (Exception ex)
{
MessageBox.Show("frmEditCustomerGroup.frmEditCustomerGroup_Load\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadIDCompanies()
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
lueCompany.Properties.DataSource = aCompaniesBO.Select_All();
lueCompany.Properties.DisplayMember = "Name";
lueCompany.Properties.ValueMember = "ID";
}
catch (Exception ex)
{
MessageBox.Show("frmIns_CustomerGroups_Customers.LoadIDCompanies\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Hiennv
public List<BookingRStatusPayViewEN> GetListUnPayBookingR_ByIDBookingR(int IDBookingR)
{
List<vw__PaymentInfo__BookingRs_BookingRooms_Customers> aListTemp = new List<vw__PaymentInfo__BookingRs_BookingRooms_Customers>();
int?[] BookingRoomStatus = new int?[] { 3, 5, 7 };
aListTemp = aDatabaseDA.vw__PaymentInfo__BookingRs_BookingRooms_Customers.Where(c => c.BookingRs_ID == IDBookingR).Where(e => BookingRoomStatus.Contains(e.BookingRooms_Status)).ToList();
List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>();
BookingRStatusPayViewEN aBookingRStatusPayViewEN;
CompaniesBO aCompaniesBO = new CompaniesBO();
for (int i = 0; i < aListTemp.Count; i++)
{
aBookingRStatusPayViewEN = new BookingRStatusPayViewEN();
aBookingRStatusPayViewEN.IDBookingR = aListTemp[i].BookingRs_ID;
aBookingRStatusPayViewEN.CreatedDate = aListTemp[i].BookingRs_CreatedDate;
aBookingRStatusPayViewEN.Customer_Name = aListTemp[i].Customers_Name;
aBookingRStatusPayViewEN.Subject = aListTemp[i].BookingRs_Subject;
aBookingRStatusPayViewEN.IDCustomer = aListTemp[i].Customers_ID;
aBookingRStatusPayViewEN.IDCustomerGroup = aListTemp[i].CustomerGroups_ID;
aBookingRStatusPayViewEN.BookingRs_Status = aListTemp[i].BookingRs_Status;
int IDCompany = !String.IsNullOrEmpty(aListTemp[i].CustomerGroups_IDCompany.ToString()) ? Convert.ToInt32(aListTemp[i].CustomerGroups_IDCompany) : 0;
Companies aCompanies = aCompaniesBO.Select_ByID(IDCompany);
aBookingRStatusPayViewEN.NameCompany = aCompanies.Name;
aBookingRStatusPayViewEN.CustomerGroups_Name = aListTemp[i].CustomerGroups_Name;
aBookingRStatusPayViewEN.StatusPay = aListTemp[i].BookingRs_StatusPay;
aBookingRStatusPayViewEN.BookingMoney = aListTemp[i].BookingRs_BookingMonye;
aBookingRStatusPayViewEN.IDBookingRoom = aListTemp[i].BookingRooms_ID;
aBookingRStatusPayViewEN.Sku = aListTemp[i].Rooms_Sku;
aBookingRStatusPayViewEN.BookingStatus = aListTemp[i].BookingRooms_Status;
aBookingRStatusPayViewEN.BookingRooms_CodeRoom = aListTemp[i].BookingRooms_CodeRoom;
switch (aBookingRStatusPayViewEN.StatusPay)
{
case 1:
aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa thanh toán";
break;
case 2:
aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Tạm ứng";
break;
case 3:
aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Đã thanh toán";
break;
default:
aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa xác định";
break;
}
switch (aBookingRStatusPayViewEN.BookingStatus)
{
case 3:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check in";
break;
case 5:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Pending";
break;
case 7:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check out nhưng chưa thanh toán";
break;
case 8:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã thanh toán";
break;
default:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Chưa xác định";
break;
}
aListReturn.Add(aBookingRStatusPayViewEN);
}
return aListReturn;
}
private void btnDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
CompaniesBO aCompaniesBO = new CompaniesBO();
int ID = int.Parse(viewAvailableCompanies.GetFocusedRowCellValue("ID").ToString());
string Name = aCompaniesBO.Select_ByID(ID).Name;
DialogResult result = MessageBox.Show("Bạn có muốn xóa công ty " + Name + " này không?", "Xóa công ty", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
aCompaniesBO.Delete(ID);
MessageBox.Show("Xóa thành công");
this.ReloadData();
}
}
//Hiennv 25/11/2014 Viet lai phuong thuc BookingRoom
public bool NewBookingRoom(NewBookingEN aNewBookingEN)
{
try
{
int IDBookingR = 0;
int IDCompany = 0;
int IDCustomerGroup = 0;
int IDCustomer = 0;
string customerType = string.Empty;
if (aNewBookingEN.CustomerType == 0)
{
customerType = "Tất cả loại khác";
}
else if (aNewBookingEN.CustomerType == 1)
{
customerType = "Khách nhà nước";
}
else if (aNewBookingEN.CustomerType == 2)
{
customerType = "Khách đoàn";
}
else if (aNewBookingEN.CustomerType == 3)
{
customerType = "Khách lẻ";
}
else if (aNewBookingEN.CustomerType == 4)
{
customerType = "Khách vãng lai";
}
else if (aNewBookingEN.CustomerType == 5)
{
customerType = "Khách bộ ngoại giao";
}
else
{
customerType = string.Empty;
}
#region Them moi khach hang khi khach hang chua co
if (aNewBookingEN.IDCustomer > 0)
{
IDCustomer = aNewBookingEN.IDCustomer;
}
else
{
CustomersBO aCustomersBO = new CustomersBO();
Customers aCustomers = new Customers();
if (aNewBookingEN.NameCustomer.Length > 50)
{
aCustomers.Name = aNewBookingEN.NameCustomer.Substring(0, 50);
}
else
{
aCustomers.Name = aNewBookingEN.NameCustomer;
}
IDCustomer = aCustomersBO.Insert(aCustomers);
}
#endregion
#region Them moi cong ty khi cong ty chua co
if (aNewBookingEN.IDCompany > 0)
{
IDCompany = aNewBookingEN.IDCompany;
}
else
{
CompaniesBO aCompaniesBO = new CompaniesBO();
Companies aCompanies = new Companies();
if (aNewBookingEN.NameCompany.Length > 250)
{
aCompanies.Name = aNewBookingEN.NameCompany.Substring(0, 250);
}
else
{
aCompanies.Name = aNewBookingEN.NameCompany;
}
aCompanies.TaxNumberCode = string.Empty;
aCompanies.Address = string.Empty;
aCompanies.Type = aNewBookingEN.CustomerType;
aCompanies.Status = 1;
aCompanies.Disable = false;
IDCompany = aCompaniesBO.Insert(aCompanies);
}
#endregion
#region Them moi nhom vao trong cong ty
if (IDCompany > 0)
{
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CustomerGroups aCustomerGroups = new CustomerGroups();
string nameGroup;
if (string.IsNullOrEmpty(aNewBookingEN.Subject))
{
nameGroup = "[" + customerType + "][" + aNewBookingEN.NameCompany + "][" + DateTime.Now.ToString() + "]";
}
else
{
nameGroup = aNewBookingEN.Subject;
}
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);
}
#endregion
#region Them moi bookingRs
if (IDCustomer > 0 && IDCustomerGroup > 0)
{
string subject = "[" + customerType + "][" + aNewBookingEN.NameCompany + "][" + DateTime.Now.ToString() + "]";
BookingRs aBookingRs = new BookingRs();
aBookingRs.CreatedDate = DateTime.Now;
aBookingRs.CustomerType = aNewBookingEN.CustomerType;
aBookingRs.BookingType = aNewBookingEN.BookingType;
if (subject.Length > 250)
{
aBookingRs.Subject = subject.Substring(0, 250);
}
else
{
aBookingRs.Subject = subject;
}
aBookingRs.IDCustomerGroup = IDCustomerGroup;
aBookingRs.IDCustomer = IDCustomer;
aBookingRs.IDSystemUser = aNewBookingEN.IDSystemUser;
aBookingRs.PayMenthod = aNewBookingEN.PayMenthod;
aBookingRs.StatusPay = aNewBookingEN.StatusPay;
aBookingRs.BookingMoney = aNewBookingEN.BookingMoney;
aBookingRs.ExchangeRate = aNewBookingEN.ExchangeRate;
aBookingRs.Level = 0;// de mac dinh hien tai chua dung den
aBookingRs.Note = string.Empty;
aBookingRs.Description = string.Empty;
aBookingRs.DatePay = aNewBookingEN.CheckOutPlan;
aBookingRs.DateEdit = aNewBookingEN.CheckInActual;
aBookingRs.Status = aNewBookingEN.Status;
aBookingRs.Type = aNewBookingEN.Type;
aBookingRs.Disable = aNewBookingEN.Disable;
//add new bookingRs
BookingRsBO aBookingRsBO = new BookingRsBO();
IDBookingR = aBookingRsBO.Insert(aBookingRs);
}
#endregion
#region them moi bookingRoom
if (IDBookingR > 0)
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms;
for (int i = 0; i < aNewBookingEN.aListNewRoomMembers.Count; i++)
{
aBookingRooms = new BookingRooms();
aBookingRooms.IDBookingR = IDBookingR;
aBookingRooms.CodeRoom = aNewBookingEN.aListNewRoomMembers[i].RoomCode;
aBookingRooms.PercentTax = 10;
aBookingRooms.CostRef_Rooms = aNewBookingEN.aListNewRoomMembers[i].RoomCostRef;
aBookingRooms.Cost = aNewBookingEN.aListNewRoomMembers[i].RoomCostRef;
aBookingRooms.CheckInPlan = aNewBookingEN.CheckInActual;
aBookingRooms.CheckInActual = aNewBookingEN.CheckInActual;
aBookingRooms.CheckOutPlan = aNewBookingEN.CheckOutPlan;
aBookingRooms.CheckOutActual = aNewBookingEN.CheckOutActual;
aBookingRooms.StartTime = aNewBookingEN.CheckInActual;
aBookingRooms.EndTime = aNewBookingEN.CheckOutPlan;
aBookingRooms.BookingStatus = 1;
aBookingRooms.Type = 3; //Tính CheckIn sớm và CheckOut muộn
aBookingRooms.Status = aNewBookingEN.Status;
aBookingRooms.PriceType = "G1";
//add new bookingRoom
aBookingRoomsBO.Insert(aBookingRooms);
}
}
#endregion
return true;
}
catch (Exception ex)
{
return false;
}
}
private void frmIns_CustomerGroups_Load(object sender, EventArgs e)
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
List<Companies> aListCompanies = aCompaniesBO.Select_All();
lueCompany.Properties.DataSource = aListCompanies;
lueCompany.Properties.DisplayMember = "Name";
lueCompany.Properties.ValueMember = "ID";
if (IDCompany == 0)
{
if(aListCompanies.Count > 0)
{
lueCompany.EditValue = aListCompanies[0].ID;
}
}
else
{
lueCompany.Enabled = false;
lueCompany.EditValue = IDCompany;
}
}
catch (Exception ex)
{
MessageBox.Show("frmIns_CustomerGroups.frmIns_CustomerGroups_Load\n" + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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 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 frmTsk_PendingCheckIn_Step2_Load(object sender, EventArgs e)
{
try
{
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(IDBookingR);
lblIDBookingR.Text = aBookingRs.ID.ToString();
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup);
lblNameCustomerGroup.Text = aCustomerGroups.Name;
CompaniesBO aCompaniesBO = new CompaniesBO();
Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany);
lblNameCompany.Text = aCompanies.Name;
CustomersBO aCustomersBO = new CustomersBO();
Customers aCustomers = aCustomersBO.Select_ByID(aBookingRs.IDCustomer);
lblNameCustomer.Text = aCustomers.Name;
RoomsBO aRoomsBO = new RoomsBO();
Rooms aRooms = aRoomsBO.Select_ByCodeRoom(CodeRoom, 1);//1=IDLang
lblSku.Text = aRooms.Sku;
dtpTo.DateTime = CheckOutPlan;
dtpFrom.DateTime = DateTime.Now;
dtpFrom.Enabled = false;
dtpFrom.Properties.ReadOnly = true;
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_PendingCheckIn_Step2.frmTsk_PendingCheckIn_Step2_Load\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void InitData(int IDBookingH)
{
CompaniesBO aCompaniesBO = new CompaniesBO();
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
SystemUsersBO aSystemUsersBO = new SystemUsersBO();
BookingHsBO aBookingHsBO = new BookingHsBO();
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
HallsBO aHallsBO = new HallsBO();
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
FoodsBO aFoodsBO = new FoodsBO();
List<int> aListIndexTemp = new List<int>();
BookingHs aBookingHs = aBookingHsBO.Select_ByID(IDBookingH);
if (aBookingHs != null)
{
aNewPaymentHEN.IDCustomer = aBookingHs.IDCustomer;
Customers aCustomers = aCustomersBO.Select_ByID(aBookingHs.IDCustomer);
if (aCustomers != null)
{
aNewPaymentHEN.NameCustomer = aCustomers.Name;
}
aNewPaymentHEN.IDSystemUser = aBookingHs.IDSystemUser;
SystemUsers aSystemUsers = aSystemUsersBO.Select_ByID(aBookingHs.IDSystemUser);
if (aSystemUsers != null)
{
aNewPaymentHEN.NameSystemUser = aSystemUsers.Name;
}
aNewPaymentHEN.IDCustomerGroup = aBookingHs.IDCustomerGroup;
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingHs.IDCustomerGroup);
if (aCustomerGroups != null)
{
aNewPaymentHEN.NameCustomerGroup = aCustomerGroups.Name;
aNewPaymentHEN.IDCompany = aCustomerGroups.IDCompany;
Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany);
if (aCompanies != null)
{
aNewPaymentHEN.NameCompany = aCompanies.Name;
aNewPaymentHEN.TaxNumberCodeCompany = aCompanies.TaxNumberCode;
aNewPaymentHEN.AddressCompany = aCompanies.Address;
}
}
aNewPaymentHEN.Subject = aBookingHs.Subject;
aNewPaymentHEN.PayMenthodH = aBookingHs.PayMenthod;
aNewPaymentHEN.CreatedDate_BookingH = aBookingHs.CreatedDate;
aNewPaymentHEN.CustomerType = aBookingHs.CustomerType;
aNewPaymentHEN.Status_BookingH = aBookingHs.Status;
aNewPaymentHEN.StatusPay = aBookingHs.StatusPay;
aNewPaymentHEN.BookingHMoney = aBookingHs.BookingMoney;
aNewPaymentHEN.AcceptDate = aBookingHs.AcceptDate;
aNewPaymentHEN.InvoiceDate = aBookingHs.InvoiceDate;
aNewPaymentHEN.InvoiceNumber = aBookingHs.InvoiceNumber;
this.aNewPaymentHEN.IDBookingH = aBookingHs.ID;
this.aNewPaymentHEN.PayMenthodH = aBookingHs.PayMenthod;
this.aNewPaymentHEN.CreatedDate_BookingH = aBookingHs.CreatedDate;
this.aNewPaymentHEN.CustomerType = aBookingHs.CustomerType;
this.aNewPaymentHEN.Status_BookingH = aBookingHs.Status;
this.aNewPaymentHEN.BookingHMoney = aBookingHs.BookingMoney;
// Truyen du lieu cho List BookingHall cua NewPayment
List<BookingHalls> aListBookingHalls = aBookingHallsBO.Select_ByIDBookigH(this.IDBookingH);
if (aListBookingHalls != null)
{
BookingHallUsedEN aBookingHallUsedEN;
foreach (BookingHalls item in aListBookingHalls)
{
aBookingHallUsedEN = new BookingHallUsedEN();
aBookingHallUsedEN.SetValue(item);
Halls aHalls = aHallsBO.Select_ByCodeHall(item.CodeHall, 1);
if (aHalls != null)
{
aBookingHallUsedEN.HallSku = aHalls.Sku;
}
else
{
aBookingHallUsedEN.HallSku = string.Empty;
}
aBookingHallUsedEN.CustomerType = aBookingHs.CustomerType;
aBookingHallUsedEN.BookingTypeBookingH = aBookingHs.BookingType;
aBookingHallUsedEN.StatusPayBookingH = aBookingHs.StatusPay;
aBookingHallUsedEN.LevelBookingH = aBookingHs.Level;
aBookingHallUsedEN.aListMenuEN = aReceptionTaskBO.GetListMenus_ByIDBookingHall(item.ID);
aListIndexTemp.Add(Convert.ToInt32(aBookingHallUsedEN.IndexSubPayment));
List<ServiceUsedEN> aListServiceTemp = aReceptionTaskBO.GetListServiceUsedInHall_ByIDBookingHall(item.ID);
foreach (ServiceUsedEN aTemp in aListServiceTemp)
{
aBookingHallUsedEN.aListServiceUsed.Add(aTemp);
aListIndexTemp.Add(Convert.ToInt32(aTemp.IndexSubPayment));
}
aNewPaymentHEN.aListBookingHallUsed.Add(aBookingHallUsedEN);
}
}
}
aNewPaymentHEN.ListIndex = aListIndexTemp.Distinct().ToList();
}
// ===============================================================================
// Khoi tao doi tuong Payment
private void InitData(int IDBookingR, int IDBookingH)
{
CompaniesBO aCompaniesBO = new CompaniesBO();
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
SystemUsersBO aSystemUsersBO = new SystemUsersBO();
BookingHsBO aBookingHsBO = new BookingHsBO();
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRoomsBO aBookingRoomBO = new BookingRoomsBO();
CustomersBO aCustomersBO = new CustomersBO();
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
RoomsBO aRoomsBO = new RoomsBO();
HallsBO aHallsBO = new HallsBO();
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
FoodsBO aFoodsBO = new FoodsBO();
ExtraCostBO aExtraCostBO = new ExtraCostBO();
List<int> aListIndexTemp = new List<int>();
BookingHs aBookingHs = new BookingHs();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(IDBookingR);
if (this.IDBookingH > 0)
{
aBookingHs = aBookingHsBO.Select_ByID(this.IDBookingH);
}
else
{
BookingRs_BookingHs aItem = (new BookingRs_BookingHsBO()).Select_ByIDBookingR(this.IDBookingR);
if (aItem != null)
{
this.IDBookingH = aItem.IDBookingH.GetValueOrDefault(0);
aBookingHs = aBookingHsBO.Select_ByID(this.IDBookingH);
}
}
// Truyen du lieu chung cua NewPayment
if (aBookingRs != null)
{
aNewPaymentEN.IDBookingR = aBookingRs.ID;
aNewPaymentEN.IDCustomer = aBookingRs.IDCustomer;
Customers aCustomers = aCustomersBO.Select_ByID(aBookingRs.IDCustomer);
if (aCustomers != null)
{
aNewPaymentEN.NameCustomer = aCustomers.Name;
}
aNewPaymentEN.IDSystemUser = aBookingRs.IDSystemUser;
SystemUsers aSystemUsers = aSystemUsersBO.Select_ByID(aBookingRs.IDSystemUser);
if (aSystemUsers != null)
{
aNewPaymentEN.NameSystemUser = aSystemUsers.Name;
}
aNewPaymentEN.IDCustomerGroup = aBookingRs.IDCustomerGroup;
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup);
if (aCustomerGroups != null)
{
aNewPaymentEN.NameCustomerGroup = aCustomerGroups.Name;
aNewPaymentEN.IDCompany = aCustomerGroups.IDCompany;
Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany);
if (aCompanies != null)
{
aNewPaymentEN.NameCompany = aCompanies.Name;
aNewPaymentEN.TaxNumberCodeCompany = aCompanies.TaxNumberCode;
aNewPaymentEN.AddressCompany = aCompanies.Address;
}
}
aNewPaymentEN.PayMenthodR = aBookingRs.PayMenthod;
aNewPaymentEN.CreatedDate_BookingR = aBookingRs.CreatedDate;
aNewPaymentEN.CustomerType = aBookingRs.CustomerType;
aNewPaymentEN.Status_BookingR = aBookingRs.Status;
aNewPaymentEN.StatusPay = aBookingRs.StatusPay;
aNewPaymentEN.BookingRMoney = aBookingRs.BookingMoney;
aNewPaymentEN.Status_BookingR = aBookingRs.Status;
aNewPaymentEN.AcceptDate = aBookingRs.AcceptDate;
aNewPaymentEN.InvoiceDate = aBookingRs.InvoiceDate;
aNewPaymentEN.InvoiceNumber = aBookingRs.InvoiceNumber;
// Truyen du lieu cho List BookingRoom cua NewPayment
List<BookingRooms> aListBookingRooms = aBookingRoomBO.Select_ByIDBookingRs(this.IDBookingR);
if (aListBookingRooms.Count > 0)
{
BookingRoomUsedEN aBookingRoomUsedEN;
foreach (BookingRooms item in aListBookingRooms)
{
aBookingRoomUsedEN = new BookingRoomUsedEN();
aBookingRoomUsedEN.SetValue(item);
aBookingRoomUsedEN.ListCustomer = aCustomersBO.SelectListCustomer_ByIDBookingRoom(item.ID);
Rooms aRooms = aRoomsBO.Select_ByCodeRoom(item.CodeRoom, 1);
if (aRooms != null)
{
aBookingRoomUsedEN.RoomSku = aRooms.Sku;
}
else
{
aBookingRoomUsedEN.RoomSku = string.Empty;
}
if (item.Status == 8 || item.Status == 7)
{
aBookingRoomUsedEN.AddTimeStart = Convert.ToDouble(aReceptionTaskBO.GetAddTimeStart(Convert.ToInt32(item.Type), item.CheckInActual));
aBookingRoomUsedEN.AddTimeEnd = Convert.ToDouble(aReceptionTaskBO.GetAddTimeEnd(Convert.ToInt32(item.Type), item.CheckOutActual));
aBookingRoomUsedEN.TimeInUse = Convert.ToDecimal(aReceptionTaskBO.GetTimeInUsed(item.CheckInActual, item.CheckOutActual) * 24 * 60);
}
else
{
aBookingRoomUsedEN.AddTimeStart = Convert.ToDouble(aReceptionTaskBO.GetAddTimeStart(Convert.ToInt32(item.Type), item.CheckInActual));
aBookingRoomUsedEN.AddTimeEnd = Convert.ToDouble(aReceptionTaskBO.GetAddTimeEnd(Convert.ToInt32(item.Type), item.CheckOutPlan));
aBookingRoomUsedEN.TimeInUse = Convert.ToDecimal(aReceptionTaskBO.GetTimeInUsed(item.CheckInActual, item.CheckOutPlan) * 24 * 60);
}
decimal? cost = 0;
if (item.Cost == null)
{
cost = item.CostRef_Rooms;
aBookingRoomUsedEN.Cost = cost + Convert.ToDecimal(aExtraCostBO.Select_BySku_ByPriceType_ByNumberPeople(aRooms.Sku, aBookingRoomUsedEN.PriceType, aBookingRoomUsedEN.ListCustomer.Count).ExtraValue);
}
else
{
cost = item.Cost;
aBookingRoomUsedEN.Cost = cost;
}
List<ServiceUsedEN> aListServiceRTemp = aReceptionTaskBO.GetListServiceUsedInRoom_ByIDBookingRoom(item.ID);
foreach (ServiceUsedEN aTemp in aListServiceRTemp)
{
aBookingRoomUsedEN.ListServiceUsed.Add(aTemp);
aListIndexTemp.Add(Convert.ToInt32(aTemp.IndexSubPayment));
}
aListIndexTemp.Add(Convert.ToInt32(aBookingRoomUsedEN.IndexSubPayment));
aNewPaymentEN.aListBookingRoomUsed.Add(aBookingRoomUsedEN);
}
}
//====================================================================================================
//====================================================================================================
//====================================================================================================
// Brucelee Thanh sửa ngày 04/06/2015
//
//---------------
// Lỗi sai điều kiện câu lệnh if khiến aBookingHs truyền dữ liệu CustomerType sai cho NewPaymentEN
//---------------
// Ban đầu : if (aBookingHs != null)
//-------------------------------------
if (aBookingHs.ID > 0)
{
aNewPaymentEN.IDBookingH = aBookingHs.ID;
aNewPaymentEN.PayMenthodH = aBookingHs.PayMenthod;
aNewPaymentEN.CreatedDate_BookingH = aBookingHs.CreatedDate;
aNewPaymentEN.CustomerType = aBookingHs.CustomerType;
aNewPaymentEN.Status_BookingH = aBookingHs.Status;
aNewPaymentEN.BookingHMoney = aBookingHs.BookingMoney;
// Truyen du lieu cho List BookingHall cua NewPayment
List<BookingHalls> aListBookingHalls = aBookingHallsBO.Select_ByIDBookigH(this.IDBookingH);
if (aListBookingHalls != null)
{
BookingHallUsedEN aBookingHallUsedEN;
foreach (BookingHalls item in aListBookingHalls)
{
aBookingHallUsedEN = new BookingHallUsedEN();
aBookingHallUsedEN.SetValue(item);
Halls aHalls = aHallsBO.Select_ByCodeHall(item.CodeHall, 1);
if (aHalls != null)
{
aBookingHallUsedEN.HallSku = aHalls.Sku;
}
else
{
aBookingHallUsedEN.HallSku = string.Empty;
}
aBookingHallUsedEN.CustomerType = aBookingHs.CustomerType;
aBookingHallUsedEN.BookingTypeBookingH = aBookingHs.BookingType;
aBookingHallUsedEN.StatusPayBookingH = aBookingHs.StatusPay;
aBookingHallUsedEN.LevelBookingH = aBookingHs.Level;
aBookingHallUsedEN.aListMenuEN = aReceptionTaskBO.GetListMenus_ByIDBookingHall(item.ID);
aListIndexTemp.Add(Convert.ToInt32(aBookingHallUsedEN.IndexSubPayment));
List<ServiceUsedEN> aListServiceTemp = aReceptionTaskBO.GetListServiceUsedInHall_ByIDBookingHall(item.ID);
foreach (ServiceUsedEN aTemp in aListServiceTemp)
{
aBookingHallUsedEN.aListServiceUsed.Add(aTemp);
aListIndexTemp.Add(Convert.ToInt32(aTemp.IndexSubPayment));
}
aNewPaymentEN.aListBookingHallUsed.Add(aBookingHallUsedEN);
}
}
}
aNewPaymentEN.ListIndex = aListIndexTemp.Distinct().ToList();
}
}
// Author : Linhting
public void LoadCustomerInfo()
{
try
{
BookingHsBO aBookingHsBO = new BookingHsBO();
CustomersBO aCustomersBO = new CustomersBO();
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CompaniesBO aCompaniesBO = new CompaniesBO();
int IDCustomer = aBookingHsBO.Select_ByID(this.IDBookingH).IDCustomer;
int IDCustomerGroup = aBookingHsBO.Select_ByID(this.IDBookingH).IDCustomerGroup;
lblCompany.Text = aCompaniesBO.Select_ByIDCustomerGroup(IDCustomerGroup).Name;
lblNameCustomerGroup.Text = aCustomerGroupsBO.Select_ByID(IDCustomerGroup).Name;
lblNameCustomer.Text = aCustomersBO.Select_ByID(IDCustomer).Name;
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_PaymentHall.LoadCustomerInfo\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private List<Companies> LoadListCompaniesByType()
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
Companies aItem = new Companies();
aItem.Name = "[Hiện tất cả]";
aItem.ID = 0;
List<Companies> aList = new List<Companies>();
aList = aCompaniesBO.Select_All();
aList.Add(aItem);
return aList;
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_BookingForRoom.LoadListCompaniesByType()\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
//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;
}
}
//hiennv
public void InitData(PaymentHallsEN aPaymentHallsEN, int IDBookingH)
{
try
{
HallsBO aHallsBO = new HallsBO();
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
FoodsBO aFoodsBO = new FoodsBO();
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CustomersBO aCustomersBO = new CustomersBO();
BookingHsBO aBookingHsBO = new BookingHsBO();
CompaniesBO aCompaniesBO = new CompaniesBO();
SystemUsersBO aSystemUsersBO = new SystemUsersBO();
BookingHs aBookingHs = aBookingHsBO.Select_ByID(IDBookingH);
if (aBookingHs != null)
{
aPaymentHallsEN.IDBookingH = aBookingHs.ID;
aPaymentHallsEN.IDCustomerGroup = aBookingHs.IDCustomerGroup;
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingHs.IDCustomerGroup);
if (aCustomerGroups != null)
{
aPaymentHallsEN.NameCustomerGroup = aCustomerGroups.Name;
aPaymentHallsEN.IDCompany = aCustomerGroups.IDCompany;
Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany);
if (aCompanies != null)
{
aPaymentHallsEN.NameCompany = aCompanies.Name;
aPaymentHallsEN.TaxNumberCodeCompany = aCompanies.TaxNumberCode;
}
}
aPaymentHallsEN.IDCustomer = aBookingHs.IDCustomer;
Customers aCustomers = aCustomersBO.Select_ByID(aBookingHs.IDCustomer);
if (aCustomers != null)
{
aPaymentHallsEN.NameCustomer = aCustomers.Name;
}
aPaymentHallsEN.IDSystemUser = aBookingHs.IDSystemUser;
SystemUsers aSystemUsers = aSystemUsersBO.Select_ByID(aBookingHs.IDSystemUser);
if (aSystemUsers != null)
{
aPaymentHallsEN.NameSystemUser = aSystemUsers.Name;
}
aPaymentHallsEN.CreatedDate_BookingH = aBookingHs.CreatedDate;
aPaymentHallsEN.CustomerType = aBookingHs.CustomerType;
aPaymentHallsEN.BookingType = aBookingHs.BookingType;
aPaymentHallsEN.PayMenthod = aBookingHs.PayMenthod;
aPaymentHallsEN.StatusPay = aBookingHs.StatusPay;
aPaymentHallsEN.Status_BookingH = aBookingHs.Status;
aPaymentHallsEN.ExchangeRate = aBookingHs.ExchangeRate;
aPaymentHallsEN.Level = aBookingHs.Level;
aPaymentHallsEN.BookingMoney = aBookingHs.BookingMoney;
}
List<BookingHalls> aListBookingHalls = new List<BookingHalls>();
aListBookingHalls = aBookingHallsBO.Select_ByIDBookigH(IDBookingH);
InfoDetailPaymentHallsEN aInfoDetailPaymentHallsEN;
for (int i = 0; i < aListBookingHalls.Count; i++)
{
aInfoDetailPaymentHallsEN = new InfoDetailPaymentHallsEN();
Halls aHalls = aHallsBO.Select_ByCodeHall(aListBookingHalls[i].CodeHall, 1);
if (aHalls != null)
{
aInfoDetailPaymentHallsEN.Sku = aHalls.Sku;
}
else
{
aInfoDetailPaymentHallsEN.Sku = string.Empty;
}
aInfoDetailPaymentHallsEN.aBookingHalls = aListBookingHalls[i];
aInfoDetailPaymentHallsEN.aMenusEN = aReceptionTaskBO.GetDetailMenu_ByIDBookingHall(aListBookingHalls[i].ID);
aInfoDetailPaymentHallsEN.aListServicesHallsEN = aReceptionTaskBO.GetListServicesHallsEN_ByIDBookingHall(aListBookingHalls[i].ID);
aPaymentHallsEN.aListInfoDetailPaymentHallsEN.Insert(i, aInfoDetailPaymentHallsEN);
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_PaymentHall.InitData\n" + ex.ToString());
}
}
private void lueIDCompanies_EditValueChanged(object sender, EventArgs e)
{
if (lueIDCompanies.EditValue == null)
{
MessageBox.Show("Vui lòng chọn tên công ty.");
lueIDCompanies.Focus();
}
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = new BookingRs();
List<PaymentExt_GetAllDataEN> aListPaymentExt_GetAllDataEN = new List<PaymentExt_GetAllDataEN>();
int IDCompany = Convert.ToInt32(lueIDCompanies.EditValue.ToString());
CustomerGroupsBO aCustomerGroupBO = new CustomerGroupsBO();
List<int> aListIDCustomerGroup = aCustomerGroupBO.Select_All().Where(x => x.IDCompany == IDCompany).Select(p => p.ID).ToList();
CompaniesBO aCompaniesBO = new CompaniesBO();
List<int> ListIDBookingR = aBookingRsBO.Select_ByIDCompany(int.Parse(lueIDCompanies.EditValue.ToString())).Select(p=>p.ID).ToList();
dgvPaymentViewAll.DataSource = this.aListPaymentExt_GetAllDataEN.Where(p => ListIDBookingR.Contains(p.BookingRs_ID));
}
//Hiennv
private void txtTaxNumberCode_Leave(object sender, EventArgs e)
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
Companies aCompanies = aCompaniesBO.Select_ByID(this.aPaymentHallsEN.IDCompany);
if (aCompanies != null)
{
aCompanies.TaxNumberCode = txtTaxNumberCode.Text;
aCompaniesBO.Update(aCompanies);
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_PaymentHall.txtTaxNumberCode_Leave\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Load IDCompany
public void LoadIDCompanies(int Type)
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
List<Companies> aListCompanies = aCompaniesBO.Select_ByType(Type);
lueIDCompanies.Properties.DataSource = aListCompanies;
lueIDCompanies.Properties.DisplayMember = "Name";
lueIDCompanies.Properties.ValueMember = "ID";
if (Type == 3)
{
if (aListCompanies.Count > 0)
{
lueIDCompanies.EditValue = aListCompanies[0].ID;
}
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_Booking_Step2.LoadIDCompanies\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Author : Linhting
public void InitData( int IDBookingH)
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
SystemUsersBO aSystemUsersBO = new SystemUsersBO();
BookingHsBO aBookingHsBO = new BookingHsBO();
CustomersBO aCustomersBO = new CustomersBO();
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
HallsBO aHallsBO = new HallsBO();
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
FoodsBO aFoodsBO = new FoodsBO();
BookingHs aBookingHs = aBookingHsBO.Select_ByID(IDBookingH);
// Truyen du lieu cho List BookingRoom cua NewPayment
if (aBookingHs != null)
{
aNewPaymentEN.IDCustomer = aBookingHs.IDCustomer;
Customers aCustomers = aCustomersBO.Select_ByID(aBookingHs.IDCustomer);
if (aCustomers != null)
{
aNewPaymentEN.NameCustomer = aCustomers.Name;
}
aNewPaymentEN.IDSystemUser = aBookingHs.IDSystemUser;
SystemUsers aSystemUsers = aSystemUsersBO.Select_ByID(aBookingHs.IDSystemUser);
if (aSystemUsers != null)
{
aNewPaymentEN.NameSystemUser = aSystemUsers.Name;
}
aNewPaymentEN.IDCustomerGroup = aBookingHs.IDCustomerGroup;
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingHs.IDCustomerGroup);
if (aCustomerGroups != null)
{
aNewPaymentEN.NameCustomerGroup = aCustomerGroups.Name;
aNewPaymentEN.IDCompany = aCustomerGroups.IDCompany;
Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany);
if (aCompanies != null)
{
aNewPaymentEN.NameCompany = aCompanies.Name;
aNewPaymentEN.TaxNumberCodeCompany = aCompanies.TaxNumberCode;
aNewPaymentEN.AddressCompany = aCompanies.Address;
}
}
aNewPaymentEN.IDBookingH = aBookingHs.ID;
aNewPaymentEN.CreatedDate_BookingH = aBookingHs.CreatedDate;
aNewPaymentEN.CustomerType = aBookingHs.CustomerType;
aNewPaymentEN.Status_BookingH = aBookingHs.Status;
aNewPaymentEN.BookingHMoney = aBookingHs.BookingMoney;
// Truyen du lieu cho List BookingHall cua NewPayment
List<BookingHalls> aListBookingHalls = aBookingHallsBO.Select_ByIDBookigH(this.IDBookingH);
if (aListBookingHalls != null)
{
BookingHallUsedEN aBookingHallUsedEN;
foreach (BookingHalls item in aListBookingHalls)
{
aBookingHallUsedEN = new BookingHallUsedEN();
aBookingHallUsedEN.SetValue(item);
Halls aHalls = aHallsBO.Select_ByCodeHall(item.CodeHall, 1);
if (aHalls != null)
{
aBookingHallUsedEN.HallSku = aHalls.Sku;
}
else
{
aBookingHallUsedEN.HallSku = string.Empty;
}
aBookingHallUsedEN.CustomerType = aBookingHs.CustomerType;
aBookingHallUsedEN.BookingTypeBookingH = aBookingHs.BookingType;
aBookingHallUsedEN.StatusPayBookingH = aBookingHs.StatusPay;
aBookingHallUsedEN.LevelBookingH = aBookingHs.Level;
aBookingHallUsedEN.aListMenuEN = aReceptionTaskBO.GetListMenus_ByIDBookingHall(item.ID);
List<ServiceUsedEN> aListServiceTemp = aReceptionTaskBO.GetListServiceUsedInHall_ByIDBookingHall(item.ID);
foreach (ServiceUsedEN aTemp in aListServiceTemp)
{
aBookingHallUsedEN.aListServiceUsed.Add(aTemp);
}
aNewPaymentEN.aListBookingHallUsed.Add(aBookingHallUsedEN);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_PaymentHall.InitData\n" + ex.ToString());
}
}
//Hiennv tạo mới 18/11/2014 Load ra toàn bộ danh sách công ty theo loại công ty (Nhà nước, đoàn ,lẻ)
private List<Companies> LoadListCompaniesByType(int type)
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
return aCompaniesBO.Select_ByType(type);
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_CheckIn.LoadListCompaniesByType()\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
public void LoadCompanies()
{
try
{
CompaniesBO aCompaniesBO = new CompaniesBO();
lueCompany.Properties.DataSource = aCompaniesBO.Select_ByType(1);// [Company] Type = 1 : Nha nuoc, 1;
lueCompany.Properties.DisplayMember = "Name";
lueCompany.Properties.ValueMember = "ID";
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_UpdBooking.LoadCompanies\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Ngoc da sua lai ten ham 26/12/2014
public List<BookingRStatusPayViewEN> GetListBookingRByStatus(DateTime? From, DateTime? To, int? CustomerType, string StatusPay)
{
List<sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay_Result> aListTemp = new List<sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay_Result>();
aListTemp = aDatabaseDA.sp_BookingRsExt_GetInfo_ByTime_ByCustomerType_ByStatusPay(From, To, CustomerType, StatusPay).ToList();
List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>();
BookingRStatusPayViewEN aBookingRStatusPayViewEN;
CompaniesBO aCompaniesBO = new CompaniesBO();
List<Companies> aListCompaniesTemp = aCompaniesBO.Select_All();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
List<BookingRooms> aListBookingRoomTemp = aBookingRoomsBO.Select_All();
for (int i = 0; i < aListTemp.Count; i++)
{
aBookingRStatusPayViewEN = new BookingRStatusPayViewEN();
aBookingRStatusPayViewEN.IDBookingR = aListTemp[i].BookingRs_ID;
aBookingRStatusPayViewEN.CreatedDate = aListTemp[i].BookingRs_CreatedDate;
aBookingRStatusPayViewEN.Customer_Name = aListTemp[i].Customers_Name;
aBookingRStatusPayViewEN.Subject = aListTemp[i].BookingRs_Subject;
aBookingRStatusPayViewEN.IDCustomer = aListTemp[i].Customers_ID;
aBookingRStatusPayViewEN.IDCustomerGroup = aListTemp[i].CustomerGroups_ID;
aBookingRStatusPayViewEN.BookingRs_Status = aListTemp[i].BookingRs_Status;
aBookingRStatusPayViewEN.CustomerGroups_Name = aListTemp[i].CustomerGroups_Name;
int IDCompany = !String.IsNullOrEmpty(aListTemp[i].Companies_ID.ToString()) ? Convert.ToInt32(aListTemp[i].Companies_ID) : 0;
if (aListCompaniesTemp.Where(c => c.ID == IDCompany).ToList().Count > 0)
{
aBookingRStatusPayViewEN.NameCompany = aListCompaniesTemp.Where(c => c.ID == IDCompany).ToList()[0].Name;
}
else
{
aBookingRStatusPayViewEN.NameCompany = string.Empty;
}
aBookingRStatusPayViewEN.StatusPay = aListTemp[i].BookingRs_StatusPay;
aBookingRStatusPayViewEN.BookingMoney = aListTemp[i].BookingRs_BookingMoney;
aBookingRStatusPayViewEN.Sku = aListTemp[i].Rooms_Sku;
aBookingRStatusPayViewEN.IDBookingH = aListTemp[i].BookingRs_BookingHs_IDBookingH;
aBookingRStatusPayViewEN.BookingHs_Status = aListTemp[i].BookingHs_Status;
aBookingRStatusPayViewEN.BookingHs_StatusPay = aListTemp[i].BookingHs_StatusPay;
aBookingRStatusPayViewEN.BookingHs_Type = aListTemp[i].BookingHs_Type;
aBookingRStatusPayViewEN.BookingHs_Disable = aListTemp[i].BookingHs_Disable;
aBookingRStatusPayViewEN.BookingHs_Subject = aListTemp[i].BookingHs_Subject;
List<BookingRooms> aListBookingRooms = aListBookingRoomTemp.Where(br => br.IDBookingR == aListTemp[i].BookingRs_ID && br.CodeRoom == aListTemp[i].Rooms_Code).ToList();
if (aListBookingRooms.Count > 0)
{
switch (aListBookingRooms[0].Status)
{
case 3:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check in";
break;
case 5:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Pending";
break;
case 7:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check out nhưng chưa thanh toán";
break;
case 8:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã thanh toán";
break;
default:
aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Chưa xác định";
break;
}
aBookingRStatusPayViewEN.IDBookingRoom = aListBookingRooms[0].ID;
aBookingRStatusPayViewEN.BookingRooms_CodeRoom = aListBookingRooms[0].CodeRoom;
aBookingRStatusPayViewEN.CheckInActual = aListBookingRooms[0].CheckInActual;
aBookingRStatusPayViewEN.CheckOut = aListBookingRooms[0].CheckOutPlan;
}
switch (aBookingRStatusPayViewEN.StatusPay)
{
case 1:
aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa thanh toán";
break;
case 2:
aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Tạm ứng";
break;
case 3:
aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Đã thanh toán";
break;
default:
aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa xác định";
break;
}
switch (aListTemp[i].BookingRs_CustomerType)
{
case 1:
aBookingRStatusPayViewEN.CustomerTypeDisplay = "Nhà nước";
break;
case 2:
aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách đoàn";
break;
case 3:
aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách lẻ";
break;
case 4:
aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách vãng lai";
break;
case 5:
aBookingRStatusPayViewEN.CustomerTypeDisplay = "Khách bộ ngoại giao";
break;
default:
aBookingRStatusPayViewEN.CustomerTypeDisplay = "Chưa xác định";
break;
}
aListReturn.Add(aBookingRStatusPayViewEN);
}
return aListReturn;
}
