protected override object GetDataFromDataRow(DataTable dt, int i)
{
NGUOIDUNG obj = new NGUOIDUNG();
obj.NGU_ID = int.Parse(dt.Rows[i]["NGU_ID"].ToString());
//some column
return((object)obj);
}
public void delete(NGUOIDUNG nguoidung)
{
SqlParameter[] prams =
{
MakeInParam("@NGU_ID", SqlDbType.Int, 4, nguoidung.NGU_ID)
};
int errorcode = RunProc("usp_DeleteNGUOIDUNG", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public void update(NGUOIDUNG nguoidung)
{
SqlParameter[] prams =
{
MakeInParam("@NGU_ID", SqlDbType.Int, 4, nguoidung.NGU_ID),
MakeInParam("@NGU_Code", SqlDbType.NVarChar, 20, nguoidung.NGU_Code),
MakeInParam("@NGU_Name", SqlDbType.NVarChar, 50, nguoidung.NGU_Name),
MakeInParam("@NGU_UserName", SqlDbType.NVarChar, 50, nguoidung.NGU_UserName),
MakeInParam("@NGU_Password", SqlDbType.NVarChar, 50, nguoidung.NGU_Password)
};
int errorcode = RunProc("usp_UpdateNGUOIDUNG", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public DataTable getByID_NGUOIDUNG(NGUOIDUNG nguoidung)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@NGU_ID", SqlDbType.Int, 4, nguoidung.NGU_ID)
};
int errorcode = RunProcDS("usp_SelectNGUOIDUNG", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
public DataTable getNguoiDung_byUserName(NGUOIDUNG userName)
{
connect();
DataSet DS = new DataSet();
SqlParameter[] prams =
{
MakeInParam("@NGU_UserName", SqlDbType.NVarChar, 50, userName.NGU_UserName)
};
int errorcode = RunProcDS("GetNguoiDung_ByUserName", prams, out DS);
if (errorcode > 0)
{
throw new Exception("Error!");
}
return(DS.Tables[0]);
}
