public frmRpt_UnSelectMenus(int IDBookingHall)
{
InitializeComponent();
this.IDBookingHall = IDBookingHall;
FoodsBO aFoodsBO = new FoodsBO();
MenusBO aMenusBO = new MenusBO();
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
// Thông tin buổi tiệc
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
BookingHalls aTemp = aBookingHallsBO.Select_ByID(IDBookingHall);
lblStartTime.Text = aTemp.StartTime.ToString();
lblEndTime.Text = aTemp.EndTime.ToString();
HallsBO aHallsBO = new HallsBO();
lblHallSku.Text = aHallsBO.Select_ByCodeHall(aTemp.CodeHall, 1).Sku;
BookingHsBO aBookingHsBO = new BookingHsBO();
lblSubject.Text = aBookingHsBO.Select_ByID(aTemp.IDBookingH).Subject;
this.LoadMenus();
//danh sach cac mon an co trong thuc don 1
DetailReport.DataSource = aListFood1;
picImage1Food.DataBindings.Add("Image", this.DataSource, "Image1");
colNameFood.DataBindings.Add("Text", this.DataSource, "Name");
colName1Food.DataBindings.Add("Text", this.DataSource, "Name1");
colName2Food.DataBindings.Add("Text", this.DataSource, "Name2");
colName3Food.DataBindings.Add("Text", this.DataSource, "Name3");
}
public frmRpt_UnSelectMenus(int IDBookingHall,int IDMenu)
{
InitializeComponent();
this.IDBookingHall = IDBookingHall;
FoodsBO aFoodsBO = new FoodsBO();
MenusBO aMenusBO = new MenusBO();
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
// Thông tin buổi tiệc
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
BookingHalls aTemp = aBookingHallsBO.Select_ByID(IDBookingHall);
lblStartTime.Text = aTemp.StartTime.ToString();
lblEndTime.Text = aTemp.EndTime.ToString();
HallsBO aHallsBO = new HallsBO();
lblHallSku.Text = aHallsBO.Select_ByCodeHall(aTemp.CodeHall, 1).Sku;
BookingHsBO aBookingHsBO = new BookingHsBO();
lblSubject.Text = aBookingHsBO.Select_ByID(aTemp.IDBookingH).Subject;
// Load Menu
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
Menus aMenus = aMenusBO.Select_ByID(IDMenu);
if (aMenus != null)
{
List<Foods> aListTemp1 = aMenus_FoodsBO.SelectListFoods_ByIDMenu(aMenus.ID);
foreach (Foods item in aListTemp1)
{
if (item.Image1 != null)
{
if (item.Image1.Length <= 0)
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
item.Image1 = aImageByte;
}
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
item.Image1 = aImageByte;
}
aListFood1.Add(item);
}
}
//danh sach cac mon an co trong thuc don 1
DetailReport.DataSource = aListFood1;
picImage1Food.DataBindings.Add("Image", this.DataSource, "Image1");
colNameFood.DataBindings.Add("Text", this.DataSource, "Name");
colName1Food.DataBindings.Add("Text", this.DataSource, "Name1");
colName2Food.DataBindings.Add("Text", this.DataSource, "Name2");
colName3Food.DataBindings.Add("Text", this.DataSource, "Name3");
}
//hiennv
public void LoadDataListFoods()
{
try
{
FoodsBO aFoodsBO = new FoodsBO();
List<Foods> aListFoods = new List<Foods>();
List<Foods> aListTemp = aFoodsBO.Select_All();
foreach (Foods item in aListTemp)
{
Foods aFoods = aFoodsBO.Select_ByID(item.ID);
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length <= 0)
{
Image image = SaleManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70,70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = SaleManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70,70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
aListFoods.Add(aFoods);
}
dgvFoods.DataSource = aListFoods;
dgvFoods.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_SearchFood.LoadDataListFoods\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();
}
//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 lueMenus_EditValueChanged(object sender, EventArgs e)
{
BookingHallUsedEN aBookingHallUsedEN = this.aNewPaymentEN.aListBookingHallUsed.Where(a => a.ID == this.CurrentIDBookingHall).ToList()[0];
MenusEN aMenusEN = aBookingHallUsedEN.aListMenuEN.Where(a => a.ID == Convert.ToInt32(lueMenus.EditValue)).ToList()[0];
List<Foods> aListFoods = new List<Foods>();
FoodsBO aFoodsBO = new FoodsBO();
foreach (Foods item in aMenusEN.aListFoods)
{
Foods aFoods = aFoodsBO.Select_ByID(item.ID);
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length <= 0)
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
aListFoods.Add(aFoods);
}
dgvFoods.DataSource = aListFoods;
dgvFoods.RefreshDataSource();
}
// Load data cho bảng món ăn
public void LoadDataListFoods()
{
try
{
this.aListFoods.Clear();
FoodsBO aFoodsBO = new FoodsBO();
MenusBO aMenusBO = new MenusBO();
this.aListFoods = aFoodsBO.Select_All();
dgvAvailableFoods.DataSource = this.aListFoods;
dgvAvailableFoods.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_BookingHall_Customer_New.LoadDataListFoods\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//hiennv
public void LoadDataListSelectFoods(int ID)
{
try
{
FoodsBO aFoodsBO = new FoodsBO();
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
List<Foods> aListTemp = aReceptionTaskBO.GetListFoods_ByIDMenu(ID);
foreach (Foods item in aListTemp)
{
Foods aFoods = aFoodsBO.Select_ByID(item.ID);
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length > 0)
{
Image image = this.ConvertByteArrayToImage(aFoods.Image1);
image = image.GetThumbnailImage(50, 50, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(50, 50, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(50, 50, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
this.aMenusEN.aListFoods.Add(aFoods);
}
dgvSelectFoods.DataSource = this.aMenusEN.aListFoods;
dgvSelectFoods.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmUpd_Menus.LoadDataListSelectFoods\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// ===============================================================================
// 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 LoadData()
{
lblCompany.Text = this.aNewPaymentEN.NameCompany;
lblNameCustomerGroup.Text = this.aNewPaymentEN.NameCustomerGroup;
lblNameCustomer.Text = this.aNewPaymentEN.NameCustomer;
txtAddressH.Text = this.aNewPaymentEN.AddressCompany;
txtTaxNumberCodeH.Text = this.aNewPaymentEN.TaxNumberCodeCompany;
// Trang thai, hinh thuc thanh toan
lblTotalMoneyBookingHs.Text = String.Format("{0:0,0}", this.aNewPaymentEN.GetMoneyHalls());
txtBookingMoney.EditValue = this.aNewPaymentEN.BookingHMoney;
lblTotalMoney.Text = String.Format("{0:0,0}", this.aNewPaymentEN.GetMoneyHalls() - this.aNewPaymentEN.BookingHMoney);
// Thong tin gia tiền, đặt trước
luePayMethod.Properties.DataSource = CORE.CONSTANTS.ListPayMethods;
luePayMethod.Properties.DisplayMember = "Name";
luePayMethod.Properties.ValueMember = "ID";
luePayMethod.EditValue = CORE.CONSTANTS.SelectedPayMethod(Convert.ToInt32(this.aNewPaymentEN.PayMenthodH)).ID;
// Danh sách các hội trường
dgvHalls.DataSource = this.aNewPaymentEN.aListBookingHallUsed;
dgvHalls.RefreshDataSource();
if (this.aNewPaymentEN.aListBookingHallUsed.Where(a => a.ID == this.CurrentIDBookingHall).ToList().Count > 0)
{
BookingHallUsedEN aBookingHallUsedEN = this.aNewPaymentEN.aListBookingHallUsed.Where(a => a.ID == this.CurrentIDBookingHall).ToList()[0];
lblSkuHall.Text = Convert.ToString(aBookingHallUsedEN.HallSku);
decimal? cost = 0;
if (aBookingHallUsedEN.Cost == null || aBookingHallUsedEN.Cost == 0)
{
cost = aBookingHallUsedEN.CostRef_Halls;
}
else
{
cost = aBookingHallUsedEN.Cost;
}
lblDate.Text = String.Format("{0:dd/MM/yyyy}", aBookingHallUsedEN.Date);
lblLunarDate.Text = String.Format("{0:dd/MM/yyyy}", aBookingHallUsedEN.LunarDate);
lblStartTime.Text = String.Format(@"{0:hh\:mm}", aBookingHallUsedEN.StartTime);
lblEndTime.Text = String.Format(@"{0:hh\:mm}", aBookingHallUsedEN.EndTime);
lueMenus.Properties.DataSource = aBookingHallUsedEN.aListMenuEN;
lueMenus.Properties.DisplayMember = "Name";
lueMenus.Properties.ValueMember = "ID";
if (aBookingHallUsedEN.aListMenuEN.Count > 0)
{
lueMenus.EditValue = aBookingHallUsedEN.aListMenuEN[0].ID;
MenusEN aMenusEN = aBookingHallUsedEN.aListMenuEN[0];
List<Foods> aListFoods = new List<Foods>();
FoodsBO aFoodsBO = new FoodsBO();
foreach (Foods item in aMenusEN.aListFoods)
{
Foods aFoods = aFoodsBO.Select_ByID(item.ID);
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length <= 0)
{
Image image = SaleManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = SaleManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
aListFoods.Add(aFoods);
}
dgvFoods.DataSource = aListFoods;
dgvFoods.RefreshDataSource();
}
txtPercentTax_Hall.EditValue = aBookingHallUsedEN.PercentTax;
lblMoneyHall.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.GetMoneyAHall(aBookingHallUsedEN.ID));
decimal? BookingHallsCost = aBookingHallUsedEN.Cost == null ? aBookingHallUsedEN.CostRef_Halls : aBookingHallUsedEN.Cost;
txtBookingHallsCost.EditValue = BookingHallsCost;
dgvServices.DataSource = this.aNewPaymentEN.GetListServiceUsedInHall(aBookingHallUsedEN.ID);
dgvServices.RefreshDataSource();
lblTotalMoneyService.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.GetMoneyListServiceUsedInAHall(aBookingHallUsedEN.ID));
}
}
//hiennv
public void LoadDataListFoods()
{
try
{
this.aListFoods.Clear();
FoodsBO aFoodsBO = new FoodsBO();
MenusBO aMenusBO = new MenusBO();
List<Foods> aListFoods = aFoodsBO.Select_All();
List<int> ListID = new List<int>();
for (int i = 0; i < aListFoods.Count; i++)
{
ListID.Add(aListFoods[i].ID);
}
List<Foods> aListTemp = aFoodsBO.Select_ByListID(ListID);
foreach (Foods item in aListFoods)
{
Foods aFoods = aListTemp.Where(p => p.ID == item.ID).ToList()[0];
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length <= 0)
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
this.aListFoods.Add(aFoods);
}
dgvAvailableFoods.DataSource = this.aListFoods;
dgvAvailableFoods.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmIns_Menus.LoadDataListFoods\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadMenus()
{
try
{
MenusBO aMenusBO = new MenusBO();
FoodsBO aFoodsBO = new FoodsBO();
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
List<Menus> aListMenus = aMenusBO.Select_ByIDBookingHall(IDBookingHall);
if (aListMenus.Count > 0)
{
List<Foods> aListTemp1 = aMenus_FoodsBO.SelectListFoods_ByIDMenu(aListMenus[0].ID);
foreach (Foods item in aListTemp1)
{
if (item.Image1 != null)
{
if (item.Image1.Length <= 0)
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
item.Image1 = aImageByte;
}
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
item.Image1 = aImageByte;
}
aListFood1.Add(item);
}
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_SelectedMenus.LoadMenus\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//hiennv
public frmRpt_DetailBookingHalls(int IDBookingHall)
{
InitializeComponent();
this.IDBookingHall = IDBookingHall;
try
{
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
BookingHallDetailEN aBookingHallDetailEN = aReceptionTaskBO.GetDetailBookingHalls_ByIDBookingHall(this.IDBookingHall);
celNameCustomer.Text = aBookingHallDetailEN.NameCustomer;
celNameCustomerGoup.Text = aBookingHallDetailEN.NameCustomerGroup;
celSkuHall.Text = aBookingHallDetailEN.HallSku;
celLunarDateBookingHall.Text = String.Format("{0:dd/MM/yyyy}", aBookingHallDetailEN.LunarDate);
celDateBookingHall.Text = String.Format("{0:dd/MM/yyyy}", aBookingHallDetailEN.Date);
lblStartTime.Text = String.Format(@"{0:hh\:mm}",aBookingHallDetailEN.StartTime);
lblEndTime.Text = String.Format(@"{0:hh\:mm}", aBookingHallDetailEN.EndTime);
lblNameMenu.Text = aBookingHallDetailEN.NameMenu;
celCustomerTypeBookingH.Text = CORE.CONSTANTS.SelectedCustomerType(Convert.ToInt32(aBookingHallDetailEN.CustomerType)).Name;
celLevelBookingH.Text = CORE.CONSTANTS.SelectedLevel(Convert.ToInt32(aBookingHallDetailEN.LevelBookingH)).Name;
celBookingTypeBookingH.Text = CORE.CONSTANTS.SelectedBookingType(Convert.ToInt32(aBookingHallDetailEN.BookingTypeBookingH)).Name;
celStatusBookingHall.Text = CORE.CONSTANTS.SelectedBookingHallStatus(Convert.ToInt32(aBookingHallDetailEN.Status)).Name;
celStatusPayBookingH.Text = CORE.CONSTANTS.SelectedStatusPay(Convert.ToInt32(aBookingHallDetailEN.StatusPayBookingH)).Name;
FoodsBO aFoodsBO = new FoodsBO();
List<Foods> aListFoods = new List<Foods>();
foreach (Foods item in aBookingHallDetailEN.aListFoods)
{
Foods aFoods = aFoodsBO.Select_ByID(item.ID);
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length <= 0)
{
Image image = SaleManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70,70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = SaleManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70,70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
aListFoods.Add(aFoods);
}
//danh sach cac mon an co trong thuc don
this.DetailReportMenu.DataSource =aListFoods;
picImage1Food.DataBindings.Add("Image", this.DetailReportMenu.DataSource, "Image1");
colNameFood.DataBindings.Add("Text", this.DetailReportMenu.DataSource, "Name");
colName1Food.DataBindings.Add("Text", this.DetailReportMenu.DataSource, "Name1");
colName2Food.DataBindings.Add("Text", this.DetailReportMenu.DataSource, "Name2");
colName3Food.DataBindings.Add("Text", this.DetailReportMenu.DataSource, "Name3");
//danh dach cac dich vu su dung
this.DetailReportServiceInUse.DataSource = aBookingHallDetailEN.aListServicesHallsEN;
colNameServices.DataBindings.Add("Text", this.DetailReportServiceInUse.DataSource,"NameService");
colDate.DataBindings.Add("Text", this.DetailReportServiceInUse.DataSource, "Date","{0:dd/MM/yyyy}");
colCostRef_Services.DataBindings.Add("Text", this.DetailReportServiceInUse.DataSource, "CostRef_Services","{0:0,0}");
colPercentTax.DataBindings.Add("Text", this.DetailReportServiceInUse.DataSource, "PercentTax");
colQuantity.DataBindings.Add("Text", this.DetailReportServiceInUse.DataSource, "Quantity","{0:0,0}");
}
catch (Exception ex)
{
MessageBox.Show("frmRpt_DetailBookingHalls.frmRpt_DetailBookingHalls\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmLst_DetailMenus_Load(object sender, EventArgs e)
{
try
{
MenusBO aMenusBO = new MenusBO();
Menus aMenus = aMenusBO.Select_ByID(this.IDMenu);
lblNameMenu.Text = aMenus.Name;
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
FoodsBO aFoodsBO = new FoodsBO();
List<Foods> aListTemp = aReceptionTaskBO.GetListFoods_ByIDMenu(this.IDMenu);
List<Foods> aListFoods = new List<Foods>();
foreach (Foods item in aListTemp)
{
Foods aFoods = aFoodsBO.Select_ByID(item.ID);
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length <= 0)
{
Image image = SaleManagement.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70,70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = SaleManagement.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70,70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
aListFoods.Add(aFoods);
}
dgvFoods.DataSource = aListFoods;
dgvFoods.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmLst_DetailMenus.frmLst_DetailMenus_Load\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Load data cho bảng món ăn
public void LoadDataListFoods()
{
try
{
this.aListFoods.Clear();
FoodsBO aFoodsBO = new FoodsBO();
MenusBO aMenusBO = new MenusBO();
int count = (lueHalls.Properties.DataSource as IList).Count;
for (int i = 0; i < count; i++)
{
this.aListFoods.Insert(i,aFoodsBO.Select_All());
}
dgvAvailableFoods.DataSource = this.aListFoods[this.lueHalls.ItemIndex];
dgvAvailableFoods.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_BookingHall_Customer_New.LoadDataListFoods\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void lueAvailableMenus_EditValueChanged(object sender, EventArgs e)
{
this.aMenusEN.aListFoods.Clear();
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
FoodsBO aFoodsBO = new FoodsBO();
int IDMenu = Convert.ToInt32(lueAvailableMenus.EditValue);
List<Foods> aListFoods = aMenus_FoodsBO.SelectListFoods_ByIDMenu(IDMenu);
List<int> ListID = new List<int>();
for (int i = 0; i < aListFoods.Count; i++)
{
ListID.Add(aListFoods[i].ID);
}
List<Foods> aListTemp = aFoodsBO.Select_ByListID(ListID);
foreach (Foods item in aListFoods)
{
Foods aFoods = aListTemp.Where(p => p.ID == item.ID).ToList()[0];
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length > 0)
{
Image image = this.ConvertByteArrayToImage(aFoods.Image1);
image = image.GetThumbnailImage(50, 50, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(50, 50, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(50, 50, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
this.aMenusEN.aListFoods.Add(aFoods);
}
dgvSelectFoods.DataSource = this.aMenusEN.aListFoods;
dgvSelectFoods.RefreshDataSource();
}
//hiennv
private void btnEditBookingHall_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
lblSku.Visible = true;
lblDate.Visible = true;
lblLunarDate.Visible = true;
lblStartTime.Visible = true;
lblEndTime.Visible = true;
txtBookingHallsCost.Visible = true;
txtPercentTax_Hall.Visible = true;
lblMoneyHall.Visible = true;
lblNameMenu.Visible = true;
IDBookingHall = Convert.ToInt32(viewHalls.GetFocusedRowCellValue("IDBookingHall"));
BookingHalls aBookingHalls = aPaymentHallsEN.GetDetailBookingHall_ByID(IDBookingHall);
HallsBO aHallsBO = new HallsBO();
Halls aHalls = aHallsBO.Select_ByCodeHall(aBookingHalls.CodeHall, 1);
lblSku.Text = aHalls.Sku;
decimal? cost = 0;
if (aBookingHalls.Cost == null || aBookingHalls.Cost == 0)
{
cost = aBookingHalls.CostRef_Halls;
}
else
{
cost = aBookingHalls.Cost;
}
lblDate.Text = String.Format("{0:dd/MM/yyyy}", aBookingHalls.Date);
lblLunarDate.Text = String.Format("{0:dd/MM/yyyy}", aBookingHalls.LunarDate);
lblStartTime.Text = String.Format(@"{0:hh\:mm}", aBookingHalls.StartTime);
lblEndTime.Text = String.Format(@"{0:hh\:mm}", aBookingHalls.EndTime);
MenusEN aMenusEN = aPaymentHallsEN.GetDetailMenus(IDBookingHall);
lblNameMenu.Text = aMenusEN.Name;
List<Foods> aListFoods = new List<Foods>();
FoodsBO aFoodsBO = new FoodsBO();
foreach (Foods item in aMenusEN.aListFoods)
{
Foods aFoods = aFoodsBO.Select_ByID(item.ID);
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length <= 0)
{
Image image = SaleManagement.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = SaleManagement.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
aListFoods.Add(aFoods);
}
dgvFoods.DataSource = aListFoods;
dgvFoods.RefreshDataSource();
txtPercentTax_Hall.EditValue =aBookingHalls.PercentTax;
lblMoneyHall.Text = String.Format("{0:0,0} (VND)", aPaymentHallsEN.GetMoneyHall(IDBookingHall));
decimal? BookingHallsCost = aBookingHalls.Cost == null ? aBookingHalls.CostRef_Halls : aBookingHalls.Cost;
txtBookingHallsCost.EditValue =BookingHallsCost;
this.LoadDataService(this.IDBookingHall);
lblTotalMoneyService.Text = String.Format("{0:0,0} (VND)", aPaymentHallsEN.GetTotalMoneyServiceHallBehindTax_ByIDBookingHall(IDBookingHall));
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_PaymentHall.btnEditBookingHall_ButtonClick\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//=======================================================
//Author: Hiennv
//Function : SelectListFoods_ByListIDFood()
//=======================================================
public List<Foods> SelectListFoods_ByListIDFood(List<int> aListIDFood)
{
FoodsBO aFoodsBO = new FoodsBO();
List<Foods> aListFoods = new List<Foods>();
for (int i = 0; i < aListIDFood.Count; i++)
{
aListFoods.Add(aFoodsBO.Select_ByID(aListIDFood[i]));
}
return aListFoods;
}
// 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());
}
}
// Load du lieu len control
private void LoadData()
{
//-------------- Phòng ---------------------
//Thong tin nguoi dat
lblCompany.Text = this.aNewPaymentEN.NameCompany;
lblNameCustomerGroup.Text = this.aNewPaymentEN.NameCustomerGroup;
lblNameCustomer.Text = this.aNewPaymentEN.NameCustomer;
txtAddressR.Text = this.aNewPaymentEN.AddressCompany;
txtTaxNumberCodeR.Text = this.aNewPaymentEN.TaxNumberCodeCompany;
// Thông tin hóa đơn
txtInvoiceNumber.Text = this.aNewPaymentEN.InvoiceNumber;
dtpAcceptDate.DateTime = this.aNewPaymentEN.AcceptDate.GetValueOrDefault(Convert.ToDateTime("01/01/1900"));
dtpInvoiceDate.DateTime = this.aNewPaymentEN.InvoiceDate.GetValueOrDefault(Convert.ToDateTime("01/01/1900"));
// Trang thai, hinh thuc thanh toan
lueBookingR_Paymethod.Properties.DataSource = CORE.CONSTANTS.ListPayMethods;
lueBookingR_Paymethod.Properties.DisplayMember = "Name";
lueBookingR_Paymethod.Properties.ValueMember = "ID";
lueBookingR_Paymethod.EditValue = CORE.CONSTANTS.SelectedPayMethod(Convert.ToInt32(this.aNewPaymentEN.PayMenthodR)).ID;
//--------------------------------------------------------------
// Thong tin gia tiền, đặt trước
lblTotalMoneyRooms1.Text = String.Format("{0:0,0}", this.aNewPaymentEN.GetMoneyRooms());
txtBookingRMoney.EditValue = this.aNewPaymentEN.BookingRMoney;
lblTotalMoneyR.Text = String.Format("{0:0,0}", this.aNewPaymentEN.GetMoneyRooms() - this.aNewPaymentEN.BookingRMoney);
// Bang danh sach phong
dgvRooms.DataSource = this.aNewPaymentEN.aListBookingRoomUsed;
dgvRooms.RefreshDataSource();
//--------- Hội trường ----------------
if (this.IDBookingH > 0)
{
btnBookHall.Visible = false;
//Thong tin nguoi dat
lblNameCompany_BookingH.Text = this.aNewPaymentEN.NameCompany;
lblNameCustomerGroup_BookingH.Text = this.aNewPaymentEN.NameCustomerGroup;
lblNameCustomer_BookingH.Text = this.aNewPaymentEN.NameCustomer;
txtAddressH.Text = this.aNewPaymentEN.AddressCompany;
txtTaxNumberCodeH.Text = this.aNewPaymentEN.TaxNumberCodeCompany;
// Trang thai, hinh thuc thanh toan
lblTotalMoneyBookingHs.Text = String.Format("{0:0,0}", this.aNewPaymentEN.GetMoneyHalls());
txtBookingHMoney.EditValue = this.aNewPaymentEN.BookingHMoney;
lblTotalMoneyH.Text = String.Format("{0:0,0}", this.aNewPaymentEN.GetMoneyHalls() - this.aNewPaymentEN.BookingHMoney);
// Thong tin gia tiền, đặt trước
lueBookingH_PayMethod.Properties.DataSource = CORE.CONSTANTS.ListPayMethods;
lueBookingH_PayMethod.Properties.DisplayMember = "Name";
lueBookingH_PayMethod.Properties.ValueMember = "ID";
lueBookingH_PayMethod.EditValue = CORE.CONSTANTS.SelectedPayMethod(Convert.ToInt32(this.aNewPaymentEN.PayMenthodH)).ID;
// Danh sách các hội trường
dgvHalls.DataSource = this.aNewPaymentEN.aListBookingHallUsed;
dgvHalls.RefreshDataSource();
// Thông tin 1 hội trường
if (this.aNewPaymentEN.aListBookingHallUsed.Where(a => a.ID == this.CurrentIDBookingHall).ToList().Count > 0)
{
BookingHallUsedEN aBookingHallUsedEN = this.aNewPaymentEN.aListBookingHallUsed.Where(a => a.ID == this.CurrentIDBookingHall).ToList()[0];
lblSkuHalls.Text = Convert.ToString(aBookingHallUsedEN.HallSku);
decimal? cost = 0;
if (aBookingHallUsedEN.Cost == null || aBookingHallUsedEN.Cost == 0)
{
cost = aBookingHallUsedEN.CostRef_Halls;
}
else
{
cost = aBookingHallUsedEN.Cost;
}
lblDate.Text = String.Format("{0:dd/MM/yyyy}", aBookingHallUsedEN.Date);
lblLunarDate.Text = String.Format("{0:dd/MM/yyyy}", aBookingHallUsedEN.LunarDate);
lblStartTime.Text = String.Format(@"{0:hh\:mm}", aBookingHallUsedEN.StartTime);
lblEndTime.Text = String.Format(@"{0:hh\:mm}", aBookingHallUsedEN.EndTime);
lueMenus.Properties.DataSource = aBookingHallUsedEN.aListMenuEN;
lueMenus.Properties.DisplayMember = "Name";
lueMenus.Properties.ValueMember = "ID";
if (aBookingHallUsedEN.aListMenuEN.Count > 0)
{
lueMenus.EditValue = aBookingHallUsedEN.aListMenuEN[0].ID;
MenusEN aMenusEN = aBookingHallUsedEN.aListMenuEN[0];
List<Foods> aListFoods = new List<Foods>();
FoodsBO aFoodsBO = new FoodsBO();
foreach (Foods item in aMenusEN.aListFoods)
{
Foods aFoods = aFoodsBO.Select_ByID(item.ID);
if (aFoods.Image1 != null)
{
if (aFoods.Image1.Length <= 0)
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
}
else
{
Image image = RoomManager.Properties.Resources.logo_nkcp_small;
image = image.GetThumbnailImage(70, 70, null, IntPtr.Zero);
Byte[] aImageByte = this.ConvertImageToByteArray(image);
aFoods.Image1 = aImageByte;
}
aListFoods.Add(aFoods);
}
dgvFoods.DataSource = aListFoods;
dgvFoods.RefreshDataSource();
}
else
{
List<Foods> aListFoods = new List<Foods>();
dgvFoods.DataSource = aListFoods;
dgvFoods.RefreshDataSource();
}
txtPercentTax_Hall.EditValue = aBookingHallUsedEN.PercentTax;
lblMoneyHall.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.GetMoneyAHall(aBookingHallUsedEN.ID));
decimal? BookingHallsCost = aBookingHallUsedEN.Cost == null ? aBookingHallUsedEN.CostRef_Halls : aBookingHallUsedEN.Cost;
txtBookingHallsCost.EditValue = BookingHallsCost;
dgvBookingHallUseServices.DataSource = this.aNewPaymentEN.GetListServiceUsedInHall(aBookingHallUsedEN.ID);
dgvBookingHallUseServices.RefreshDataSource();
lblTotalMoneyServices_BookingH.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.GetMoneyListServiceUsedInAHall(aBookingHallUsedEN.ID));
}
}
else
{
btnBookHall.Visible = true;
btnPaymentHall.Enabled = false;
btnPrintBookingH.Enabled = false;
txtTaxNumberCodeH.Enabled = false;
txtAddressH.Enabled = false;
}
// Thông tin tổng tiền
lblTotalBookingRAndBookingHBeforeTax.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.GetTotalMoneyBeforeTax());
lblTotalBookingRAndBookingHAfterTax.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.GetTotalMoney());
if (this.aNewPaymentEN.BookingHMoney != null)
{
lblBookingMoney_BookingRAndBookingH.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.BookingHMoney + this.aNewPaymentEN.BookingRMoney);
lblTotalBookingRAndBookingH.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.GetTotalMoney() - (this.aNewPaymentEN.BookingHMoney + this.aNewPaymentEN.BookingRMoney));
}
else
{
lblBookingMoney_BookingRAndBookingH.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.BookingRMoney);
lblTotalBookingRAndBookingH.Text = String.Format("{0:0,0} (VND)", this.aNewPaymentEN.GetTotalMoney() - this.aNewPaymentEN.BookingRMoney);
}
}
public void LoadMenus()
{
try
{
MenusBO aMenusBO = new MenusBO();
FoodsBO aFoodsBO = new FoodsBO();
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
List<Menus> aListMenus = aMenusBO.Select_ByIDBookingHall(IDBookingHall);
dgvMenus.DataSource = aListMenus;
dgvMenus.RefreshDataSource();
if (aListMenus.Count > 0)
{
btnCreateMenu.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_SelectedMenus.LoadMenus\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//=======================================================
//Author: Hiennv
//Function : SelectListFoods_ByIDMenu()
//=======================================================
public List<Foods> SelectListFoods_ByIDMenu(int IDMenu)
{
try
{
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
List<Menus_Foods> aList = aDatabaseDA.Menus_Foods.Where(a => a.IDMenu == IDMenu).ToList();
List<Foods> aListFoods = new List<Foods>();
Foods aFoods;
FoodsBO aFoodsBO = new FoodsBO();
for (int i = 0; i < aList.Count; i++)
{
aFoods = new Foods();
aFoods = aFoodsBO.Select_ByID(aList[i].IDFood);
aListFoods.Add(aFoods);
}
return aListFoods;
}
catch (Exception ex)
{
throw new Exception("Menus_FoodsBO.SelectListFoods_ByIDMenu\n" + ex.ToString());
}
}
