private void butXoa_Click(object sender, EventArgs e) { if (listRoom.SelectedItems.Count > 0) { using (MotelManagerEntities data = new MotelManagerEntities()) { DialogResult result = MessageBox.Show("Ban co chac xoa phong co ID = " + listRoom.FocusedItem.Text + " khong? (tat ca cac du lieu lien quan deu se bi xoa!)", "WARNING", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2); switch (result) { case DialogResult.Cancel: return; case DialogResult.Yes: { MOTELROOM temp = data.MOTELROOMs.Find(int.Parse(listRoom.FocusedItem.Text)); data.MOTELROOMs.Remove(temp); data.SaveChanges(); listRoom.Clear(); loadRoom(0, soLuong); dem = 0; break; } case DialogResult.No: return; default: break; } } } else { MessageBox.Show("hay chon phong tu danh sach!", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public void loadRoom() { listRoom.Clear(); datePickerCheckOut.Value = DateTime.Now; var listRent = (from a in data.REINTINFORs where a.CheckOutDate.Value.ToString() == "" select a).ToList(); listRoom.Columns.Add("ID", 100); listRoom.Columns.Add("Tên Phòng", 150); listRoom.Columns.Add("Trạng Thái", 120); listRoom.Columns.Add("Loại phòng", 140); listRoom.Columns.Add("Tên Khu Vực ", 200); List <MOTELROOM> listMotel = new List <MOTELROOM>(); int dem = 0; foreach (var a in listRent) { if (listMotel.Count > 0) { for (int i = 0; i < listMotel.Count; i++) { if (a.IDRoom.Equals(listMotel[i].ID)) { dem = 1; } } if (dem == 0) { MOTELROOM b = data.MOTELROOMs.Find(a.IDRoom); listMotel.Add(b); } } else { MOTELROOM b = data.MOTELROOMs.Find(a.IDRoom); listMotel.Add(b); } dem = 0; } foreach (MOTELROOM b in listMotel) { ListViewItem item = new ListViewItem(b.ID.ToString()); item.SubItems.Add(b.RoomName); if (b.StateRoom.Value == true) { item.SubItems.Add("phòng đã được thuê"); } else { item.SubItems.Add("phòng trống"); } ROOMRANK c = data.ROOMRANKs.Find(b.IDRoomRank); item.SubItems.Add(c.RankName.ToString()); ROOMRANGE d = data.ROOMRANGEs.Find(b.IDRoomRange); item.SubItems.Add(d.RangeName.ToString()); listRoom.Items.Add(item); } }
public void saveDate() { MOTELROOM room = new MOTELROOM() { RoomName = textRoomName.Text, StateRoom = false, IDRoomRank = int.Parse(comBoxIDRank.Text), IDRoomRange = int.Parse(comBoxIDRange.Text) }; data.MOTELROOMs.Add(room); data.SaveChanges(); }
public void updateData() { MOTELROOM temp = data.MOTELROOMs.Find(int.Parse(labIDRoomShow.Text)); temp.RoomName = textRoomName.Text; temp.IDRoomRank = int.Parse(comBoxIDRank.Text); temp.IDRoomRange = int.Parse(comBoxIDRange.Text); data.SaveChanges(); }
private void listRoom_SelectedIndexChanged(object sender, EventArgs e) { listGuest.Clear(); String temp = listRoom.FocusedItem.Text; MOTELROOM a = data.MOTELROOMs.Find(int.Parse(temp)); List <REINTINFOR> listRent = (from b in data.REINTINFORs where b.IDRoom == a.ID && b.CheckOutDate.Value.ToString().Equals("") select b).ToList(); listGuest.Columns.Add("ID", 100); listGuest.Columns.Add("Họ Tên", 150); foreach (REINTINFOR c in listRent) { CUSTOMER d = data.CUSTOMERs.Find(c.IDCustomer); ListViewItem item = new ListViewItem(d.ID.ToString()); item.SubItems.Add(d.CustomerName); listGuest.Items.Add(item); } }
private void listGuest_SelectedIndexChanged(object sender, EventArgs e) { clearShow(); String temp = listGuest.FocusedItem.Text; CUSTOMER customer = data.CUSTOMERs.Find(temp); textIDGuest.Text = customer.ID.ToString(); textPhone.Text = customer.NumberPhone.ToString(); textAddress.Text = customer.Address; textHoTen.Text = customer.CustomerName; textSexual.Text = customer.Sexual.ToString(); textBirth.Text = customer.DateOfBirth.ToString(); List <REINTINFOR> a = (from d in data.REINTINFORs where d.IDCustomer == temp select d).ToList(); MOTELROOM b = data.MOTELROOMs.Find(a[0].IDRoom); textIDRoom.Text = b.ID.ToString(); textRoomName.Text = b.RoomName; textCheckIn.Text = a[0].CheckInDate.ToString(); datePickerCheckOut.Value = DateTime.Now; }
public void loadData(String a) { MOTELROOM c = data.MOTELROOMs.Find(int.Parse(a)); labIDRoomShow.Text = c.ID.ToString(); textRoomName.Text = c.RoomName; if (c.StateRoom.Value == true) { labStateShow.Text = "phòng đã được thuê"; } else { labStateShow.Text = "phòng trống"; } comBoxIDRank.Text = c.IDRoomRank.ToString(); ROOMRANK d = data.ROOMRANKs.Find(c.IDRoomRank); textRankName.Text = d.RankName; comBoxIDRange.Text = c.IDRoomRange.ToString(); ROOMRANGE b = data.ROOMRANGEs.Find(c.IDRoomRange); textRangeName.Text = b.RangeName; }
private void textSearch_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Return) { listRoom.Clear(); using (MotelManagerEntities data = new MotelManagerEntities()) { String temp = textSearch.Text; List <REINTINFOR> listRent = (from a in data.REINTINFORs where a.CheckOutDate.Value.ToString() == "" select a).ToList(); listRoom.Columns.Add("ID", 100); listRoom.Columns.Add("Tên Phòng", 150); listRoom.Columns.Add("Trạng Thái", 120); listRoom.Columns.Add("Loại phòng", 140); listRoom.Columns.Add("Tên Khu Vực ", 200); List <MOTELROOM> listMotel = new List <MOTELROOM>(); int dem = 0; foreach (REINTINFOR a in listRent) { if (listMotel.Count > 0) { for (int i = 0; i < listMotel.Count; i++) { if (a.IDRoom.Equals(listMotel[i].ID)) { dem = 1; } } if (dem == 0) { MOTELROOM b = data.MOTELROOMs.Find(a.IDRoom); listMotel.Add(b); } } else { MOTELROOM b = data.MOTELROOMs.Find(a.IDRoom); listMotel.Add(b); } dem = 0; } List <MOTELROOM> listMotel2 = (from a in listMotel where a.RoomName.Contains(temp) || a.ID.ToString().Contains(temp) select a).ToList(); foreach (MOTELROOM b in listMotel2) { ListViewItem item = new ListViewItem(b.ID.ToString()); item.SubItems.Add(b.RoomName); if (b.StateRoom.Value == true) { item.SubItems.Add("phòng đã được thuê"); } else { item.SubItems.Add("phòng trống"); } ROOMRANK c = data.ROOMRANKs.Find(b.IDRoomRank); item.SubItems.Add(c.RankName.ToString()); ROOMRANGE d = data.ROOMRANGEs.Find(b.IDRoomRange); item.SubItems.Add(d.RangeName.ToString()); listRoom.Items.Add(item); } } } }