private void buttonViewScript_Click(object sender, EventArgs e) { string flags = GetFlags(); if (string.IsNullOrEmpty(flags)) { MessageBox.Show("Please choose at least one flag", "Prompt"); return; } TableSynchronization.OptimizeOption option = TableSynchronization.OptimizeOption.Minimum; if (comboBoxOptimizeOption.Text.Equals("Middle")) { option = TableSynchronization.OptimizeOption.Middle; } else if (comboBoxOptimizeOption.Text.Equals("None")) { option = TableSynchronization.OptimizeOption.None; } int step = (int)numericUpDownStep.Value; _TableSync = new TableSynchronization(DataAccess.Conn, TableName, step, option, checkBoxFastestMode.Checked, flags); textBoxScript.Text = _TableSync.GetSql(); this.Height = textBoxScript.Top + textBoxScript.Height + 40; }
private bool Start() { try { _StartTime = DateTime.Now; TableSynchronization.OptimizeOption option = TableSynchronization.OptimizeOption.Minimum; if (comboBoxOptimizeOption.Text.Equals("Middle")) { option = TableSynchronization.OptimizeOption.Middle; } else if (comboBoxOptimizeOption.Text.Equals("None")) { option = TableSynchronization.OptimizeOption.None; } int step = (int)numericUpDownStep.Value; _TableSync = new TableSynchronization(DataAccess.Conn, TableName, step, option, checkBoxFastestMode.Checked, _Flags); _TableSync.Synchronize(); _Thread = new System.Threading.Thread(ShowProgress); _Thread.IsBackground = true; _Thread.Start(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
protected override void OnInit(EventArgs e) { InitializeComponent(); base.OnInit(e); if (!LocalTablesLinked()) { ResetModelGoToModels(); } if (IsWhatifMode()) { Response.Redirect("whatif_" + PAGENAME); } string dataFile = GetDirectory() + userDir + MAIN_USER_DATABASE; srcProductStructure.DataFile = dataFile; try { dropListProducts.DataBind(); } catch (Exception) { Master.ShowErrorMessage(); } Control buttondiv = getButtonDiv(); tableSync = new TableSynchronization(userDir); //string sheet = "Cheat Sheat IBOM Page"; //Master.SetHelpSheet(sheet + ".pdf", sheet); }
protected override void OnInit(EventArgs e) { InitializeComponent(); base.OnInit(e); tableSync = new TableSynchronization(userDir); //string sheet = "Cheat Sheat Models Page"; //Master.SetHelpSheet(sheet + ".pdf", sheet); }
protected override void OnInit(EventArgs e) { InitializeComponent(); pnlMenu.Controls.Add(new LiteralControl("<h2>What-If: Products</h2>")); base.OnInit(e); if (!IsWhatifMode()) { string whatifPart = "whatif_"; Response.Redirect(PAGENAME.Substring(whatifPart.Length)); } helperProduct.SetMenuContainer(pnlMenu); helperProduct.OnInit(e); tableSync = new TableSynchronization(userDir); }
protected override void OnInit(EventArgs e) { InitializeComponent(); //pnlMenu.Controls.Add(new LiteralControl("<h2>Products</h2>")); base.OnInit(e); if (IsWhatifMode()) { Response.Redirect("whatif_" + PAGENAME); } string dataFile = GetDirectory() + userDir + MAIN_USER_DATABASE; srcProductsList.DataFile = dataFile; dropListProducts.DataBind(); helperProduct.SetMenuContainer(pnlMenu); helperProduct.OnInit(e); tableSync = new TableSynchronization(userDir); string sheet = "Cheat Sheat Product Operations and Routings Page"; Master.SetHelpSheet(sheet + ".pdf", sheet); }
private bool Start() { try { _StartTime = DateTime.Now; TableSynchronization.OptimizeOption option = TableSynchronization.OptimizeOption.Minimum; if (comboBoxOptimizeOption.Text.Equals("Middle")) { option = TableSynchronization.OptimizeOption.Middle; } else if (comboBoxOptimizeOption.Text.Equals("None")) { option = TableSynchronization.OptimizeOption.None; } int step = (int)numericUpDownStep.Value; string sql = GetSql(step, option); GlobalSetting.DataAccess.Excute(sql); _TableSync = new TableSynchronization(DataAccess.Conn, TableName, step, option, false, null); _Thread = new System.Threading.Thread(ShowProgress); _Thread.IsBackground = true; _Thread.Start(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
protected override void OnInit(EventArgs e) { InitializeComponent(); pnlMenu.Controls.Add(new LiteralControl("<h2>What-If: Products</h2>")); base.OnInit(e); if (!LocalTablesLinked()) { ResetModelGoToModels(); } if (!IsWhatifMode()) { string whatifPart = "whatif_"; Response.Redirect(PAGENAME.Substring(whatifPart.Length)); } helperProduct.SetMenuContainer(pnlMenu); helperProduct.OnInit(e); string dataFile = GetDirectory() + userDir + MAIN_USER_DATABASE; srcProductsList.DataFile = dataFile; srcProductStructure.DataFile = dataFile; try { dropListProducts.DataBind(); } catch (Exception) { Master.ShowErrorMessage(); } Control buttondiv = getButtonDiv(); Button btnCopyTable = buttondiv.FindControl(PageControls.BTN_COPY_TABLE) as Button; extenderCopy.TargetControlID = copyAllDummy.ID; btnCopyTable.Click += btnCopyTable_Click; hdnCopyMode = new HiddenField(); pnlCopyTable.Controls.Add(hdnCopyMode); tableSync = new TableSynchronization(userDir); }