public void AddLog(SeverityLevel level, string ExceptionMessage, string ExceptionStacktrace, string customMessage)
{
try
{
var sqlCom = _db.GetWriteCommand(@"INSERT INTO logs
(
LogLevel,
ExceptionMessage,
ExceptionStacktrace,
CustomMessage,
Date
)
Values
(
@LogLevel,
@ExceptionMessage,
@ExceptionStacktrace,
@CustomMessage,
@Date
);");
sqlCom.Parameters.AddWithValue("@LogLevel", level.ToString());
sqlCom.Parameters.AddWithValue("@ExceptionMessage", ExceptionMessage);
sqlCom.Parameters.AddWithValue("@ExceptionStacktrace", ExceptionStacktrace);
sqlCom.Parameters.AddWithValue("@CustomMessage", customMessage);
sqlCom.Parameters.AddWithValue("@Date", DateTime.Now);
sqlCom.ExecuteNonQuery();
}
finally
{
_db.CloseConnections();
}
}
internal E_VerificationStatus GetVerificationStatus(string email, string passwordHash)
{
E_VerificationStatus resultStatus = E_VerificationStatus.emailUnknown;
var sqlCom = _db.GetReadCommand(@"
SELECT `EmailID`, `EmailAddress`, `PasswordHash`, EmailVerificationID
FROM email
WHERE `EmailAddress` LIKE ?Address;");
sqlCom.Parameters.AddWithValue("?Address", email);
try
{
using (var rdr = sqlCom.ExecuteReader())
{
while (rdr.Read())
{
if (rdr.GetString("PasswordHash") == passwordHash)
{
resultStatus = E_VerificationStatus.successfull;
if (rdr["EmailVerificationID"] != DBNull.Value)
{
resultStatus = E_VerificationStatus.emailNotYetVerified;
}
}
else
{
resultStatus = E_VerificationStatus.wrongPassword;
}
}
}
}
finally
{
_db.CloseConnections();
}
return(resultStatus);
}
