public RequestStatusList SelectRows(DbTransaction pTran, System.Int32?Id, System.String name, System.String nameAr)
{
RequestStatusList RequestStatusList = new RequestStatusList();
Exception exception = null;
DbParameter[] Parameters = new DbParameter[3];
Parameters[0] = _getIdParameter(Id, ParameterDirection.Input);
Parameters[1] = _getnameParameter(name, ParameterDirection.Input);
Parameters[2] = _getnameArParameter(nameAr, ParameterDirection.Input);
DbDataReader Dr = ExecuteReader(pTran, "[Lookups].[SelectRequestStatus]", Parameters);
try
{
if (Dr != null)
{
while (Dr.Read())
{
RequestStatus RequestStatus = new RequestStatus();
if (Dr["Id"] != DBNull.Value)
{
RequestStatus.Id = (System.Int32)Dr["Id"];
}
if (Dr["name"] != DBNull.Value)
{
RequestStatus.name = (System.String)Dr["name"];
}
if (Dr["nameAr"] != DBNull.Value)
{
RequestStatus.nameAr = (System.String)Dr["nameAr"];
}
RequestStatusList.FillRow(RequestStatus);
RequestStatus = null;
}
}
}
catch (Exception Ex)
{
exception = Ex;
}
finally
{
if (Dr != null)
{
if (Dr.IsClosed == false)
{
Dr.Close();
}
Dr = null;
}
}
return(RequestStatusList);
}
