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