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); }