public Task <IEnumerable <PendenzenItem> > GetPendenzenData(string itemType) { var identity = (ClaimsIdentity)HttpContext.User.Identity; IEnumerable <Claim> claims = identity.Claims; var userId = claims.Where(c => c.Type == Kiss4WebClaims.UserId) .Select(c => c.Value).SingleOrDefault(); var query = new GetPendenzenQuery { ItemType = itemType, UserId = userId }; return(_mediator.Process(query)); }
public override async Task <IEnumerable <PendenzenItem> > Handle(GetPendenzenQuery query) { var userId = query.UserId; string searchCommand = GetPendenzenCommand.GetPendenzen; if (!string.IsNullOrEmpty(query.ItemType)) { searchCommand += " WHERE "; switch (query.ItemType) { case "SC001_left-menu_meine-pendenzen_fallige": // set load condition of case Meine Pendenzen - fällige searchCommand += GetPendenzenCommand.FilterPendenzen_11; break; case "1_2": // set load condition of case Meine Pendenzen - offene searchCommand += GetPendenzenCommand.FilterPendenzen_12; break; case "1_3": // set load condition of case Meine Pendenzen - in Bearbeitung searchCommand += GetPendenzenCommand.FilterPendenzen_13; break; case "1_4": // set load condition of case Meine Pendenzen - selber erstellte searchCommand += GetPendenzenCommand.FilterPendenzen_14; break; case "1_5": // set load condition of case Meine Pendenzen - erhaltene searchCommand += GetPendenzenCommand.FilterPendenzen_15; break; case "1_6": // set load condition of case Meine Pendenzen - zu visierende searchCommand += GetPendenzenCommand.FilterPendenzen_16; break; case "1_7": // set load condition of case Meine Pendenzen - zu visierende searchCommand += GetPendenzenCommand.FilterPendenzen_17; break; case "1_8": // set load condition of case Meine Pendenzen - erledigte searchCommand += GetPendenzenCommand.FilterPendenzen_18; break; case "2_1": // set load condition of case Erstellte Pendenzen - fällige searchCommand += GetPendenzenCommand.FilterPendenzen_21; break; case "2_2": // set load condition of case Erstellte Pendenzen - offene searchCommand += GetPendenzenCommand.FilterPendenzen_22; break; case "2_3": // set load condition of case Erstellte Pendenzen - allgemeine searchCommand += GetPendenzenCommand.FilterPendenzen_23; break; case "2_4": // set load condition of case Erstellte Pendenzen - zu visierende searchCommand += GetPendenzenCommand.FilterPendenzen_24; break; case "2_5": // set load condition of case Erstellte Pendenzen - zu visierende searchCommand += GetPendenzenCommand.FilterPendenzen_25; break; case "2_6": // set load condition of case Erstellte Pendenzen - erledigte searchCommand += GetPendenzenCommand.FilterPendenzen_26; break; } searchCommand += " ORDER BY TSK.CreateDate DESC"; var data = await _dbConnection.QueryAsync <PendenzenItem>(searchCommand, new { userId }); var result = data.AsList(); if (result.Count > 0) { return(result); } } return(new List <PendenzenItem>()); }