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); }