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