public static int InsertErrorLog(ErrorLog err)
{
string sql = "INSERT INTO ErrorLog VALUES(@RegisterID,@Timestamp,@Message,@Stacktrace)";
DbParameter par1 = Database.AddParameter(Database.ADMIN_DB, "@RegisterID", err.RegisterID);
DbParameter par2 = Database.AddParameter(Database.ADMIN_DB, "@Timestamp", err.TimeStamp);
DbParameter par3 = Database.AddParameter(Database.ADMIN_DB, "@Message", err.Message);
DbParameter par4 = Database.AddParameter(Database.ADMIN_DB, "@Stacktrace", err.Stacktrace);
return Database.InsertData(Database.GetConnection(Database.ADMIN_DB), sql, par1, par2, par3, par4);
}
public HttpResponseMessage Post(ErrorLog e)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
int id = ErrorlogDA.InsertErrorLog(e, p.Claims);
HttpResponseMessage message = new HttpResponseMessage(HttpStatusCode.OK);
message.Content = new StringContent(id.ToString());
return message;
}
public static ErrorLog GetErrorLogsByRegID(int registerID)
{
ErrorLog reg = new ErrorLog();
string sql = "SELECT * FROM ErrorLog WHERE ID=@ID";
DbParameter parID = Database.AddParameter(Database.ADMIN_DB, "@ID", registerID);
DbDataReader reader = Database.GetData(Database.GetConnection(Database.ADMIN_DB), sql, parID);
while (reader.Read())
{
reg = Create(reader);
}
reader.Close();
return reg;
}
public int Post(ErrorLog e)
{
return ErrorlogDA.InsertErrorLog(e);
}
