public static List <IssueDiagnosticData> GetDiagnostics(long IssueId)
{
List <IssueDiagnosticData> Diagnostics = new List <IssueDiagnosticData>();
using (MySqlConnection Connection = new MySqlConnection(SqlConnector.ConnectionString))
{
Connection.Open();
StringBuilder CommandBuilder = new StringBuilder();
CommandBuilder.Append("SELECT BuildId, Message, Url FROM ugs_db.IssueDiagnostics");
CommandBuilder.Append(" WHERE IssueDiagnostics.IssueId = @IssueId");
using (MySqlCommand Command = new MySqlCommand(CommandBuilder.ToString(), Connection))
{
Command.Parameters.AddWithValue("@IssueId", IssueId);
using (MySqlDataReader Reader = Command.ExecuteReader())
{
while (Reader.Read())
{
IssueDiagnosticData Diagnostic = new IssueDiagnosticData();
Diagnostic.BuildId = Reader.IsDBNull(0)? (long?)null : (long?)Reader.GetInt64(0);
Diagnostic.Message = Reader.GetString(1);
Diagnostic.Url = Reader.GetString(2);
Diagnostics.Add(Diagnostic);
}
}
}
}
return(Diagnostics);
}
public static void AddDiagnostic(long IssueId, IssueDiagnosticData Diagnostic)
{
using (MySqlConnection Connection = new MySqlConnection(SqlConnector.ConnectionString))
{
Connection.Open();
using (MySqlCommand Command = new MySqlCommand("INSERT INTO ugs_db.IssueDiagnostics (IssueId, BuildId, Message, Url) VALUES (@IssueId, @BuildId, @Message, @Url)", Connection))
{
Command.Parameters.AddWithValue("@IssueId", IssueId);
Command.Parameters.AddWithValue("@BuildId", Diagnostic.BuildId);
Command.Parameters.AddWithValue("@Message", SanitizeText(Diagnostic.Message, 1000));
Command.Parameters.AddWithValue("@Url", Diagnostic.Url);
Command.ExecuteNonQuery();
}
}
}
public void Post(long IssueId, [FromBody] IssueDiagnosticData Data)
{
SqlConnector.AddDiagnostic(IssueId, Data);
}
