public static void themTK(string tentk, string mk, float soTienThem)
{
QLInternetDataContext db = new QLInternetDataContext();
DichVu giadv = db.DichVus.Where(p => p.TenDV.Trim() == "GiaCuoc").SingleOrDefault();
TaiKhoan tk = new TaiKhoan();
ThongTinTK tt = new ThongTinTK();
tk.MatKhau = maHoaMK(mk);
tk.TenTK = tentk;
tk.TongTG = 0;
tk.TrangThai = false;
tk.TGconLai = soTienThem / giadv.GiaDV;
LichSu ls = new LichSu();
ls.TenTK = tentk;
ls.TienThem = soTienThem;
ls.NgayGD = DateTime.Now;
ls.TGThem = soTienThem / giadv.GiaDV;
db.TaiKhoans.InsertOnSubmit(tk);
db.SubmitChanges();
db.LichSus.InsertOnSubmit(ls);
db.SubmitChanges();
}
public static void suaThongTin(string tenTK, string matKhau, string sdt, string email, float soTienThem)
{
QLInternetDataContext db = new QLInternetDataContext();
ThongTinTK tt = db.ThongTinTKs.Where(p => p.TenTK == tenTK).SingleOrDefault();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK == tenTK).SingleOrDefault();
DichVu giadv = db.DichVus.Where(p => p.TenDV.Trim() == "GiaCuoc").SingleOrDefault();
if (tt == null)
{
return;
}
else
{
if (matKhau != "")
{
tk.MatKhau = maHoaMK(matKhau);
}
if (soTienThem != 0)
{
tk.TGconLai = soTienThem / giadv.GiaDV;
}
tt.SDT = sdt;
tt.Email = email;
db.SubmitChanges();
}
}
public static ThongTinTK layThongTintk(string tentk)
{
QLInternetDataContext db = new QLInternetDataContext();
ThongTinTK tt = db.ThongTinTKs.Where(p => p.TenTK.Trim() == tentk).SingleOrDefault();
return(tt);
}
public static void xoaTK(string tentk)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK.Trim() == tentk).SingleOrDefault();
ThongTinTK tt = db.ThongTinTKs.Where(p => p.TenTK.Trim() == tentk).SingleOrDefault();
db.ThongTinTKs.DeleteOnSubmit(tt);
db.TaiKhoans.DeleteOnSubmit(tk);
db.SubmitChanges();
}
public static void themThongTin(string tenTK, string sdt, string email)
{
QLInternetDataContext db = new QLInternetDataContext();
ThongTinTK tttk = new ThongTinTK();
tttk.TenTK = tenTK;
if (sdt != "")
{
tttk.SDT = sdt;
}
if (email != "")
{
tttk.Email = email;
}
db.ThongTinTKs.InsertOnSubmit(tttk);
db.SubmitChanges();
}
partial void DeleteThongTinTK(ThongTinTK instance);
partial void UpdateThongTinTK(ThongTinTK instance);
partial void InsertThongTinTK(ThongTinTK instance);
