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);
                    }
                }

            }
        }
Beispiel #13
0
        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));
            }
        }