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; }
public RequestForm RetrieveRequest(Guid uniqueRequestID) { SqlConnection connection = new SqlConnection(_connectionString); string commandstring = "EXEC [Intern_CoyoteMoves].[dbo].[spRequestData_GetRequestDataByUniqueID] @guid"; SqlCommand command = new SqlCommand(commandstring); try { command.Parameters.AddWithValue("@guid", uniqueRequestID); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); SqlToFormModelFactory formFactory = new SqlToFormModelFactory(reader); return formFactory.GetRequest(uniqueRequestID); } catch (Exception ex) { throw new Exception(ex.Message); } }