public BESIMREG_REQUESTEDTYPEs GetSIMREG_REQUESTEDTYPEs(SQLHelper sqlHelper)
{
string sql = string.Empty;
BESIMREG_REQUESTEDTYPEs SIMREG_REQUESTEDTYPEs = new BESIMREG_REQUESTEDTYPEs();
try
{
sql = sqlHelper.MakeSQL(@"SELECT * FROM SIMREG_REQUESTEDTYPE ORDER BY REQUESTEDTYPEID");
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToSIMREG_REQUESTEDTYPECollection(SIMREG_REQUESTEDTYPEs, reader);
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return SIMREG_REQUESTEDTYPEs;
}
public BESIMREG_REQUESTEDTYPE GetSIMREG_REQUESTEDTYPE(SQLHelper sqlHelper, int SIMREG_REQUESTEDTYPEId)
{
string sql = string.Empty;
BESIMREG_REQUESTEDTYPEs SIMREG_REQUESTEDTYPEs = new BESIMREG_REQUESTEDTYPEs();
try
{
sql = sqlHelper.MakeSQL(@"SELECT * FROM SIMREG_REQUESTEDTYPE WHERE REQUESTEDTYPEID=$n ORDER BY REQUESTEDTYPEID", SIMREG_REQUESTEDTYPEId);
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToSIMREG_REQUESTEDTYPECollection(SIMREG_REQUESTEDTYPEs, reader);
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
if (SIMREG_REQUESTEDTYPEs.Count > 0)
return SIMREG_REQUESTEDTYPEs[0];
else return new BESIMREG_REQUESTEDTYPE();
}
private BESIMREG_REQUESTEDTYPEs AddToSIMREG_REQUESTEDTYPECollection(BESIMREG_REQUESTEDTYPEs SIMREG_REQUESTEDTYPEs, IDataReader reader)
{
NULLHandler nullHandler = new NULLHandler(reader);
while (reader.Read())
{
SIMREG_REQUESTEDTYPEs.Add(PreaperSIMREG_REQUESTEDTYPEObject(nullHandler));
}
return SIMREG_REQUESTEDTYPEs;
}
