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