public RetrieveRequest ( System.Guid uniqueRequestID ) : |
||
uniqueRequestID | System.Guid | |
Результат |
public Collection <RequestForm> GetApprovedRequestsBetweenDates(SqlDateTime begin, SqlDateTime end) { Collection <RequestForm> requestCollection = new Collection <RequestForm>(); SqlConnection connection = new SqlConnection(_connectionString); string commandString = "SELECT [UniqueRequestID] FROM [Intern_CoyoteMoves].[dbo].[RequestData] WHERE [CreateDate] <= @end AND [CreateDate] >= @begin AND [Pending] = 0"; SqlCommand command = new SqlCommand(commandString); command.Parameters.AddWithValue("@begin", begin); command.Parameters.AddWithValue("@end", end); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); SqlToFormModelFactory RequestFactory = new SqlToFormModelFactory(reader); while (reader.Read()) { requestCollection.Add(_requester.RetrieveRequest(reader.GetGuid(reader.GetOrdinal("UniqueRequestID")))); } connection.Close(); return(requestCollection); }