public async Task <ICollection <NotificacionQueueItem> > GetByStatusAsync(QueueStatus queueStatus) { using (IDbConnection db = new SqlConnection(connectionString)) { string sqlCommand = "SELECT * FROM dbo.NotificationQ WHERE Status = @status"; string status = queueStatus.ToString(); var notificationQList = await db.QueryAsync <Entities.NotificationQ>(sqlCommand, new { status }); var outputResult = new List <NotificacionQueueItem>(); if (notificationQList == null) { return(outputResult); } foreach (var notificacionQ in notificationQList) { var actionType = (ActionType)Enum.Parse(typeof(ActionType), notificacionQ.ActionType); var qStatus = (QueueStatus)Enum.Parse(typeof(QueueStatus), notificacionQ.Status); outputResult.Add(NotificacionQueueItem.Load(notificacionQ.ID, notificacionQ.FuncionarioID, notificacionQ.UserName, actionType, qStatus, notificacionQ.CreateDate, notificacionQ.ModifyDate, notificacionQ.ErrorMessage)); } return(outputResult); } }
private static string ToStatusString(this QueueStatus status) { return(status.ToString().ToLowerInvariant()); }