public string GetPinFromUserId(int userId, string fileName = "")
{
if (!string.IsNullOrEmpty(fileName))
{
userId = GetUserIdFromFile(fileName);
}
var query = "Select Pin From dbo.UserAccount Where UserId = @userId";
var cmd = new SqlCommand(query, _connector.GetConnectionObject());
cmd.Parameters.AddWithValue("@userId", userId);
return(_connector.ExecuteSqlScalarStatement(cmd).ToString());
}
public int InsertNewRecord(EmailAccount record)
{
var query = InsertQueryStatement();
var cmd = new SqlCommand(query, _connector.GetConnectionObject());
cmd = InsertEmailValuesIntoCommandObject(record, cmd);
return(Convert.ToInt32(_connector.ExecuteSqlScalarStatement(cmd)));
}
public int InsertNewRecord(Passwords pw)
{
var query = InsertQueryStatement();
var cmd = new SqlCommand(query, _connector.GetConnectionObject());
pw.DateCreated = string.IsNullOrEmpty(pw.DateCreated.ToString(CultureInfo.InvariantCulture))
? DateTime.Today
: pw.DateCreated;
pw.DateModified = string.IsNullOrEmpty(pw.DateModified.ToString(CultureInfo.InvariantCulture))
? DateTime.Today
: pw.DateModified;
cmd = InsertPasswordValuesIntoCommandObject(pw, cmd);
return(Convert.ToInt32(_connector.ExecuteSqlScalarStatement(cmd)));
}
private void EmailUser(string pin, string errorMsg = "")
{
var userId = _textFile.GetUserIdFromPin(pin);
_password.UserId = userId;
var credentials = _password.GetRecords()
.Where(x => x.Name.ToLower() == "google" && x.Username.Contains("epym7pfs"))
.ToDictionary(x => x.Username, x => x.Password)
.FirstOrDefault();
var emailTable = _connector.ConfigDictionary.FirstOrDefault(x => x.Key.Contains("EmailAccount")).Value;
var accTable = _connector.ConfigDictionary.FirstOrDefault(x => x.Key.Contains("UserAccount")).Value;
var query = $"Select Email From {emailTable} Join {accTable} on {emailTable}.UserId = {accTable}.UserId " +
$"Where {emailTable}.UserId = {userId}";
var cmd = new SqlCommand(query, _connector.GetConnectionObject());
var email = _connector.ExecuteSqlScalarStatement(cmd).ToString();
SendEmail(email, credentials, errorMsg);
}
