//======================================================= //Author: LinhTing //Function : Update Room //======================================================= public int Update(Rooms Rooms) { try { aDatabaseDA.Rooms.AddOrUpdate(Rooms); return aDatabaseDA.SaveChanges(); } catch (Exception ex) { throw new Exception(string.Format("RoomBO.Update :" + ex.Message)); } }
public List<RoomExtStatusEN> GetListUsingRooms(DateTime Now) { try { List<RoomExtStatusEN> aListTemp = new List<RoomExtStatusEN>(); RoomsBO aRoomsBO = new RoomsBO(); Rooms aRooms = new Rooms(); aListTemp = aRoomsBO.GetListStatusRoom(Now).Where(p => p.RoomStatus == 3).ToList(); return aListTemp; } catch (Exception ex) { throw new Exception("UsingServiceTask.GetListUsingRooms\n" + ex.ToString()); } }
//hiennv public List<RoomExtStatusEN> GetListUsingRooms_ByCode(DateTime Now ,string code) { try { List<RoomExtStatusEN> aListTemp = new List<RoomExtStatusEN>(); RoomsBO aRoomsBO = new RoomsBO(); Rooms aRooms = new Rooms(); if (String.IsNullOrEmpty(code) == true) { aListTemp = aRoomsBO.GetListStatusRoom(Now).Where(p => p.RoomStatus == 3).ToList(); } else { aListTemp = aRoomsBO.GetListStatusRoom(Now).Where(p => p.RoomStatus == 3).Where(p => p.Code == code).ToList(); } return aListTemp; } catch (Exception ex) { throw new Exception("UsingServiceTask.GetListUsingRooms_ByCode\n" + ex.ToString()); } }
private void btnAddRoom_Click(object sender, EventArgs e) { try { if (this.ValidateData() == true) { List<Rooms> aListRoomTemp = aRoomsBO.Select_All(); Rooms aRoom = new Rooms(); aRoom.Sku = txtSku.Text; aRoom.Bed1 = !String.IsNullOrEmpty(txtBed1.Text) ? Convert.ToInt32(txtBed1.Text) : 0; aRoom.Bed2 = !String.IsNullOrEmpty(txtBed2.Text) ? Convert.ToInt32(txtBed2.Text) : 0; aRoom.Disable = bool.Parse(cbbDisable.Text); aRoom.Status = int.Parse(cbbStatus.Text); aRoom.Type = Convert.ToInt32(lueRoomType.EditValue); aRoom.Image = (Byte[])new ImageConverter().ConvertTo(pbxImage.Image, typeof(Byte[])); TimeSpan Codespan = new TimeSpan(DateTime.Now.Ticks); string b = Math.Floor(Codespan.TotalSeconds).ToString(); for (int i = 1; i <= 2; i++) { switch (i) { case 1: Rooms a1 = aListRoomTemp.Find(p => p.Sku == txtSku.Text & p.IDLang == 1); if (a1 == null) { aRoom.CostRef = String.IsNullOrEmpty(txtCostRef1.Text) == true ? 0 : Decimal.Parse(txtCostRef1.Text); aRoom.CostUnit = txtCostUnit1.Text; aRoom.IDLang = 1; aRoom.Info = txtInfo1.Text; aRoom.Intro = txtIntro1.Text; aRoom.Code = b; aRoomsBO.Insert(aRoom); } else { MessageBox.Show("Mã phòng này đã tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } break; case 2: Rooms a2 = aListRoomTemp.Find(p => p.Sku == txtSku.Text & p.IDLang == 2); if (a2 == null) { aRoom.CostRef = String.IsNullOrEmpty(txtCostRef1.Text) == true ? 0 : Decimal.Parse(txtCostRef1.Text); aRoom.CostUnit = txtCostUnit2.Text; aRoom.IDLang = 2; aRoom.Info = txtInfo2.Text; aRoom.Intro = txtIntro2.Text; aRoom.Code = b; aRoomsBO.Insert(aRoom); } else { MessageBox.Show("Mã phòng này đã tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } break; } } MessageBox.Show("Thêm phòng thành công"); this.Close(); if (this.afrmLst_Rooms != null) { this.afrmLst_Rooms.ReloadData(); if(this.afrmLst_Rooms.afrmMain !=null) { this.afrmLst_Rooms.afrmMain.ReloadData(); } } if(this.afrmMain !=null) { this.afrmMain.ReloadData(); } } } catch (Exception ex) { MessageBox.Show("frmIns_Rooms.btnAddRoom_Click\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ResetFormWhenTimeChange() { if (aBookingRs.CustomerType == 1) { lblCustomerType.Text = "Khách nhà nước"; } else if (aBookingRs.CustomerType == 2) { lblCustomerType.Text = "Cty ngoài"; } else if (aBookingRs.CustomerType == 3) { lblCustomerType.Text = "Khách lẻ"; } else if (aBookingRs.CustomerType == 4) { lblCustomerType.Text = "Khách vãng lai"; } CustomersBO aCustomersBO = new CustomersBO(); CustomerInfoEN aCustomers = new CustomerInfoEN(); aCustomers = new CustomerInfoEN (aCustomersBO.Select_ByID(aBookingRs.IDCustomer)); lblCustomer.Text = aCustomers.Name; lblTel.Text = aCustomers.Tel; CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup); lblGroup.Text = aCustomerGroups.Name; CompaniesBO aCompaniesBO = new CompaniesBO(); lblCompany.Text = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany).Name; // Fill All Customer dgvAvailableCustomers.DataSource = ConvertListCustomer ((new CustomersBO()).Select_All()); lueRooms.Properties.DataSource = this.GetAvaiableRoom(); lueRooms.Properties.ValueMember = "Code"; lueRooms.Properties.DisplayMember = "Sku"; RoomsBO aRoomsBO = new RoomsBO(); Rooms aRooms = new Rooms(); aRooms = aRoomsBO.Select_ByCodeRoom(this.aBookingRoom.CodeRoom, 1); lueRooms.Properties.NullText = aRooms.Sku; lueRooms.SelectedText = aRooms.Sku; lueRooms.EditValue = aRooms.Code; BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); List<BookingRoomsMembers> aListBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom (this.aBookingRoom.ID); dgvSelectCustomers.DataSource = GetCustomers(aListBookingRoomsMembers); }
private void InitForm() { // Kiem tra xem phong dang o che do checkIn hay book phong if (this.aBookingRoom.Status < 3) { dtpCheckIn.Text = aBookingRoom.CheckInPlan.ToString(); dtpCheckOut.Text = aBookingRoom.CheckOutPlan.ToString(); } else if (this.aBookingRoom.Status == 3) // Phong da checkIn { dtpCheckIn.Text = DateTime.Now.ToString(); dtpCheckOut.Text = aBookingRoom.CheckOutPlan.ToString(); } if (aBookingRs.CustomerType == 1) { lblCustomerType.Text = "Khách nhà nước"; } else if (aBookingRs.CustomerType == 2) { lblCustomerType.Text = "Cty ngoài"; } else if (aBookingRs.CustomerType == 3) { lblCustomerType.Text = "Khách lẻ"; } else if (aBookingRs.CustomerType == 4) { lblCustomerType.Text = "Khách vãng lai"; } CustomersBO aCustomersBO = new CustomersBO(); CustomerInfoEN aCustomers = new CustomerInfoEN(); aCustomers = new CustomerInfoEN (aCustomersBO.Select_ByID(aBookingRs.IDCustomer)); lblCustomer.Text = aCustomers.Name; lblTel.Text = aCustomers.Tel; CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup); lblGroup.Text = aCustomerGroups.Name; CompaniesBO aCompaniesBO = new CompaniesBO(); lblCompany.Text = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany).Name; // Fill All Customer dgvAvailableCustomers.DataSource = ConvertListCustomer ((new CustomersBO()).Select_All()); lueRooms.Properties.DataSource = this.GetAvaiableRoom(); lueRooms.Properties.ValueMember = "Code"; lueRooms.Properties.DisplayMember = "Sku"; RoomsBO aRoomsBO = new RoomsBO(); Rooms aRooms = new Rooms(); aRooms = aRoomsBO.Select_ByCodeRoom(this.aBookingRoom.CodeRoom, 1); lueRooms.Properties.NullText = aRooms.Sku; lueRooms.SelectedText = aRooms.Sku; lueRooms.EditValue = aRooms.Code; BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); List<BookingRoomsMembers> aListBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom (this.aBookingRoom.ID); dgvSelectCustomers.DataSource = GetCustomers(aListBookingRoomsMembers); //this.aChangeRoomEn.InsertItemChangeRooms() }
public List<Rooms> GetListAvailableRooms(DateTime From, DateTime To, int Lang) { try { List<sp_Rooms_GetAvailable_ByTime_ByLang_Result> aListTemp = new List<sp_Rooms_GetAvailable_ByTime_ByLang_Result>(); aListTemp = aDatabaseDA.sp_Rooms_GetAvailable_ByTime_ByLang(From, To, Lang).ToList(); List<Rooms> aListReturn = new List<Rooms>(); Rooms aRooms; for (int i = 0; i < aListTemp.Count; i++) { aRooms = new Rooms(); aRooms.ID = aListTemp[i].ID; aRooms.Sku = aListTemp[i].Sku; aRooms.Image = aListTemp[i].Image; aRooms.Bed1 = aListTemp[i].Bed1; aRooms.Bed2 = aListTemp[i].Bed2; aRooms.Intro = aListTemp[i].Intro; aRooms.Info = aListTemp[i].Info; aRooms.CostRef = aListTemp[i].CostRef; aRooms.CostUnit = aListTemp[i].CostUnit; aRooms.Type = aListTemp[i].Type; aRooms.Status = aListTemp[i].Status; aRooms.Disable = aListTemp[i].Disable; aRooms.Code = aListTemp[i].Code; aRooms.IDLang = aListTemp[i].IDLang; aListReturn.Add(aRooms); } return aListReturn; } catch (Exception ex) { throw new Exception("ReceptionTaskBO.CheckInGoverment\n" + ex.ToString()); } }