public List <LopHocPhanModel> KiemTra()
{
List <LopHocPhanModel> list = new List <LopHocPhanModel>();
Object[] par =
{
new SqlParameter("@mSLOPHOCPHAN", DBNull.Value),
new SqlParameter("@mSHOCKY", MSHOCKY),
new SqlParameter("@mSHOCPHAN", DBNull.Value),
new SqlParameter("@mALOPHOCPHAN", MALOPHOCPHAN),
new SqlParameter("@tENLOPHOCPHAN", TENLOPHOCPHAN),
new SqlParameter("@sISO", DBNull.Value),
new SqlParameter("@lOAILOPHOCPHAN", DBNull.Value),
new SqlParameter("@kEY", DBKey.CHECK),
};
DataTable dt = DBConnect.SqlStoredProcedure("sp_LopHocPhan", par);
foreach (DataRow item in dt.Rows)
{
LopHocPhanModel lhp = new LopHocPhanModel();
MSLOPHOCPHAN = int.Parse(item["MSLOPHOCPHAN"].ToString());
MALOPHOCPHAN = item["MALOPHOCPHAN"].ToString();
TENLOPHOCPHAN = item["MALOPHOCPHAN"].ToString();
SISO = int.Parse(item["MSLOPHOCPHAN"].ToString());
LOAILOPHOCPHAN = int.Parse(item["MSLOPHOCPHAN"].ToString());
MSHOCPHAN = int.Parse(item["MSLOPHOCPHAN"].ToString());
TENHOCPHAN = item["MALOPHOCPHAN"].ToString();
LYTHUYET = int.Parse(item["MSLOPHOCPHAN"].ToString());
THUCHANH = int.Parse(item["MSLOPHOCPHAN"].ToString());
MSHOCKY = int.Parse(item["MSLOPHOCPHAN"].ToString());
TENHOCKY = item["MALOPHOCPHAN"].ToString();
list.Add(lhp);
}
return(list);
}
public List <LopHocPhanModel> DanhSach()
{
List <LopHocPhanModel> list = new List <LopHocPhanModel>();
Object[] par =
{
new SqlParameter("@mSLOPHOCPHAN", DBNull.Value),
new SqlParameter("@mSHOCKY", MSHOCKY),
new SqlParameter("@mSHOCPHAN", MSHOCPHAN),
new SqlParameter("@mALOPHOCPHAN", DBNull.Value),
new SqlParameter("@tENLOPHOCPHAN", DBNull.Value),
new SqlParameter("@sISO", DBNull.Value),
new SqlParameter("@lOAILOPHOCPHAN", DBNull.Value),
new SqlParameter("@kEY", DBKey.SELECT),
};
DataTable dt = DBConnect.SqlStoredProcedure("sp_LopHocPhan", par);
foreach (DataRow item in dt.Rows)
{
LopHocPhanModel lhp = new LopHocPhanModel();
lhp.MSLOPHOCPHAN = int.Parse(item["MSLOPHOCPHAN"].ToString());
lhp.MALOPHOCPHAN = item["MALOPHOCPHAN"].ToString();
lhp.TENLOPHOCPHAN = item["TENLOPHOCPHAN"].ToString();
lhp.SISO = int.Parse(item["SISO"].ToString());
lhp.LOAILOPHOCPHAN = int.Parse(item["LOAILOPHOCPHAN"].ToString());
lhp.MSHOCPHAN = int.Parse(item["MSHOCPHAN"].ToString());
lhp.TENHOCPHAN = item["TENHOCPHAN"].ToString();
lhp.LYTHUYET = int.Parse(item["LYTHUYET"].ToString());
lhp.THUCHANH = int.Parse(item["THUCHANH"].ToString());
lhp.MSHOCKY = int.Parse(item["MSHOCKY"].ToString());
lhp.TENHOCKY = item["TENHOCKY"].ToString();
lhp.NGAYBATDAU = DateTime.ParseExact(item["NGAYBATDAU"].ToString(), "dd/MM/yyyy", null);
lhp.NGAYKETTHUC = DateTime.ParseExact(item["NGAYKETTHUC"].ToString(), "dd/MM/yyyy", null);
lhp.THOIGIANBATDAUDUTRU = DateTime.ParseExact(item["THOIGIANBATDAUDUTRU"].ToString(), "dd/MM/yyyy", null);
lhp.THOIGIANKETTHUCDUTRU = DateTime.ParseExact(item["THOIGIANKETTHUCDUTRU"].ToString(), "dd/MM/yyyy", null);
list.Add(lhp);
}
return(list);
}