public static bool addnewHoaDon(QuanLyHomestayEntities db, HOADON hd) { if (hd.NgayDen == null) { return(false); } else if (hd.NgayDen < DateTime.Today) { return(false); } else if (hd.NgayDen > hd.NgayDi) { return(false); } else if (hd.NgayDi == null) { return(false); } else if (hd.MaLoaiPhong == null) { return(false); } else if (hd.MaHoaDon == null) { return(false); } else { db.HOADONs.Add(hd); db.SaveChanges(); return(true); } }
public static bool deletePhong(QuanLyHomestayEntities db, HOADON hd) { db = new QuanLyHomestayEntities(); db.HOADONs.Attach(hd); db.HOADONs.Remove(hd); db.SaveChanges(); return(true); }
public static bool checkTK(string a) { QuanLyHomestayEntities db = new QuanLyHomestayEntities(); TAIKHOAN s = (from i in db.TAIKHOANs where i.TaiKhoan1.Equals(a) select i).FirstOrDefault(); if (s != null) { return(true); } return(false); }
public static bool testLogin(string tk, string mk) { db = new QuanLyHomestayEntities(); try { TAIKHOAN s = (from i in db.TAIKHOANs where i.TaiKhoan1 == tk && i.Matkhau == mk select i).FirstOrDefault(); if (s != null) { return(true); } } catch { } return(false); }
public Confirm(HOADON obj, string status) { InitializeComponent(); db = new QuanLyHomestayEntities(); lOAIPHONGBindingSource.DataSource = db.LOAIPHONGs.ToList(); if (status.Equals("add")) { bindingSource1.DataSource = obj; hd = obj; LOAIPHONG p = (from i in db.LOAIPHONGs where i.MaLoaiPhong == obj.MaLoaiPhong select i).FirstOrDefault(); textBox1.Text = p.TenLoaiPhong; this.status = status; } else if (status.Equals("edit")) { bindingSource1.DataSource = obj; hd = obj; db.HOADONs.Attach(hd); unlock(); this.status = status; } }
public static bool addNew(QuanLyHomestayEntities db, TAIKHOAN a) { if (checkTK(a.TaiKhoan1)) { return(false); } else if (a.Matkhau == null || a.Matkhau == "") { return(false); } else if (a.Matkhau.Length < 8 || a.Matkhau.Length > 16) { return(false); } else if (a.HoTen == null || a.HoTen == "") { return(false); } else if (a.Phone == null || a.Phone == "") { return(false); } else if (a.TaiKhoan1 == null || a.TaiKhoan1 == "") { return(false); } else if (a != null) { db.TAIKHOANs.Add(a); db.SaveChanges(); return(true); } else { return(false); } }
public static List <TAIKHOAN> LayDuLieu() { QuanLyHomestayEntities db = new QuanLyHomestayEntities(); return((from i in db.TAIKHOANs select i).ToList()); }
public fmDangKi() { InitializeComponent(); db = new QuanLyHomestayEntities(); }