public static void ResetMK(string maND)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
NGUOIDUNG nd = db.NGUOIDUNGs.Where(a => a.MAND == maND).FirstOrDefault();
nd.MATKHAU = "123456789";
db.SubmitChanges();
}
}
// Xóa người dùng
public static void delete(string maND)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
NGUOIDUNG nd = db.NGUOIDUNGs.Where(a => a.MAND == maND).FirstOrDefault();
db.NGUOIDUNGs.DeleteOnSubmit(nd);
db.SubmitChanges();
}
}
// Sửa môn học
public static void update(string maMH, string tenMH)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
MONHOC mh = db.MONHOCs.Where(a => a.MAMONHOC == maMH).FirstOrDefault();
mh.TENMONHOC = tenMH;
db.SubmitChanges();
}
}
// Sửa hệ số học kỳ
public static void Update(string maHK, int heSo)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
HOCKY hk = db.HOCKies.Where(a => a.MAHK == maHK).FirstOrDefault();
hk.HESO = heSo;
db.SubmitChanges();
}
}
// Sửa người dùng
public static void update(string maND, string tenNguoiDung, string maLND)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
NGUOIDUNG nd = db.NGUOIDUNGs.Where(a => a.MAND == maND).FirstOrDefault();
nd.TENNGUOIDUNG = tenNguoiDung;
nd.MALND = maLND;
db.SubmitChanges();
}
}
// Sửa lớp
public static void Update(string maLop, string tenLop, string maKhoi)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
LOP l = db.LOPs.Where(a => a.MALOP == maLop).FirstOrDefault();
l.TENLOP = tenLop;
l.MAKHOI = maKhoi;
db.SubmitChanges();
}
}
// Thêm môn học
public static void insert(string maMH, string tenMH)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
MONHOC mh = new MONHOC();
mh.MAMONHOC = maMH;
mh.TENMONHOC = tenMH;
db.MONHOCs.InsertOnSubmit(mh);
db.SubmitChanges();
}
}
// Sửa học sinh
public static void Update(string maHS, string hoTen, string gioiTinh, DateTime ngaySinh, string diaChi, string email)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
HOCSINH hs = db.HOCSINHs.Where(a => a.MAHS == maHS).FirstOrDefault();
hs.HOTEN = hoTen;
hs.GIOITINH = gioiTinh;
hs.NGAYSINH = ngaySinh;
hs.DIACHI = diaChi;
hs.EMAIL = email;
db.SubmitChanges();
}
}
// Thêm Lớp
public static void Insert(string maLop, string tenLop, string maKhoi)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
LOP l = new LOP();
l.MALOP = maLop;
l.TENLOP = tenLop;
l.MAKHOI = maKhoi;
l.SISO = null;
db.LOPs.InsertOnSubmit(l);
db.SubmitChanges();
}
}
// Thêm người dùng
public static void insert(string maND, string tenNguoiDung, string maLND, string tenDangNhap)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
NGUOIDUNG nd = new NGUOIDUNG();
nd.MAND = maND;
nd.TENNGUOIDUNG = tenNguoiDung;
nd.MALND = maLND;
nd.TENDANGNHAP = tenDangNhap;
nd.MATKHAU = "123456789";
db.NGUOIDUNGs.InsertOnSubmit(nd);
db.SubmitChanges();
}
}
// Thêm học sinh
public static void Insert(string maHS, string hoTen, string gioiTinh, DateTime ngaySinh, string diaChi, string email)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
HOCSINH hs = new HOCSINH();
hs.MAHS = maHS;
hs.HOTEN = hoTen;
hs.GIOITINH = gioiTinh;
hs.NGAYSINH = ngaySinh;
hs.DIACHI = diaChi;
hs.EMAIL = email;
db.HOCSINHs.InsertOnSubmit(hs);
db.SubmitChanges();
}
}