public List <EventBriteSearchCriteria> GetAllByCriteria()
{
List <EventBriteSearchCriteria> eventCriterias = new List <EventBriteSearchCriteria>();
_dataProvider.ExecuteCmd("EventBriteSearchCriteria_SelectAll",
parameter => { },
(reader, var) =>
{
EventBriteSearchCriteria eventCriteria = new EventBriteSearchCriteria()
{
Id = (int)reader["Id"],
CriteriaId = (long)reader["CriteriaId"],
CriteriaText = (string)reader["CriteriaText"],
TypeId = (int)reader["TypeId"],
TypeTitle = (string)reader["TypeTitle"]
};
object resourceCheck = reader["ResourceId"];
if (resourceCheck != DBNull.Value)
{
eventCriteria.ResourceId = (int)reader["ResourceId"];
}
eventCriterias.Add(eventCriteria);
});
return(eventCriterias);
}
public HttpResponseMessage ReadEventBriteSearchCriteriaById(int id)
{
EventBriteSearchCriteria answer = _eventBriteService.ReadEventBriteSearchCriteriaById(id);
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
return(Request.CreateResponse(HttpStatusCode.OK, new ItemResponse <EventBriteSearchCriteria>
{
Item = answer
}));
}
public EventBriteSearchCriteria ReadEventBriteSearchCriteriaById(int Id)
{
EventBriteSearchCriteria EventBriteSearchCriteria = new EventBriteSearchCriteria();
_dataProvider.ExecuteCmd(
"EventBriteSearchCriteria_Select_ById",
cmd =>
{
cmd.AddWithValue("@Id", Id);
},
(reader, var) =>
{
EventBriteSearchCriteria.Id = (int)reader["Id"];
EventBriteSearchCriteria.CriteriaId = (long)reader["CriteriaId"];
EventBriteSearchCriteria.CriteriaText = (string)reader["CriteriaText"];
EventBriteSearchCriteria.TypeId = (int)reader["TypeId"];
EventBriteSearchCriteria.TypeTitle = (string)reader["Type"];
});
return(EventBriteSearchCriteria);
}
