public int KiemtraTKDK(string TenDN, string TenNV, ref string err)
{
GameStackEntities1 GS = new GameStackEntities1();
var t = (from mk in GS.TaiKhoans
where mk.TenTK == TenDN
select mk).SingleOrDefault();
if (t != null)
{
return(1);
}
else
{
return(0);
}
var t2 = (from mk in GS.TaiKhoans
where mk.TenNV == TenNV
select mk).SingleOrDefault();
if (t != null)
{
return(2);
}
else
{
return(0);
}
}
public void ThemTK(string TenTK, string TenNV, string MK, string SDT, ref string err)
{
GameStackEntities1 gs = new GameStackEntities1();
TaiKhoan tk = new TaiKhoan();
BoSuuTapCaNhan Bst = new BoSuuTapCaNhan();
BangXH bxh = new BangXH();
int id = 0;
var sotk = from t in gs.TaiKhoans
select t;
foreach (var t in sotk)
{
id++;
}
id++;
tk.TenTK = TenTK;
tk.TenNV = TenNV;
tk.MatKhau = MK;
tk.SDT = SDT;
tk.ID = id;
Bst.TenTK = TenTK;
Bst.ID = id;
bxh.TenTK = TenTK;
bxh.TenNV = TenNV;
gs.TaiKhoans.Add(tk);
gs.BoSuuTapCaNhans.Add(Bst);
gs.BangXHs.Add(bxh);
gs.SaveChanges();
}
public bool LayMK(string TenDN, string MK, ref string err)
{
GameStackEntities1 gs = new GameStackEntities1();
var t = (from mk in gs.TaiKhoans
where mk.TenTK == TenDN
select mk).SingleOrDefault();
if (t != null)
{
t.MatKhau = MK;
gs.SaveChanges();
}
return(true);
}
public bool KiemtraTK(string TenDN, string SoDT, ref string err)
{
GameStackEntities1 GS = new GameStackEntities1();
var t = (from mk in GS.TaiKhoans
where mk.TenTK == TenDN
select mk).SingleOrDefault();
if (t != null)
{
if (t.SDT == SoDT)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public bool KiemTra(string TenDN, string MK, ref string err)
{
GameStackEntities1 tk = new GameStackEntities1();
var f = (from dn in tk.TaiKhoans
where dn.TenTK == TenDN
select dn).SingleOrDefault();
if (f != null)
{
if (f.MatKhau == MK)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
