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);