public void SetValue(BookingHalls aTemp)
{
this.ID = aTemp.ID;
this.CodeHall = aTemp.CodeHall;
this.Cost = aTemp.Cost;
this.PercentTax = aTemp.PercentTax;
this.CostRef_Halls = aTemp.CostRef_Halls;
this.Date = aTemp.Date;
this.LunarDate = aTemp.LunarDate;
this.BookingStatus = aTemp.BookingStatus;
this.Unit = aTemp.Unit;
this.TableOrPerson = aTemp.TableOrPerson;
this.Note = aTemp.Note;
this.Status = aTemp.Status;
this.Location = aTemp.Location;
this.StartTime = aTemp.StartTime;
this.EndTime = aTemp.EndTime;
this.IsAllDayEvent = aTemp.IsAllDayEvent;
this.Color = aTemp.Color;
this.IsRecurring = aTemp.IsRecurring;
this.IsEditable = aTemp.IsEditable;
this.AdditionalColumn1 = aTemp.AdditionalColumn1;
this.IDBookingH = aTemp.IDBookingH;
this.IndexSubPayment = aTemp.IndexSubPayment;
this.AcceptDate = aTemp.AcceptDate;
this.InvoiceDate = aTemp.InvoiceDate;
this.InvoiceNumber = aTemp.InvoiceNumber;
//this.TotalMoney = this.GetTotalMoneyHall();
//this.MoneyHallBeforeTax = this.GetOnlyMoneyHallBeforeTax();
//this.MoneyHall = this.GetOnlyMoneyHall();
}
private void simpleButton1_Click(object sender, EventArgs e)
{
try
{
if (ValidateData() == true)
{
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
//Add du lieu cho BookingH
BookingHs aBookingHs = new BookingHs();
aBookingHs.ID = IDBookingH;
aBookingHs.Subject = txtSubject.Text;
aBookingHs.CreatedDate = this.aBookingHs.CreatedDate;
aBookingHs.CustomerType = this.aBookingHs.CustomerType;
aBookingHs.BookingType = Convert.ToInt16(lueBookingType.EditValue);
aBookingHs.Note = txtNote.Text;
aBookingHs.IDGuest = Convert.ToInt16(lueGuest.EditValue);
if (txtBookingMoney.Text == "")
{
aBookingHs.BookingMoney = 0;
lueStatusPay.EditValue = CORE.CONSTANTS.SelectedStatusPay(1).ID;
}
else
{
aBookingHs.BookingMoney = Convert.ToDecimal(txtBookingMoney.Text);
lueStatusPay.EditValue = CORE.CONSTANTS.SelectedStatusPay(2).ID;
}
aBookingHs.StatusPay = Convert.ToInt16(lueStatusPay.EditValue);
aBookingHs.Status = Convert.ToInt16(lueBookingStatus.EditValue);
aBookingHs.PayMenthod = 1;
if (cbbType.Text == "Tiệc không thuộc phạm trù nhà bếp")
{
aBookingHs.Type = 1;
}
else
{
aBookingHs.Type = 2;
}
aBookingHs.Disable = false;
aBookingHs.Level = Convert.ToInt16(lueLevel.EditValue);
aBookingHs.Description = "";
aBookingHs.IDCustomer = Convert.ToInt16(lueCustomer.EditValue);
aBookingHs.IDCustomerGroup = Convert.ToInt16(lueCustomerGroup.EditValue);
aBookingHs.IDSystemUser = 1;// Để tạm
//Add du lieu cho BookingHall
List<BookingHalls> aListBookingHall = new List<BookingHalls>();
BookingHalls aTemp;
for (int i = 0; i < aListSelected.Count; i++)
{
aTemp = new BookingHalls();
aTemp.CodeHall = aListSelected[i].Code;
aTemp.Cost = aListSelected[i].Cost;
aTemp.PercentTax = 10;
aTemp.CostRef_Halls = aListSelected[i].CostRef;
aTemp.Date = dtpFrom.DateTime;
IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true);
//DateTime Lunardate = DateTime.ParseExact(LunarDateExt.ToLunarDate(dtpFrom.DateTime, 7).ToString(), "dd/MM/yyyy", theCultureInfo);
//aTemp.LunarDate = Lunardate;
aTemp.BookingStatus = null;
aTemp.Unit = aListSelected[i].Unit;
aTemp.TableOrPerson = aListSelected[i].TableOrPerson;
aTemp.Note = "";
aTemp.Status = Convert.ToInt16(lueBookingStatus.EditValue);
aTemp.StartTime = !string.IsNullOrEmpty(tedStart.Time.ToString()) ? tedStart.Time.TimeOfDay : TimeSpan.Zero;
aTemp.EndTime = !string.IsNullOrEmpty(tedEnd.Time.ToString()) ? tedEnd.Time.TimeOfDay : TimeSpan.Zero;
aListBookingHall.Add(aTemp);
}
aReceptionTaskBO.UpdateCheckIn(aBookingHs, aListBookingHall);
if (afrmTsk_ManageBookingHs != null)
{
afrmTsk_ManageBookingHs.ReloadData();
}
else if (afrmMain_Halls != null)
{
afrmMain_Halls.ReloadData();
}
MessageBox.Show("Đặt hội trường thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_UpdBooking.CheckIn\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Author: Linhting
public void InsertUnSync(BookingHalls bookingHalls)
{
try
{
aDatabaseDA.BookingHalls.Add(bookingHalls);
aDatabaseDA.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("BookingHallsBO.InsertUnSync:" + ex.ToString());
}
}
//Author: Linhting
public int Insert(BookingHalls bookingHalls)
{
try
{
BookingHsBO aBookingHsBO = new BookingHsBO();
aDatabaseDA.BookingHalls.Add(bookingHalls);
aBookingHsBO.AutoChangeStatusBookingH(bookingHalls.IDBookingH);
return aDatabaseDA.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("BookingHallsBO.Insert:" + ex.ToString());
}
}
private void btnCheckIn_Click(object sender, System.EventArgs e)
{
try
{
if (ValidateData() == true)
{
ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO();
//Add du lieu cho BookingH
BookingHs aBookingHs = new BookingHs();
aBookingHs.Subject = txtSubject.Text;
aBookingHs.CreatedDate = DateTime.Now;
aBookingHs.CustomerType = 2;
aBookingHs.BookingType = Convert.ToInt32(lueBookingType.EditValue);
aBookingHs.Note = txtNote.Text;
aBookingHs.IDGuest = Convert.ToInt32(lueGuest.EditValue);
if (txtBookingMoney.Text == "")
{
aBookingHs.BookingMoney = 0;
lueStatusPay.EditValue = CORE.CONSTANTS.SelectedStatusPay(1).ID;
}
else
{
aBookingHs.BookingMoney = Convert.ToDecimal(txtBookingMoney.Text);
lueStatusPay.EditValue = CORE.CONSTANTS.SelectedStatusPay(2).ID;
}
aBookingHs.StatusPay = Convert.ToInt32(lueStatusPay.EditValue);
aBookingHs.Status = Convert.ToInt32(lueBookingStatus.EditValue);
aBookingHs.PayMenthod = 1;
if (cbbType.Text == "Tiệc không thuộc phạm trù nhà bếp")
{
aBookingHs.Type = 1;
}
else
{
aBookingHs.Type = 2;
}
aBookingHs.Disable = false;
aBookingHs.Description = "";
aBookingHs.IDCustomer = Convert.ToInt32(lueCustomer.EditValue);
aBookingHs.IDCustomerGroup = Convert.ToInt32(lueCustomerGroup.EditValue);
aBookingHs.IDSystemUser = CORE.CURRENTUSER.SystemUser.ID;
//Add du lieu cho BookingHall
List<BookingHalls> aListBookingHall = new List<BookingHalls>();
BookingHalls aTemp;
for (int i = 0; i < aListSelected.Count; i++)
{
aTemp = new BookingHalls();
aTemp.CodeHall = aListSelected[i].Code;
aTemp.Cost = aListSelected[i].Cost;
aTemp.PercentTax = 10;
aTemp.CostRef_Halls = aListSelected[i].CostRef;
aTemp.Date = DateTime.Now;
IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true);
DateTime Lunardate = DateTime.ParseExact(Convert.ToString(LunarDateExt.ToLunarDate(DateTime.Now, 7)), "d/M/yyyy", theCultureInfo);
aTemp.LunarDate = Lunardate;
aTemp.BookingStatus = null;
aTemp.Unit = aListSelected[i].Unit;
aTemp.TableOrPerson = aListSelected[i].TableOrPerson;
aTemp.Note = "";
aTemp.Status = Convert.ToInt32(lueBookingStatus.EditValue);
aTemp.StartTime = !string.IsNullOrEmpty(tedStart.Time.ToString()) ? tedStart.Time.TimeOfDay : TimeSpan.Zero;
aTemp.EndTime = !string.IsNullOrEmpty(tedEnd.Time.ToString()) ? tedEnd.Time.TimeOfDay : TimeSpan.Zero;
aListBookingHall.Add(aTemp);
}
this.IDBookingH = aReceptionTaskBO.CheckIn(aBookingHs, aListBookingHall);
//Hiennv
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);
DialogResult result = MessageBox.Show("Bạn có thêm dịch vụ cho hội trường " + aBookingHs.Subject + " này không?", "Thêm dịch vụ hội trường", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
//frmTsk_Payment_Step2 afrmTsk_Payment_Step2 = new frmTsk_Payment_Step2(Convert.ToInt32(this.IDBookingR), Convert.ToInt32(this.IDBookingH));
//afrmTsk_Payment_Step2.ShowDialog();
}
if (afrmMain_Halls != null)
{
this.afrmMain_Halls.ReloadData();
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_BookingHall_Group.CheckIn\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Author: Linhting
public int CheckIn(BookingHs BookingHs, List<BookingHalls> ListBookingHalls)
{
try
{
BookingHs aBookingHs = new BookingHs();
aBookingHs.CreatedDate = BookingHs.CreatedDate;
aBookingHs.CustomerType = BookingHs.CustomerType;
aBookingHs.BookingType = BookingHs.BookingType;
aBookingHs.Note = BookingHs.Note;
aBookingHs.IDGuest = BookingHs.IDGuest;
aBookingHs.StatusPay = BookingHs.StatusPay;
aBookingHs.BookingMoney = BookingHs.BookingMoney;
aBookingHs.Status = BookingHs.Status;
aBookingHs.Type = BookingHs.Type;
aBookingHs.Disable = BookingHs.Disable;
aBookingHs.Level = BookingHs.Level;
aBookingHs.Subject = BookingHs.Subject;
aBookingHs.IDCustomerGroup = BookingHs.IDCustomerGroup;
aBookingHs.IDCustomer = BookingHs.IDCustomer;
aBookingHs.IDSystemUser = BookingHs.IDSystemUser;
aBookingHs.Description = BookingHs.Description;
//add new bookingRs
BookingHsBO aBookingHsBO = new BookingHsBO();
int IDBookingH = aBookingHsBO.InsertUnSync(aBookingHs);
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
BookingHalls aBookingHall;
for (int i = 0; i < ListBookingHalls.Count; i++)
{
aBookingHall = new BookingHalls();
aBookingHall.IDBookingH = IDBookingH;
aBookingHall.CodeHall = ListBookingHalls[i].CodeHall;
aBookingHall.Cost = ListBookingHalls[i].Cost;
aBookingHall.PercentTax = ListBookingHalls[i].PercentTax;
aBookingHall.CostRef_Halls = ListBookingHalls[i].CostRef_Halls;
aBookingHall.Date = ListBookingHalls[i].Date;
aBookingHall.LunarDate = ListBookingHalls[i].LunarDate;
aBookingHall.BookingStatus = ListBookingHalls[i].BookingStatus;
aBookingHall.Unit = ListBookingHalls[i].Unit;
aBookingHall.TableOrPerson = ListBookingHalls[i].TableOrPerson;
aBookingHall.Note = ListBookingHalls[i].Note;
aBookingHall.Status = ListBookingHalls[i].Status;
aBookingHall.StartTime = ListBookingHalls[i].StartTime;
aBookingHall.EndTime = ListBookingHalls[i].EndTime;
aBookingHall.Location = ListBookingHalls[i].Location;
aBookingHall.Color = ListBookingHalls[i].Color;
aBookingHallsBO.InsertUnSync(aBookingHall);
}
return IDBookingH;
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.CheckIn\n" + ex.ToString());
}
}
//Linhting - Book hội trường mới
public int NewBookHall(NewBookingHEN aNewBookingHEN)
{
try
{
BookingHalls_ServicesBO aBookingHalls_ServicesBO = new BookingHalls_ServicesBO();
//Tạo BookingH mới
BookingHs aBookingHs = new BookingHs();
aBookingHs.CreatedDate = aNewBookingHEN.CreatedDate;
aBookingHs.CustomerType = aNewBookingHEN.CustomerType;
aBookingHs.BookingType = aNewBookingHEN.BookingType;
aBookingHs.Note = aNewBookingHEN.Note;
aBookingHs.IDGuest = 0;
aBookingHs.StatusPay = aNewBookingHEN.StatusPay;
aBookingHs.BookingMoney = aNewBookingHEN.BookingMoney;
aBookingHs.Status = aNewBookingHEN.Status;
aBookingHs.Type = aNewBookingHEN.Type;
aBookingHs.Disable = aNewBookingHEN.Disable;
aBookingHs.Level = aNewBookingHEN.Level;
aBookingHs.Subject = aNewBookingHEN.Subject;
aBookingHs.IDCustomerGroup = aNewBookingHEN.IDCustomerGroup;
aBookingHs.IDCustomer = aNewBookingHEN.IDCustomer;
aBookingHs.IDSystemUser = aNewBookingHEN.IDSystemUser;
aBookingHs.Description = aNewBookingHEN.Description;
//Tạo BookingHall mới
BookingHsBO aBookingHsBO = new BookingHsBO();
int IDBookingH = aBookingHsBO.InsertUnSync(aBookingHs);
BookingHallsBO aBookingHallsBO = new BookingHallsBO();
BookingHalls aBookingHall;
for (int i = 0; i < aNewBookingHEN.aListBookingHallUsed.Count; i++)
{
aBookingHall = new BookingHalls();
aBookingHall.IDBookingH = IDBookingH;
aBookingHall.CodeHall = aNewBookingHEN.aListBookingHallUsed[i].CodeHall;
aBookingHall.Cost = aNewBookingHEN.aListBookingHallUsed[i].Cost;
aBookingHall.PercentTax = 10; //Để tạm thuế = 10%
aBookingHall.CostRef_Halls = aNewBookingHEN.aListBookingHallUsed[i].CostRef_Halls;
aBookingHall.Date = aNewBookingHEN.aListBookingHallUsed[i].Date;
aBookingHall.LunarDate = aNewBookingHEN.aListBookingHallUsed[i].LunarDate;
aBookingHall.BookingStatus = aNewBookingHEN.aListBookingHallUsed[i].BookingStatus;
aBookingHall.Unit = aNewBookingHEN.aListBookingHallUsed[i].Unit;
aBookingHall.TableOrPerson = aNewBookingHEN.aListBookingHallUsed[i].TableOrPerson;
aBookingHall.Note = aNewBookingHEN.aListBookingHallUsed[i].Note;
aBookingHall.Status = aNewBookingHEN.aListBookingHallUsed[i].Status;
aBookingHall.StartTime = aNewBookingHEN.aListBookingHallUsed[i].StartTime;
aBookingHall.EndTime = aNewBookingHEN.aListBookingHallUsed[i].EndTime;
aBookingHall.Location = aNewBookingHEN.aListBookingHallUsed[i].Location;
aBookingHall.Color = aNewBookingHEN.aListBookingHallUsed[i].Color;
aBookingHallsBO.InsertUnSync(aBookingHall);
int IDBookingHall = aBookingHall.ID;
// Thêm dịch vụ đã chọn vào hội trường
foreach (ServiceUsedEN aTemp in aNewBookingHEN.aListBookingHallUsed[i].aListServiceUsed)
{
BookingHalls_Services aBookingHalls_Services = new BookingHalls_Services();
aBookingHalls_Services.Info = "";
aBookingHalls_Services.Type = 1;
aBookingHalls_Services.Status = 1;
aBookingHalls_Services.Disable = false;
aBookingHalls_Services.IDBookingHall = aBookingHall.ID;
aBookingHalls_Services.IDService = aTemp.IDService;
aBookingHalls_Services.Cost = aTemp.Cost;
aBookingHalls_Services.Date = aTemp.DateUsed;
aBookingHalls_Services.CostRef_Services = aTemp.CostRef_Service;
aBookingHalls_Services.PercentTax = 10;// de mac dinh
aBookingHalls_Services.Quantity = aTemp.Quantity;
aBookingHalls_ServicesBO.Insert(aBookingHalls_Services);
}
// Thêm thực đơn vào hội trường
foreach (MenusEN aMenuEN in aNewBookingHEN.aListBookingHallUsed[i].aListMenuEN)
{
aMenuEN.IDBookingHall = IDBookingHall;
aMenuEN.Type = 1; // type =1 ; thuc don mau ; Type 2: thuc don moi
aMenuEN.Status = 1; // de tam
aMenuEN.Disable = false; // de tam
aMenuEN.IDSystemUser = 1;//Khi kinh doanh thêm thực đơn mặc định trạng thái là 0 - đã xác nhận thực đơn
this.CreateMenus(aMenuEN);
}
}
return IDBookingH;
}
catch (Exception ex)
{
throw new Exception("ReceptionTaskBO.NewBookHall\n" + ex.ToString());
}
}