public MainForm() { InitializeComponent(); #region Get the configuration for the app Propiedades prop = new Propiedades(); prop.FileName = MainForm.DataStorageDir + "\\EzConfig.cfg"; if (File.Exists(prop.FileName)) { prop.LoadData(); } else { prop.AddProperty("CheckForDangerousExecutions", "1"); prop.SaveData(); } _ApplicationConfiguration = new AppConfig(); _ApplicationConfiguration.CheckForDangerousExecutions = prop.GetValue("CheckForDangerousExecutions") == "1"; #endregion StatusBar.Padding = new Padding(StatusBar.Padding.Left, StatusBar.Padding.Top, StatusBar.Padding.Left, StatusBar.Padding.Bottom); #region Connection Bar AdBar = new AddressBarExt.Controls.AddressBarExt(); this.AdBar.BackColor = System.Drawing.Color.White; this.AdBar.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.AdBar.CurrentNode = null; this.AdBar.Dock = System.Windows.Forms.DockStyle.Left; this.AdBar.Font = new System.Drawing.Font("Calibri", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.AdBar.ForeColor = System.Drawing.Color.Navy; this.AdBar.Location = new System.Drawing.Point(0, 0); this.AdBar.MinimumSize = new System.Drawing.Size(385, 26); this.AdBar.Name = "AddressBar"; this.AdBar.RootNode = null; this.AdBar.SelectedStyle = ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Underline))); this.AdBar.Size = new System.Drawing.Size(482, 31); this.AdBar.TabIndex = 2; this.AdBar.SelectionChange += new AddressBarExt.Controls.AddressBarExt.SelectionChanged(this.AddressBarSelectionChange); ToolStripControlHost Helper = new ToolStripControlHost(AdBar); Helper.Width = 350; MainMenu.Items.Insert(0, Helper); #endregion //not using tha app path anymore, better yet is to use a diferent folder for each winuser that uses the app, //this also makes unnecesary the manifest, and the problems it causes //DataStorageDir = Application.StartupPath; DataStorageDir = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Ez SQL"; if (!Directory.Exists(DataStorageDir)) { Directory.CreateDirectory(DataStorageDir); } ConDataFileName = String.Format("{0}\\ConnectionGroups.xml", DataStorageDir); if (!Directory.Exists(String.Format("{0}\\Snippets", DataStorageDir)))//create snippets dir, and create default snippets { Directory.CreateDirectory(String.Format("{0}\\Snippets", DataStorageDir)); #region Create the default snippets files using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Begin - end.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Begin___end, 0, Properties.Resources.Begin___end.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Complex Snippet.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Complex_Snippet, 0, Properties.Resources.Complex_Snippet.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Create procedure.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Create_procedure, 0, Properties.Resources.Create_procedure.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Cross join.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Cross_join, 0, Properties.Resources.Cross_join.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Cursor.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Cursor, 0, Properties.Resources.Cursor.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\declare.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.declare, 0, Properties.Resources.declare.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Inner join.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Inner_join, 0, Properties.Resources.Inner_join.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Insert into.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Insert_into, 0, Properties.Resources.Insert_into.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Insert into all.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Insert_into_all, 0, Properties.Resources.Insert_into_all.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Left outer join.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Left_outer_join, 0, Properties.Resources.Left_outer_join.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\order by.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.order_by, 0, Properties.Resources.order_by.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Outer apply.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Outer_apply, 0, Properties.Resources.Outer_apply.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Right outer join.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Right_outer_join, 0, Properties.Resources.Right_outer_join.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Select all.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Select_all, 0, Properties.Resources.Select_all.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Select some from.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Select_some_from, 0, Properties.Resources.Select_some_from.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Select top records.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Select_top_records, 0, Properties.Resources.Select_top_records.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Drop Table Helper.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Drop_Table_Helper, 0, Properties.Resources.Drop_Table_Helper.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Drop Table.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Drop_Table, 0, Properties.Resources.Drop_Table.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Is Unique.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Is_Unique, 0, Properties.Resources.Is_Unique.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Record Count.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Record_Count, 0, Properties.Resources.Record_Count.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Select Count.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Select_count, 0, Properties.Resources.Select_count.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Truncate Table.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Truncate_Table, 0, Properties.Resources.Truncate_Table.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Where.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.Where, 0, Properties.Resources.Where.Length); writer.Flush(); writer.Close(); } using (FileStream writer = new FileStream(String.Format("{0}\\Snippets\\Select.snp", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { writer.Write(Properties.Resources.select, 0, Properties.Resources.select.Length); writer.Flush(); writer.Close(); } #endregion } if (!Directory.Exists(String.Format("{0}\\QueriesLog", DataStorageDir))) { Directory.CreateDirectory(String.Format("{0}\\QueriesLog", DataStorageDir)); } if (!Directory.Exists(MainForm.DataStorageDir + "\\SintaxHighLight")) { Directory.CreateDirectory(MainForm.DataStorageDir + "\\SintaxHighLight\\"); } if (!File.Exists(String.Format("{0}\\SintaxHighLight\\SQL.xshd", DataStorageDir))) { using (FileStream Writer = new FileStream(String.Format("{0}\\SintaxHighLight\\SQL.xshd", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { Writer.Write(Properties.Resources.SQL, 0, Properties.Resources.SQL.Length); Writer.Close(); } } if (!File.Exists(String.Format("{0}\\SintaxHighLight\\CSharp.xshd", DataStorageDir))) { using (FileStream Writer = new FileStream(String.Format("{0}\\SintaxHighLight\\CSharp.xshd", DataStorageDir), System.IO.FileMode.Create, System.IO.FileAccess.Write)) { Writer.Write(Properties.Resources.CSharp, 0, Properties.Resources.CSharp.Length); Writer.Close(); } } LoadSnippets(); this.MainMenu.MouseDown += new MouseEventHandler(MainMenu_MouseDown); }