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)); }