public static IssueBuildData GetBuild(long BuildId)
{
IssueBuildData Build = null;
using (SQLiteConnection Connection = new SQLiteConnection(SqlConnector.ConnectionString))
{
Connection.Open();
using (SQLiteCommand Command = new SQLiteCommand("SELECT IssueBuilds.Id, IssueBuilds.Stream, IssueBuilds.Change, IssueBuilds.JobName, IssueBuilds.JobUrl, IssueBuilds.JobStepName, IssueBuilds.JobStepUrl, IssueBuilds.ErrorUrl, IssueBuilds.Outcome FROM [IssueBuilds] WHERE IssueBuilds.Id = @BuildId", Connection))
{
Command.Parameters.AddWithValue("@BuildId", BuildId);
using (SQLiteDataReader Reader = Command.ExecuteReader())
{
while (Reader.Read())
{
long Id = Reader.GetInt64(0);
string Stream = Reader.GetString(1);
int Change = Reader.GetInt32(2);
string JobName = Reader.GetString(3);
string JobUrl = Reader.GetString(4);
string JobStepName = Reader.GetString(5);
string JobStepUrl = Reader.GetString(6);
string ErrorUrl = Reader.GetString(7);
int Outcome = Reader.GetInt32(8);
Build = new IssueBuildData {
Id = Id, Stream = Stream, Change = Change, JobName = JobName, JobUrl = JobUrl, JobStepName = JobStepName, JobStepUrl = JobStepUrl, ErrorUrl = ErrorUrl, Outcome = Outcome
};
}
}
}
}
return(Build);
}
public static long AddBuild(long IssueId, IssueBuildData Build)
{
using (SQLiteConnection Connection = new SQLiteConnection(SqlConnector.ConnectionString))
{
Connection.Open();
using (SQLiteCommand Command = new SQLiteCommand("INSERT INTO [IssueBuilds] (IssueId, Stream, Change, JobName, JobUrl, JobStepName, JobStepUrl, ErrorUrl, Outcome) VALUES (@IssueId, @Stream, @Change, @JobName, @JobUrl, @JobStepName, @JobStepUrl, @ErrorUrl, @Outcome)", Connection))
{
Command.Parameters.AddWithValue("@IssueId", IssueId);
Command.Parameters.AddWithValue("@Stream", Build.Stream);
Command.Parameters.AddWithValue("@Change", Build.Change);
Command.Parameters.AddWithValue("@JobName", Build.JobName);
Command.Parameters.AddWithValue("@JobUrl", Build.JobUrl);
Command.Parameters.AddWithValue("@JobStepName", Build.JobStepName);
Command.Parameters.AddWithValue("@JobStepUrl", Build.JobStepUrl);
Command.Parameters.AddWithValue("@ErrorUrl", Build.ErrorUrl);
Command.Parameters.AddWithValue("@Outcome", Build.Outcome);
Command.ExecuteNonQuery();
return(Connection.LastInsertRowId);
}
}
}
public object Post(long IssueId, [FromBody] IssueBuildData Data)
{
long BuildId = SqlConnector.AddBuild(IssueId, Data);
return(new { Id = BuildId });
}
public void Post(long IssueId, [FromBody] IssueBuildData Data)
{
SqlConnector.AddBuild(IssueId, Data);
}
