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