//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);
}
}
// 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());
}
}
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();
}
//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());
}
}
// ===============================================================================
// 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();
}
}
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();
}
}
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);
}
}
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()
}
//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;
}
//=======================================================
//Author: LinhTing
//Function : Tìm danh sách phòng + hóa đơn đã đặt
//=======================================================
public List<BookingRStatusPayViewEN> GetListBookedBookingR_BookingRoom(DateTime From, DateTime To, int CustomerType, int BookingStatus)
{
List<vw__PaymentInfo__BookingRs_BookingRooms_Customers> aListTemp = new List<vw__PaymentInfo__BookingRs_BookingRooms_Customers>();
aListTemp = aDatabaseDA.vw__PaymentInfo__BookingRs_BookingRooms_Customers.ToList().Where(a => a.BookingRs_CreatedDate > From).Where(b => b.BookingRs_CreatedDate < To).Where(c => c.BookingRooms_Status == BookingStatus).Where(d => d.BookingRs_CustomerType == CustomerType).ToList();
List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>();
BookingRStatusPayViewEN aBookingRStatusPayViewEN = new BookingRStatusPayViewEN();
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;
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;
aListReturn.Add(aBookingRStatusPayViewEN);
}
return aListReturn;
}
