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 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();
        }
 partial void UpdateLichSu(LichSu instance);
 partial void DeleteLichSu(LichSu instance);
 partial void InsertLichSu(LichSu instance);