public DataTable getLOP_MONHOC_LastCode()
{
CHUNG_CHI cClop = new CHUNG_CHI();
DAL_LOP dao = new DAL_LOP();
return(dao.getLop_MonHoc_LastCode());
}
// Trieu add new
public DataTable getSubjectName(int sCcId)
{
DAL_DANG_KI_HOC dangki_dal = new DAL_DANG_KI_HOC();
CHUNG_CHI sCchi = new CHUNG_CHI();
sCchi.CHC_ID = sCcId;
return(dangki_dal.getSubjectName(sCchi));
}
public DataTable getCC_MONHOC_BY_CCID(int sCcId)
{
cClop = new CHUNG_CHI();
cClop.CHC_ID = sCcId;
DAL_LOP dao = new DAL_LOP();
return(dao.getCC_MONHOC_ID_ID_byCcId(cClop));
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
CHUNG_CHI obj = new CHUNG_CHI();
obj.CHC_ID = int.Parse(dt.Rows[i]["CHC_ID"].ToString());
//some column
return((object)obj);
}
public DataTable getLOP_LastId()
{
CHUNG_CHI cClop = new CHUNG_CHI();
DAL_LOP dao = new DAL_LOP();
return(dao.getLop_LastId());
}
public DataTable getChungChi_ByID(int cCID)
{
CHUNG_CHI cChi = new CHUNG_CHI();
cChi.CHC_ID = cCID;
DAL_CHUNG_CHI dao = new DAL_CHUNG_CHI();
return(dao.getDsCerificate_ByID(cChi));
}
public void delete(int cCID)
{
CHUNG_CHI cChi = new CHUNG_CHI();
cChi.CHC_ID = cCID;
DAL_CHUNG_CHI dao = new DAL_CHUNG_CHI();
dao.delete(cChi);
}
public void delete(CHUNG_CHI Cerificate)
{
SqlParameter[] prams = { MakeInParam("@CHC_ID", SqlDbType.Int, 4, Cerificate.CHC_ID), };
int errorcode = RunProc("usp_DeleteCHUNG_CHI", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
private DataTable vGetCapChungChiGeneral()
{
tbl = new DataTable();
BoCc = new BO_CHUNG_CHI();
vDto = new CHUNG_CHI();
rptbl = new DataTable();
DataColumn colSTT = new DataColumn("STT");
DataColumn colCHCName = new DataColumn("CHC_Name");
DataColumn colCapMoi = new DataColumn("TotlaCapMoi");
DataColumn colCapDoi = new DataColumn("TotalCapDoi");
DataColumn colCapLai = new DataColumn("TotalCapLai");
rptbl.Columns.Add(colSTT);
rptbl.Columns.Add(colCHCName);
rptbl.Columns.Add(colCapMoi);
rptbl.Columns.Add(colCapDoi);
rptbl.Columns.Add(colCapLai);
vDto.CHC_ID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
tbl = BoCc.vGetCapChungChiGeneral(vDto, dateFrom.DateTime, dateEnd.DateTime);
DataTable tblCcName = new DataTable();
if (tbl.Rows.Count > 0)
{
tblCcName = tbl.DefaultView.ToTable(true, "CHC_Name", "CHC_ID");
if (tblCcName.Rows.Count > 0)
{
for (int i = 0; i < tblCcName.Rows.Count; i++)
{
}
DataRow vRow = rptbl.NewRow();
vRow[colSTT] = 1;
for (int i = 0; i < tbl.Rows.Count; i++)
{
DataRow [] xxcolCapLai = tbl.Select("CCC_Status=1");
}
}
}
int ccx = 0;
//ccx = xx.Length;
return(tbl);
}
private void initSubjectList()
{
boMonHoc = new BO_MONHOC();
dtoChungChi = new CHUNG_CHI();
DataTable tb = new DataTable();
dtoChungChi.CHC_ID = int.Parse(lookCcID.GetColumnValue("CHC_ID").ToString());
tb = boMonHoc.getSubjectName(dtoChungChi);
if (tb.Rows.Count > 0)
{
listSubject.DataSource = tb.DefaultView;
listSubject.ValueMember = "MON_ID";
listSubject.DisplayMember = "MON_Name";
listSubject.CheckAll();
}
}
public DataTable vGetCapChungChiGeneral(CHUNG_CHI vDto, DateTime dateFrom, DateTime dateTo)
{
connect();
DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@CHC_ID", SqlDbType.Int, 4, vDto.CHC_ID),
MakeInParam("@DateFrom", SqlDbType.Date, 4, dateFrom),
MakeInParam("@DateTo", SqlDbType.Date, 4, dateTo),
};
errorcode = RunProcDS("CAPCHUNGCHI_ThongKeByIDAndDate", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public DataTable getSubjectName(CHUNG_CHI sCcID)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@CHC_ID", SqlDbType.Int, 4, sCcID.CHC_ID)
};
int errorcode = RunProcDS("usp_SelectSubjectName_ByCouresID", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public DataTable getDsCerificate_ByID(CHUNG_CHI Cerificate)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@CHC_ID", SqlDbType.Int, 4, Cerificate.CHC_ID)
};
int errorcode = RunProcDS("usp_SelectCHUNG_CHI",
prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public void update(string cCCode, string cCName, string vNdung1, string vNdung2, string vNdung3, string vNdung4, string vQtac, string vModleCode, int vStatus, int cCID, string vQDinh, string vQDinhEng)
{
CHUNG_CHI cChi = new CHUNG_CHI();
cChi.CHC_Code = cCCode;
cChi.CHC_Name = cCName;
cChi.CHC_Content1 = vNdung1;
cChi.CHC_Content2 = vNdung2;
cChi.CHC_Content3 = vNdung3;
cChi.CHC_Content4 = vNdung4;
cChi.CHC_QuyTac = vQtac;
cChi.CHC_ModleCode = vModleCode;
cChi.CHC_Status = vStatus;
cChi.CHC_QuyDinh = vQDinh;
cChi.CHC_QuyDinhEngl = vQDinhEng;
cChi.CHC_ID = cCID;
DAL_CHUNG_CHI dao = new DAL_CHUNG_CHI();
dao.update(cChi);
}
private bool vLoadChungChi()
{
DataTable vtb = new System.Data.DataTable();
dtoChungChi = new CHUNG_CHI();
boChungChi = new BO_CHUNG_CHI();
vtb = boChungChi.getChungChi_All();
if (vtb.Rows.Count > 0)
{
lookCcID.Properties.DataSource = vtb.DefaultView;
lookCcID.Properties.ValueMember = "CHC_ID";
lookCcID.Properties.DisplayMember = "CHC_Name";
lookCcID.EditValue = gChungChiID;
return(true);
}
else
{
return(false);
}
}
public DataTable getCC_MONHOC_ID_ID_byCcId(CHUNG_CHI ccID)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@CHC_ID", SqlDbType.Int, 4, ccID.CHC_ID)
};
int errorcode = RunProcDS("usp_SelectMONHOC_ID_byCcId",
prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public void update(CHUNG_CHI Cerificate)
{
SqlParameter[] prams = { MakeInParam("@CHC_ID", SqlDbType.Int, 4, Cerificate.CHC_ID),
MakeInParam("@CHC_Code", SqlDbType.NVarChar, 50, Cerificate.CHC_Code),
MakeInParam("@CHC_Name", SqlDbType.NVarChar, 200, Cerificate.CHC_Name),
MakeInParam("@CHC_Content1", SqlDbType.NVarChar, 200, Cerificate.CHC_Content1),
MakeInParam("@CHC_Content2", SqlDbType.NVarChar, 200, Cerificate.CHC_Content2),
MakeInParam("@CHC_Content3", SqlDbType.NVarChar, 200, Cerificate.CHC_Content3),
MakeInParam("@CHC_Content4", SqlDbType.NVarChar, 200, Cerificate.CHC_Content4),
MakeInParam("@CHC_QuyTac", SqlDbType.NVarChar, 50, Cerificate.CHC_QuyTac),
MakeInParam("@CHC_ModleCode", SqlDbType.NVarChar, 50, Cerificate.CHC_ModleCode),
MakeInParam("@CHC_Status", SqlDbType.Int, 4, Cerificate.CHC_Status),
MakeInParam("@CHC_QuyDinh", SqlDbType.NVarChar, 50, Cerificate.CHC_QuyDinh),
MakeInParam("@CHC_QuyDinhEng", SqlDbType.NVarChar, 50, Cerificate.CHC_QuyDinhEngl)
//MakeInParam("@ActionOpt",SqlDbType.Bit,0,0)
};
int errorcode = RunProc("usp_UpdateCHUNG_CHI", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public void insert(string cCCode, string cCName, string vNdung1, string vNdung2, string vNdung3, string vNdung4, string vQtac, string vModleCode, int vStatus, string vQDinh, string vQDinhEng, int vFontSize1, int vFontSize2, int vFontSize3, int vFontSize4)
{
CHUNG_CHI cChi = new CHUNG_CHI();
cChi.CHC_Code = cCCode;
cChi.CHC_Name = cCName;
cChi.CHC_Content1 = vNdung1;
cChi.CHC_Content2 = vNdung2;
cChi.CHC_Content3 = vNdung3;
cChi.CHC_Content4 = vNdung4;
cChi.CHC_QuyTac = vQtac;
cChi.CHC_ModleCode = vModleCode;
cChi.CHC_Status = vStatus;
cChi.CHC_QuyDinh = vQDinh;
cChi.CHC_QuyDinhEngl = vQDinhEng;
cChi.CHC_FontSize1 = vFontSize1;
cChi.CHC_FontSize2 = vFontSize2;
cChi.CHC_FontSize3 = vFontSize3;
cChi.CHC_FontSize4 = vFontSize4;
cChi.CHC_ID = 1;
DAL_CHUNG_CHI dao = new DAL_CHUNG_CHI();
dao.insert(cChi);
}
public DataTable getLOP_LastCode()
{
cClop = new CHUNG_CHI();
dao = new DAL_LOP();
return(dao.getDsLop_LastCode());
}
public DataTable getSubjectName(CHUNG_CHI vDto)
{
dao = new DAL_MONHOC();
return(dao.getSubjectName(vDto));
}
