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