private void PastBuildReviewForm_Load(object sender, System.EventArgs e)
{
this.Text = String.Format(this.Text, this.connData.SQLServerName);
if (this.scriptId != Guid.Empty)
{
this.txtScriptId.Text = this.scriptId.ToString();
try
{
SqlSync.SqlBuild.ScriptRunLog log = SqlSync.SqlBuild.SqlBuildHelper.GetScriptRunLog(this.scriptId, this.connData);
this.dataGridView1.DataSource = log;
if (log.Rows.Count > 0)
{
this.txtScriptName.Text = log[0].ScriptFileName;
}
else
{
this.txtScriptName.Text = "Unable to read from log";
}
}
catch (Exception exe)
{
string message = "Unable to retrieve script run log.\r\n" + exe.Message;
MessageBox.Show(message, "Error getting log", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtScriptName.Text = "Unable to read from log";
}
}
else if (this.scriptFileName != string.Empty)
{
this.txtScriptId.Text = "N/A";
try
{
SqlSync.SqlBuild.ScriptRunLog log = SqlSync.SqlBuild.SqlBuildHelper.GetObjectRunHistoryLog(this.scriptFileName, this.connData);
this.dataGridView1.DataSource = log;
if (log.Rows.Count > 0)
{
this.txtScriptName.Text = log[0].ScriptFileName;
}
else
{
this.txtScriptName.Text = "Unable to read from log";
}
}
catch (Exception exe)
{
string message = "Unable to retrieve object run log.\r\n" + exe.Message;
MessageBox.Show(message, "Error getting log", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtScriptName.Text = "Unable to read from log";
}
}
txtScriptHash.Text = this.scriptHash;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ScriptRunHistoryForm));
this.label1 = new System.Windows.Forms.Label();
this.txtScriptName = new System.Windows.Forms.TextBox();
this.txtScriptId = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.panel1 = new System.Windows.Forms.Panel();
this.label3 = new System.Windows.Forms.Label();
this.txtScriptHash = new System.Windows.Forms.TextBox();
this.dataGridTextBoxColumn10 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridTextBoxColumn9 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridTextBoxColumn7 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.buildFileNameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.scriptFileNameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.tagDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.scriptFileHashDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.commitDateDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.userIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.scriptTextDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.contextMenuStrip1 = new System.Windows.Forms.ContextMenuStrip(this.components);
this.viewScriptAsRunOnServerToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator();
this.scriptRunLogBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.scriptRunLog1 = new SqlSync.SqlBuild.ScriptRunLog();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.contextMenuStrip1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.scriptRunLogBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.scriptRunLog1)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point);
this.label1.Location = new System.Drawing.Point(16, 8);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(96, 16);
this.label1.TabIndex = 1;
this.label1.Text = "Script Name:";
//
// txtScriptName
//
this.txtScriptName.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.txtScriptName.Location = new System.Drawing.Point(120, 9);
this.txtScriptName.Name = "txtScriptName";
this.txtScriptName.Size = new System.Drawing.Size(568, 14);
this.txtScriptName.TabIndex = 2;
this.txtScriptName.TabStop = false;
//
// txtScriptId
//
this.txtScriptId.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.txtScriptId.Location = new System.Drawing.Point(120, 27);
this.txtScriptId.Name = "txtScriptId";
this.txtScriptId.Size = new System.Drawing.Size(568, 14);
this.txtScriptId.TabIndex = 4;
this.txtScriptId.TabStop = false;
//
// label2
//
this.label2.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point);
this.label2.Location = new System.Drawing.Point(16, 27);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(96, 16);
this.label2.TabIndex = 3;
this.label2.Text = "Script ID:";
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.White;
this.panel1.Controls.Add(this.label3);
this.panel1.Controls.Add(this.txtScriptHash);
this.panel1.Controls.Add(this.txtScriptName);
this.panel1.Controls.Add(this.label1);
this.panel1.Controls.Add(this.label2);
this.panel1.Controls.Add(this.txtScriptId);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(976, 66);
this.panel1.TabIndex = 5;
//
// label3
//
this.label3.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point);
this.label3.Location = new System.Drawing.Point(16, 46);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(96, 16);
this.label3.TabIndex = 5;
this.label3.Text = "Script Hash:";
//
// txtScriptHash
//
this.txtScriptHash.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.txtScriptHash.Location = new System.Drawing.Point(120, 46);
this.txtScriptHash.Name = "txtScriptHash";
this.txtScriptHash.Size = new System.Drawing.Size(568, 14);
this.txtScriptHash.TabIndex = 6;
this.txtScriptHash.TabStop = false;
//
// dataGridTextBoxColumn10
//
this.dataGridTextBoxColumn10.DataPropertyName = "ScriptText";
this.dataGridTextBoxColumn10.HeaderText = "Script Text";
this.dataGridTextBoxColumn10.Name = "dataGridTextBoxColumn10";
this.dataGridTextBoxColumn10.Width = 75;
//
// dataGridTextBoxColumn9
//
this.dataGridTextBoxColumn9.DataPropertyName = "AllowScriptBlock";
this.dataGridTextBoxColumn9.HeaderText = "Blocking?";
this.dataGridTextBoxColumn9.Name = "dataGridTextBoxColumn9";
this.dataGridTextBoxColumn9.Width = 70;
//
// dataGridTextBoxColumn3
//
this.dataGridTextBoxColumn3.DataPropertyName = "BuildFileName";
this.dataGridTextBoxColumn3.HeaderText = "Source Build File";
this.dataGridTextBoxColumn3.Name = "dataGridTextBoxColumn3";
this.dataGridTextBoxColumn3.Width = 245;
//
// dataGridTextBoxColumn2
//
this.dataGridTextBoxColumn2.DataPropertyName = "ScriptFileHash";
this.dataGridTextBoxColumn2.HeaderText = "Script Hash";
this.dataGridTextBoxColumn2.Name = "dataGridTextBoxColumn2";
this.dataGridTextBoxColumn2.Width = 305;
//
// dataGridTextBoxColumn7
//
this.dataGridTextBoxColumn7.DataPropertyName = "UserId";
this.dataGridTextBoxColumn7.HeaderText = "Run By";
this.dataGridTextBoxColumn7.Name = "dataGridTextBoxColumn7";
this.dataGridTextBoxColumn7.Width = 80;
//
// dataGridTextBoxColumn1
//
this.dataGridTextBoxColumn1.DataPropertyName = "CommitDate";
this.dataGridTextBoxColumn1.HeaderText = "Commit Date";
this.dataGridTextBoxColumn1.Name = "dataGridTextBoxColumn1";
this.dataGridTextBoxColumn1.Width = 125;
//
// dataGridView1
//
this.dataGridView1.AllowUserToAddRows = false;
this.dataGridView1.AllowUserToDeleteRows = false;
this.dataGridView1.AllowUserToOrderColumns = true;
dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
this.dataGridView1.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.buildFileNameDataGridViewTextBoxColumn,
this.scriptFileNameDataGridViewTextBoxColumn,
this.tagDataGridViewTextBoxColumn,
this.scriptFileHashDataGridViewTextBoxColumn,
this.commitDateDataGridViewTextBoxColumn,
this.userIdDataGridViewTextBoxColumn,
this.scriptTextDataGridViewTextBoxColumn
});
this.dataGridView1.ContextMenuStrip = this.contextMenuStrip1;
this.dataGridView1.DataSource = this.scriptRunLogBindingSource;
this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;
this.dataGridView1.Location = new System.Drawing.Point(0, 66);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.ReadOnly = true;
this.dataGridView1.RowHeadersVisible = false;
this.dataGridView1.RowTemplate.DefaultCellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point);
this.dataGridView1.Size = new System.Drawing.Size(976, 308);
this.dataGridView1.TabIndex = 0;
this.dataGridView1.RowsAdded += new System.Windows.Forms.DataGridViewRowsAddedEventHandler(this.dataGridView1_RowsAdded);
//
// buildFileNameDataGridViewTextBoxColumn
//
this.buildFileNameDataGridViewTextBoxColumn.DataPropertyName = "BuildFileName";
this.buildFileNameDataGridViewTextBoxColumn.HeaderText = "Build File Name";
this.buildFileNameDataGridViewTextBoxColumn.Name = "buildFileNameDataGridViewTextBoxColumn";
this.buildFileNameDataGridViewTextBoxColumn.ReadOnly = true;
this.buildFileNameDataGridViewTextBoxColumn.Width = 200;
//
// scriptFileNameDataGridViewTextBoxColumn
//
this.scriptFileNameDataGridViewTextBoxColumn.DataPropertyName = "ScriptFileName";
this.scriptFileNameDataGridViewTextBoxColumn.HeaderText = "Script File Name";
this.scriptFileNameDataGridViewTextBoxColumn.Name = "scriptFileNameDataGridViewTextBoxColumn";
this.scriptFileNameDataGridViewTextBoxColumn.ReadOnly = true;
this.scriptFileNameDataGridViewTextBoxColumn.Width = 200;
//
// tagDataGridViewTextBoxColumn
//
this.tagDataGridViewTextBoxColumn.DataPropertyName = "Tag";
this.tagDataGridViewTextBoxColumn.HeaderText = "Tag";
this.tagDataGridViewTextBoxColumn.Name = "tagDataGridViewTextBoxColumn";
this.tagDataGridViewTextBoxColumn.ReadOnly = true;
this.tagDataGridViewTextBoxColumn.Width = 75;
//
// scriptFileHashDataGridViewTextBoxColumn
//
this.scriptFileHashDataGridViewTextBoxColumn.DataPropertyName = "ScriptFileHash";
this.scriptFileHashDataGridViewTextBoxColumn.HeaderText = "Script Hash";
this.scriptFileHashDataGridViewTextBoxColumn.Name = "scriptFileHashDataGridViewTextBoxColumn";
this.scriptFileHashDataGridViewTextBoxColumn.ReadOnly = true;
this.scriptFileHashDataGridViewTextBoxColumn.Width = 200;
//
// commitDateDataGridViewTextBoxColumn
//
this.commitDateDataGridViewTextBoxColumn.DataPropertyName = "CommitDate";
this.commitDateDataGridViewTextBoxColumn.HeaderText = "Commit Date";
this.commitDateDataGridViewTextBoxColumn.Name = "commitDateDataGridViewTextBoxColumn";
this.commitDateDataGridViewTextBoxColumn.ReadOnly = true;
//
// userIdDataGridViewTextBoxColumn
//
this.userIdDataGridViewTextBoxColumn.DataPropertyName = "UserId";
this.userIdDataGridViewTextBoxColumn.HeaderText = "User Id";
this.userIdDataGridViewTextBoxColumn.Name = "userIdDataGridViewTextBoxColumn";
this.userIdDataGridViewTextBoxColumn.ReadOnly = true;
this.userIdDataGridViewTextBoxColumn.Width = 80;
//
// scriptTextDataGridViewTextBoxColumn
//
this.scriptTextDataGridViewTextBoxColumn.DataPropertyName = "ScriptText";
this.scriptTextDataGridViewTextBoxColumn.HeaderText = "Script Text";
this.scriptTextDataGridViewTextBoxColumn.Name = "scriptTextDataGridViewTextBoxColumn";
this.scriptTextDataGridViewTextBoxColumn.ReadOnly = true;
//
// contextMenuStrip1
//
this.contextMenuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
this.viewScriptAsRunOnServerToolStripMenuItem,
this.toolStripSeparator1
});
this.contextMenuStrip1.Name = "contextMenuStrip1";
this.contextMenuStrip1.Size = new System.Drawing.Size(223, 76);
this.contextMenuStrip1.Opening += new System.ComponentModel.CancelEventHandler(this.contextMenuStrip1_Opening);
//
// viewScriptAsRunOnServerToolStripMenuItem
//
this.viewScriptAsRunOnServerToolStripMenuItem.Name = "viewScriptAsRunOnServerToolStripMenuItem";
this.viewScriptAsRunOnServerToolStripMenuItem.Size = new System.Drawing.Size(222, 22);
this.viewScriptAsRunOnServerToolStripMenuItem.Text = "View Script as Run on Server";
this.viewScriptAsRunOnServerToolStripMenuItem.Click += new System.EventHandler(this.viewScriptAsRunOnServerToolStripMenuItem_Click);
//
// toolStripSeparator1
//
this.toolStripSeparator1.Name = "toolStripSeparator1";
this.toolStripSeparator1.Size = new System.Drawing.Size(219, 6);
//
// scriptRunLogBindingSource
//
this.scriptRunLogBindingSource.DataSource = typeof(SqlSync.SqlBuild.ScriptRunLog);
//
// scriptRunLog1
//
this.scriptRunLog1.Namespace = "";
this.scriptRunLog1.PrimaryKey = new System.Data.DataColumn[0];
this.scriptRunLog1.TableName = "ScriptRunLog";
//
// ScriptRunHistoryForm
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(976, 374);
this.Controls.Add(this.dataGridView1);
this.Controls.Add(this.panel1);
this.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.KeyPreview = true;
this.Name = "ScriptRunHistoryForm";
this.Text = "Script Run History on {0}";
this.Load += new System.EventHandler(this.PastBuildReviewForm_Load);
this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.ScriptRunHistoryForm_KeyDown);
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.contextMenuStrip1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.scriptRunLogBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.scriptRunLog1)).EndInit();
this.ResumeLayout(false);
}
