void ConstructDataBase() { try { string pathScript = Path.Combine(Application.StartupPath, @"script/scripts.txt"); StreamReader sr = new StreamReader(pathScript); string sqlScripts = sr.ReadToEnd(); sr.Close(); string database = _database; sqlScripts = sqlScripts.Replace("#DataBaseName#", database); string pathMdf = dataBasePath; string pathLdf = pathMdf; pathMdf = Path.Combine(dataBasePath, database + ".mdf"); pathLdf = Path.Combine(dataBasePath, database + "_log.ldf"); sqlScripts = sqlScripts.Replace("#PathMdf#", pathMdf); sqlScripts = sqlScripts.Replace("#PathLdf#", pathLdf); sqlScripts = sqlScripts.Replace("HAN_log", database + "_log"); ProcessDataBase pData = new ProcessDataBase(); pData.ExecuteNonQueries(sqlScripts, textBox1); btnKapat.Enabled = true; Settings set = Engine.FindSettings(); set.Kurulum = "1"; Engine.SaveSettings(set); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } }
private void btnTest_Click(object sender, EventArgs e) { try { StringBuilder conStr = new StringBuilder(); conStr.AppendFormat("Server={0};", txtServer.Text); conStr.AppendFormat("Initial Catalog={0};", txtDatabase.Text); conStr.AppendFormat("Password={0};", txtPassword.Text); conStr.AppendFormat("User ID={0}", txtUserID.Text); Settings set = new Settings { ConnectionString = conStr.ToString() }; //set.Paket = (IndeksPaket)Enum.Parse(typeof(IndeksPaket), cmbPaket.Text); set.Paket = IndeksPaket.Pro; set.DataBase = "MsSql"; set.Kurulum = "0"; //Engine.SaveConnectinString(conStr.ToString()); Engine.SaveSettings(set); ProcessDataBase prc = new ProcessDataBase(); bool test = prc.TestConnection(); if (test) { MessageBox.Show("Bağlandı"); } else { MessageBox.Show("Bağlanamadı"); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
private void button1_Click(object sender, EventArgs e) { try { ProcessDataBase prc = new ProcessDataBase(Engine.GetConString()); prc.ExecuteNonQueries(textBox1.Text); MessageBox.Show("Komutlar çalıştırıldı.Lütfen programı kapatıp tekrar açın"); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
void LoadAllSube() { try { //Stopwatch stopwatch = new Stopwatch(); //stopwatch.Start(); //mngFac = new ManagerFactory(Engine.GetConString(), Engine.GetSqlServerType()); //mngSube = mngFac.GetSubeManager(); //mngUSer = mngFac.GetKullaniciManager(); ProcessDataBase pd = new ProcessDataBase(Engine.GetConString()); IList <Sube> listSube = pd.SubeListe(); bool first = true; foreach (Sube sube in listSube) { cmbSube.Items.Add(sube.Id); if (first) { cmbSube.Text = sube.Id; first = false; } } //List<Sube>liste= mngSube.GetAll(); //foreach (Sube sube in liste) // cmbSube.Items.Add(sube.Id); //TimeSpan ts = stopwatch.Elapsed; //string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", //ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); //txtKulAdi.Text = elapsedTime; //stopwatch.Stop(); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }