public List <KQHT_DanhSachDuThiInfo> GetList(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
        {
            List <KQHT_DanhSachDuThiInfo> oKQHT_DanhSachDuThiInfoList = new List <KQHT_DanhSachDuThiInfo>();
            DataTable dtb = Get(pKQHT_DanhSachDuThiInfo);

            if (dtb != null)
            {
                for (int i = 0; i < dtb.Rows.Count; i++)
                {
                    oKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo();

                    oKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID = long.Parse(dtb.Rows[i]["KQHT_DanhSachDuThiID"].ToString());
                    oKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi     = int.Parse(dtb.Rows[i]["IDKQHT_ToChucThi"].ToString());
                    oKQHT_DanhSachDuThiInfo.IDSV_SinhVien        = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
                    oKQHT_DanhSachDuThiInfo.IDDM_PhongHoc        = int.Parse(dtb.Rows[i]["IDDM_PhongHoc"].ToString());
                    oKQHT_DanhSachDuThiInfo.SoBaoDanh            = int.Parse(dtb.Rows[i]["SoBaoDanh"].ToString());
                    oKQHT_DanhSachDuThiInfo.SoPhach  = dtb.Rows[i]["SoPhach"].ToString();
                    oKQHT_DanhSachDuThiInfo.TuiThiSo = int.Parse(dtb.Rows[i]["TuiThiSo"].ToString());
                    oKQHT_DanhSachDuThiInfo.GhiChu   = dtb.Rows[i]["GhiChu"].ToString();

                    oKQHT_DanhSachDuThiInfoList.Add(oKQHT_DanhSachDuThiInfo);
                }
            }
            return(oKQHT_DanhSachDuThiInfoList);
        }
        public void Delete(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID));

            RunProcedure("sp_KQHT_DanhSachDuThi_Delete", colParam);
        }
        public DataTable Get(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID));

            return(RunProcedureGet("sp_KQHT_DanhSachDuThi_Get", colParam));
        }
        public int Add(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
        {
            int ID = 0;

            ID            = oDKQHT_DanhSachDuThi.Add(pKQHT_DanhSachDuThiInfo);
            mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
            mErrorNumber  = oDKQHT_DanhSachDuThi.ErrorNumber;
            return(ID);
        }
 public void ToInfo(ref KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo, DataRow dr)
 {
     pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID = long.Parse(dr[pKQHT_DanhSachDuThiInfo.strKQHT_DanhSachDuThiID].ToString());
     pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi     = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDKQHT_ToChucThi].ToString());
     pKQHT_DanhSachDuThiInfo.IDSV_SinhVien        = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDSV_SinhVien].ToString());
     pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc        = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDDM_PhongHoc].ToString());
     pKQHT_DanhSachDuThiInfo.SoBaoDanh            = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strSoBaoDanh].ToString());
     pKQHT_DanhSachDuThiInfo.SoPhach  = dr[pKQHT_DanhSachDuThiInfo.strSoPhach].ToString();
     pKQHT_DanhSachDuThiInfo.TuiThiSo = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strTuiThiSo].ToString());
     pKQHT_DanhSachDuThiInfo.GhiChu   = dr[pKQHT_DanhSachDuThiInfo.strGhiChu].ToString();
 }
 public void ToDataRow(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo, ref DataRow dr)
 {
     dr[pKQHT_DanhSachDuThiInfo.strKQHT_DanhSachDuThiID] = pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID;
     dr[pKQHT_DanhSachDuThiInfo.strIDKQHT_ToChucThi]     = pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi;
     dr[pKQHT_DanhSachDuThiInfo.strIDSV_SinhVien]        = pKQHT_DanhSachDuThiInfo.IDSV_SinhVien;
     dr[pKQHT_DanhSachDuThiInfo.strIDDM_PhongHoc]        = pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc;
     dr[pKQHT_DanhSachDuThiInfo.strSoBaoDanh]            = pKQHT_DanhSachDuThiInfo.SoBaoDanh;
     dr[pKQHT_DanhSachDuThiInfo.strSoPhach]  = pKQHT_DanhSachDuThiInfo.SoPhach;
     dr[pKQHT_DanhSachDuThiInfo.strTuiThiSo] = pKQHT_DanhSachDuThiInfo.TuiThiSo;
     dr[pKQHT_DanhSachDuThiInfo.strGhiChu]   = pKQHT_DanhSachDuThiInfo.GhiChu;
 }
        public void Update(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi));
            colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDSV_SinhVien));
            colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc));
            colParam.Add(CreateParam("@SoBaoDanh", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.SoBaoDanh));
            colParam.Add(CreateParam("@SoPhach", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.SoPhach));
            colParam.Add(CreateParam("@TuiThiSo", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.TuiThiSo));
            colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.GhiChu));
            colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID));

            RunProcedure("sp_KQHT_DanhSachDuThi_Update", colParam);
        }
        public int Add(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi));
            colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.LanThi));
            colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDSV_SinhVien));
            colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc));
            colParam.Add(CreateParam("@SoBaoDanh", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.SoBaoDanh));
            colParam.Add(CreateParam("@SoPhach", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.SoPhach));
            colParam.Add(CreateParam("@TuiThiSo", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.TuiThiSo));
            colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.GhiChu));
            colParam.Add(CreateParamOut("@ID", SqlDbType.Int));

            return((int)RunProcedureOut("sp_KQHT_DanhSachDuThi_Add", colParam));
        }
        public frmToChucThi(int mIDKQHT_ToChucThi, int mIDDM_MonHoc, string TenMonHoc)
        {
            InitializeComponent();
            IDKQHT_ToChucThi        = mIDKQHT_ToChucThi;
            IDDM_MonHoc             = mIDDM_MonHoc;
            txtTenMonHoc.Text       = TenMonHoc;
            oBDM_Lop                = new cBDM_Lop();
            oBDM_MonHoc             = new cBDM_MonHoc();
            oBKQHT_ToChucThi        = new cBKQHT_ToChucThi();
            pKQHT_ToChucThiInfo     = new KQHT_ToChucThiInfo();
            oBKQHT_DanhSachDuThi    = new cBKQHT_DanhSachDuThi();
            pKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo();
            DataTable dt = (new cBDM_PhongHoc()).GetAll();

            repositoryItemLookUpEditPhongThi.DataSource = dt;
            dtpNgayThi.EditValue = DateTime.Today;
        }
        public frmToChucThi_TotNghiep(int mIDKQHT_ToChucThi, int mIDDM_MonHoc, DataTable dtMonHoc)
        {
            InitializeComponent();
            IDKQHT_ToChucThi = mIDKQHT_ToChucThi;
            cmbMonThiTotNghiep.Properties.DataSource = dtMonHoc;
            cmbMonThiTotNghiep.EditValue             = mIDDM_MonHoc;
            cmbSapXepDanhSach.Properties.DataSource  = bLoadSapXep();

            oBDM_Lop                = new cBDM_Lop();
            oBDM_MonHoc             = new cBDM_MonHoc();
            oBKQHT_ToChucThi        = new cBKQHT_ToChucThi();
            pKQHT_ToChucThiInfo     = new KQHT_ToChucThiInfo();
            oBKQHT_DanhSachDuThi    = new cBKQHT_DanhSachDuThi();
            pKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo();
            DataTable dt = (new cBDM_PhongHoc()).GetAll();

            repositoryItemLookUpEditPhongThi.DataSource = dt;
            dtpNgayThi.EditValue = DateTime.Today;
        }
 public void Update(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
 {
     oDKQHT_DanhSachDuThi.Update(pKQHT_DanhSachDuThiInfo);
     mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
     mErrorNumber  = oDKQHT_DanhSachDuThi.ErrorNumber;
 }
 public DataTable Get(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
 {
     return(oDKQHT_DanhSachDuThi.Get(pKQHT_DanhSachDuThiInfo));
 }