public BESIMREG_REQUESTEDBYs GetSIMREG_REQUESTEDBYs(SQLHelper sqlHelper)
{
string sql = string.Empty;
BESIMREG_REQUESTEDBYs SIMREG_REQUESTEDBYs = new BESIMREG_REQUESTEDBYs();
try
{
sql = sqlHelper.MakeSQL(@"SELECT * FROM SIMREG_REQUESTEDBY ORDER BY REQUESTEDBYID");
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToSIMREG_REQUESTEDBYCollection(SIMREG_REQUESTEDBYs, reader);
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return SIMREG_REQUESTEDBYs;
}
public BESIMREG_REQUESTEDBY GetSIMREG_REQUESTEDBY(SQLHelper sqlHelper, int SIMREG_REQUESTEDBYId)
{
string sql = string.Empty;
BESIMREG_REQUESTEDBYs SIMREG_REQUESTEDBYs = new BESIMREG_REQUESTEDBYs();
try
{
sql = sqlHelper.MakeSQL(@"SELECT * FROM SIMREG_REQUESTEDBY WHERE REQUESTEDBYID=$n ORDER BY REQUESTEDBYID", SIMREG_REQUESTEDBYId);
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToSIMREG_REQUESTEDBYCollection(SIMREG_REQUESTEDBYs, reader);
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
if (SIMREG_REQUESTEDBYs.Count > 0)
return SIMREG_REQUESTEDBYs[0];
else return new BESIMREG_REQUESTEDBY();
}
private BESIMREG_REQUESTEDBYs AddToSIMREG_REQUESTEDBYCollection(BESIMREG_REQUESTEDBYs SIMREG_REQUESTEDBYs, IDataReader reader)
{
NULLHandler nullHandler = new NULLHandler(reader);
while (reader.Read())
{
SIMREG_REQUESTEDBYs.Add(PreaperSIMREG_REQUESTEDBYObject(nullHandler));
}
return SIMREG_REQUESTEDBYs;
}
