public void LoadDatabases() { EntityBusiness business = new EntityBusiness(); var databases = business.GetAllServers(); dgvDatabases.DataSource = databases; dgvDatabases.ClearSelection(); }
private void LoadEnvironments() { EntityBusiness edata = new EntityBusiness(); var serverlist = edata.GetServerList().ToList(); if (serverlist != null) { _envlist = serverlist; foreach (var s in serverlist) { ToolStripItem item = new ToolStripMenuItem(); item.Text = s.DbAlias; item.Name = s.ServerID.ToString(); item.Click += new EventHandler(item_Click); tsbtnExeOn.DropDownItems.Add(item); ToolStripItem item2 = new ToolStripMenuItem(); item2.Text = s.DbAlias; item2.Name = s.ServerID.ToString(); item2.Click += new EventHandler(itemcheck_Click); tsbtnExeOnSelected.DropDownItems.Add(item2); } } ToolStripSeparator tsSeparator = new ToolStripSeparator(); tsbtnExeOn.DropDownItems.Add(tsSeparator); ToolStripItem itemall = new ToolStripMenuItem(); itemall.Text = "All Environments"; itemall.Name = "all"; itemall.Click += new EventHandler(item_Click); tsbtnExeOn.DropDownItems.Add(itemall); }
void LoadExistingServers() { EntityBusiness business = new EntityBusiness(); var servers = business.GetServerList(); cmbServerName.DisplayMember = "ServerName"; cmbServerName.ValueMember = "ServerID"; cmbServerName.DataSource = servers; cmbServerName.SelectedIndex = -1; }
private void LoadLastSavedSession() { try { EntityBusiness entityBusiness = new EntityBusiness(); var lastsess = entityBusiness.GetLastTableScriptSession(); selectedtables = lastsess; dgvtblSelected.DataSource = selectedtables; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void LoadDataBases() { EntityBusiness edata = new EntityBusiness(); var serverlist = edata.GetServerList(); //Column5.DisplayMember = "Database"; //Column5.ValueMember = "ServerID"; Column3.DataSource = serverlist; DataGridViewComboBoxColumn ComboColumn = (DataGridViewComboBoxColumn)(dataGridView1.Columns[2]); ComboColumn.DataSource = serverlist; ComboColumn.DisplayMember = "Database"; ComboColumn.ValueMember = "ServerID"; }
void AddNewServer() { ServerModel ns = new ServerModel(); ns.ServerName = cmbServerName.Text.Trim(); ns.Username = txtUsername.Text.Trim(); ns.Password = txtPassword.Text.Trim(); ns.Database = cmbDatabase.Text.Trim(); ns.DbAlias = txtDatabase.Text.Trim(); EntityBusiness business = new EntityBusiness(); int res = business.AddNewDbServer(ns); ClearForm(); if (res > 0) MessageBox.Show("Details saved succesfully", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public void LoadDatabases() { cmbDatabase.SelectedIndexChanged -= cmbDatabase_SelectedIndexChanged; EntityBusiness entityBusiness = new EntityBusiness(); var dbs = entityBusiness.GetServerList(); cmbDatabase.ComboBox.DisplayMember = "DbAlias"; cmbDatabase.ComboBox.ValueMember = "ServerID"; cmbDatabase.ComboBox.DataSource = dbs; string mainserver = new ConfigurationHelper().GetConfigurationValue("mainserver"); //string mainserver = System.Configuration.ConfigurationSettings.AppSettings["mainserver"]; if (mainserver != "0" && mainserver != "") cmbDatabase.ComboBox.SelectedValue = Convert.ToInt32(mainserver); else cmbDatabase.ComboBox.SelectedIndex = -1; cmbDatabase.SelectedIndexChanged += cmbDatabase_SelectedIndexChanged; }
void RemoveDatabase() { EntityBusiness entityBusiness = new EntityBusiness(); int id = Convert.ToInt32(dgvDatabases.SelectedRows[0].Cells[1].Value); entityBusiness.RemoveServer(id); LoadDatabases(); }
public string GenerateDataScript() { DataGenType dtype = DataGenType.Insert; if (rbDInsert.Checked) dtype = DataGenType.Insert; else if (rbDUpdate.Checked) dtype = DataGenType.Update; else if (rbDTruncate.Checked) dtype = DataGenType.Truncate; else if (rbDTruncateInsert.Checked) dtype = DataGenType.TruncateInsert; ScriptBusiness scriptBusiness = new ScriptBusiness(); var server = new EntityBusiness().GetServerList().Where(x=> x.ServerID == Convert.ToInt32(tscomserver.ComboBox.SelectedValue)).First(); string query = scriptBusiness.GenerateTableData(server, dtype, selectedtables); return query; }
private void btnRemove_Click(object sender, EventArgs e) { dgvtblSelected.EndEdit(); var remlist = new List<int>(); foreach (DataGridViewRow rw in dgvtblSelected.Rows) { if (Convert.ToBoolean(rw.Cells[1].Value)) { remlist.Add(Convert.ToInt32(rw.Cells[0].Value)); } } EntityBusiness entityBusiness = new EntityBusiness(); entityBusiness.RemoveTabelObject(remlist.Select(x=> new TableModel() { TableId = x }).ToList()); foreach (var id in remlist) { selectedtables.Remove(selectedtables.Where(x => x.TableId == id).First()); } selectedtables = selectedtables.OrderBy(x => x.TableName).ToList(); dgvtblSelected.DataSource = selectedtables; }
private void tscomserver_SelectedIndexChanged(object sender, EventArgs e) { try { if (tscomserver.ComboBox.Items.Count > 0) { if (tscomserver.ComboBox.SelectedIndex != -1) { int id = Convert.ToInt32(tscomserver.ComboBox.SelectedValue); EntityBusiness data = new EntityBusiness(); var servers = data.GetServerList(); maindb = servers.Where(x => x.ServerID == id).FirstOrDefault(); LoadTables(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void LoadDatabases() { tscomserver.SelectedIndexChanged -= tscomserver_SelectedIndexChanged; EntityBusiness entityBusiness = new EntityBusiness(); var dbs = entityBusiness.GetServerList(); tscomserver.ComboBox.DisplayMember = "DbAlias"; tscomserver.ComboBox.ValueMember = "ServerID"; tscomserver.ComboBox.DataSource = dbs; string mainserver = new ConfigurationHelper().GetConfigurationValue("mainserver"); if (mainserver != "0" && mainserver != "") { tscomserver.ComboBox.SelectedValue = Convert.ToInt32(mainserver); maindb = dbs.Where(x => x.ServerID == Convert.ToInt32(mainserver)).FirstOrDefault(); //LoadOtherDBs(dbs, Convert.ToInt32(mainserver)); } else { tscomserver.ComboBox.SelectedIndex = -1; //LoadOtherDBs(dbs, 0); } tscomserver.SelectedIndexChanged += tscomserver_SelectedIndexChanged; }
private void cmbDatabase_SelectedIndexChanged(object sender, EventArgs e) { try { if (cmbDatabase.ComboBox.Items.Count > 0) { if (cmbDatabase.ComboBox.SelectedIndex != -1) { int id = Convert.ToInt32(cmbDatabase.ComboBox.SelectedValue); EntityBusiness data= new EntityBusiness(); var servers = data.GetServerList(); AppTimeConfiguration.MainServer = servers.Where(x => x.ServerID == id).FirstOrDefault(); new ConfigurationHelper().AddConfiguration("mainserver",id.ToString()); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void UpdateDatabases() { List<ServerModel> slist = new List<ServerModel>(); dgvDatabases.EndEdit(); foreach (DataGridViewRow row in dgvDatabases.Rows) { slist.Add(new ServerModel() { ServerID = Convert.ToInt32(row.Cells[1].Value), IsVisible = Convert.ToBoolean(row.Cells[7].Value) }); } EntityBusiness entityBusiness = new EntityBusiness(); entityBusiness.UpdateDatabases(slist); }
void CompareScript(int rowindex) { string spname = dgvSP.Rows[rowindex].Cells[3].Value.ToString(); StoredProcedureBusiness spdata = new StoredProcedureBusiness(); int sourceid = Convert.ToInt32(dgvSP.Rows[rowindex].Cells[5].Value); int toid = Convert.ToInt32(dgvSP.Rows[rowindex].Cells[6].Value); var serverlist = new EntityBusiness().GetServerList(); var serversource = serverlist.Where(x => x.ServerID == sourceid).First(); var serverto = serverlist.Where(x => x.ServerID == toid).First(); string leftquery = new StoredProcedureBusiness().GetScript(serversource, spname); string rightquery = new StoredProcedureBusiness().GetScript(serverto, spname); frmCompare frm = new frmCompare(leftquery,rightquery); frm.Show(); }
void RemoveAll() { EntityBusiness entityBusiness = new EntityBusiness(); entityBusiness.ClearAllDatabases(); LoadDatabases(); }
void LoadDataBases() { EntityBusiness edata = new EntityBusiness(); var serverlist = edata.GetServerList(); DataGridViewComboBoxColumn colsource = (DataGridViewComboBoxColumn)(dgvSP.Columns[5]); colsource.DataSource = serverlist; colsource.DisplayMember = "Database"; colsource.ValueMember = "ServerID"; DataGridViewComboBoxColumn colto = (DataGridViewComboBoxColumn)(dgvSP.Columns[6]); colto.DataSource = serverlist; colto.DisplayMember = "Database"; colto.ValueMember = "ServerID"; }
public void LoadStoredProcedures(DateTime date) { EntityBusiness edata = new EntityBusiness(); var splist = edata.GetDailyStoredProcedures(date); dgvSP.DataSource = splist; var ms = AppTimeConfiguration.MainServer.ServerID; foreach (DataGridViewRow rw in dgvSP.Rows) { rw.Cells[5].Value = ms; rw.Cells[6].Value = ms; } }
private void frmHome_Load(object sender, EventArgs e) { try { LoadDatabases(); string serverid = new ConfigurationHelper().GetConfigurationValue("mainserver"); EntityBusiness data = new EntityBusiness(); var servers = data.GetServerList(); var server = servers.Where(x => x.ServerID == Convert.ToInt32(serverid)).FirstOrDefault(); if (server != null) { AppTimeConfiguration.MainServer = server; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void AddTables() { EntityBusiness entityBusiness = new EntityBusiness(); dgvallTables.EndEdit(); var tbllist = new List<TableModel>(); foreach (DataGridViewRow rw in dgvallTables.Rows) { if (Convert.ToBoolean(rw.Cells[1].Value)) tbllist.Add(new TableModel() { TableId = Convert.ToInt32(rw.Cells[0].Value.ToString()), bSelected = true, TableName = rw.Cells[2].Value.ToString() }); } var newtables = tbllist.Where(y => !selectedtables.Select(x => x.TableId).Contains(y.TableId)) .ToList(); entityBusiness.AddTableObject(newtables); selectedtables.AddRange(newtables); selectedtables = selectedtables.OrderBy(x => x.TableName).ToList(); dgvtblSelected.DataSource = selectedtables; }
void AddNewStoredProcedure() { string spname = txtspname.Text.Trim(); StoredProcedureBusiness spData = new StoredProcedureBusiness(); var splist = spData.GetStoredProcedureList(AppTimeConfiguration.MainServer); if (splist.Select(x => x.SPName.ToLower()).Contains(spname.ToLower())) { string procname = splist.Where(x => x.SPName.ToLower() == spname.ToLower()).First().SPName; EntityBusiness edata = new EntityBusiness(); SPModel sp = new SPModel(); sp.SPName = procname; sp.SPDate = dtpScriptDate.Value; sp.CreatedDate = DateTime.Now; long res = edata.AddNewSP(sp); if (res != -1) { LoadStoredProcedures(dtpScriptDate.Value); txtspname.Clear(); } else { MessageBox.Show("Stored Procedures already exists.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Stored Procedures does not exists in current database.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
void SelectServer() { if (cmbServerName.SelectedIndex >= 0) { if (cmbServerName.Items.Count > 0) { EntityBusiness business = new EntityBusiness(); var server = business.SelectServer(Convert.ToInt32(cmbServerName.SelectedValue)); if (server != null) { txtUsername.Text = server.Username; txtPassword.Text = server.Password; } } } }
void LoadStoredProcedures(DateTime date) { EntityBusiness edata = new EntityBusiness(); var splist = edata.GetDailyStoredProcedures(date); dgvSP.DataSource = splist; }
private void tsbtnRemove_Click(object sender, EventArgs e) { try { dgvSP.EndEdit(); EntityBusiness entityBusiness = new EntityBusiness(); foreach (DataGridViewRow rw in dgvSP.Rows) { if (Convert.ToBoolean(rw.Cells[2].Value)) entityBusiness.RemoveStoredProcedure(Convert.ToInt64(rw.Cells[0].Value)); } LoadStoredProcedures(dtpScriptDate.Value); } catch (Exception ex) { MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void ImportProcedures() { List<Int64> idlist = new List<Int64>(); foreach (DataGridViewRow row in dgvSP.Rows) { if(Convert.ToBoolean(row.Cells[2].Value) == true) idlist.Add(Convert.ToInt64(row.Cells[0].Value)); } EntityBusiness entityBusiness = new EntityBusiness(); entityBusiness.ImportStoredProcedures(idlist, _parentForm.dtpScriptDate.Value); }