public void CallSQLWithError(string user, string method, string errorMessage)
{
string crtlvl = "SELECT * FROM " + tablename + " WHERE " + errorMessage + " IS NOT NULL;";
//string sql = SQLHelper.GetSqlCommand(user, method, errorMessage, "DBMID");
SQLHelper.ExecuteCommand(crtlvl);
//foreach (DataRow dataRow in Table.Rows)
//{
// foreach (var item in dataRow.ItemArray)
// {
// Console.WriteLine(item);
// }
//}
}
public int LogErrorEvent(string user, string method, string errorMessage)
{
int crt = SQLHelper.GetCritcalLevel(method, errorMessage, N, M);
if (crt > 4)
{
Console.WriteLine("*********ALARM**********");
}
string sql = SQLHelper.GetSqlCommand(user, method, errorMessage, "DBMID");
SQLHelper.ExecuteCommand(sql);
return(crt);
}
public void LogSuccessfulEvent(string user, string method)
{
string sql = SQLHelper.GetSqlCommand(user, method, "NULL", "DBMID");
SQLHelper.ExecuteCommand(sql);
}
public void LogErrorEvent(string user, string method, string errorMessage)
{
string sql = SQLHelper.GetSqlCommand(user, method, errorMessage, "DBMID");
SQLHelper.ExecuteCommand(sql);
}