public async Task <ActionResult <IEnumerable <EventMessage> > > getEventMessageErrorList()
{
// 1. Create DbAdapter object for execute user to database.
var adapter = new DbAdapter(_config.GetConnectionString("DefaultConnection"));
// 2. Execute SqlCommand data to DataSet.
DataSet dsSet = await adapter.getDataSetAsync(
"SP_EventMessage_ErrorList",
CommandType.StoredProcedure);
// Final Return the events
return(EventMessageHelper.convertDataSetToEventMessageList(dsSet));
}
public async Task <ActionResult <IEnumerable <EventMessage> > > findEventMessageByKey(string eventKey)
{
// 1. Create DbAdapter object for execute user to database.
var adapter = new DbAdapter(_config.GetConnectionString("DefaultConnection"));
// 2. Get stream data to DataSet object.
DataSet dsSet = await adapter.getDataSetAsync(
"SP_EventMessage_Find",
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@EventKey", eventKey)
});
// 3. If not seek event key then return notfound object.
if (dsSet == null && dsSet.Tables[0].Rows.Count == 0)
{
return(NotFound());
}
// Final return events.
return(EventMessageHelper.convertDataSetToEventMessageList(dsSet));
}
