public static void SuaNguoiDung(NguoiDung nguoidung, string matkhau, dbQuanLyDataContext db) { string encodedMatkhau = GetMD5(matkhau); nguoidung.MatKhau = encodedMatkhau; db.SubmitChanges(); }
public static void SuaSinhVien(SinhVien sinhvien, string tensv, string diachi, DateTime ngaysinh, dbQuanLyDataContext db) { sinhvien.TenSV = tensv; sinhvien.DiaChi = diachi; sinhvien.NgaySinh = ngaysinh; db.SubmitChanges(); }
public static void SuaMonHoc(MonHoc monhoc, string tenmh, string gv, int sotinchi, dbQuanLyDataContext db) { monhoc.TenMH = tenmh; monhoc.GV = gv; monhoc.SoTinChi = sotinchi; db.SubmitChanges(); }
public static void ThemKhoa(string makhoa, string tenkhoa, dbQuanLyDataContext db) { Khoa kh = new Khoa { MaKhoa = makhoa, TenKhoa = tenkhoa }; db.Khoas.InsertOnSubmit(kh); db.SubmitChanges(); }
public static void ThemNguoiDung(string tendangnhap, string matkhau, dbQuanLyDataContext db) { string encodedMatkhau = GetMD5(matkhau); NguoiDung user = new NguoiDung { TenDangNhap = tendangnhap, MatKhau = encodedMatkhau, Moderator = 0 }; db.NguoiDungs.InsertOnSubmit(user); db.SubmitChanges(); }
public static void ThemSinhVien(string masv, string tensv, DateTime ngaysinh, string diachi, string makhoa, dbQuanLyDataContext db) { SinhVien sinhvien = new SinhVien { MaSV = masv, TenSV = tensv, NgaySinh = ngaysinh, DiaChi = diachi, MaKhoa = makhoa, }; db.SinhViens.InsertOnSubmit(sinhvien); db.SubmitChanges(); }
public static void ThemMonHoc(string mamh, string tenmh, string makhoa, int sotinchi, string gv, dbQuanLyDataContext db) { MonHoc mh = new MonHoc { MaMH = mamh, TenMH = tenmh, GV = gv, SoTinChi = sotinchi, MaKhoa = makhoa }; db.MonHocs.InsertOnSubmit(mh); db.SubmitChanges(); }
public static void XoaMonHoc(MonHoc monhoc, dbQuanLyDataContext db) { db.MonHocs.DeleteOnSubmit(monhoc); db.SubmitChanges(); }
public static void XoaNguoiDung(NguoiDung nguoidung, dbQuanLyDataContext db) { db.NguoiDungs.DeleteOnSubmit(nguoidung); db.SubmitChanges(); }
public static void SuaKhoa(Khoa khoa, string tenkhoa, dbQuanLyDataContext db) { khoa.TenKhoa = tenkhoa; db.SubmitChanges(); }
public static void XoaKhoa(Khoa khoa, dbQuanLyDataContext db) { db.Khoas.DeleteOnSubmit(khoa); db.SubmitChanges(); }
public static void XoaSinhVien(SinhVien sv, dbQuanLyDataContext db) { db.SinhViens.DeleteOnSubmit(sv); db.SubmitChanges(); }