public bool ThemPhong(Phong_Ent phong_ent) { Phong ph = db.Phongs.Where(n => n.so_Phong.Equals(phong_ent.So_Phong)).SingleOrDefault(); if (ph != null) { return(false); } try { Phong p = new Phong(); p.id_Phong = phong_ent.Id_Phong; p.id_loai_phong = Convert.ToInt32(phong_ent.Id_loai_phong); p.ghi_chu = phong_ent.Ghi_chu; p.so_luong_nguoi = phong_ent.So_luong_nguoi; p.so_Phong = phong_ent.So_Phong; p.tang = phong_ent.Tang; p.tinh_trang = Convert.ToInt32(phong_ent.Tinh_trang); //p.ghi_chu = null; db.Phongs.InsertOnSubmit(p); db.SubmitChanges(); } catch (Exception) { return(false); } return(true); }
private void frmTextPhong_Load(object sender, EventArgs e) { if (kieuForm == 2) { Phong_WCFClient p_wcf = new Phong_WCFClient(); Phong_Ent p_ent = p_wcf.GetPhong_by_ID(id_Phong); txtSoPhong.Text = p_ent.So_Phong.Trim(); cbx_SoNguoi.Text = (p_ent.So_luong_nguoi.ToString()); cbx_Tang.Text = p_ent.Tang.ToString(); if (p_ent.Id_loai_phong.Equals("1")) { cbx_LoaiPhong.Text = "Phòng Standard"; } else if (p_ent.Id_loai_phong.Equals("2")) { cbx_LoaiPhong.Text = "Phòng Deluxe"; } if (p_ent.Id_loai_phong.Equals("3")) { cbx_LoaiPhong.Text = "Phòng Express View"; } else { cbx_LoaiPhong.Text = "Phòng VIP"; } } else { lbTieuDe.Text = Lb_TitleName; cbx_LoaiPhong.SelectedIndex = 0; cbx_SoNguoi.SelectedIndex = 0; cbx_Tang.SelectedIndex = 0; //cbx_TinhTrang.SelectedIndex = 0; } }
public Phong_Ent GetPhong_by_ID(string id) { Phong_Ent p_ent = new Phong_Ent(); Phong p = db.Phongs.Where(n => n.id_Phong.Equals(id)).SingleOrDefault(); if (p != null) { p_ent.Id_Phong = Convert.ToInt32(id); p_ent.So_Phong = p.so_Phong; p_ent.Id_loai_phong = (p.id_loai_phong).ToString(); p_ent.Ghi_chu = p.ghi_chu; p_ent.Tang = p.tang; p_ent.So_luong_nguoi = p.so_luong_nguoi; //Get Tinh Trang if (p.tinh_trang == 0) { p_ent.Tinh_trang = "Phòng đã đặt"; } else { p_ent.Tinh_trang = "Phòng Trống"; } } return(p_ent); }
public List <Phong_Ent> SapXepTinhTrang(string TinhTrang) { List <Phong_Ent> p_ents = new List <Phong_Ent>(); int tam = 0; if (TinhTrang.Equals("Phòng đã đặt")) { tam = 1; } else { tam = 0; } IQueryable phongs = db.Phongs.Where(n => n.tinh_trang == tam); if (phongs != null) { foreach (Phong p in phongs) { Phong_Ent p_ent = new Phong_Ent(); p_ent.Id_Phong = Convert.ToInt32(p.id_Phong); p_ent.So_Phong = p.so_Phong.Trim(); p_ent.Id_loai_phong = p.id_loai_phong.ToString(); p_ent.So_luong_nguoi = p.so_luong_nguoi; //p_ent.Ghi_chu = p.ghi_chu.Trim(); if (p.id_loai_phong == 1) { p_ent.Id_loai_phong = "Phòng Standard"; } else if (p.id_loai_phong == 2) { p_ent.Id_loai_phong = "Phòng Deluxe"; } else if (p.id_loai_phong == 3) { p_ent.Id_loai_phong = "Phòng Express View"; } else if (p.id_loai_phong == 4) { p_ent.Id_loai_phong = "Phòng VIP"; } p_ent.Tang = p.tang; //Get tinh trang if (p.tinh_trang == 0) { p_ent.Tinh_trang = "Phòng trống"; } else { p_ent.Tinh_trang = "Phòng đã đặt"; } p_ents.Add(p_ent); } } return(p_ents); }
public List <Phong_Ent> GetPhongTrong_byLoaiPhong(int idLoaiPhong) { List <Phong_Ent> p_ents = new List <Phong_Ent>(); IQueryable phongs = db.Phongs.Where(n => n.id_loai_phong == Convert.ToInt32(idLoaiPhong) && n.tinh_trang == 0); if (phongs != null) { foreach (Phong p in phongs) { Phong_Ent p_ent = new Phong_Ent(); p_ent.Id_Phong = Convert.ToInt32(p.id_Phong); p_ent.So_Phong = p.so_Phong.Trim(); p_ent.So_luong_nguoi = p.so_luong_nguoi; if (p.id_loai_phong == 1) { p_ent.Id_loai_phong = "Phòng Standard"; } else if (p.id_loai_phong == 2) { p_ent.Id_loai_phong = "Phòng Deluxe"; } else if (p.id_loai_phong == 3) { p_ent.Id_loai_phong = "Phòng Express View"; } else if (p.id_loai_phong == 4) { p_ent.Id_loai_phong = "Phòng VIP"; } p_ent.Tang = p.tang; if (p.tinh_trang == 0) { p_ent.Tinh_trang = "Phòng trống"; } else { p_ent.Tinh_trang = "Phòng đã đặt"; } p_ents.Add(p_ent); } } return(p_ents); }
public List <Phong_Ent> GetPhongs() { List <Phong_Ent> phong_ents = new List <Phong_Ent>(); foreach (Phong p in db.Phongs.Select(n => n)) { Phong_Ent p_ent = new Phong_Ent(); p_ent.Id_Phong = Convert.ToInt32(p.id_Phong); // p_ent.Id_loai_phong = p.id_loai_phong; if (p.id_loai_phong == 1) { p_ent.Id_loai_phong = "Phòng Standard"; } else if (p.id_loai_phong == 2) { p_ent.Id_loai_phong = "Phòng Deluxe"; } else if (p.id_loai_phong == 3) { p_ent.Id_loai_phong = "Phòng Express View"; } else if (p.id_loai_phong == 4) { p_ent.Id_loai_phong = "Phòng VIP"; } p_ent.Ghi_chu = p.ghi_chu; p_ent.So_luong_nguoi = p.so_luong_nguoi; p_ent.So_Phong = p.so_Phong; p_ent.Tang = p.tang; if (p.tinh_trang == 0) { p_ent.Tinh_trang = "Phòng trống"; } else { p_ent.Tinh_trang = "Phòng đã đặt"; } phong_ents.Add(p_ent); } return(phong_ents); }
public List <Phong_Ent> Tim_Kiem_By_SoPhong(string soPhong) { List <Phong_Ent> p_ents = new List <Phong_Ent>(); foreach (Phong p in db.Phongs.Where(n => n.so_Phong.Contains(soPhong))) { Phong_Ent p_ent = new Phong_Ent(); p_ent.Id_Phong = Convert.ToInt32(p.id_Phong); if (p.id_loai_phong == 1) { p_ent.Id_loai_phong = "Phòng Standard"; } else if (p.id_loai_phong == 2) { p_ent.Id_loai_phong = "Phòng Deluxe"; } else if (p.id_loai_phong == 3) { p_ent.Id_loai_phong = "Phòng Express View"; } else if (p.id_loai_phong == 4) { p_ent.Id_loai_phong = "Phòng VIP"; } p_ent.Ghi_chu = p.ghi_chu; p_ent.So_luong_nguoi = p.so_luong_nguoi; p_ent.So_Phong = p.so_Phong; p_ent.Tang = p.tang; if (p.tinh_trang == 0) { p_ent.Tinh_trang = "Phòng trống"; } else { p_ent.Tinh_trang = "Phòng đã đặt"; } p_ents.Add(p_ent); } return(p_ents); }
public bool CapNhatPhong(Phong_Ent phong_ent) { Phong p = db.Phongs.Where(n => n.id_Phong.Equals(phong_ent.Id_Phong)).SingleOrDefault(); if (p == null) { return(false); } try { p.id_loai_phong = Convert.ToInt32(phong_ent.Id_loai_phong); p.ghi_chu = phong_ent.Ghi_chu; p.so_luong_nguoi = phong_ent.So_luong_nguoi; p.so_Phong = phong_ent.So_Phong; p.tang = phong_ent.Tang; db.SubmitChanges(); } catch (Exception) { return(false); } return(true); }
private void Luu_Sua() { if (!CheckNull()) { MessageBox.Show("Chưa Nhập Đủ Thông Tin", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } Phong_WCFClient p_wcf = new Phong_WCFClient(); Phong_Ent p_ent = new Phong_Ent(); p_ent.Id_Phong = Convert.ToInt32(id_Phong); p_ent.So_Phong = txtSoPhong.Text.Trim(); p_ent.Ghi_chu = txtGhiChu.Text.Trim(); if (cbx_LoaiPhong.SelectedIndex == 0) { p_ent.Id_loai_phong = "1"; } if (cbx_LoaiPhong.SelectedIndex == 1) { p_ent.Id_loai_phong = "2"; } if (cbx_LoaiPhong.SelectedIndex == 2) { p_ent.Id_loai_phong = "3"; } if (cbx_LoaiPhong.SelectedIndex == 3) { p_ent.Id_loai_phong = "4"; } if (cbx_Tang.SelectedIndex == 0) { p_ent.Tang = 1; } if (cbx_Tang.SelectedIndex == 1) { p_ent.Tang = 2; } if (cbx_Tang.SelectedIndex == 2) { p_ent.Tang = 3; } if (cbx_Tang.SelectedIndex == 3) { p_ent.Tang = 4; } if (cbx_SoNguoi.SelectedIndex == 0) { p_ent.So_luong_nguoi = 1; } if (cbx_SoNguoi.SelectedIndex == 1) { p_ent.So_luong_nguoi = 2; } if (cbx_SoNguoi.SelectedIndex == 2) { p_ent.So_luong_nguoi = 3; } if (cbx_SoNguoi.SelectedIndex == 3) { p_ent.So_luong_nguoi = 4; } if (cbx_SoNguoi.SelectedIndex == 4) { p_ent.So_luong_nguoi = 5; } if (p_wcf.CapNhatPhong(p_ent)) { DialogResult ds = MessageBox.Show("Lưu Thành Công, Tiếp Tục ?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (ds == DialogResult.Yes) { Clear_TextBox(); return; } else { this.Close(); } } else { DialogResult ds = MessageBox.Show("Lưu Thất Bại, Thử Lại ?", "Lỗi", MessageBoxButtons.YesNo, MessageBoxIcon.Error); if (ds == DialogResult.Yes) { return; } else { this.Close(); } } }