public static void SuaNguoiDung(NguoiDung nguoidung, string matkhau, dbQuanLyDataContext db)
{
string encodedMatkhau = GetMD5(matkhau);
nguoidung.MatKhau = encodedMatkhau;
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 IQueryable <MonHoc> GetDSMonHocbyMaKhoa(string makhoa, dbQuanLyDataContext db)
{
return(db.MonHocs.Where(p => p.MaKhoa == makhoa));
}
public static void XoaNguoiDung(NguoiDung nguoidung, dbQuanLyDataContext db)
{
db.NguoiDungs.DeleteOnSubmit(nguoidung);
db.SubmitChanges();
}
public static NguoiDung GetNguoiDung(string tendangnhap, dbQuanLyDataContext db)
{
return(db.NguoiDungs.SingleOrDefault(p => p.TenDangNhap == tendangnhap));
}
public static SinhVien GetSinhVienbyMaSV(string masv, dbQuanLyDataContext db)
{
return(db.SinhViens.SingleOrDefault(p => p.MaSV == masv));
}
public static void XoaMonHoc(MonHoc monhoc, dbQuanLyDataContext db)
{
db.MonHocs.DeleteOnSubmit(monhoc);
db.SubmitChanges();
}
public static void XoaKhoa(Khoa khoa, dbQuanLyDataContext db)
{
db.Khoas.DeleteOnSubmit(khoa);
db.SubmitChanges();
}
public static Khoa GetKhoabyMaKhoa(string makhoa, dbQuanLyDataContext db)
{
return(db.Khoas.Where(p => p.MaKhoa == makhoa).SingleOrDefault());
}
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 XoaSinhVien(SinhVien sv, dbQuanLyDataContext db)
{
db.SinhViens.DeleteOnSubmit(sv);
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 MonHoc GetMonHocbyMaMH(string mamh, dbQuanLyDataContext db)
{
return(db.MonHocs.SingleOrDefault(p => p.MaMH == mamh));
}
public static void SuaKhoa(Khoa khoa, string tenkhoa, dbQuanLyDataContext db)
{
khoa.TenKhoa = tenkhoa;
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 List <Khoa> GetDSKhoa(dbQuanLyDataContext db)
{
return(db.Khoas.Select(p => p).ToList());
}
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 IQueryable <SinhVien> GetDSSinhVienbyMaKhoa(string makhoa, dbQuanLyDataContext db)
{
return(db.SinhViens.Where(p => p.MaKhoa == makhoa));
}
