public GetRequest ( System.Guid requestID ) : |
||
requestID | System.Guid | |
Résultat |
public RequestForm GetRequest(Guid requestID)
{
if (this.reader == null)
{
return null;
}
RequestForm temp = null;
while (this.reader.Read())
{
temp = new RequestForm()
{
CreatedByID = GetCreateByID(),
Current = MakeCurrentInfo(),
Future = MakeFutureInfo(),
EmailInfo = MakeEmailInfo(),
EmployeeId = GetEmployeeID(),
ReviewInfo = MakeReviewInfo(),
UniqueId = requestID,
};
break;
}
return temp;
}
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); } }