/// <summary>Add a build to the build database.</summary>
/// <param name="pullRequestNumber">The GitHub pull request number.</param>
/// <param name="changeDBPassword">The password</param>
public void AddBuild(int pullRequestNumber, string changeDBPassword)
{
if (changeDBPassword == BuildsClassic.GetValidPassword())
{
using (SqlConnection connection = BuildsClassic.Open())
{
string sql = "INSERT INTO ApsimX (Date, PullRequestID, IssueNumber, IssueTitle, Released, Version) " +
"VALUES (@Date, @PullRequestID, @IssueNumber, @IssueTitle, @Released, @Version)";
PullRequest pull = GitHubUtilities.GetPullRequest(pullRequestNumber, owner, repo);
DateTime date = pull.GetTestDate(owner, repo);
pull.GetIssueDetails(out int issueNumber, out bool released);
string issueTitle = pull.GetIssueTitle(owner, repo);
int nextVersion = Convert.ToInt32(GetNextVersion());
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.Add(new SqlParameter("@Date", date));
command.Parameters.Add(new SqlParameter("@PullRequestID", pullRequestNumber));
command.Parameters.Add(new SqlParameter("@IssueNumber", issueNumber));
command.Parameters.Add(new SqlParameter("@IssueTitle", issueTitle));
command.Parameters.Add(new SqlParameter("@Released", released));
command.Parameters.Add(new SqlParameter("@Version", nextVersion));
command.ExecuteNonQuery();
}
}
}
}
/// <summary>Add a build to the build database.</summary>
/// <param name="pullRequestNumber">The GitHub pull request number.</param>
/// <param name="issueID">The issue ID.</param>
/// <param name="issueTitle">The issue title.</param>
/// <param name="changeDBPassword">The password</param>
public void AddBuild(int pullRequestNumber, int issueID, string issueTitle, bool released, string changeDBPassword)
{
if (changeDBPassword == BuildsClassic.GetValidPassword())
{
using (SqlConnection connection = BuildsClassic.Open())
{
string sql = "UPDATE ApsimX " +
"SET IssueNumber=@IssueNumber, IssueTitle=@IssueTitle, Released=@Released " +
"WHERE PullRequestID=" + pullRequestNumber;
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.Add(new SqlParameter("@IssueNumber", issueID));
command.Parameters.Add(new SqlParameter("@IssueTitle", issueTitle));
command.Parameters.Add(new SqlParameter("@Released", released));
command.ExecuteNonQuery();
}
}
}
}
/// <summary>Add a green build to the build database.</summary>
/// <param name="pullRequestNumber">The GitHub pull request number.</param>
/// <param name="buildTimeStamp">The build time stamp</param>
/// <param name="changeDBPassword">The password</param>
public void AddGreenBuild(int pullRequestNumber, string buildTimeStamp, string changeDBPassword)
{
if (changeDBPassword == BuildsClassic.GetValidPassword())
{
using (SqlConnection connection = BuildsClassic.Open())
{
string sql = "INSERT INTO ApsimX (Date, PullRequestID, IssueNumber, IssueTitle, Released) " +
"VALUES (@Date, @PullRequestID, @IssueNumber, @IssueTitle, @Released)";
DateTime date = DateTime.ParseExact(buildTimeStamp, "yyyy.MM.dd-HH:mm", null);
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.Add(new SqlParameter("@Date", date));
command.Parameters.Add(new SqlParameter("@PullRequestID", pullRequestNumber));
command.Parameters.Add(new SqlParameter("@IssueNumber", string.Empty));
command.Parameters.Add(new SqlParameter("@IssueTitle", string.Empty));
command.Parameters.Add(new SqlParameter("@Released", false));
command.ExecuteNonQuery();
}
}
}
}