public static void LuuPhanLopHS(string maHS, string maLop, string maNamHoc)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
db.sp_ThemQTH(maHS, maLop, maNamHoc);
}
}
// Xóa học sinh
public static void Delete(string maHS)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
db.sp_XoaHocSinh(maHS);
}
}
// Lấy danh sách Mã HS, họ tên học sinh đã được phân lớp
public static DataTable LayDSHocSinhDaPhanLop()
{
DataTable dt = new DataTable();
dt.Columns.Add("MAHS", typeof(string));
dt.Columns.Add("HOTEN", typeof(string));
SQL_QLHSDataContext db = new SQL_QLHSDataContext();
var lst = HOCSINH_DAL.LayDSHocSinhDaPhanLop();
foreach (var i in lst)
{
DataRow r = dt.NewRow();
if (i.MAHS != null)
{
r["MAHS"] = i.MAHS;
}
if (i.HOTEN != null)
{
r["HOTEN"] = i.HOTEN;
}
dt.Rows.Add(r);
}
if (dt.Rows.Count == 0)
{
return(null);
}
return(dt);
}
// Lấy tham số
public static THAMSO LayThamSo(string tenThamSo)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
return(db.THAMSOs.Where(a => a.TENTHAMSO == tenThamSo).FirstOrDefault());
}
}
// Lấy danh sách tất cả học sinh
public static List <HOCSINH> LayTatCaHocSinh()
{
List <HOCSINH> lst = new List <HOCSINH>();
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
var ds = from hs in db.HOCSINHs
select new
{
MAHS = hs.MAHS,
HOTEN = hs.HOTEN,
GIOITINH = hs.GIOITINH,
NGAYSINH = hs.NGAYSINH,
DIACHI = hs.DIACHI,
EMAIL = hs.EMAIL
};
foreach (var x in ds)
{
HOCSINH hs = new HOCSINH();
{
hs.MAHS = x.MAHS;
hs.HOTEN = x.HOTEN;
hs.GIOITINH = x.GIOITINH;
hs.NGAYSINH = x.NGAYSINH;
hs.DIACHI = x.DIACHI;
hs.EMAIL = x.EMAIL;
lst.Add(hs);
}
}
}
return(lst);
}
// Lấy tất cả các lớp
public static List <LOP> LayTatCaLop()
{
//using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
//{
// List<LOP> lst = db.LOPs.ToList();
// return lst;
//}
List <LOP> lst = new List <LOP>();
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
var ds = from lop in db.LOPs
select lop;
foreach (var x in ds)
{
LOP lop = new LOP();
{
lop.MALOP = x.MALOP;
lop.TENLOP = x.TENLOP;
lst.Add(lop);
}
}
}
return(lst);
}
// Tạo MaHS
public static string autoMaHS()
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
return(db.AUTO_IDHS());
}
}
// Sửa điểm
public static void SuaDiem(string maHS, string maMon, string mahocky, string maLop, float diemMieng, float diem15P, float diem1Tiet, float diemThi)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
db.sp_SuaDiem(maHS, maMon, mahocky, maLop, diemMieng, diem15P, diem1Tiet, diemThi);
}
}
// Xóa môn học
public static void delete(string maMH)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
db.sp_XoaMonHoc(maMH);
}
}
// Xóa lớp
public static void Delete(string maLop)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
db.sp_XoaLop(maLop);
}
}
// Lấy khối lớp theo mã khối mã năm
public static List <KHOILOP> LayKhoiTheoMaKhoiMaNam(string tenKhoiLop, string maNamHoc)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
return(db.KHOILOPs.Where(a => a.MANAM == maNamHoc && a.TENKHOI == tenKhoiLop).ToList());
}
}
// Lấy năm học theo Mã HS
public static DataTable LayNamHocTheoMaHS(string maHS)
{
DataTable dt = new DataTable();
dt.Columns.Add("MANAMHOC", typeof(string));
dt.Columns.Add("TENNAMHOC", typeof(string));
SQL_QLHSDataContext db = new SQL_QLHSDataContext();
var lst = NAMHOC_DAL.LayNamHocTheoMaHS(maHS);
foreach (var i in lst)
{
DataRow r = dt.NewRow();
if (i.MANAMHOC != null)
{
r["MANAMHOC"] = i.MANAMHOC;
}
if (i.TENNAMHOC != null)
{
r["TENNAMHOC"] = i.TENNAMHOC;
}
dt.Rows.Add(r);
}
if (dt.Rows.Count == 0)
{
return(null);
}
return(dt);
}
// Xóa năm học
public static void Delete(string maNamHoc)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
db.sp_XoaNamHoc(maNamHoc);
}
}
// Thêm năm học
public static void Insert()
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
db.sp_ThemNamHoc();
}
}
// Lấy tất cả các môn học
public static List <MONHOC> LayTatCaMonHoc()
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
List <MONHOC> lst = db.MONHOCs.ToList();
return(lst);
}
}
// Lấy tất cả các khối
public static List <KHOILOP> LayTatCaKhoi()
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
List <KHOILOP> lst = db.KHOILOPs.ToList();
return(lst);
}
}
// Lấy tất cả các học kỳ
public static List <HOCKY> LayTatCaHocKy()
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
List <HOCKY> lst = db.HOCKies.ToList();
return(lst);
}
}
// Lưu quy định
public static void LuuQuyDinh(double tuoiToiThieu, double tuoiToiDa, double siSoToiDa,
double diemToiThieu, double diemToiDa, double diemDatMon, double diemDatHK)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
db.sp_LuuQuyDinh(tuoiToiThieu, tuoiToiDa, siSoToiDa, diemToiThieu, diemToiDa, diemDatMon, diemDatHK);
}
}
// Lấy hệ số
public static int layHeSo(string maHK)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
HOCKY hk = db.HOCKies.Where(a => a.MAHK == maHK).FirstOrDefault();
return(hk.HESO.Value);
}
}
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();
}
}
public static string LayMatKhau(string code)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
if (db.NGUOIDUNGs.Any(u => u.MAND == code))
{
return(db.NGUOIDUNGs.First(u => u.MAND == code).MATKHAU);
}
return("unknown");
}
}
public static string LayQuyen(string code)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
if (db.NGUOIDUNGs.Any(u => u.MAND == code))
{
return(db.NGUOIDUNGs.First(u => u.MAND == code).LOAINGUOIDUNG.TENLOAIND);
}
return("unknown");
}
}
public static string LayTenDangNhap(string code)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
if (db.NGUOIDUNGs.Any(u => u.MAND == code))
{
return(db.NGUOIDUNGs.First(u => u.MAND == code).TENDANGNHAP);
}
return("unknown");
}
}
public static string LayTenNguoiDung(string code)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
if (db.NGUOIDUNGs.Any(u => u.MAND == code))
{
return(db.NGUOIDUNGs.First(u => u.MAND == code).TENNGUOIDUNG);
}
return("unknown");
}
}
public static bool KiemTraTonTai(string tendangnhap)
{
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
if (db.NGUOIDUNGs.Any(u => u.TENDANGNHAP == tendangnhap))
{
return(true);
}
return(false);
}
}
