public void printSomeStuff() { //var receiverAddresses = _appUsers.Select(u => u.Email).ToList(); var theseUsers = _appUsers.Select(u => new { u.Email, u.LocationIds }) .Where(u => u.Email == "*****@*****.**") .ToList(); List <UserSelection> thisEmail = new List <UserSelection>(_appUsers.FindAll(u => u.Email == "*****@*****.**")); UserSelection thisUser = _appUsers.Find(u => u.Email == "*****@*****.**"); foreach (int id in thisUser.LocationIds) { Console.WriteLine(Convert.ToString(id) + "\n"); } int hi = 434; if (thisEmail[0].LocationIds.Contains(hi)) { Console.WriteLine("here it is"); } else { Console.WriteLine("It was not in there"); } }
public static List <UserSelection> BuildUserSelection() { List <UserSelection> userSelections = new List <UserSelection>(); using (var connection = new MySqlConnection("Server=test1.ce8cn9mhhgds.us-east-1.rds.amazonaws.com;Database=whattodo;Uid=Wallen;Pwd=MyRDSdb1;Allow User Variables=True;")) { var users = connection.Query <string>("SELECT DISTINCT UserId FROM UserSelection;").ToList(); foreach (string usr in users) { //Console.WriteLine(usr); var locs = connection.Query <int>($"SELECT DISTINCT LocationId FROM UserSelection WHERE UserId = '{usr}';").ToList(); UserSelection userSelection = new UserSelection(usr, locs); userSelections.Add(userSelection); } } return(userSelections); //Console.WriteLine(_appUsers.Count()); }
//List<string> receiverAddresses = new List<string> { "*****@*****.**" }; //var receiverAddresses = _appUsers.Select(u => u.Email).ToList(); public MailBuilder(List <WeatherEvaluator> weatherEvaluators, UserSelection userSelection) { this._weatherEvaluators = weatherEvaluators; this._userSelection = userSelection; this._receiverAddresses.Add(userSelection.Email); }