public void DeleteServiceUsed(int IDBookingHallService)
{
DatabaseDA aDatabaseDA = new DatabaseDA();
BookingHalls_Services aBookingHalls_Services = aDatabaseDA.BookingHalls_Services.Where(a => a.ID == IDBookingHallService).ToList()[0];
if (aBookingHalls_Services != null)
{
aDatabaseDA.BookingHalls_Services.Remove(aBookingHalls_Services);
aDatabaseDA.SaveChanges();
}
}
// Ngocbm
public List<vw__BookingRInfo__BookingRooms_Room_Customers_CustomerGroups> SelectListInfoCustomer_ByIDBookingR(int IDBookingR)
{
DatabaseDA aDatabaseDA = new DatabaseDA();
return aDatabaseDA.vw__BookingRInfo__BookingRooms_Room_Customers_CustomerGroups.Where(p => p.BookingRooms_IDBookingR == IDBookingR).ToList();
}
public int Save()
{
try
{
DatabaseDA aDatabaseDA = new DatabaseDA();
BookingRooms aTemp = aDatabaseDA.BookingRooms.Where(a => a.ID == this.ID).ToList()[0];
aTemp.ID = this.ID;
aTemp.IDBookingR = this.IDBookingR;
aTemp.CodeRoom = this.CodeRoom;
aTemp.Cost = this.Cost;
aTemp.PercentTax = this.PercentTax;
aTemp.CostRef_Rooms = this.CostRef_Rooms;
aTemp.Note = this.Note;
aTemp.CheckInPlan = this.CheckInPlan;
aTemp.CheckInActual = this.CheckInActual;
aTemp.CheckOutPlan = this.CheckOutPlan;
aTemp.CheckOutActual = this.CheckOutActual;
aTemp.BookingStatus = this.BookingStatus;
aTemp.Status = this.Status;
aTemp.StartTime = this.StartTime;
aTemp.EndTime = this.EndTime;
aTemp.IsAllDayEvent = this.IsAllDayEvent;
aTemp.Color = this.Color;
aTemp.IsRecurring = this.IsRecurring;
aTemp.IsEditable = this.IsEditable;
aTemp.AdditionalColumn1 = this.AdditionalColumn1;
aTemp.CostPendingRoom = this.CostPendingRoom;
aTemp.TimeInUse = this.TimeInUse;
aTemp.AddTimeStart = this.AddTimeStart;
aTemp.AddTimeEnd = this.AddTimeEnd;
aTemp.Type = this.Type;
//aTemp.Type = this.SetBookingRoomType(this.IsCheckInEarly, this.IsCheckOutLate);
aTemp.Disable = this.Disable;
aTemp.IndexSubPayment = this.IndexSubPayment;
aTemp.AcceptDate = this.AcceptDate;
aTemp.InvoiceDate = this.InvoiceDate;
aTemp.InvoiceNumber = this.InvoiceNumber;
foreach (ServiceUsedEN item in this.ListServiceUsed)
{
item.Save(1);
}
aTemp.PriceType = this.PriceType;
aDatabaseDA.BookingRooms.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
return 0;
}
catch (Exception e)
{
return 1;
//throw new Exception("Lỗi khi insert...");
}
}
public void Save()
{
try
{
DatabaseDA aDatabaseDA = new DatabaseDA();
BookingHalls aTemp = aDatabaseDA.BookingHalls.Where(a => a.ID == this.ID).ToList()[0];
if (aTemp != null)
{
aTemp.ID = this.ID;
aTemp.CodeHall = this.CodeHall;
aTemp.Cost = this.Cost;
aTemp.PercentTax = this.PercentTax;
aTemp.CostRef_Halls = this.CostRef_Halls;
aTemp.Date = this.Date;
aTemp.LunarDate = this.LunarDate;
aTemp.BookingStatus = this.BookingStatus;
aTemp.Unit = this.Unit;
aTemp.TableOrPerson = this.TableOrPerson;
aTemp.Note = this.Note;
aTemp.Status = this.Status;
aTemp.Location = this.Location;
aTemp.StartTime = this.StartTime;
aTemp.EndTime = this.EndTime;
aTemp.IsAllDayEvent = this.IsAllDayEvent;
aTemp.Color = this.Color;
aTemp.IsRecurring = this.IsRecurring;
aTemp.IsEditable = this.IsEditable;
aTemp.AdditionalColumn1 = this.AdditionalColumn1;
aTemp.IDBookingH = this.IDBookingH;
aTemp.IndexSubPayment = this.IndexSubPayment;
aTemp.AcceptDate = this.AcceptDate;
aTemp.InvoiceDate = this.InvoiceDate ;
aTemp.InvoiceNumber = this.InvoiceNumber;
foreach (ServiceUsedEN item in this.aListServiceUsed)
{
item.Save(2);
}
aDatabaseDA.BookingHalls.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(string.Format("BookingHallUsedEN.Save :" + ex.Message.ToString()));
}
}
public void PaymentHall()
{
DatabaseDA aDatabaseDA = new DatabaseDA();
if (aDatabaseDA.BookingHs.Where(a => a.ID == IDBookingH).ToList().Count > 0)
{
BookingHs aTemp = aDatabaseDA.BookingHs.Where(a => a.ID == IDBookingH).ToList()[0];
aTemp.CreatedDate = this.CreatedDate_BookingH;
aTemp.Status = 8;
aTemp.BookingMoney = this.BookingHMoney;
aTemp.InvoiceDate = this.InvoiceDate;
aTemp.InvoiceNumber = this.InvoiceNumber;
aTemp.DatePay = DateTime.Now;
aDatabaseDA.BookingHs.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
foreach (BookingHallUsedEN item in this.aListBookingHallUsed)
{
foreach (ServiceUsedEN item1 in item.aListServiceUsed)
{
item1.StatusPay = 8;
}
item.Status = 8;
item.Save();
}
}
}
public void Save(int ServiceType)
{
try
{
DatabaseDA aDatabaseDA = new DatabaseDA();
if (ServiceType == 1)
{
if (aDatabaseDA.BookingRooms_Services.Where(b => b.ID == this.IDBookingService).ToList().Count > 0 )
{
BookingRooms_Services aTemp = aDatabaseDA.BookingRooms_Services.Where(b => b.ID == this.IDBookingService).ToList()[0];
aTemp.Cost = this.Cost;
aTemp.CostRef_Services = this.CostRef_Service;
aTemp.Date = this.DateUsed;
aTemp.PercentTax = this.Tax;
aTemp.Quantity = this.Quantity;
aTemp.Status = this.StatusPay;
aTemp.ID = this.IDBookingService;
aTemp.IndexSubPayment = this.IndexSubPayment;
aTemp.AcceptDate = this.AcceptDate;
aTemp.InvoiceDate = this.InvoiceDate;
aTemp.InvoiceNumber = this.InvoiceNumber;
aDatabaseDA.BookingRooms_Services.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
}
}
else if (ServiceType == 2)
{
if (aDatabaseDA.BookingHalls_Services.Where(b => b.ID == this.IDBookingService).ToList().Count > 0)
{
BookingHalls_Services aTemp = aDatabaseDA.BookingHalls_Services.Where(b => b.ID == this.IDBookingService).ToList()[0];
aTemp.Cost = this.Cost;
aTemp.CostRef_Services = this.CostRef_Service;
aTemp.Date = this.DateUsed;
aTemp.PercentTax = this.Tax;
aTemp.Quantity = this.Quantity;
aTemp.Status = this.StatusPay;
aTemp.ID = this.IDBookingService;
aTemp.IndexSubPayment = this.IndexSubPayment;
aTemp.AcceptDate = this.AcceptDate;
aTemp.InvoiceDate = this.InvoiceDate;
aTemp.InvoiceNumber = this.InvoiceNumber;
aDatabaseDA.BookingHalls_Services.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
}
}
}
catch (Exception ex)
{
throw new Exception(string.Format("ServiceUsedEN.Save :" + ex.Message.ToString()));
}
}
public void PaymentTotal()
{
if (this.aListBookingHallUsed.Count > 0)
{
this.PaymentHall();
DatabaseDA aDatabaseDA = new DatabaseDA();
if (aDatabaseDA.BookingRs.Where(a => a.ID == IDBookingR).ToList().Count > 0)
{
BookingRs aTemp = aDatabaseDA.BookingRs.Where(a => a.ID == IDBookingR).ToList()[0];
aTemp.DatePay = DateTime.Now;
aTemp.Status = 8;
aTemp.InvoiceDate = this.InvoiceDate;
aTemp.InvoiceNumber = this.InvoiceNumber;
aTemp.BookingMoney = this.BookingRMoney;
aDatabaseDA.BookingRs.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
foreach (BookingRoomUsedEN item in this.aListBookingRoomUsed)
{
foreach (ServiceUsedEN item1 in item.ListServiceUsed)
{
item1.StatusPay = 8;
}
item.Status = 8;
item.CheckOutActual = DateTime.Now;
item.Save();
}
}
}
else
{
DatabaseDA aDatabaseDA = new DatabaseDA();
if (aDatabaseDA.BookingRs.Where(a => a.ID == IDBookingR).ToList().Count > 0)
{
BookingRs aTemp = aDatabaseDA.BookingRs.Where(a => a.ID == IDBookingR).ToList()[0];
aTemp.DatePay = DateTime.Now;
aTemp.Status = 8;
aTemp.InvoiceDate = this.InvoiceDate;
aTemp.InvoiceNumber = this.InvoiceNumber;
aTemp.BookingMoney = this.BookingRMoney;
aDatabaseDA.BookingRs.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
foreach (BookingRoomUsedEN item in this.aListBookingRoomUsed)
{
foreach (ServiceUsedEN item1 in item.ListServiceUsed)
{
item1.StatusPay = 8;
}
item.Status = 8;
item.CheckOutActual = DateTime.Now;
item.Save();
}
}
}
}
public void Save()
{
try
{
DatabaseDA aDatabaseDA = new DatabaseDA();
if (IDBookingR != null)
{
BookingRs aTemp = aDatabaseDA.BookingRs.Where(a => a.ID == IDBookingR).ToList()[0];
if (aTemp != null)
{
aTemp.CreatedDate = this.CreatedDate_BookingR;
aTemp.ID = Convert.ToInt32(this.IDBookingR);
aTemp.Status = this.Status_BookingR;
aTemp.InvoiceNumber = this.InvoiceNumber;
aTemp.AcceptDate = this.AcceptDate.GetValueOrDefault(Convert.ToDateTime("01/01/1900"));
aTemp.InvoiceDate = this.InvoiceDate.GetValueOrDefault(Convert.ToDateTime("01/01/1900"));
aTemp.BookingMoney = this.BookingRMoney;
aTemp.PayMenthod = this.PayMenthodR;
aDatabaseDA.BookingRs.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
}
foreach (BookingRoomUsedEN item in this.aListBookingRoomUsed)
{
item.Save();
}
}
if (IDBookingH != null)
{
BookingHs aTemp = aDatabaseDA.BookingHs.Where(a => a.ID == IDBookingH).ToList()[0];
if (aTemp != null)
{
aTemp.CreatedDate = this.CreatedDate_BookingH;
aTemp.ID = Convert.ToInt32(this.IDBookingH);
aTemp.Status = this.Status_BookingH;
aTemp.BookingMoney = this.BookingHMoney;
aTemp.InvoiceNumber = this.InvoiceNumber;
aTemp.AcceptDate = this.AcceptDate;
aTemp.InvoiceDate = this.InvoiceDate;
aTemp.PayMenthod = this.PayMenthodH;
aDatabaseDA.BookingHs.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
}
foreach (BookingHallUsedEN item in this.aListBookingHallUsed)
{
item.Save();
}
}
// Luu thong tin cong ty
Companies aCompany = aDatabaseDA.Companies.Where(a => a.ID == this.IDCompany).ToList()[0];
aCompany.TaxNumberCode = this.TaxNumberCodeCompany;
aCompany.Address = this.AddressCompany;
aCompany.ID = Convert.ToInt32(this.IDCompany);
aDatabaseDA.Companies.AddOrUpdate(aCompany);
aDatabaseDA.SaveChanges();
// Luu thong tin bookingRoom + Hall
}
catch (Exception ex)
{
throw new Exception(string.Format("BookingRoomUsedEN.Save :" + ex.Message.ToString()));
}
}
public void LoadData()
{
//-----------------------------------------------------
lueIDCompanies.Properties.DataSource = this.LoadListCompaniesByType();
lueIDCompanies.Properties.ValueMember = "ID";
lueIDCompanies.Properties.DisplayMember = "Name";
//-----------------------------------------------------
this.aListPaymentExt_GetAllDataEN = new List<PaymentExt_GetAllDataEN>();
List<sp_PaymentExt_GetAllData_Ext_Result> aListData = new List<sp_PaymentExt_GetAllData_Ext_Result>();
DatabaseDA aDatabaseDA = new DatabaseDA();
aListData = aDatabaseDA.sp_PaymentExt_GetAllData_Ext().ToList();
PaymentExt_GetAllDataEN aPaymentExt_GetAllDataEN;
foreach (sp_PaymentExt_GetAllData_Ext_Result item in aListData)
{
aPaymentExt_GetAllDataEN = new PaymentExt_GetAllDataEN();
aPaymentExt_GetAllDataEN.SetValue(item);
if (item.Service_PaymentStatus == null)
{
aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "";
}
else if (item.Service_PaymentStatus == 8 )
{
aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "Đã thanh toán";
}
else
{
//aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "Chưa thanh toán";
aPaymentExt_GetAllDataEN.DisplayService_PaymentStatus = "";
}
//-----------------------------------------------------------
if (item.Object_PaymentStatus == null)
{
aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "";
}
else if (item.Object_PaymentStatus == 8)
{
aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "Đã thanh toán";
}
else
{
//aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "Chưa thanh toán";
aPaymentExt_GetAllDataEN.DisplayObject_PaymentStatus = "";
}
//------------------------------------------------------------------------------------
if (item.BillR_PaymentStatus == 8)
{
aPaymentExt_GetAllDataEN.DisplayBillR_PaymentStatus = "Đã thanh toán";
}
else
{
//aPaymentExt_GetAllDataEN.DisplayBillR_PaymentStatus = "Chưa thanh toán";
aPaymentExt_GetAllDataEN.DisplayBillR_PaymentStatus = "";
}
//------------------------------------------------------------
if (item.Object_InvoiceDate.GetValueOrDefault().Year == 0001 || item.Object_InvoiceDate.GetValueOrDefault().Year == 1900)
{
aPaymentExt_GetAllDataEN.Object_InvoiceDate = "";
}
//------------------------------------------------------------
if (item.Object_AcceptDate.GetValueOrDefault().Year == 0001 || item.Object_AcceptDate.GetValueOrDefault().Year == 1900)
{
aPaymentExt_GetAllDataEN.Object_AcceptDate = null;
}
aListPaymentExt_GetAllDataEN.Add(aPaymentExt_GetAllDataEN);
}
dgvPaymentViewAll.DataSource = aListPaymentExt_GetAllDataEN;
dgvPaymentViewAll.RefreshDataSource();
}
public int SaveBookingRoom(BookingRoomUsedEN aBookingRoomUsedEN)
{
DatabaseDA aDatabaseDA = new DatabaseDA();
BookingRooms aTemp = aDatabaseDA.BookingRooms.Where(a => a.ID == aBookingRoomUsedEN.ID).ToList()[0];
aTemp.ID = aBookingRoomUsedEN.ID;
aTemp.IDBookingR = aBookingRoomUsedEN.IDBookingR;
aTemp.CodeRoom = aBookingRoomUsedEN.CodeRoom;
aTemp.Cost = aBookingRoomUsedEN.Cost;
aTemp.PercentTax = aBookingRoomUsedEN.PercentTax;
aTemp.CostRef_Rooms = aBookingRoomUsedEN.CostRef_Rooms;
aTemp.Note = aBookingRoomUsedEN.Note;
aTemp.CheckInPlan = aBookingRoomUsedEN.CheckInPlan;
aTemp.CheckInActual = aBookingRoomUsedEN.CheckInActual;
aTemp.CheckOutPlan = aBookingRoomUsedEN.CheckOutPlan;
aTemp.CheckOutActual = aBookingRoomUsedEN.CheckOutActual;
aTemp.BookingStatus = aBookingRoomUsedEN.BookingStatus;
aTemp.Status = aBookingRoomUsedEN.Status;
aTemp.StartTime = aBookingRoomUsedEN.StartTime;
aTemp.EndTime = aBookingRoomUsedEN.EndTime;
aTemp.IsAllDayEvent = aBookingRoomUsedEN.IsAllDayEvent;
aTemp.Color = aBookingRoomUsedEN.Color;
aTemp.IsRecurring = aBookingRoomUsedEN.IsRecurring;
aTemp.IsEditable = aBookingRoomUsedEN.IsEditable;
aTemp.AdditionalColumn1 = aBookingRoomUsedEN.AdditionalColumn1;
aTemp.CostPendingRoom = aBookingRoomUsedEN.CostPendingRoom;
aTemp.TimeInUse = aBookingRoomUsedEN.TimeInUse;
aTemp.AddTimeStart = aBookingRoomUsedEN.AddTimeStart;
aTemp.AddTimeEnd = aBookingRoomUsedEN.AddTimeEnd;
aTemp.Type = aBookingRoomUsedEN.Type;
aTemp.Disable = aBookingRoomUsedEN.Disable;
aTemp.IndexSubPayment = aBookingRoomUsedEN.IndexSubPayment;
aTemp.AcceptDate = aBookingRoomUsedEN.AcceptDate;
aTemp.InvoiceDate = aBookingRoomUsedEN.InvoiceDate;
aTemp.InvoiceNumber = aBookingRoomUsedEN.InvoiceNumber;
foreach (ServiceUsedEN item in aBookingRoomUsedEN.ListServiceUsed)
{
this.SaveServiceUsed(item, 1);
}
aTemp.PriceType = aBookingRoomUsedEN.PriceType;
aDatabaseDA.BookingRooms.AddOrUpdate(aTemp);
return aDatabaseDA.SaveChanges();
}
public void Save(NewPaymentHEN aNewPaymentHEN)
{
try
{
DatabaseDA aDatabaseDA = new DatabaseDA();
if (aNewPaymentHEN.IDBookingH != null)
{
BookingHs aTemp = aDatabaseDA.BookingHs.Where(a => a.ID == aNewPaymentHEN.IDBookingH).ToList()[0];
if (aTemp != null)
{
aTemp.CreatedDate = aNewPaymentHEN.CreatedDate_BookingH;
aTemp.ID = Convert.ToInt32(aNewPaymentHEN.IDBookingH);
aTemp.Status = aNewPaymentHEN.Status_BookingH;
aTemp.BookingMoney = aNewPaymentHEN.BookingHMoney;
aTemp.InvoiceNumber = aNewPaymentHEN.InvoiceNumber;
aTemp.AcceptDate = aNewPaymentHEN.AcceptDate;
aTemp.InvoiceDate = aNewPaymentHEN.InvoiceDate;
aTemp.PayMenthod = aNewPaymentHEN.PayMenthodH;
aDatabaseDA.BookingHs.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
}
foreach (BookingHallUsedEN item in aNewPaymentHEN.aListBookingHallUsed)
{
this.SaveBookingHall(item);
}
}
// Luu thong tin cong ty
Companies aCompany = aDatabaseDA.Companies.Where(a => a.ID == aNewPaymentHEN.IDCompany).ToList()[0];
aCompany.TaxNumberCode = aNewPaymentHEN.TaxNumberCodeCompany;
aCompany.Address = aNewPaymentHEN.AddressCompany;
aCompany.ID = Convert.ToInt32(aNewPaymentHEN.IDCompany);
aDatabaseDA.Companies.AddOrUpdate(aCompany);
aDatabaseDA.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(string.Format("AccountancyBO.Save :" + ex.Message.ToString()));
}
}
public void PaymentRoom(NewPaymentEN aNewPaymentEN)
{
if (aNewPaymentEN.IDBookingH != null)
{
foreach (BookingRoomUsedEN item in aNewPaymentEN.aListBookingRoomUsed)
{
if (item.Status == 7)
{
item.Status = 8;
}
else
{
item.Status = 8;
item.CheckOutActual = DateTime.Now;
}
foreach (ServiceUsedEN item1 in item.ListServiceUsed)
{
item1.StatusPay = 8;
}
this.SaveBookingRoom(item);
}
}
else
{
DatabaseDA aDatabaseDA = new DatabaseDA();
if (aDatabaseDA.BookingRs.Where(a => a.ID == aNewPaymentEN.IDBookingR).ToList().Count > 0)
{
BookingRs aTemp = aDatabaseDA.BookingRs.Where(a => a.ID == aNewPaymentEN.IDBookingR).ToList()[0];
aTemp.DatePay = DateTime.Now;
aTemp.Status = 8;
aTemp.InvoiceDate = aNewPaymentEN.InvoiceDate;
aTemp.InvoiceNumber = aNewPaymentEN.InvoiceNumber;
aTemp.BookingMoney = aNewPaymentEN.BookingRMoney;
aTemp.AcceptDate = aNewPaymentEN.AcceptDate;
aDatabaseDA.BookingRs.AddOrUpdate(aTemp);
aDatabaseDA.SaveChanges();
foreach (BookingRoomUsedEN item in aNewPaymentEN.aListBookingRoomUsed)
{
if (item.Status == 7)
{
item.Status = 8;
}
else
{
item.Status = 8;
item.CheckOutActual = DateTime.Now;
}
foreach (ServiceUsedEN item1 in item.ListServiceUsed)
{
item1.StatusPay = 8;
}
this.SaveBookingRoom(item);
}
}
}
}
public int RemoveContentFormCategoryLevel1(string CodeContent, string CodeCategoryLevel1)
{
try
{
DatabaseDA aDatabaseDA = new DatabaseDA();
List<Contents_CategoryLevel1> aList = aDatabaseDA.Contents_CategoryLevel1.Where(p => p.CodeContents == CodeContent).Where(p => p.CodeCategoryLevel1 == CodeCategoryLevel1).ToList();
return aDatabaseDA.Contents_CategoryLevel1.RemoveRange(aList).Count();
}
catch (Exception ex)
{
//return null;
throw new Exception(String.Format("ContentsBO.RemoveContentFormCategoryLevel1: {0}", ex.Message));
}
}