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