public DataTable Get(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DanhSachMienGiamID", SqlDbType.Int, pTC_DanhSachMienGiamInfo.TC_DanhSachMienGiamID));
return(RunProcedureGet("sp_TC_DanhSachMienGiam_Get", colParam));
}
public void Delete(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DanhSachMienGiamID", SqlDbType.Int, pTC_DanhSachMienGiamInfo.TC_DanhSachMienGiamID));
RunProcedure("sp_TC_DanhSachMienGiam_Delete", colParam);
}
public int Add(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo)
{
int ID = 0;
ID = oDTC_DanhSachMienGiam.Add(pTC_DanhSachMienGiamInfo);
mErrorMessage = oDTC_DanhSachMienGiam.ErrorMessages;
mErrorNumber = oDTC_DanhSachMienGiam.ErrorNumber;
return(ID);
}
public void ToInfo(ref TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo, DataRow dr)
{
pTC_DanhSachMienGiamInfo.TC_DanhSachMienGiamID = int.Parse(dr[pTC_DanhSachMienGiamInfo.strTC_DanhSachMienGiamID].ToString());
pTC_DanhSachMienGiamInfo.IDSV_SinhVien = int.Parse(dr[pTC_DanhSachMienGiamInfo.strIDSV_SinhVien].ToString());
pTC_DanhSachMienGiamInfo.IDDM_NamHoc = int.Parse(dr[pTC_DanhSachMienGiamInfo.strIDDM_NamHoc].ToString());
pTC_DanhSachMienGiamInfo.HocKy = int.Parse(dr[pTC_DanhSachMienGiamInfo.strHocKy].ToString());
pTC_DanhSachMienGiamInfo.IDTC_LoaiThuChi = int.Parse(dr[pTC_DanhSachMienGiamInfo.strIDTC_LoaiThuChi].ToString());
pTC_DanhSachMienGiamInfo.SoTienMienGiam = double.Parse(dr[pTC_DanhSachMienGiamInfo.strSoTienMienGiam].ToString());
pTC_DanhSachMienGiamInfo.GhiChu = dr[pTC_DanhSachMienGiamInfo.strGhiChu].ToString();
}
public void ToDataRow(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo, ref DataRow dr)
{
dr[pTC_DanhSachMienGiamInfo.strTC_DanhSachMienGiamID] = pTC_DanhSachMienGiamInfo.TC_DanhSachMienGiamID;
dr[pTC_DanhSachMienGiamInfo.strIDSV_SinhVien] = pTC_DanhSachMienGiamInfo.IDSV_SinhVien;
dr[pTC_DanhSachMienGiamInfo.strIDDM_NamHoc] = pTC_DanhSachMienGiamInfo.IDDM_NamHoc;
dr[pTC_DanhSachMienGiamInfo.strHocKy] = pTC_DanhSachMienGiamInfo.HocKy;
dr[pTC_DanhSachMienGiamInfo.strIDTC_LoaiThuChi] = pTC_DanhSachMienGiamInfo.IDTC_LoaiThuChi;
dr[pTC_DanhSachMienGiamInfo.strSoTienMienGiam] = pTC_DanhSachMienGiamInfo.SoTienMienGiam;
dr[pTC_DanhSachMienGiamInfo.strGhiChu] = pTC_DanhSachMienGiamInfo.GhiChu;
}
public frmDanhSachMienGiam()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_DoiTuongMienGiamInfo = new DM_DoiTuongMienGiamInfo();
oBDM_DoiTuongMienGiam = new cBDM_DoiTuongMienGiam();
pTC_DanhSachMienGiamInfo = new TC_DanhSachMienGiamInfo();
oBTC_DanhSachMienGiam = new cBTC_DanhSachMienGiam();
pTC_LoaiThuChiInfo = new TC_LoaiThuChiInfo();
oBTC_LoaiThuChi = new cBTC_LoaiThuChi();
oBTC_DanhSachMienGiam_ChiTiet = new cBTC_DanhSachMienGiam_ChiTiet();
pTC_DanhSachMienGiam_ChiTietInfo = new TC_DanhSachMienGiam_ChiTietInfo();
}
public void Update(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DanhSachMienGiamInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DanhSachMienGiamInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DanhSachMienGiamInfo.HocKy));
colParam.Add(CreateParam("@IDTC_LoaiThuChi", SqlDbType.Int, pTC_DanhSachMienGiamInfo.IDTC_LoaiThuChi));
colParam.Add(CreateParam("@SoTienMienGiam", SqlDbType.Money, pTC_DanhSachMienGiamInfo.SoTienMienGiam));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pTC_DanhSachMienGiamInfo.GhiChu));
colParam.Add(CreateParam("@TC_DanhSachMienGiamID", SqlDbType.Int, pTC_DanhSachMienGiamInfo.TC_DanhSachMienGiamID));
RunProcedure("sp_TC_DanhSachMienGiam_Update", colParam);
}
public int Add(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DanhSachMienGiamInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DanhSachMienGiamInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DanhSachMienGiamInfo.HocKy));
colParam.Add(CreateParam("@IDTC_LoaiThuChi", SqlDbType.Int, pTC_DanhSachMienGiamInfo.IDTC_LoaiThuChi));
colParam.Add(CreateParam("@SoTienMienGiam", SqlDbType.Money, pTC_DanhSachMienGiamInfo.SoTienMienGiam));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pTC_DanhSachMienGiamInfo.GhiChu));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_DanhSachMienGiam_Add", colParam));
}
public List <TC_DanhSachMienGiamInfo> GetList(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo)
{
List <TC_DanhSachMienGiamInfo> oTC_DanhSachMienGiamInfoList = new List <TC_DanhSachMienGiamInfo>();
DataTable dtb = Get(pTC_DanhSachMienGiamInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_DanhSachMienGiamInfo = new TC_DanhSachMienGiamInfo();
oTC_DanhSachMienGiamInfo.TC_DanhSachMienGiamID = int.Parse(dtb.Rows[i]["TC_DanhSachMienGiamID"].ToString());
oTC_DanhSachMienGiamInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oTC_DanhSachMienGiamInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oTC_DanhSachMienGiamInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oTC_DanhSachMienGiamInfo.IDTC_LoaiThuChi = int.Parse(dtb.Rows[i]["IDTC_LoaiThuChi"].ToString());
oTC_DanhSachMienGiamInfo.SoTienMienGiam = double.Parse(dtb.Rows[i]["SoTienMienGiam"].ToString());
oTC_DanhSachMienGiamInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString();
oTC_DanhSachMienGiamInfoList.Add(oTC_DanhSachMienGiamInfo);
}
}
return(oTC_DanhSachMienGiamInfoList);
}
public void Delete(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo)
{
oDTC_DanhSachMienGiam.Delete(pTC_DanhSachMienGiamInfo);
mErrorMessage = oDTC_DanhSachMienGiam.ErrorMessages;
mErrorNumber = oDTC_DanhSachMienGiam.ErrorNumber;
}
public DataTable Get(TC_DanhSachMienGiamInfo pTC_DanhSachMienGiamInfo)
{
return(oDTC_DanhSachMienGiam.Get(pTC_DanhSachMienGiamInfo));
}