private void butXoa_Click(object sender, EventArgs e) { if (listRank.SelectedItems.Count > 0) { using (MotelManagerEntities data = new MotelManagerEntities()) { DialogResult result = MessageBox.Show("Ban co chac xoa khach co ID = " + listRank.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: { ROOMRANK temp = data.ROOMRANKs.Find(int.Parse(listRank.FocusedItem.Text)); data.ROOMRANKs.Remove(temp); data.SaveChanges(); listRank.Clear(); loadData(0, soLuong); dem = 0; break; } case DialogResult.No: return; default: break; } } } else { MessageBox.Show("Hay chon khach can xoa 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 loadData(String a) { ROOMRANK c = data.ROOMRANKs.Find(int.Parse(a)); textRankName.Text = c.RankName; textPrice.Text = c.Price.ToString(); textDeposit.Text = c.Deposits.ToString(); textAbout.Text = c.About; }
public void saveDate() { ROOMRANK temp = new ROOMRANK() { RankName = textRankName.Text, Price = int.Parse(textPrice.Text), Deposits = int.Parse(textDeposit.Text), About = textAbout.Text }; data.ROOMRANKs.Add(temp); data.SaveChanges(); }
public void updateData() { ROOMRANK temp = data.ROOMRANKs.Find(int.Parse(labIDShow.Text)); temp.RankName = textRankName.Text; decimal a = decimal.Parse(textPrice.Text); temp.Price = a; a = decimal.Parse(textDeposit.Text); temp.Deposits = a; temp.About = textAbout.Text; data.SaveChanges(); }
public void loadRoom(int e, int f) { using (MotelManagerEntities data = new MotelManagerEntities()) { listRoom.Columns.Add("ID Phòng", 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); var list = (from d in data.USP_PageRoom(e, f) select d).ToList(); foreach (var c in list) { ListViewItem item = new ListViewItem(c.ID.ToString()); item.SubItems.Add(c.RoomName); if (c.StateRoom.Value == true) { item.SubItems.Add("phòng đã được thuê"); } else { item.SubItems.Add("phòng trống"); } ROOMRANK a = data.ROOMRANKs.Find(c.IDRoomRank); item.SubItems.Add(a.RankName.ToString()); ROOMRANGE b = data.ROOMRANGEs.Find(c.IDRoomRange); item.SubItems.Add(b.RangeName.ToString()); listRoom.Items.Add(item); } var temp2 = (from c in data.USP_CountRoom() select c).ToList(); tong = int.Parse(temp2[0].ToString()); if (tong % soLuong != 0) { tinh = tong / soLuong + 1; } else { tinh = tong / soLuong; } labPage.Text = "Trang 1/" + tinh; } }
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 <MOTELROOM> list = (from a in data.MOTELROOMs where a.RoomName.Contains(temp) || a.ID.ToString().Contains(temp) select a).ToList(); listRoom.Columns.Add("ID Phòng", 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); foreach (MOTELROOM c in list) { ListViewItem item = new ListViewItem(c.ID.ToString()); item.SubItems.Add(c.RoomName); if (c.StateRoom.Value == true) { item.SubItems.Add("phòng đã được thuê"); } else { item.SubItems.Add("phòng trống"); } ROOMRANK a = data.ROOMRANKs.Find(c.IDRoomRank); item.SubItems.Add(a.RankName.ToString()); ROOMRANGE b = data.ROOMRANGEs.Find(c.IDRoomRange); item.SubItems.Add(b.RangeName.ToString()); listRoom.Items.Add(item); } labPage.Text = "Trang 1/1"; } } }
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); } } } }
private void comBoxIDRank_SelectedIndexChanged(object sender, EventArgs e) { ROOMRANK d = data.ROOMRANKs.Find(int.Parse(comBoxIDRank.Text)); textRankName.Text = d.RankName; }