|
public GetRequest ( System.Guid requestID ) : |
||
| requestID | System.Guid | |
| return | ||
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);
}
}
