public CurrentCreationsResponse GetCurrentCreations(CurrentCreationsRequest request) { var response = new CurrentCreationsResponse { ResponseStatus = ResponseStatus.Success }; var creationsProvider = new CreationsProvider(); try { if (request.ActionType == ActionType.Select) { response.Creations = creationsProvider.GetCreations(request); } else { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = "Not update action"; } } catch (Exception ex) { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = ex.Message; } return(response); }
public List <Creation> GetCreations(CurrentCreationsRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Get_Creations", conn); AddInParameter(commandWrapper, "@TeamId", DbType.Int16, request.TeamId); AddInParameter(commandWrapper, "@Role", DbType.Int16, request.Role); IDataReader reader = null; List <Creation> tmp = new List <Creation>(); try { conn.Open(); reader = commandWrapper.ExecuteReader(); FillCreations(reader, tmp, 0, int.MaxValue); MakeDboLog(request.ToString(), reader.ToString(), "dbo.Get_Creations"); return(tmp); } finally { if (reader != null) { reader.Close(); } commandWrapper.Dispose(); conn.Close(); } }
public CurrentCreationsRequest GetCurrentCreations(int teamId, Role role) { var request = new CurrentCreationsRequest() { TeamId = teamId, Role = role, ActionType = Requests.ActionType.Select }; return(request); }