public string AssignEmailVerificationCode(long userId, string purpose)
{
string generatedCode = Universal.RandomNumericString(6);
string sql = " DELETE FROM Verification_Codes WHERE Times_Checked >= 5 OR DATEDIFF(minute, Assigned_Time, SYSDATETIME()) > 60; ";
sql += " IF((SELECT COUNT(Verification_Code) FROM Verification_Codes WHERE user_Id = " + userId + " AND Purpose = '" + purpose + "') = 0) BEGIN INSERT INTO Verification_Codes (User_Id, Purpose, Verification_Code) VALUES (" + userId + ", '" + purpose + "', '" + generatedCode + "'); END \n";
sql += " SELECT Verification_Code FROM Verification_Codes WHERE user_Id = " + userId + ";";
return(this.ExecuteSqlScalar(sql));
}
