private void btnGenerate_Click_1(object sender, EventArgs e)
{
base.buildDuration = 0;
base.timer1.Start();
this.checkFieldValue = this.txtCheckValue.Text;
if (!int.TryParse(this.txtTimeout.Text, out this.timeOut))
{
this.timeOut = 20;
}
switch (ddValidationType.SelectedItem.ToString())
{
case "Build File Name":
this.buildValidation = BuildValidationType.BuildFileName;
break;
case "Individual Script Hash":
this.buildValidation = BuildValidationType.IndividualScriptHash;
break;
case "Individual Script Name":
this.buildValidation = BuildValidationType.IndividualScriptName;
break;
case "Build File Hash":
default:
this.buildValidation = BuildValidationType.BuildFileHash;
break;
}
}
public void GetBuildValidationResults(ref BackgroundWorker bgWorker, string fileName, string checkValue, ReportType reportType, BuildValidationType validationType, int scriptTimeout)
{
string scriptFormat = @"SELECT {0}, {1}, CommitDate, count(1) as [Script Count]
FROM dbo.SqlBuild_Logging WITH (NOLOCK) WHERE {0} = '{2}'
GROUP BY {0}, {1}, CommitDate ORDER BY CommitDate DESC";
string script;
switch (validationType)
{
case BuildValidationType.BuildFileName:
script = string.Format(scriptFormat, "BuildFileName", "BuildProjectHash", checkValue);
break;
case BuildValidationType.IndividualScriptHash:
script = string.Format(scriptFormat, "ScriptFileHash", "ScriptFileName", checkValue);
break;
case BuildValidationType.IndividualScriptName:
script = string.Format(scriptFormat, "ScriptFileName", "ScriptFileHash", checkValue);
break;
case BuildValidationType.BuildFileHash:
default:
script = string.Format(scriptFormat, "BuildProjectHash", "BuildFileName", checkValue);
break;
}
GetQueryResults(ref bgWorker, fileName, reportType, script, scriptTimeout);
}
