public void Reload()
{
try
{
BookingRsBO aBookingRsBO = new BookingRsBO();
List<BookingRsEN> aList_BookingRsEN = new List<BookingRsEN>();
List<vw__PaymentInfo__BookingRs_BookingRooms_Customers> aList = aBookingRsBO.Select_ByStatusAndDateAndCustomerType(2, DateTime.Now, this.customerType);// status = 2 :Checked ; customerType =1 : khach nha nuoc ; customerType =2 : khach doan ; customerType =3 : khach le
BookingRsEN item;
for (int i = 0; i < aList.Count; i++)
{
item = new BookingRsEN();
item.StatusDisplay = CORE.CONSTANTS.SelectedBookingRoomStatus(aList[i].BookingRooms_Status.GetValueOrDefault()).Name;
item.CustomerTypeDisplay = CORE.CONSTANTS.SelectedCustomerType(aList[i].BookingRs_CustomerType.GetValueOrDefault()).Name;
item.SetValue(aList[i]);
aList_BookingRsEN.Add(item);
}
if (this.IDBookingR == 0)
{
dgvBookingRs.DataSource = aList_BookingRsEN;
dgvBookingRs.RefreshDataSource();
}
else
{
dgvBookingRs.DataSource = aList_BookingRsEN.Where(b=>b.BookingRs_ID == this.IDBookingR);
dgvBookingRs.RefreshDataSource();
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_BookingRs.ReLoad.\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadData()
{
try
{
CustomersBO aCustomersBO = new CustomersBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms = new BookingRooms();
RoomsBO aRoomsBO = new RoomsBO();
// Load các thông tin chung về phòng
aBookingRooms = aBookingRoomsBO.Select_ByID(this.IDBookingRooms);
if (aBookingRooms != null)
{
lblCheckIn.Text = aBookingRooms.CheckInActual.ToString("dd/MM/yyyy HH:mm");
lblCheckOut.Text = aBookingRooms.CheckOutPlan.ToString("dd/MM/yyyy HH:mm");
lblRoomSku.Text = aRoomsBO.Select_ByCodeRoom(aBookingRooms.CodeRoom, 1).Sku;
}
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = new BookingRs();
aBookingRs = aBookingRsBO.Select_ByID(this.IDBookingRs);
if (aBookingRs != null)
{
lblCustomerType.Text = CORE.CONSTANTS.SelectedCustomerType(Convert.ToInt32(aBookingRs.CustomerType)).Name;
CompaniesBO aCompaniesBO = new CompaniesBO();
lblCompany.Text = aCompaniesBO.Select_ByIDBookingRoom(this.IDBookingRooms).Name;
lblCustomer.Text = aCustomersBO.Select_ByID(aBookingRs.IDCustomer).Name;
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
lblGroup.Text = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup).Name;
lblTel.Text = aCustomersBO.Select_ByID(aBookingRs.IDCustomer).Tel;
this.IDCustomerGroup = aBookingRs.IDCustomerGroup;
}
//Load danh sách phòng còn trống
lueRooms.Properties.DataSource = this.LoadListAvailableRooms(aBookingRooms.CheckInActual, aBookingRooms.CheckOutPlan);
lueRooms.Properties.ValueMember = "RoomCode";
lueRooms.EditValue = this.IDBookingRooms;
//Load danh sách khách trong phòng
this.aListCustomersInRoom = aCustomersBO.SelectListCustomer_ByIDBookingRoom(this.IDBookingRooms);
dgvAvailableCustomers.DataSource = this.aListCustomersInRoom;
dgvAvailableCustomers.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_EditBooking.ReloadData\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public frmTsk_EditBooking(int IDBookingRoom, frmMain afrmMain)
{
InitializeComponent();
BookingRoomsBO aBookingRoomBO = new BookingRoomsBO();
this.aBookingRoom = aBookingRoomBO.Select_ByID(IDBookingRoom);
BookingRsBO aBookingRsBO = new BookingRsBO();
this.aBookingRs = aBookingRsBO.Select_ByID(this.aBookingRoom.IDBookingR);
this.afrmMain = afrmMain;
this.IsReadyInitData = false;
this.aCurrentCustomerClick = new CustomerInfoEN();
}
public void LoadData()
{
try
{
CustomersBO aCustomersBO = new CustomersBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms = new BookingRooms();
RoomsBO aRoomsBO = new RoomsBO();
aBookingRooms = aBookingRoomsBO.Select_ByID(this.IDBookingRooms);
if (aBookingRooms != null)
{
lblCheckIn.Text = aBookingRooms.CheckInActual.ToString("dd/MM/yyyy HH:mm");
lblCheckOut.Text = aBookingRooms.CheckOutPlan.ToString("dd/MM/yyyy HH:mm");
lblRoomSku.Text = aRoomsBO.Select_ByCodeRoom(aBookingRooms.CodeRoom,1).Sku;
}
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = new BookingRs();
aBookingRs = aBookingRsBO.Select_ByID(this.IDBookingRs);
if (aBookingRs != null)
{
lblCustomerType.Text = CORE.CONSTANTS.SelectedCustomerType(Convert.ToInt32(aBookingRs.CustomerType)).Name;
CompaniesBO aCompaniesBO = new CompaniesBO();
lblCompany.Text = aCompaniesBO.Select_ByIDBookingRoom(this.IDBookingRooms).Name;
lblCustomer.Text = aCustomersBO.Select_ByID(aBookingRs.IDCustomer).Name;
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
lblGroup.Text = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup).Name;
lblTel.Text = aCustomersBO.Select_ByID(aBookingRs.IDCustomer).Tel;
this.IDCustomerGroup = aBookingRs.IDCustomerGroup;
}
dgvAvaiableRooms.DataSource = this.LoadListAvailableRooms(aBookingRooms.CheckInActual, aBookingRooms.CheckOutPlan);
dgvAvaiableRooms.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_EditBooking.ReloadData\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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));
}
//-----------------Select by list idbookingroom-------------------------------
public List<BookingRs> Select_ByListIDBookingRoom(List<int> ListIDBookingRoom)
{
try
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRsBO aBookingRsBO = new BookingRsBO();
List<BookingRooms> aListItem = new List<BookingRooms>();
aListItem = aBookingRoomsBO.Select_ByListID(ListIDBookingRoom);
List<int> aListIDBookingRs = new List<int>();
int aIDBookingRs;
for (int i = 0; i < aListItem.Count; i++)
{
aIDBookingRs = new int();
aIDBookingRs = aListItem[i].IDBookingR;
aListIDBookingRs.Add(aIDBookingRs);
}
List<BookingRs> aListBookingRs = aBookingRsBO.Select_ByListID(aListIDBookingRs);
return aListBookingRs;
}
catch (Exception ex)
{
throw new Exception("BookingRsBO.Select_ByListIDBookingRoom:" + ex.ToString());
}
}
//=======================================================
//Author: Hiennv
//Function : Booking()
//=======================================================
public bool Booking(BookingEN aBookingEN)
{
try
{
//========================================================
BookingRs aBookingRs = new BookingRs();
aBookingRs.CreatedDate = DateTime.Now;
aBookingRs.CustomerType = aBookingEN.CustomerType;
aBookingRs.BookingType = aBookingEN.BookingType;
aBookingRs.Note = aBookingEN.Note;
aBookingRs.IDCustomerGroup = aBookingEN.IDCustomerGroup;
aBookingRs.IDCustomer = aBookingEN.IDCustomer;
aBookingRs.IDSystemUser = aBookingEN.IDSystemUser;
aBookingRs.PayMenthod = aBookingEN.PayMenthod;
aBookingRs.StatusPay = aBookingEN.StatusPay;
aBookingRs.BookingMoney = aBookingEN.BookingMoney;
aBookingRs.ExchangeRate = aBookingEN.ExchangeRate;
aBookingRs.Status = aBookingEN.Status;
aBookingRs.Type = aBookingEN.Type;
aBookingRs.Disable = aBookingEN.Disable;
aBookingRs.Level = aBookingEN.Level;
aBookingRs.Subject = aBookingEN.Subject;
aBookingRs.Description = aBookingEN.Description;
aBookingRs.DatePay = aBookingEN.DatePay;
aBookingRs.DateEdit = aBookingEN.DateEdit;
//add new bookingRs
BookingRsBO aBookingRsBO = new BookingRsBO();
aBookingRsBO.Insert(aBookingRs);
int IDBookingR = aBookingRs.ID;
//==========================================================
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms;
BookingRoomsMembers aBookingRoomsMembers;
for (int i = 0; i < aBookingEN.aListRoomsEN.Count; i++)
{
aBookingRooms = new BookingRooms();
aBookingRooms.IDBookingR = IDBookingR;
aBookingRooms.CodeRoom = aBookingEN.aListRoomsEN[i].Code;
aBookingRooms.PercentTax = 10;
aBookingRooms.CostRef_Rooms = aBookingEN.aListRoomsEN[i].CostRef;
aBookingRooms.Cost = aBookingEN.aListRoomsEN[i].CostRef;
aBookingRooms.CheckInPlan = aBookingEN.CheckInActual;
aBookingRooms.CheckInActual = aBookingEN.CheckInActual;
aBookingRooms.CheckOutPlan = aBookingEN.CheckOutPlan;
aBookingRooms.CheckOutActual = aBookingEN.CheckOutActual;
aBookingRooms.StartTime = aBookingEN.CheckInActual;
aBookingRooms.EndTime = aBookingEN.CheckOutPlan;
aBookingRooms.BookingStatus = 1;
aBookingRooms.Status = aBookingEN.Status;
aBookingRooms.Type = 1;//Tính CheckIn sớm và CheckOut muộn
//add new bookingRoom
aBookingRoomsBO.Insert(aBookingRooms);
}
return true;
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.Booking\n" + ex.ToString());
}
}
//hiennv
public bool PaymentRoom(PaymentEN aPaymentEN)
{
try
{
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(aPaymentEN.IDBookingR);
if (aBookingRs != null)
{
aBookingRs.ID = aPaymentEN.IDBookingR;
aBookingRs.PayMenthod = aPaymentEN.PayMenthod;
aBookingRs.StatusPay = 3;
aBookingRs.Status = 8;
aBookingRs.DatePay = DateTime.Now;
aBookingRs.BookingMoney = 0;
aBookingRsBO.Update(aBookingRs);
}
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms_ServicesBO aBookingRooms_ServicesBO = new BookingRooms_ServicesBO();
for (int i = 0; i < aPaymentEN.aListInfoDetailPaymentEN.Count; i++)
{
if (aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.IDBookingR == aPaymentEN.IDBookingR)
{
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.ID);
if (aBookingRooms != null)
{
aBookingRooms.ID = aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.ID;
aBookingRooms.PercentTax = aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.PercentTax;
decimal? cost = aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.Cost == null ? aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.CostRef_Rooms : aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.Cost;
aBookingRooms.Cost = cost;
aBookingRooms.Status = 8;
aBookingRooms.CheckOutActual = aPaymentEN.aListInfoDetailPaymentEN[i].CheckOut;
aBookingRooms.TimeInUse = Convert.ToDecimal(aPaymentEN.aListInfoDetailPaymentEN[i].DateInUse * 24 * 60);
aBookingRoomsBO.Update(aBookingRooms);
}
for (int j = 0; j < aPaymentEN.aListInfoDetailPaymentEN[i].aListService.Count; j++)
{
if (aPaymentEN.aListInfoDetailPaymentEN[i].aBookingRooms.ID == aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].IDBookingRoom)
{
BookingRooms_Services aBookingRooms_Services = aBookingRooms_ServicesBO.Select_ByID(aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].IDBookingRoomService);
if (aBookingRooms_Services != null)
{
aBookingRooms_Services.ID = aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].IDBookingRoomService;
aBookingRooms_Services.Quantity = aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].Quantity;
aBookingRooms_Services.PercentTax = aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].PercentTax;
aBookingRooms_Services.Cost = aPaymentEN.aListInfoDetailPaymentEN[i].aListService[j].Cost;
aBookingRooms_Services.Status = 8;
aBookingRooms_ServicesBO.Update(aBookingRooms_Services);
}
}
}
}
}
return true;
}
catch (Exception ex)
{
return false;
throw new Exception(string.Format("ReceptionTaskBO.PaymentRoom\n" + ex.Message));
}
}
public List<RoomServiceInfoEN> Select_Service_ByCodeRoom_ByStatus(string Code, DateTime now,int Status)
{
try
{
string Sku = string.Empty;
RoomsBO aRoomsBO = new RoomsBO();
Rooms aRooms = aRoomsBO.Select_ByCodeRoom(Code,1);
if(aRooms !=null)
{
Sku = aRooms.Sku;
}
int IDBookingRoom=0;
BookingRsBO aBookingRsBO = new BookingRsBO();
List<BookingRooms> aListBookingRooms =aDatabaseDA.BookingRooms.Where(p => p.CodeRoom == Code && p.CheckInActual < now && p.CheckOutActual > now && (p.Status == 3 || p.Status == 7)).ToList();
if(aListBookingRooms.Count > 0)
{
IDBookingRoom = aListBookingRooms[0].ID;
}
List<RoomServiceInfoEN> alist = aDatabaseDA.vw__BookingRooms_ServicesInfo__BookingRooms_BookingRoomsServices_Services_ServiceGroups
.Where(p => p.BookingRooms_Services_IDBookingRoom == IDBookingRoom && p.BookingRooms_Services_Status !=Status)
.Select(p => new RoomServiceInfoEN
{
IDBookingRooms = IDBookingRoom,
IDBookingRs = p.BookingRooms_IDBookingR,
CodeRoom = Code,
Sku = Sku,
ID = p.BookingRooms_Services_ID,
Date = p.BookingRooms_Services_Date,
IDService=p.Services_ID,
ServiceName = p.Services_Name,
IDServiceGroup=p.ServiceGroups_ID,
Quantity = p.BookingRooms_Services_Quantity,
CostRef = p.Services_CostRef,
Unit = p.Services_Unit,
Cost = p.BookingRooms_Services_Cost,
PercentTax = p.BookingRooms_Services_PercentTax,
Status=p.BookingRooms_Services_Status
}).ToList();
return alist;
}
catch (Exception ex)
{
throw new Exception("BookingRooms_ServicesBO.Sel_Service_BySku\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();
}
}
// Tạm thanh toán ( Update lại BookingRMoney)
private void btnDownPayment_Click(object sender, EventArgs e)
{
try
{
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(this.IDBookingR);
aBookingRs.BookingMoney = this.aNewPaymentEN.BookingRMoney;
aBookingRs.StatusPay = 2;// Tạm ứng
int count = aBookingRsBO.Update(aBookingRs);
if (this.afrmTsk_Payment_Step1 != null)
{
this.afrmTsk_Payment_Step1.LoadListBookingR();
}
//this.LoadData();
MessageBox.Show("Thực hiện thành công !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_PaymentStep2.btnDownPayment_Click\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//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 List<CustomerInfoEN> GetDataForSelectCustomerGridview(string CodeRoom)
{
BookingRsBO aBookingRsBO = new BookingRsBO();
List<Rooms> aListRoom = aBookingRsBO.SelectListRooms_ByIDBookingR(this.aBookingRoom.IDBookingR, 1);
bool IsRoomInBookingR = false;
if (aListRoom.Where(p=>p.Code == CodeRoom).Where(p=>p.Status <7).ToList().Count == 1)
{
IsRoomInBookingR = true;
}
// Kiem tra xem phong co phai cung hoa don tong khong (cung BookingR)
if (IsRoomInBookingR == true)
{
// Kiem tra xem da co thong tin cap nhat trong aChangeRoom chua, neu chua thi lay danh sachs khach trong database
if (this.aChangeRoomEn.IsExitRoom(CodeRoom) == false)
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
int CurrentIDBookingRooms = aBookingRoomsBO.Select_ByIDBookingRsAndCodeRoom(this.aBookingRoom.IDBookingR, CodeRoom).Max(p=>p.ID);
CustomersBO aCustomersBO = new CustomersBO();
List<Customers> aList = aCustomersBO.SelectListCustomer_ByIDBookingRoom(CurrentIDBookingRooms);
List<CustomerInfoEN> aListRet = new List<CustomerInfoEN>();
for (int i = 0; i < aList.Count; i++)
{
CustomerInfoEN aItem = new CustomerInfoEN(aList[i]);
aListRet.Add(aItem);
}
return aListRet;
}
// nếu thông tin phong đã có trong khối aChangeRoom thì lấy danh sách người ở trong khối đó ra
else
{
return this.aChangeRoomEn.GetItemChangeRooms(CodeRoom).GetAllCustomers();
}
}
else
{
if (this.aChangeRoomEn.IsExitRoom(CodeRoom) == false)
{
return new List<CustomerInfoEN>();
}
// nếu thông tin phong đã có trong khối aChangeRoom thì lấy danh sách người ở trong khối đó ra
else
{
return this.aChangeRoomEn.GetItemChangeRooms(CodeRoom).GetAllCustomers();
}
}
}
//Hiennv 26/11/2014 ham dung de load toan bo du lieu theo IDBookingR
public CheckInEN InitData(int IDBookingR)
{
try
{
CheckInEN aCheckInEN = new CheckInEN();
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = new BookingRs();
aBookingRs = aBookingRsBO.Select_ByID(IDBookingR);
if(aBookingRs != null)
{
aCheckInEN.IDBookingR = aBookingRs.ID;
aCheckInEN.CustomerType = aBookingRs.CustomerType.GetValueOrDefault();
aCheckInEN.BookingType = aBookingRs.BookingType.GetValueOrDefault();
aCheckInEN.Note = aBookingRs.Note;
aCheckInEN.IDCustomerGroup = aBookingRs.IDCustomerGroup;
aCheckInEN.IDCustomer = aBookingRs.IDCustomer;
aCheckInEN.IDSystemUser = aBookingRs.IDSystemUser;
aCheckInEN.PayMenthod = aBookingRs.PayMenthod.GetValueOrDefault();
aCheckInEN.StatusPay = aBookingRs.StatusPay.GetValueOrDefault();
aCheckInEN.BookingMoney = aBookingRs.BookingMoney.GetValueOrDefault();
aCheckInEN.ExchangeRate = aBookingRs.ExchangeRate.GetValueOrDefault();
aCheckInEN.Status = aBookingRs.Status.GetValueOrDefault();
aCheckInEN.Type = aBookingRs.Type.GetValueOrDefault();
aCheckInEN.Disable = aBookingRs.Disable.GetValueOrDefault();
aCheckInEN.Level = aBookingRs.Level;
aCheckInEN.Subject = aBookingRs.Subject;
aCheckInEN.Description = aBookingRs.Description;
aCheckInEN.DatePay = aBookingRs.DatePay;
aCheckInEN.DateEdit = aBookingRs.DateEdit;
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CustomerGroups aCustomerGroups = new CustomerGroups();
aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup);
if(aCustomerGroups !=null)
{
aCheckInEN.IDCompany = aCustomerGroups.IDCompany;
}
}
RoomsBO aRoomsBO = new RoomsBO();
List<Rooms> aListRooms = new List<Rooms>();
aListRooms = aRoomsBO.Select_All();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
List<BookingRooms> aListBookingRooms = new List<BookingRooms>();
aListBookingRooms = aBookingRoomsBO.Select_ByIDBookingRs(IDBookingR);
for (int i = 0; i < aListBookingRooms.Count; i++ )
{
RoomMemberEN aRoomMemberEN = new RoomMemberEN();
aRoomMemberEN.IDBookingRooms = aListBookingRooms[i].ID;
aRoomMemberEN.RoomCode = aListBookingRooms[i].CodeRoom;
aRoomMemberEN.RoomSku = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Sku;
aRoomMemberEN.RoomType = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Type.GetValueOrDefault();
aRoomMemberEN.RoomTypeDisplay = CORE.CONSTANTS.SelectedRoomsType(aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Type.GetValueOrDefault()).Name;
aRoomMemberEN.RoomBed1 = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Bed1.GetValueOrDefault();
aRoomMemberEN.RoomBed2 = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Bed2.GetValueOrDefault();
aRoomMemberEN.RoomCostRef = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).CostRef.GetValueOrDefault();
aRoomMemberEN.RoomCost = aListBookingRooms[i].Cost.GetValueOrDefault();
aCheckInEN.InsertRoom(aRoomMemberEN);
}
return aCheckInEN;
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_CheckInForRoomBooking.InitData()\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
private List<Rooms> GetAvaiableRoom()
{
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
BookingRsBO aBookingRsBO = new BookingRsBO();
List<Rooms> aListAvaiableRooms = aReceptionTaskBO.GetListAvailableRooms(DateTime.Parse(dtpCheckIn.Text.ToString()), DateTime.Parse(dtpCheckOut.Text.ToString()), 1);
List<Rooms> aListRoomInBookingR = aBookingRsBO.SelectListRooms_ByIDBookingR(this.aBookingRoom.IDBookingR, 1);
return aListRoomInBookingR.Union(aListAvaiableRooms).ToList(); // Nối và loại trừ trùng lặp
}
//Author :Hiennv
public bool CheckInForRoomAlreadyBooking(CheckInRoomBookingEN aCheckInRoomBookingEN)
{
try
{
//========================================================
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(aCheckInRoomBookingEN.IDBookingR);
if (aBookingRs != null)
{
aBookingRs.Subject = aCheckInRoomBookingEN.Subject;
aBookingRs.Level = aCheckInRoomBookingEN.Level;
aBookingRs.Description = aCheckInRoomBookingEN.Description;
aBookingRs.Note = aCheckInRoomBookingEN.Note;
aBookingRs.IDCustomerGroup = aCheckInRoomBookingEN.IDCustomerGroup;
aBookingRs.IDCustomer = aCheckInRoomBookingEN.IDCustomer;
aBookingRs.BookingMoney = aCheckInRoomBookingEN.BookingMoney;
aBookingRs.IDSystemUser = aCheckInRoomBookingEN.IDSystemUser;
aBookingRs.BookingType = aCheckInRoomBookingEN.BookingType;
aBookingRs.Status = aCheckInRoomBookingEN.Status;
aBookingRs.StatusPay = aCheckInRoomBookingEN.StatusPay;
aBookingRs.DateEdit = DateTime.Now;
//cap nhat lai bang BookingRs
aBookingRsBO.Update(aBookingRs);
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms;
BookingRoomsMembers aBookingRoomsMembers;
foreach (RoomMemberEN aRoomMemberEN in aCheckInRoomBookingEN.aListRoomMembers)
{
aBookingRooms = new BookingRooms();
aBookingRooms = aBookingRoomsBO.Select_ByID(aRoomMemberEN.IDBookingRooms);
if (aBookingRooms != null)
{
aBookingRooms.CheckInActual = aCheckInRoomBookingEN.CheckInActual;
aBookingRooms.CheckOutActual = aCheckInRoomBookingEN.CheckOutActual;
aBookingRooms.CheckOutPlan = aCheckInRoomBookingEN.CheckOutPlan;
aBookingRooms.Status = aCheckInRoomBookingEN.Status;
aBookingRoomsBO.Update(aBookingRooms);
}
else
{
aBookingRooms = new BookingRooms();
aBookingRooms.IDBookingR = aCheckInRoomBookingEN.IDBookingR;
aBookingRooms.CodeRoom = aRoomMemberEN.RoomCode;
aBookingRooms.PercentTax = 10;
aBookingRooms.CostRef_Rooms = aRoomMemberEN.RoomCostRef;
aBookingRooms.Cost = aRoomMemberEN.RoomCostRef;
aBookingRooms.CheckInPlan = aCheckInRoomBookingEN.CheckInActual;
aBookingRooms.CheckInActual = aCheckInRoomBookingEN.CheckInActual;
aBookingRooms.CheckOutPlan = aCheckInRoomBookingEN.CheckOutPlan;
aBookingRooms.CheckOutActual = aCheckInRoomBookingEN.CheckOutActual;
aBookingRooms.StartTime = aCheckInRoomBookingEN.CheckInActual;
aBookingRooms.EndTime = aCheckInRoomBookingEN.CheckOutPlan;
aBookingRooms.BookingStatus = 1;
aBookingRooms.Status = aCheckInRoomBookingEN.Status;
aBookingRooms.Status = 1;//Tính CheckIn sớm và CheckOut muộn
//add new bookingRoom
aBookingRoomsBO.Insert(aBookingRooms);
aRoomMemberEN.IDBookingRooms = aBookingRooms.ID;
}
//-----------------------------------------------------------
aBookingRoomsMembers = new BookingRoomsMembers();
aBookingRoomsMembers.IDBookingRoom = aRoomMemberEN.IDBookingRooms;
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
foreach (CustomerInfoEN aCustomerInfoEN in aRoomMemberEN.ListCustomer)
{
aBookingRoomsMembers.IDCustomer = aCustomerInfoEN.ID;
aBookingRoomsMembers.PurposeComeVietnam = aCustomerInfoEN.PurposeComeVietnam;
aBookingRoomsMembers.DateEnterCountry = aCustomerInfoEN.DateEnterCountry;
aBookingRoomsMembers.EnterGate = aCustomerInfoEN.EnterGate;
aBookingRoomsMembers.TemporaryResidenceDate = aCustomerInfoEN.TemporaryResidenceDate;
aBookingRoomsMembers.LimitDateEnterCountry = aCustomerInfoEN.LimitDateEnterCountry;
aBookingRoomsMembers.Organization = aCustomerInfoEN.Organization;
aBookingRoomsMembers.LeaveDate = aCustomerInfoEN.LeaveDate;
//add new bookingRoomMember
aBookingRoomsMembersBO.Insert(aBookingRoomsMembers);
}
}
}
return true;
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.CheckInForRoomAlreadyBooking\n" + ex.ToString());
}
}
public bool CheckIn(CheckInEN aCheckInEN)
{
try
{
//========================================================
BookingRs aBookingRs = new BookingRs();
aBookingRs.CreatedDate = DateTime.Now;
aBookingRs.CustomerType = aCheckInEN.CustomerType;
aBookingRs.BookingType = aCheckInEN.BookingType;
aBookingRs.Note = aCheckInEN.Note;
aBookingRs.IDCustomerGroup = aCheckInEN.IDCustomerGroup;
aBookingRs.IDCustomer = aCheckInEN.IDCustomer;
aBookingRs.IDSystemUser = aCheckInEN.IDSystemUser;
aBookingRs.PayMenthod = aCheckInEN.PayMenthod;
aBookingRs.StatusPay = aCheckInEN.StatusPay;
aBookingRs.BookingMoney = aCheckInEN.BookingMoney;
aBookingRs.ExchangeRate = aCheckInEN.ExchangeRate;
aBookingRs.Status = aCheckInEN.Status;
aBookingRs.Type = aCheckInEN.Type;
aBookingRs.Disable = aCheckInEN.Disable;
aBookingRs.Level = aCheckInEN.Level;
aBookingRs.Subject = aCheckInEN.Subject;
aBookingRs.Description = aCheckInEN.Description;
aBookingRs.DatePay = aCheckInEN.DatePay;
aBookingRs.DateEdit = aCheckInEN.DateEdit;
//add new bookingRs
BookingRsBO aBookingRsBO = new BookingRsBO();
aBookingRsBO.Insert(aBookingRs);
int IDBookingR = aBookingRs.ID;
//==========================================================
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRooms aBookingRooms;
BookingRoomsMembers aBookingRoomsMembers;
for (int i = 0; i < aCheckInEN.aListRoomMembers.Count; i++)
{
aBookingRooms = new BookingRooms();
aBookingRooms.IDBookingR = IDBookingR;
aBookingRooms.CodeRoom = aCheckInEN.aListRoomMembers[i].RoomCode;
aBookingRooms.PercentTax = 10;
aBookingRooms.CostRef_Rooms = aCheckInEN.aListRoomMembers[i].RoomCostRef;
aBookingRooms.Cost = aCheckInEN.aListRoomMembers[i].RoomCostRef;
aBookingRooms.CheckInPlan = aCheckInEN.CheckInActual;
aBookingRooms.CheckInActual = aCheckInEN.CheckInActual;
aBookingRooms.CheckOutPlan = aCheckInEN.CheckOutPlan;
aBookingRooms.CheckOutActual = aCheckInEN.CheckOutActual;
aBookingRooms.StartTime = aCheckInEN.CheckInActual;
aBookingRooms.EndTime = aCheckInEN.CheckOutPlan;
aBookingRooms.BookingStatus = 1;
aBookingRooms.Type = 3; //Tính CheckIn sớm và CheckOut muộn
aBookingRooms.Status = aCheckInEN.Status;
aBookingRooms.PriceType = "G1";
//add new bookingRoom
aBookingRoomsBO.Insert(aBookingRooms);
int IDBookingRooms = aBookingRooms.ID;
aCheckInEN.aListRoomMembers[i].IDBookingRooms = IDBookingRooms;
//-----------------------------------------------------------
aBookingRoomsMembers = new BookingRoomsMembers();
aBookingRoomsMembers.IDBookingRoom = aCheckInEN.aListRoomMembers[i].IDBookingRooms;
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
for (int ii = 0; ii < aCheckInEN.aListRoomMembers[i].ListCustomer.Count; ii++)
{
aBookingRoomsMembers.IDCustomer = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].ID;
aBookingRoomsMembers.PurposeComeVietnam = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].PurposeComeVietnam;
aBookingRoomsMembers.DateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].DateEnterCountry;
aBookingRoomsMembers.EnterGate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].EnterGate;
aBookingRoomsMembers.TemporaryResidenceDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].TemporaryResidenceDate;
aBookingRoomsMembers.LimitDateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LimitDateEnterCountry;
aBookingRoomsMembers.Organization = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Organization;
aBookingRoomsMembers.LeaveDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LeaveDate;
//add new bookingRoomMember
aBookingRoomsMembersBO.Insert(aBookingRoomsMembers);
}
}
return true;
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.CheckInGoverment\n" + ex.ToString());
}
}
//Hiennv 31/08/2014 Thanh toan le cho phong
public void SplitPaymentForBookingR(NewPaymentEN aNewPaymentEN, List<BookingRoomUsedEN> aListRooms, List<ServiceUsedEN> aListServicesR)
{
try
{
foreach (ServiceUsedEN aServicesEN in aListServicesR)
{
aServicesEN.StatusPay = 8;
aServicesEN.Save(1);
}
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
foreach (BookingRoomUsedEN aBookingRoomUsedEN in aListRooms)
{
aBookingRoomUsedEN.Status = 8;//da thanh toan
aBookingRoomUsedEN.CheckOutActual = DateTime.Now;
aBookingRoomUsedEN.Save();
}
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(Convert.ToInt32(aNewPaymentEN.IDBookingR));
List<BookingRooms> aListBookingRooms = aBookingRoomsBO.Select_ByIDBookingR_ByStatus(Convert.ToInt32(aNewPaymentEN.IDBookingR), 8);
if (aListBookingRooms.Count < 1)
{
aBookingRs.ID = Convert.ToInt32(aNewPaymentEN.IDBookingR);
aBookingRs.PayMenthod = aNewPaymentEN.PayMenthodR;
aBookingRs.StatusPay = 3;
aBookingRs.Status = 8;
aBookingRs.DatePay = DateTime.Now;
}
aBookingRs.BookingMoney = aNewPaymentEN.BookingRMoney;
aBookingRsBO.Update(aBookingRs);
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.SplitPaymentForBookingR \n" + ex.ToString());
}
}
private void txtSubject_Leave(object sender, EventArgs e)
{
int IDBookingR = Convert.ToInt32(grvPaymentViewAll.GetFocusedRowCellValue("BookingRs_ID"));
string ObjectType = grvPaymentViewAll.GetFocusedRowCellValue("ObjectType").ToString();
string Subject = grvPaymentViewAll.GetFocusedRowCellValue("Subject").ToString();
if (ObjectType == "Phòng")
{
BookingRs aItem = new BookingRs();
BookingRsBO aBookingRsBO = new BookingRsBO();
aItem = aBookingRsBO.Select_ByID(IDBookingR);
aItem.Subject = Subject;
aBookingRsBO.Update(aItem);
this.LoadData();
}
else
{
BookingHs aItem = new BookingHs();
BookingHsBO aBookingHsBO = new BookingHsBO();
BookingRs_BookingHsBO aBookingRs_BookingHsBO = new BookingRs_BookingHsBO();
int IDBookingH = aBookingRs_BookingHsBO.Select_ByIDBookingR(IDBookingR).IDBookingH.GetValueOrDefault(0);
aItem = aBookingHsBO.Select_ByID(IDBookingH);
aItem.Subject = Subject;
aBookingHsBO.Update(aItem);
this.LoadData();
}
}
private void lueIDCompanies_EditValueChanged(object sender, EventArgs e)
{
try
{
if (lueIDCompanies.EditValue == null)
{
MessageBox.Show("Vui lòng chọn tên công ty.");
lueIDCompanies.Focus();
return;
}
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();
List<int> ListIDBookingR = abookingRsBO.Select_ByListCustomerGroup(aListIDCustomerGroup).Select(p => p.ID).ToList();
PaymentBO aPaymentBO = new PaymentBO();
List<sp_PaymentExt_GetAllData_Result> aListTemp = aPaymentBO.Search_ServicesStatus_ObjectStatus_BillRPaymentStatusByCompany(ListIDBookingR);
PaymentExt_GetAllDataEN aPaymentExt_GetAllDataEN;
foreach (sp_PaymentExt_GetAllData_Result item in aListTemp)
{
BookingRooms aBookingRoom = aBookingRoomBO.Select_ByIDBookingR(item.BookingRs_ID);
decimal? cost = aBookingRoom.Cost;
if (cost == null)
{
cost = 0;
}
double? addTimeStart = aBookingRoom.AddTimeStart;
if (addTimeStart == null)
{
addTimeStart = 0;
}
double? addTimeEnd = aBookingRoom.AddTimeEnd;
if (addTimeEnd == null)
{
addTimeEnd = 0;
}
decimal? timeUser = aBookingRoom.TimeInUse;
if (timeUser == null)
{
timeUser = 0;
}
double? costPendingRoom = aBookingRoom.CostPendingRoom;
if (costPendingRoom == null)
{
costPendingRoom = 0;
}
double? tax = aBookingRoom.PercentTax;
if (tax == null)
{
tax = 0;
}
decimal? sum = CalculatorMoneyRoom(cost, addTimeStart, addTimeEnd, timeUser);
// Tinh pending
aPaymentExt_GetAllDataEN = new PaymentExt_GetAllDataEN();
aPaymentExt_GetAllDataEN.SetValue(item);
if (item.IDService == null)
{
aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "";
}
else
{
aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "Đã thanh toán";
}
if (item.BillR_PaymentStatus == 8)
{
aPaymentExt_GetAllDataEN.DisplayBillR_PaymentStatus = "Đã thanh toán";
}
else
{
aPaymentExt_GetAllDataEN.DisplayBillR_PaymentStatus = "Chưa thanh toán";
}
if (item.Object_PaymentStatus == 8)
{
aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "Đã thanh toán";
}
else
{
aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "Chưa thanh toán";
}
aPaymentExt_GetAllDataEN.DisplayMoneySumRoom = sum;
aListPaymentExt_GetAllDataEN.Add(aPaymentExt_GetAllDataEN);
}
dgvPaymentViewUnPay.DataSource = aListPaymentExt_GetAllDataEN;
dgvPaymentViewUnPay.RefreshDataSource();
}
catch (Exception ex)
{
throw new Exception("frmTsk_UnPay " + ex.ToString());
}
}
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 btnDelBooking_Click(object sender, EventArgs e)
{
int BookingRs_ID = Convert.ToInt32(grvOvertimeBooking.GetFocusedRowCellValue("BookingRs_ID").ToString());
DialogResult aRet = MessageBox.Show("Có chắc bạn muốn xóa đặt phòng này không ?", "Cảnh báo", MessageBoxButtons.YesNo);
if (aRet == System.Windows.Forms.DialogResult.Yes)
{
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
List<BookingRooms> aListBookingRooms = aBookingRoomsBO.Select_ByIDBookingRs(BookingRs_ID);
int ret1 = aBookingRoomsBO.Delete(aListBookingRooms);
int ret2 = aBookingRsBO.Delete(BookingRs_ID);
if (ret2 > 0 && ret1 >0)
{
MessageBox.Show("Xóa thành công");
LoadDataForOverTimeBooking();
}
else
{
MessageBox.Show("Xóa không thành công");
}
}
}
private void btnDeleteBookingR_Click(object sender, EventArgs e)
{
BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO();
BookingRooms_ServicesBO aBookingRooms_ServicesBO = new BookingRooms_ServicesBO();
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
BookingRsBO aBookingRsBO = new BookingRsBO();
CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO();
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
BookingHsBO aBookingHsBO = new BookingHsBO();
BookingHalls_ServicesBO aBookingHalls_ServicesBO = new BookingHalls_ServicesBO();
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
MenusBO aMenusBO = new MenusBO();
Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO();
try
{
MessageBox.Show("Chức năng này sẽ xóa tất cả các phòng và hóa đơn đặt phòng đã đặt!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (this.IDBookingH == 0)
{
DialogResult result = MessageBox.Show("Xóa tất cả các phòng đã đặt. Tiếp tục?", "Xóa phòng", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
foreach (BookingRoomUsedEN item in this.aNewPaymentEN.aListBookingRoomUsed)
{
aBookingRooms_ServicesBO.DeleteListServiceUsed(item.ID);
aBookingRoomsMembersBO.DeleteListBookingRoomsMembers(item.ID);
aBookingRoomsBO.Delete(item.ID);
}
aCustomerGroups_CustomersBO.DeleteAllCustomersFromCustomerGroup_ByIDBookingRs(this.IDBookingR);
aCustomerGroupsBO.Delete_ByID(Convert.ToInt32(this.aNewPaymentEN.IDCustomerGroup));
int ret = aBookingRsBO.Delete(this.IDBookingR);
if (ret > 0)
{
MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
DialogResult result = MessageBox.Show("Xóa tất cả các phòng và hội trường đã đặt. Tiếp tục?", "Xóa hóa đơn", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
foreach (BookingRoomUsedEN item in this.aNewPaymentEN.aListBookingRoomUsed)
{
aBookingRooms_ServicesBO.DeleteListServiceUsed(item.ID);
aBookingRoomsMembersBO.DeleteListBookingRoomsMembers(item.ID);
aBookingRoomsBO.Delete(item.ID);
}
aCustomerGroups_CustomersBO.DeleteAllCustomersFromCustomerGroup_ByIDBookingRs(this.IDBookingR);
aCustomerGroupsBO.Delete_ByID(Convert.ToInt32(this.aNewPaymentEN.IDCustomerGroup));
aBookingRsBO.Delete(this.IDBookingR);
foreach (BookingHallUsedEN item1 in this.aNewPaymentEN.aListBookingHallUsed)
{
aBookingHalls_ServicesBO.DeleteListServiceUsed(item1.ID);
aBookingHallsBO.Delete(item1.ID);
foreach (MenusEN aMenu in item1.aListMenuEN)
{
aMenusBO.Delete(aMenu.ID);
aMenus_FoodsBO.Delete_ByIDMenu(aMenu.ID);
}
}
int ret = aBookingHsBO.Delete(this.IDBookingH);
if (ret > 0)
{
MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
this.Close();
if (this.afrmMain != null)
{
this.afrmMain.ReloadData();
}
else if (this.afrmMain_Halls != null)
{
this.afrmMain_Halls.ReloadData();
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_UpdBookingHall.btnDeleteBookingRs\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//hiennv
private void btnNext_Click(object sender, EventArgs e)
{
try
{
if (this.aCheckInRoomBookingEN.aListRoomMembers.Count > 0)
{
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = aBookingRsBO.Select_ByID(this.IDBookingRs);
if (aBookingRs !=null)
{
this.aCheckInRoomBookingEN.IDCustomer = aBookingRs.IDCustomer;
this.aCheckInRoomBookingEN.IDCustomerGroup = aBookingRs.IDCustomerGroup;
this.aCheckInRoomBookingEN.Subject = aBookingRs.Subject;
this.aCheckInRoomBookingEN.Level = aBookingRs.Level;
this.aCheckInRoomBookingEN.Description = aBookingRs.Description;
this.aCheckInRoomBookingEN.Note = aBookingRs.Note;
CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO();
CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup);
if (aCustomerGroups !=null)
{
this.aCheckInRoomBookingEN.IDCompany = aCustomerGroups.IDCompany;
}
}
this.aCheckInRoomBookingEN.IDBookingR = this.IDBookingRs;
this.aCheckInRoomBookingEN.CheckInActual = dtpFrom.DateTime;
this.aCheckInRoomBookingEN.CheckOutActual = dtpTo.DateTime;
this.aCheckInRoomBookingEN.CheckOutPlan = dtpTo.DateTime;
frmTsk_CheckInGoverment_ForRoomBooking_Step2 afrmTsk_CheckInGoverment_ForRoomBooking_Step2 = new frmTsk_CheckInGoverment_ForRoomBooking_Step2(this, this.aCheckInRoomBookingEN);
afrmTsk_CheckInGoverment_ForRoomBooking_Step2.ShowDialog();
}
else
{
MessageBox.Show("Vui lòng chọn phòng trước khi thực hiện bước tiếp theo !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_CheckInGoverment_ForRoomBooking_Step1.btnNext_Click\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnBook_Click(object sender, EventArgs e)
{
try
{
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
if (this.ValidateData() == true)
{
//Truyền dữ liệu BookingH
this.aNewBookingHEN.Subject = txtSubject.Text;
this.aNewBookingHEN.CreatedDate = dtpFrom.DateTime;
this.aNewBookingHEN.CustomerType = this.CustomerType;
this.aNewBookingHEN.BookingType = 3;//3 : Đặt trực tiếp
if (txtBookingMoney.Text == "")
{
this.aNewBookingHEN.BookingMoney = 0;
this.aNewBookingHEN.StatusPay = 1;//1 : Trạng thái chưa thanh toán
}
else
{
this.aNewBookingHEN.BookingMoney = this.aNewBookingHEN.BookingMoney = Convert.ToDecimal(txtBookingMoney.Text);
this.aNewBookingHEN.StatusPay = 2;//2 : Trạng thái tạm ứng
}
this.aNewBookingHEN.Status = 2;//2: Trạng thái đã xác thực
this.aNewBookingHEN.PayMenthod = 1;
if (cbbType.EditValue.ToString().ToUpper() == "NGOÀI NẤU")
{
this.aNewBookingHEN.Type = 1;//1: Tiệc KHÔNG thuộc phạm trù bếp
}
else if (cbbType.EditValue.ToString().ToUpper() == "BẾP NẤU")
{
this.aNewBookingHEN.Type = 2;//2: Tiệc thuộc phạm trù bếp
}
this.aNewBookingHEN.Disable = false;
this.aNewBookingHEN.Description = "";
string CustomerGroupName;
if (Convert.ToInt32(lueCompany.EditValue) == 0)
{
this.IDCompany = this.aCompaniesBO.AutoInsertCompany(txtCompanyName.Text, 3);// 3 : Loại khách lẻ
if (lueCustomer.Text == "")
{
if (txtSubject.Text == "")
{
CustomerGroupName = "[" + txtCompanyName.Text + "][" + DateTime.Now.ToShortDateString() + "]" + "[" + txtCustomerName.Text + "]";
}
else
{
CustomerGroupName = txtSubject.Text;
}
}
else
{
if (txtSubject.Text == "")
{
CustomerGroupName = "[" + txtCompanyName.Text + "][" + DateTime.Now.ToShortDateString() + "]" + "[" + lueCustomer.Text + "]";
}
else
{
CustomerGroupName = txtSubject.Text;
}
}
this.IDCustomerGroup = this.aCustomerGroupsBO.AutoInsertCustomerGroup(CustomerGroupName, IDCompany);
}
else
{
this.IDCompany = Convert.ToInt32(lueCompany.EditValue);
if (lueCustomer.Text == "")
{
if (txtSubject.Text == "")
{
CustomerGroupName = "[" + txtCompanyName.Text + "][" + DateTime.Now.ToShortDateString() + "]" + "[" + txtCustomerName.Text + "]";
}
else
{
CustomerGroupName = txtSubject.Text;
}
}
else
{
if (txtSubject.Text == "")
{
CustomerGroupName = "[" + txtCompanyName.Text + "][" + DateTime.Now.ToShortDateString() + "]" + "[" + lueCustomer.Text + "]";
}
else
{
CustomerGroupName = txtSubject.Text;
}
}
this.IDCustomerGroup = this.aCustomerGroupsBO.AutoInsertCustomerGroup(CustomerGroupName, Convert.ToInt32(lueCompany.EditValue));
}
if (Convert.ToInt32(lueCustomer.EditValue) == 0)
{
this.IDCustomer = this.aCustomersBO.AutoInsertCustomer(txtCustomerName.Text, this.IDCustomerGroup, txtPhoneNumber.Text, DateTime.Now);
}
else
{
CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO();
this.IDCustomer = Convert.ToInt32(lueCustomer.EditValue);
aCustomerGroups_CustomersBO.AutoInsertCustomerToGroup(IDCustomer, this.IDCustomerGroup, dtpFrom.DateTime);
}
this.aNewBookingHEN.Disable = false;
this.aNewBookingHEN.IDCustomer = this.IDCustomer;
this.aNewBookingHEN.IDSystemUser = CORE.CURRENTUSER.SystemUser.ID;
this.aNewBookingHEN.IDCustomerGroup = this.IDCustomerGroup;
//===============================================================================
// Ngoc edit. All BookingR and BookingH join together
// Tao them 1 bookingR neu chua co
//===============================================================================
if (this.IDBookingR == 0)
{
BookingRsBO aBookingRsBO = new BookingRsBO();
BookingRs aBookingRs = new BookingRs();
aBookingRs.CreatedDate = this.aNewBookingHEN.CreatedDate;
aBookingRs.ID = 0;
aBookingRs.CustomerType = this.aNewBookingHEN.CustomerType;
aBookingRs.IDCustomer = this.aNewBookingHEN.IDCustomer;
aBookingRs.IDCustomerGroup = this.aNewBookingHEN.IDCustomerGroup;
aBookingRs.DatePay = Convert.ToDateTime("01/01/1900");
aBookingRs.DateEdit = Convert.ToDateTime("01/01/1900");
aBookingRs.IDSystemUser = this.aNewBookingHEN.IDSystemUser;
aBookingRs.Type = 0;
aBookingRs.Status = 0;
aBookingRs.Disable = true;
aBookingRs.Level = -1;
this.IDBookingR = aBookingRsBO.Insert(aBookingRs);
}
//===============================================================================
this.IDBookingH = aReceptionTaskBO.NewBookHall(this.aNewBookingHEN);
if (this.IDBookingR != 0)
{
BookingRs_BookingHsBO aBookingRs_BookingHsBO = new BookingRs_BookingHsBO();
BookingRs_BookingHs aBookingRs_BookingHs = new BookingRs_BookingHs();
aBookingRs_BookingHs.IDBookingR = this.IDBookingR;
aBookingRs_BookingHs.IDBookingH = this.IDBookingH;
aBookingRs_BookingHs.Type = String.Empty;
aBookingRs_BookingHs.Status = String.Empty;
aBookingRs_BookingHs.Disable = false;
aBookingRs_BookingHs.Extension1 = String.Empty;
aBookingRs_BookingHs.Extension2 = String.Empty;
aBookingRs_BookingHs.Extension3 = String.Empty;
aBookingRs_BookingHsBO.Insert(aBookingRs_BookingHs);
}
MessageBox.Show("Đặt hội trường thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (afrmMain_Halls != null)
{
this.afrmMain_Halls.Reload();
}
if (afrmTsk_Payment_Step2 != null)
{
this.afrmTsk_Payment_Step2.Reload();
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_BookingHall_Customer_New.btnBook_Click\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//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;
}
}