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