public RequestList SelectRows(DbTransaction pTran, System.Int32?Id, System.String requestNumber, System.Int32?customerID, System.DateTime?creationDate, System.Int32?creationUserID, System.DateTime?approvalDate, System.Int32?approvalUserID, System.DateTime?receiveDate, System.Int32?receiveUserID, System.DateTime?rejectionDate, System.Int32?rejectionUserID, System.Int32?rejectionReasonID, System.Int32?requestTypeID, System.Int32?requestStatusID, System.Int32?requestCalssID, System.Int32?requestPriorityID)
{
RequestList RequestList = new RequestList();
Exception exception = null;
DbParameter[] Parameters = new DbParameter[16];
Parameters[0] = _getIdParameter(Id, ParameterDirection.Input);
Parameters[1] = _getrequestNumberParameter(requestNumber, ParameterDirection.Input);
Parameters[2] = _getcustomerIDParameter(customerID, ParameterDirection.Input);
Parameters[3] = _getcreationDateParameter(creationDate, ParameterDirection.Input);
Parameters[4] = _getcreationUserIDParameter(creationUserID, ParameterDirection.Input);
Parameters[5] = _getapprovalDateParameter(approvalDate, ParameterDirection.Input);
Parameters[6] = _getapprovalUserIDParameter(approvalUserID, ParameterDirection.Input);
Parameters[7] = _getreceiveDateParameter(receiveDate, ParameterDirection.Input);
Parameters[8] = _getreceiveUserIDParameter(receiveUserID, ParameterDirection.Input);
Parameters[9] = _getrejectionDateParameter(rejectionDate, ParameterDirection.Input);
Parameters[10] = _getrejectionUserIDParameter(rejectionUserID, ParameterDirection.Input);
Parameters[11] = _getrejectionReasonIDParameter(rejectionReasonID, ParameterDirection.Input);
Parameters[12] = _getrequestTypeIDParameter(requestTypeID, ParameterDirection.Input);
Parameters[13] = _getrequestStatusIDParameter(requestStatusID, ParameterDirection.Input);
Parameters[14] = _getrequestCalssIDParameter(requestCalssID, ParameterDirection.Input);
Parameters[15] = _getrequestPriorityIDParameter(requestPriorityID, ParameterDirection.Input);
DbDataReader Dr = ExecuteReader(pTran, "[Transactions].[SelectRequest]", Parameters);
try
{
if (Dr != null)
{
while (Dr.Read())
{
Request Request = new Request();
if (Dr["Id"] != DBNull.Value)
{
Request.Id = (System.Int32)Dr["Id"];
}
if (Dr["requestNumber"] != DBNull.Value)
{
Request.requestNumber = (System.String)Dr["requestNumber"];
}
if (Dr["totalQuantity"] != DBNull.Value)
{
Request.totalQuantity = (System.Int32?)Dr["totalQuantity"];
}
if (Dr["PDD"] != DBNull.Value)
{
Request.PDD = (System.DateTime?)Dr["PDD"];
}
if (Dr["customerID"] != DBNull.Value)
{
Request.customerID = (System.Int32?)Dr["customerID"];
}
if (Dr["creationDate"] != DBNull.Value)
{
Request.creationDate = (System.DateTime?)Dr["creationDate"];
}
if (Dr["creationUserID"] != DBNull.Value)
{
Request.creationUserID = (System.Int32?)Dr["creationUserID"];
}
if (Dr["approvalDate"] != DBNull.Value)
{
Request.approvalDate = (System.DateTime?)Dr["approvalDate"];
}
if (Dr["approvalUserID"] != DBNull.Value)
{
Request.approvalUserID = (System.Int32?)Dr["approvalUserID"];
}
if (Dr["receiveDate"] != DBNull.Value)
{
Request.receiveDate = (System.DateTime?)Dr["receiveDate"];
}
if (Dr["receiveUserID"] != DBNull.Value)
{
Request.receiveUserID = (System.Int32?)Dr["receiveUserID"];
}
if (Dr["rejectionDate"] != DBNull.Value)
{
Request.rejectionDate = (System.DateTime?)Dr["rejectionDate"];
}
if (Dr["rejectionUserID"] != DBNull.Value)
{
Request.rejectionUserID = (System.Int32?)Dr["rejectionUserID"];
}
if (Dr["rejectionReasonID"] != DBNull.Value)
{
Request.rejectionReasonID = (System.Int32?)Dr["rejectionReasonID"];
}
if (Dr["requestTypeID"] != DBNull.Value)
{
Request.requestTypeID = (System.Int32?)Dr["requestTypeID"];
}
if (Dr["requestStatusID"] != DBNull.Value)
{
Request.requestStatusID = (System.Int32?)Dr["requestStatusID"];
}
if (Dr["requestCalssID"] != DBNull.Value)
{
Request.requestCalssID = (System.Int32?)Dr["requestCalssID"];
}
if (Dr["requestPriorityID"] != DBNull.Value)
{
Request.requestPriorityID = (System.Int32?)Dr["requestPriorityID"];
}
RequestList.FillRow(Request);
Request = null;
}
}
}
catch (Exception Ex)
{
exception = Ex;
}
finally
{
if (Dr != null)
{
if (Dr.IsClosed == false)
{
Dr.Close();
}
Dr = null;
}
}
return(RequestList);
}