public PastBuildReviewForm(SqlSyncBuildData buildData) { // // Required for Windows Form Designer support // InitializeComponent(); this.sqlSyncBuildData1 = buildData; }
public ComparisonForm(ref SqlBuild.SqlSyncBuildData buildData, double lastBuildNumber, string leftZipFilePath, string leftTempFilePath, string rightZipFilePath, bool startImmediateCompare) { InitializeComponent(); this.leftTempFilePath = leftTempFilePath; this.leftZipFilePath = leftZipFilePath; this.rightZipFilePath = rightZipFilePath; this.buildData = buildData; this.lastBuildNumber = lastBuildNumber; this.startImmediateCompare = startImmediateCompare; this.linkedBoxes.FileChanged += new EventHandler(linkedBoxes_FileChanged); }
public void GetUnifiedDiff(ref SqlSync.SqlBuild.SqlSyncBuildData leftBuildData, string leftTempFilePath, string rightBuildZipPath, out List <FileCompareResults> onlyInLeft, out List <FileCompareResults> onlyInRight, out List <FileCompareResults> modified, out string rightFileTempDirectory) { this.extractPathLeftFile = leftTempFilePath; string tmpDir = System.IO.Path.GetTempPath(); this.extractPathRightFile = tmpDir + @"SqlsyncCompare-" + System.Guid.NewGuid().ToString().Replace("-", ""); Directory.CreateDirectory(this.extractPathRightFile); rightFileTempDirectory = this.extractPathRightFile; ZipHelper.UnpackZipPackage(this.extractPathRightFile, rightBuildZipPath, false); SqlSync.SqlBuild.SqlSyncBuildData rightBuildData = new SqlSyncBuildData(); rightBuildData.ReadXml(Path.Combine(this.extractPathRightFile, XmlFileNames.MainProjectFile)); //TODO: wrap load failure. List <FileCompareResults> filesOnlyInLeft = GetFileListDiff(leftBuildData, rightBuildData, true); List <FileCompareResults> filesOnlyInRight = GetFileListDiff(rightBuildData, leftBuildData, false); List <FileCompareResults> commonFiles = GetCommonFileList(leftBuildData, rightBuildData); modified = ProcessUnifiedDiff(this.extractPathLeftFile, this.extractPathRightFile, commonFiles); onlyInRight = GetFileContents(this.extractPathRightFile, filesOnlyInRight); onlyInLeft = GetFileContents(this.extractPathLeftFile, filesOnlyInLeft); }
/// <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.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(PastBuildReviewForm)); this.sqlSyncBuildData1 = new SqlSync.SqlBuild.SqlSyncBuildData(); this.contextMenuStrip1 = new System.Windows.Forms.ContextMenuStrip(this.components); this.viewScriptToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.splitContainer1 = new System.Windows.Forms.SplitContainer(); this.label2 = new System.Windows.Forms.Label(); this.dgMaster = new System.Windows.Forms.DataGridView(); this.buildStartDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.buildEndDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.serverNameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.nameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.buildTypeDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.finalStatusDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.userIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.ctxMaster = new System.Windows.Forms.ContextMenuStrip(this.components); this.saveBuildDetailsForSelectedRowsToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.buildBindingSource = new System.Windows.Forms.BindingSource(this.components); this.sqlSyncBuildDataBindingSource = new System.Windows.Forms.BindingSource(this.components); this.label1 = new System.Windows.Forms.Label(); this.dgDetail = new System.Windows.Forms.DataGridView(); this.fileNameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.resultsDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.runOrderDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.databaseDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.runStartDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.runEndDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.successDataGridViewCheckBoxColumn = new System.Windows.Forms.DataGridViewCheckBoxColumn(); this.fileHashDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.scriptRunIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.scriptRunBindingSource = new System.Windows.Forms.BindingSource(this.components); this.sqlSyncBuildProjectBindingSource = new System.Windows.Forms.BindingSource(this.components); this.saveFileDialog1 = new System.Windows.Forms.SaveFileDialog(); ((System.ComponentModel.ISupportInitialize)(this.sqlSyncBuildData1)).BeginInit(); this.contextMenuStrip1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).BeginInit(); this.splitContainer1.Panel1.SuspendLayout(); this.splitContainer1.Panel2.SuspendLayout(); this.splitContainer1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dgMaster)).BeginInit(); this.ctxMaster.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.buildBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.sqlSyncBuildDataBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dgDetail)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.scriptRunBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.sqlSyncBuildProjectBindingSource)).BeginInit(); this.SuspendLayout(); // // sqlSyncBuildData1 // this.sqlSyncBuildData1.DataSetName = "SqlSyncBuildData"; this.sqlSyncBuildData1.EnforceConstraints = false; this.sqlSyncBuildData1.Locale = new System.Globalization.CultureInfo("en-US"); this.sqlSyncBuildData1.Namespace = "http://schemas.mckechney.com/SqlSyncBuildProject.xsd"; this.sqlSyncBuildData1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // contextMenuStrip1 // this.contextMenuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { this.viewScriptToolStripMenuItem }); this.contextMenuStrip1.Name = "contextMenuStrip1"; this.contextMenuStrip1.Size = new System.Drawing.Size(140, 26); // // viewScriptToolStripMenuItem // this.viewScriptToolStripMenuItem.Name = "viewScriptToolStripMenuItem"; this.viewScriptToolStripMenuItem.Size = new System.Drawing.Size(139, 22); this.viewScriptToolStripMenuItem.Text = "View Results"; this.viewScriptToolStripMenuItem.Click += new System.EventHandler(this.viewScriptToolStripMenuItem_Click); // // splitContainer1 // this.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainer1.Location = new System.Drawing.Point(0, 0); this.splitContainer1.Name = "splitContainer1"; this.splitContainer1.Orientation = System.Windows.Forms.Orientation.Horizontal; // // splitContainer1.Panel1 // this.splitContainer1.Panel1.Controls.Add(this.label2); this.splitContainer1.Panel1.Controls.Add(this.dgMaster); // // splitContainer1.Panel2 // this.splitContainer1.Panel2.Controls.Add(this.label1); this.splitContainer1.Panel2.Controls.Add(this.dgDetail); this.splitContainer1.Size = new System.Drawing.Size(1096, 534); this.splitContainer1.SplitterDistance = 173; this.splitContainer1.TabIndex = 2; // // label2 // this.label2.AutoSize = true; this.label2.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point); this.label2.Location = new System.Drawing.Point(4, 6); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(63, 16); this.label2.TabIndex = 4; this.label2.Text = "Build List:"; // // dgMaster // this.dgMaster.AllowUserToAddRows = false; this.dgMaster.AllowUserToDeleteRows = false; this.dgMaster.AllowUserToOrderColumns = true; dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224))))); this.dgMaster.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1; this.dgMaster.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.dgMaster.AutoGenerateColumns = false; this.dgMaster.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.buildStartDataGridViewTextBoxColumn, this.buildEndDataGridViewTextBoxColumn, this.serverNameDataGridViewTextBoxColumn, this.nameDataGridViewTextBoxColumn, this.buildTypeDataGridViewTextBoxColumn, this.finalStatusDataGridViewTextBoxColumn, this.userIdDataGridViewTextBoxColumn }); this.dgMaster.ContextMenuStrip = this.ctxMaster; this.dgMaster.DataSource = this.buildBindingSource; this.dgMaster.Location = new System.Drawing.Point(0, 42); this.dgMaster.Name = "dgMaster"; this.dgMaster.ReadOnly = true; this.dgMaster.RowHeadersVisible = false; this.dgMaster.RowTemplate.DefaultCellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point); this.dgMaster.Size = new System.Drawing.Size(1096, 143); this.dgMaster.TabIndex = 3; this.dgMaster.CellEnter += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgMaster_CellEnter); this.dgMaster.Click += new System.EventHandler(this.dgMaster_Click); // // buildStartDataGridViewTextBoxColumn // this.buildStartDataGridViewTextBoxColumn.DataPropertyName = "BuildStart"; this.buildStartDataGridViewTextBoxColumn.HeaderText = "Start"; this.buildStartDataGridViewTextBoxColumn.Name = "buildStartDataGridViewTextBoxColumn"; this.buildStartDataGridViewTextBoxColumn.ReadOnly = true; this.buildStartDataGridViewTextBoxColumn.Width = 150; // // buildEndDataGridViewTextBoxColumn // this.buildEndDataGridViewTextBoxColumn.DataPropertyName = "BuildEnd"; this.buildEndDataGridViewTextBoxColumn.HeaderText = "End"; this.buildEndDataGridViewTextBoxColumn.Name = "buildEndDataGridViewTextBoxColumn"; this.buildEndDataGridViewTextBoxColumn.ReadOnly = true; this.buildEndDataGridViewTextBoxColumn.Width = 150; // // serverNameDataGridViewTextBoxColumn // this.serverNameDataGridViewTextBoxColumn.DataPropertyName = "ServerName"; this.serverNameDataGridViewTextBoxColumn.HeaderText = "ServerName"; this.serverNameDataGridViewTextBoxColumn.Name = "serverNameDataGridViewTextBoxColumn"; this.serverNameDataGridViewTextBoxColumn.ReadOnly = true; this.serverNameDataGridViewTextBoxColumn.Width = 200; // // nameDataGridViewTextBoxColumn // this.nameDataGridViewTextBoxColumn.DataPropertyName = "Name"; this.nameDataGridViewTextBoxColumn.HeaderText = "Description"; this.nameDataGridViewTextBoxColumn.Name = "nameDataGridViewTextBoxColumn"; this.nameDataGridViewTextBoxColumn.ReadOnly = true; this.nameDataGridViewTextBoxColumn.Width = 200; // // buildTypeDataGridViewTextBoxColumn // this.buildTypeDataGridViewTextBoxColumn.DataPropertyName = "BuildType"; this.buildTypeDataGridViewTextBoxColumn.HeaderText = "Build Type"; this.buildTypeDataGridViewTextBoxColumn.Name = "buildTypeDataGridViewTextBoxColumn"; this.buildTypeDataGridViewTextBoxColumn.ReadOnly = true; // // finalStatusDataGridViewTextBoxColumn // this.finalStatusDataGridViewTextBoxColumn.DataPropertyName = "FinalStatus"; this.finalStatusDataGridViewTextBoxColumn.HeaderText = "Final Status"; this.finalStatusDataGridViewTextBoxColumn.Name = "finalStatusDataGridViewTextBoxColumn"; this.finalStatusDataGridViewTextBoxColumn.ReadOnly = true; // // userIdDataGridViewTextBoxColumn // this.userIdDataGridViewTextBoxColumn.DataPropertyName = "UserId"; this.userIdDataGridViewTextBoxColumn.HeaderText = "UserId"; this.userIdDataGridViewTextBoxColumn.Name = "userIdDataGridViewTextBoxColumn"; this.userIdDataGridViewTextBoxColumn.ReadOnly = true; // // ctxMaster // this.ctxMaster.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { this.saveBuildDetailsForSelectedRowsToolStripMenuItem }); this.ctxMaster.Name = "ctxMaster"; this.ctxMaster.Size = new System.Drawing.Size(263, 26); // // saveBuildDetailsForSelectedRowsToolStripMenuItem // this.saveBuildDetailsForSelectedRowsToolStripMenuItem.Name = "saveBuildDetailsForSelectedRowsToolStripMenuItem"; this.saveBuildDetailsForSelectedRowsToolStripMenuItem.Size = new System.Drawing.Size(262, 22); this.saveBuildDetailsForSelectedRowsToolStripMenuItem.Text = "Save Build Details for Selected Rows"; this.saveBuildDetailsForSelectedRowsToolStripMenuItem.Click += new System.EventHandler(this.saveBuildDetailsForSelectedRowsToolStripMenuItem_Click); // // buildBindingSource // this.buildBindingSource.DataMember = "Build"; this.buildBindingSource.DataSource = this.sqlSyncBuildDataBindingSource; // // sqlSyncBuildDataBindingSource // this.sqlSyncBuildDataBindingSource.DataSource = typeof(SqlSync.SqlBuild.SqlSyncBuildData); this.sqlSyncBuildDataBindingSource.Position = 0; // // label1 // this.label1.AutoSize = true; this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point); this.label1.Location = new System.Drawing.Point(4, 11); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(85, 16); this.label1.TabIndex = 3; this.label1.Text = "Build Details:"; // // dgDetail // this.dgDetail.AllowUserToAddRows = false; this.dgDetail.AllowUserToDeleteRows = false; this.dgDetail.AllowUserToOrderColumns = true; dataGridViewCellStyle2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224))))); this.dgDetail.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle2; this.dgDetail.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.dgDetail.AutoGenerateColumns = false; this.dgDetail.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.fileNameDataGridViewTextBoxColumn, this.resultsDataGridViewTextBoxColumn, this.runOrderDataGridViewTextBoxColumn, this.databaseDataGridViewTextBoxColumn, this.runStartDataGridViewTextBoxColumn, this.runEndDataGridViewTextBoxColumn, this.successDataGridViewCheckBoxColumn, this.fileHashDataGridViewTextBoxColumn, this.scriptRunIdDataGridViewTextBoxColumn }); this.dgDetail.ContextMenuStrip = this.contextMenuStrip1; this.dgDetail.DataSource = this.scriptRunBindingSource; this.dgDetail.Location = new System.Drawing.Point(0, 38); this.dgDetail.Name = "dgDetail"; this.dgDetail.ReadOnly = true; this.dgDetail.RowHeadersVisible = false; this.dgDetail.RowTemplate.DefaultCellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point); this.dgDetail.Size = new System.Drawing.Size(1096, 319); this.dgDetail.TabIndex = 2; // // fileNameDataGridViewTextBoxColumn // this.fileNameDataGridViewTextBoxColumn.DataPropertyName = "FileName"; this.fileNameDataGridViewTextBoxColumn.HeaderText = "File Name"; this.fileNameDataGridViewTextBoxColumn.Name = "fileNameDataGridViewTextBoxColumn"; this.fileNameDataGridViewTextBoxColumn.ReadOnly = true; this.fileNameDataGridViewTextBoxColumn.Width = 200; // // resultsDataGridViewTextBoxColumn // this.resultsDataGridViewTextBoxColumn.DataPropertyName = "Results"; this.resultsDataGridViewTextBoxColumn.HeaderText = "Results"; this.resultsDataGridViewTextBoxColumn.Name = "resultsDataGridViewTextBoxColumn"; this.resultsDataGridViewTextBoxColumn.ReadOnly = true; this.resultsDataGridViewTextBoxColumn.Width = 200; // // runOrderDataGridViewTextBoxColumn // this.runOrderDataGridViewTextBoxColumn.DataPropertyName = "RunOrder"; this.runOrderDataGridViewTextBoxColumn.HeaderText = "Order"; this.runOrderDataGridViewTextBoxColumn.Name = "runOrderDataGridViewTextBoxColumn"; this.runOrderDataGridViewTextBoxColumn.ReadOnly = true; this.runOrderDataGridViewTextBoxColumn.Width = 65; // // databaseDataGridViewTextBoxColumn // this.databaseDataGridViewTextBoxColumn.DataPropertyName = "Database"; this.databaseDataGridViewTextBoxColumn.HeaderText = "Database"; this.databaseDataGridViewTextBoxColumn.Name = "databaseDataGridViewTextBoxColumn"; this.databaseDataGridViewTextBoxColumn.ReadOnly = true; // // runStartDataGridViewTextBoxColumn // this.runStartDataGridViewTextBoxColumn.DataPropertyName = "RunStart"; this.runStartDataGridViewTextBoxColumn.HeaderText = "Start"; this.runStartDataGridViewTextBoxColumn.Name = "runStartDataGridViewTextBoxColumn"; this.runStartDataGridViewTextBoxColumn.ReadOnly = true; this.runStartDataGridViewTextBoxColumn.Width = 120; // // runEndDataGridViewTextBoxColumn // this.runEndDataGridViewTextBoxColumn.DataPropertyName = "RunEnd"; this.runEndDataGridViewTextBoxColumn.HeaderText = "End"; this.runEndDataGridViewTextBoxColumn.Name = "runEndDataGridViewTextBoxColumn"; this.runEndDataGridViewTextBoxColumn.ReadOnly = true; this.runEndDataGridViewTextBoxColumn.Width = 120; // // successDataGridViewCheckBoxColumn // this.successDataGridViewCheckBoxColumn.DataPropertyName = "Success"; this.successDataGridViewCheckBoxColumn.HeaderText = "Success"; this.successDataGridViewCheckBoxColumn.Name = "successDataGridViewCheckBoxColumn"; this.successDataGridViewCheckBoxColumn.ReadOnly = true; this.successDataGridViewCheckBoxColumn.Width = 70; // // fileHashDataGridViewTextBoxColumn // this.fileHashDataGridViewTextBoxColumn.DataPropertyName = "FileHash"; this.fileHashDataGridViewTextBoxColumn.HeaderText = "FileHash"; this.fileHashDataGridViewTextBoxColumn.Name = "fileHashDataGridViewTextBoxColumn"; this.fileHashDataGridViewTextBoxColumn.ReadOnly = true; // // scriptRunIdDataGridViewTextBoxColumn // this.scriptRunIdDataGridViewTextBoxColumn.DataPropertyName = "ScriptRunId"; this.scriptRunIdDataGridViewTextBoxColumn.HeaderText = "Run ID"; this.scriptRunIdDataGridViewTextBoxColumn.Name = "scriptRunIdDataGridViewTextBoxColumn"; this.scriptRunIdDataGridViewTextBoxColumn.ReadOnly = true; // // scriptRunBindingSource // this.scriptRunBindingSource.DataMember = "ScriptRun"; this.scriptRunBindingSource.DataSource = this.sqlSyncBuildDataBindingSource; // // sqlSyncBuildProjectBindingSource // this.sqlSyncBuildProjectBindingSource.DataMember = "SqlSyncBuildProject"; this.sqlSyncBuildProjectBindingSource.DataSource = this.sqlSyncBuildDataBindingSource; // // saveFileDialog1 // this.saveFileDialog1.DefaultExt = "xml"; this.saveFileDialog1.Filter = "XML Files *.xml|*.xml|All Files *.*|*.*"; this.saveFileDialog1.Title = "Save Build History"; // // PastBuildReviewForm // this.AutoScaleBaseSize = new System.Drawing.Size(6, 16); this.ClientSize = new System.Drawing.Size(1096, 534); this.Controls.Add(this.splitContainer1); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.Name = "PastBuildReviewForm"; this.Text = "Review Past Builds"; this.Load += new System.EventHandler(this.PastBuildReviewForm_Load); ((System.ComponentModel.ISupportInitialize)(this.sqlSyncBuildData1)).EndInit(); this.contextMenuStrip1.ResumeLayout(false); this.splitContainer1.Panel1.ResumeLayout(false); this.splitContainer1.Panel1.PerformLayout(); this.splitContainer1.Panel2.ResumeLayout(false); this.splitContainer1.Panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).EndInit(); this.splitContainer1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dgMaster)).EndInit(); this.ctxMaster.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.buildBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.sqlSyncBuildDataBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dgDetail)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.scriptRunBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.sqlSyncBuildProjectBindingSource)).EndInit(); this.ResumeLayout(false); }