public static async Task <UserPostingHistory> GetUserPostingHistory(string userName) { using (var con = DirtBagConnection.GetConn()) { var query = "" + "Select up.ChannelID, up.ThingID " + "FROM dirtbag.UserPosts up " + //"left JOIN dirtbag.PostRemovals rem on up.PostID = rem.PostID " + "where username like @UserName " + "and up.ChannelID is not null " + //"group by channelid"; ""; UserPostingHistory results = new UserPostingHistory(); results.UserName = userName; results.PostingHistory = new Dictionary <string, List <string> >(); var vals = await con.QueryAsync(query, param : new { userName }); foreach (dynamic kv in vals) { if (!results.PostingHistory.ContainsKey(kv.ChannelID)) { results.PostingHistory.Add(kv.ChannelID, new List <string>()); } results.PostingHistory[kv.ChannelID].Add(kv.ThingID); } return(results); } }
public static async Task<UserPostingHistory> GetUserPostingHistory( string userName ) { using ( var con = DirtBagConnection.GetConn() ) { var query = "" + "Select up.ChannelID, up.ThingID " + "FROM dirtbag.UserPosts up " + //"left JOIN dirtbag.PostRemovals rem on up.PostID = rem.PostID " + "where username like @UserName " + "and up.ChannelID is not null " + //"group by channelid"; ""; UserPostingHistory results = new UserPostingHistory(); results.UserName = userName; results.PostingHistory = new Dictionary<string, List<string>>(); var vals = await con.QueryAsync( query, param: new { userName } ); foreach(dynamic kv in vals ) { if ( !results.PostingHistory.ContainsKey( kv.ChannelID ) ) results.PostingHistory.Add( kv.ChannelID, new List<string>() ); results.PostingHistory[kv.ChannelID].Add( kv.ThingID ); } return results; } }