public List <Phong> getListPhong()
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
List <Phong> list = db.Phongs.ToList();
return(list);
}
public void DeleteDB(string userName)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
TaiKhoan tk = db.TaiKhoans.SingleOrDefault(x => x.TenTaiKhoan == userName);
db.TaiKhoans.Remove(tk);
db.SaveChanges();
}
public void InsertDB(string tenHienThi, string tenTaiKhoan, string matKhau, int kieuNguoiDung)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
TaiKhoan tk = new TaiKhoan();
tk.TenTaiKhoan = tenTaiKhoan;
tk.TenHienThi = tenHienThi;
tk.MatKhau = matKhau;
tk.KieuNguoiDung = kieuNguoiDung;
db.TaiKhoans.Add(tk);
db.SaveChanges();
}
public void Insert(int RoomID, int TVNguoiDungID)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
DatPhong dp = new DatPhong();
dp.idDatPhong = 0;
dp.idPhong = RoomID;
dp.idUser = TVNguoiDungID;
dp.TenPhong = new ModifyPhong().GetTenPhongByID(RoomID);
dp.NgayDangKy = DateTime.Now;
db.DatPhongs.Add(dp);
db.SaveChanges();
}
public void Delete(int ID)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
TVNguoiDung t = db.TVNguoiDungs.SingleOrDefault(x => x.idUser == ID);
db.TVNguoiDungs.Remove(t);
db.SaveChanges();
//QLPhongTroDBContext db = new QLPhongTroDBContext();
//TVNguoiDung t = db.TVNguoiDungs.SingleOrDefault(x => x.idUser == ID);
//t.SoDT = "34234234";
//db.SaveChanges();
}
public void InsertDB(string tenUser, string gioiTinh, string email, int soDienThoai, string diaChi, string tenTaiKhoan)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
TVNguoiDung tvNguoiDung = new TVNguoiDung();
tvNguoiDung.TenUser = tenUser;
tvNguoiDung.GioiTinh = gioiTinh;
tvNguoiDung.Email = email;
tvNguoiDung.SoDT = soDienThoai;
tvNguoiDung.DiaChi = diaChi;
tvNguoiDung.idUser = 1;
tvNguoiDung.TenTaiKhoan = tenTaiKhoan;
db.TVNguoiDungs.Add(tvNguoiDung);
db.SaveChanges();
}
public string Register(register model)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
TaiKhoan tk = db.TaiKhoans.SingleOrDefault(x => x.TenTaiKhoan == userName);
if (tk == null)
{
ModifyAccount mA = new ModifyAccount();
ModifyTVNguoiDung mTV = new ModifyTVNguoiDung();
mA.InsertDB(model.name, model.userName, model.passWord, 2);
mTV.InsertDB(model.name, model.gender, model.email, model.phone, model.address, model.userName);
return("true");
}
else
{
return("false");
}
}
public string VerifyLogin(string user, string pass)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
TaiKhoan tk = db.TaiKhoans.SingleOrDefault(x => x.TenTaiKhoan == user);
if (tk != null)
{
if (tk.MatKhau == pass)
{
return(tk.KieuNguoiDung + "");
}
else
{
return("false");
}
}
else
{
return("false");
}
}
public int GetIDByUsername(string username)
{
QLPhongTroDBContext db = new QLPhongTroDBContext();
return(db.TVNguoiDungs.SingleOrDefault(x => x.TenTaiKhoan == username).idUser);
}
