public BESIMREG_DOMAINUSER GetSIMREG_DOMAINUSER(SQLHelper sqlHelper, string UserName)
{
string sql = string.Empty;
BESIMREG_DOMAINUSERs SIMREG_DOMAINUSERs = new BESIMREG_DOMAINUSERs();
try
{
sql = sqlHelper.MakeSQL("SELECT * FROM SIMREG_DOMAINUSER WHERE username=$s", UserName);
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToCollection(SIMREG_DOMAINUSERs, reader);
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
if (SIMREG_DOMAINUSERs.Count > 0)
{
return SIMREG_DOMAINUSERs[0];
}
else return new BESIMREG_DOMAINUSER();
}
public BESIMREG_DOMAINUSERs GetSIMREG_DOMAINUSERs(SQLHelper sqlHelper)
{
string sql = string.Empty;
BESIMREG_DOMAINUSERs SIMREG_DOMAINUSERs = new BESIMREG_DOMAINUSERs();
try
{
sql = sqlHelper.MakeSQL("SELECT userid, loginname, username FROM SIMREG_DOMAINUSER WHERE IsDeleted=$b", false);
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToCollection(SIMREG_DOMAINUSERs, reader);
reader.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return SIMREG_DOMAINUSERs;
}
private BESIMREG_DOMAINUSERs AddToCollection(BESIMREG_DOMAINUSERs SIMREG_DOMAINUSERs, IDataReader reader)
{
try
{
NULLHandler nullHandler = new NULLHandler(reader);
while (reader.Read())
{
SIMREG_DOMAINUSERs.Add(PreaperObject(nullHandler));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return SIMREG_DOMAINUSERs;
}
