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