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