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 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 TaiKhoan layTaiKhoan(string tentk)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK.Trim() == tentk).SingleOrDefault();
return(tk);
}
public static string thongKe()
{
string k = "";
QLInternetDataContext db = new QLInternetDataContext();
double tkNgay = 0, tkThang = 0, tkNam = 0;
foreach (var i in db.LichSus)
{
if (i.NgayGD.Date == DateTime.Now.Date)
{
tkNgay = tkNgay + i.TienThem.Value;
}
if (i.NgayGD.Month == DateTime.Now.Month)
{
tkThang += i.TienThem.Value;
}
if (i.NgayGD.Year == DateTime.Now.Year)
{
tkNam += i.TienThem.Value;
}
}
k = tkNgay.ToString() + "," + tkThang.ToString() + "," + tkNam.ToString();
return(k);
}
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 float layGiaDV()
{
QLInternetDataContext db = new QLInternetDataContext();
//var n = from GiaDV in db.DichVus select GiaDV;
//var n = /*from GiaDV in*/ db.DichVus /*select GiaDV*/;
DichVu dv = db.DichVus.Where(p => p.TenDV == "GiaCuoc").SingleOrDefault();
return(float.Parse(dv.GiaDV.ToString()));
}
public static bool ktKhopMK(string tentk, string mkKiemTra)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK == tentk).SingleOrDefault();
if (tk.MatKhau.Trim() == maHoaMK(mkKiemTra))
{
return(true);
}
return(false);
}
public static void doiMatKhau(string tentk, string mkMoi)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK == tentk).SingleOrDefault();
if (tk != null)
{
tk.MatKhau = maHoaMK(mkMoi);
db.SubmitChanges();
}
}
public static bool ktTaiKhoanTonTai(string tentk)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK == tentk).SingleOrDefault();
if (tk != null)
{
return(true);
}
return(false);
}
public static List <string> layDsTenTK()
{
List <string> danhSach = new List <string>();
QLInternetDataContext db = new QLInternetDataContext();
foreach (var i in db.TaiKhoans)
{
danhSach.Add(i.TenTK.Trim());
}
return(danhSach);
}
public static void upDate_Exit(string tentk, float tgConLai, float tgSuDung)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK.Trim() == tentk).SingleOrDefault();
tk.TongTG += tgSuDung;
tk.TGconLai = tgConLai;
tk.TrangThai = false;
db.SubmitChanges();
}
public static List <TaiKhoan> layDsTaiKhoan()
{
QLInternetDataContext db = new QLInternetDataContext();
List <TaiKhoan> danhSachTK = new List <TaiKhoan>();
foreach (var i in db.TaiKhoans)
{
danhSachTK.Add(i);
}
return(danhSachTK);
}
public static void thayDoiGiaDV(float giaMoi)
{
QLInternetDataContext db = new QLInternetDataContext();
//var n = from GiaDV in db.DichVus select GiaDV;
//var n = /*from GiaDV in*/ db.DichVus /*select GiaDV*/;
DichVu dv = db.DichVus.Where(p => p.TenDV == "GiaCuoc").SingleOrDefault();
if (dv != null)
{
dv.GiaDV = giaMoi;
db.SubmitChanges();
}
}
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 TaiKhoan dangNhap(string tentk, string mk)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK.Trim() == tentk).SingleOrDefault();
if (tk != null)
{
tk.TrangThai = true;
db.SubmitChanges();
}
return(tk);
}
public static List <LichSu> layLichSuGD(string tentk)
{
QLInternetDataContext db = new QLInternetDataContext();
List <LichSu> lichSu = new List <LichSu>();
foreach (var i in db.LichSus)
{
if (i.TenTK.Trim() == tentk)
{
lichSu.Add(i);
}
}
return(lichSu);
}
public static void capNhatThongTin(string tentk, string sdt, string email)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK.Trim() == tentk).SingleOrDefault();
//tk.MatKhau = XuLyDAL.maHoaMK(mk);
if (sdt != "")
{
tk.ThongTinTK.SDT = sdt.Replace(" ", string.Empty);
}
if (email != "")
{
tk.ThongTinTK.Email = email;
}
db.SubmitChanges();
}
public static void themTien(string tentk, float soTienThem)
{
QLInternetDataContext db = new QLInternetDataContext();
TaiKhoan tk = db.TaiKhoans.Where(p => p.TenTK == tentk).SingleOrDefault();
DichVu giadv = db.DichVus.Where(p => p.TenDV.Trim() == "GiaCuoc").SingleOrDefault();
tk.TGconLai += (soTienThem / giadv.GiaDV);
LichSu ls = new LichSu();
ls.NgayGD = DateTime.Now;
ls.TenTK = tentk;
ls.TienThem = soTienThem;
ls.TGThem = soTienThem / giadv.GiaDV;
db.LichSus.InsertOnSubmit(ls);
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();
}
public static List <ThongTinTK> laDsThongTin()
{
QLInternetDataContext db = new QLInternetDataContext();
List <ThongTinTK> n = new List <ThongTinTK>();
foreach (var i in db.ThongTinTKs)
{
i.TenTK = i.TenTK.Trim();
if (i.SDT != null)
{
i.SDT = i.SDT.Trim();
}
if (i.Email != null)
{
i.Email = i.Email.Trim();
}
n.Add(i);
}
return(n);
}
public static List <LichSu> laylsGD(string tentk, string loai)
{
QLInternetDataContext db = new QLInternetDataContext();
List <LichSu> lichSu = new List <LichSu>();
foreach (var i in db.LichSus)
{
if (loai == "tbtNgayLS")
{
if (tentk != "")
{
if (tentk == i.TenTK.Trim() && i.NgayGD.Date == DateTime.Now.Date)
{
lichSu.Add(i);
}
}
else
{
if (i.NgayGD.Date == DateTime.Now.Date)
{
lichSu.Add(i);
}
}
}
else if (loai == "rbtThangLS")
{
if (tentk != "")
{
if (tentk == i.TenTK.Trim() && i.NgayGD.Month == DateTime.Now.Month)
{
lichSu.Add(i);
}
}
else
{
if (i.NgayGD.Month == DateTime.Now.Month)
{
lichSu.Add(i);
}
}
}
else if (loai == "rbtNamLS")
{
if (tentk != "")
{
if (tentk == i.TenTK.Trim() && i.NgayGD.Year == DateTime.Now.Year)
{
lichSu.Add(i);
}
}
else
{
if (i.NgayGD.Year == DateTime.Now.Year)
{
lichSu.Add(i);
}
}
}
}
return(lichSu);
}
