/// <summary>
/// Returns a user from the db, given the user's email
/// </summary>
/// <param name="email">The email of the user. (string)</param>
/// <returns>The user.</returns>
public static User LoadUserFromEmail(string email)
{
Stopwatch watch = Stopwatch.StartNew();
string sql = @"SELECT Id, Email, Username, Password, SchoolId FROM dbo.Users
WHERE Email = @Id";
List <User> users = AzureDataStore.LoadDataWithString <User>(sql, email);
User output = users.FirstOrDefault();
watch.Stop();
Analytics.TrackEvent(nameof(LoadUserFromEmail), new Dictionary <string, string>
{
{ "ElapsedTime", $"{ watch.ElapsedMilliseconds } ms" }
});
return(output);
}
/// <summary>
/// Checks whether an email has an account.
/// </summary>
/// <param name="email">The email to check in the db.s</param>
/// <returns>Whether the email has an account. (bool)</returns>
public static bool CheckForUser(string email)
{
Stopwatch watch = Stopwatch.StartNew();
string sql = @"SELECT 1 FROM dbo.Users
WHERE Email = @Id";
List <User> result = AzureDataStore.LoadDataWithString <User>(sql, email);
bool output = result.Count > 0;
watch.Stop();
Analytics.TrackEvent(nameof(CheckForUser), new Dictionary <string, string>
{
{ "ElapsedTime", $"{ watch.ElapsedMilliseconds } ms" }
});
return(output);
}