private static void ErrorLogToDatabase(Errorlog error, SQLModal sqlmodal)
{
SqlParameter compnayidparam = sqlmodal.sqlParameters.FirstOrDefault(p => p.ParameterName == "@companyid");
error.companyid = (int)(compnayidparam.Value ?? 0);
error.functionname = sqlmodal.functionName;
StringBuilder sb = new StringBuilder("Parameters Used: ");
foreach (SqlParameter parameter in sqlmodal.sqlParameters)
{
sb.AppendLine($"Parameter Name: {parameter.ParameterName}, Parameter Value: {parameter.Value}");
}
error.inputparameters = sb.ToString();
error.userid = sqlmodal.userid;
string insertquery = $"insert into tblerrorlog(logdatetime, functionname, inputparameters, errotext, stacktrace, appid, companyid, userid) " +
$"values(GETUTCDATE(), '{error.functionname}', '{error.inputparameters}','{error.errotext.Replace("'", "''")}','{error.stacktrace.Replace("'", "''")}','{error.appid}','{error.companyid}','{error.userid}')";
Preparecommand(insertquery, null, out SqlCommand ErrorCommand, CommandType.Text);
try
{
using (ErrorCommand.Connection)
{
ErrorCommand.Connection.Open();
ErrorCommand.ExecuteNonQuery();
}
}
catch (Exception)
{
ErrorLogToTextFile(error, sqlmodal);
}
finally
{
ErrorCommand.Connection.Close();
}
}
