private static Dictionary <string, DbUtility> LoadDatabaseList() { DatabaseList list = SerializerProvider.SerializerHelper <DatabaseList> .LoadFromXmlFile(Configer.ServerListFileLocation); if (list == null || list.Databases == null || list.Databases.Length == 0) { throw new DatabaseNotSpecifiedException(); } var hashtable = new Dictionary <string, DbUtility>(list.Databases.Length); foreach (DatabaseMajor instance in list.Databases) { DbUtility database = VisitorFactory.CreateComDataVisitor(instance.Connection.DataProvider.Value); database.Provider = instance.Connection.DataProvider.Value; database.DataServer = instance.Connection.DataServer.Value; database.DataSource = instance.Connection.DataSource.Value; database.UserID = instance.Connection.DataUserID.Value; database.Password = instance.Connection.DataPassword.Value; database.Initialize(); //TODO:此处应解析Password hashtable.Add(instance.Name.ToUpper(), database); } return(hashtable); }
public ActionResult GetTaskInfoStrList() { DatabaseList da = DatabaseList.GetData(); var list = CompontInfoManage.GetTaskInfo(da, 0, ""); return(Json(CompontInfoManage.GetAllTaskInfoStr(list), JsonRequestBehavior.AllowGet)); }
/// <summary> /// Initializes a new instance of the MainViewModel class. /// </summary> public MainViewModel(IDataService dataService) { try { _dataService = dataService; LoadCommand = new RelayCommand(Load); SaveCommand = new RelayCommand(Save); SelectionChangedCommand = new RelayCommand <IList>(SelectionChanged); var dbList = new DatabaseList(); if (IsInDesignMode) { _sourceDb = dbList.First(d => d.name == "TARIF"); _targetDb = dbList.First(d => d.name == "SMODEV"); } else { string[] args = Environment.GetCommandLineArgs(); if (args.Length < 2) { throw new Exception("Nombre d'argument insuffisant"); } _sourceDb = dbList.First(d => d.name == args[1]); _targetDb = dbList.First(d => d.name == args[2]); } _dataService.SetDatabases(_targetDb, _sourceDb); ObjectNameList = _dataService.GetSyncablesObjects(); _dataService.Log += Log; CurrentObjectName = "ARTICLE"; Title = $"Synchronisation de {_sourceDb.name} vers {_targetDb.name}"; } catch (Exception ex) { Messenger.Default.Send(ex.Message, "LambdaMessage"); } }
private void settingsControl1_ServerChanged(object sender, string serverName, string username, string password, AuthenticationType authType) { Connection.ConnectionData oldConnData = new Connection.ConnectionData(); this.connData.Fill(oldConnData); this.Cursor = Cursors.WaitCursor; this.connData.SQLServerName = serverName; if (!string.IsNullOrWhiteSpace(username) && (!string.IsNullOrWhiteSpace(password))) { this.connData.UserId = username; this.connData.Password = password; } this.connData.AuthenticationType = authType; this.connData.ScriptTimeout = 5; try { DatabaseList dbList = SqlSync.DbInformation.InfoHelper.GetDatabaseList(this.connData); //this.LookUpTable_Load(null, EventArgs.Empty); } catch { MessageBox.Show("Error retrieving database list. Is the server running?", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.connData = oldConnData; this.settingsControl1.Server = oldConnData.SQLServerName; } this.Cursor = Cursors.Default; }
public RebuildForm(Connection.ConnectionData connData, DatabaseList databaseList) { this.dbList = databaseList; this.connData = connData; InitializeComponent(); ddDatabases.Items.AddRange(databaseList.ToArray()); }
/// <summary> /// 获取所有任务信息 /// </summary> /// <returns></returns> public ActionResult GetTaskInfoCreate() { DatabaseList da = DatabaseList.GetData(); var list = CompontInfoManage.GetTaskInfoCreate(da, 0, ""); return(Json(list, JsonRequestBehavior.AllowGet)); }
internal void SetConnection() { try { this.ddDatabase.Items.Clear(); ConnectionData connData = new ConnectionData(); connData.SQLServerName = this.ddServers.Text; connData.UserId = this.txtUser.Text; connData.Password = this.txtPassword.Text; connData.AuthenticationType = this.AuthenticationType; connData.ScriptTimeout = 10; bool hasError; this.databaseList = InfoHelper.GetDatabaseList(connData, out hasError); if (hasError) { MessageBox.Show("Unable to connect to specified SQL Server.\r\nPlease select another server.", "Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error); if (this.ServersEnumerated != null) { this.ServersEnumerated(this, new ServersEnumeratedEventArgs(new string[0], "Connection error. Please re-select.")); } this.Cursor = Cursors.Default; return; } for (int i = 0; i < databaseList.Count; i++) { this.ddDatabase.Items.Add(databaseList[i].DatabaseName); } if (ddDatabase.Visible) { this.ddDatabase.Sorted = true; if (this.ddDatabase.Items.Count > 0) { this.ddDatabase.SelectedIndex = 0; this.ddDatabase.Enabled = true; } else { this.ddDatabase.Enabled = false; this.ddDatabase.Text = "<No databases found>"; } } if (this.ServerConnected != null) { UtilityHelper.UpdateRecentServerList(this.ddServers.Text, this.txtUser.Text, this.txtPassword.Text, this.AuthenticationType); this.ServerConnected(this, new ServerConnectedEventArgs(true, this.AuthenticationType)); } this.Cursor = Cursors.Default; } catch (Exception err) { this.Cursor = Cursors.Default; MessageBox.Show(err.Message, "Error"); } }
private Series LoadCpuSeries(WorkloadAnalysis analysis, OxyColor color, double baseOffset) { if (analysis == null) { return(null); } LineSeries cpuSeries = new LineSeries() { StrokeThickness = 2, MarkerSize = 3, MarkerStroke = OxyColor.Parse("#FF0000"), //Red MarkerType = MarkerType.None, CanTrackerInterpolatePoints = false, Title = analysis.Name, Color = color, Smooth = false }; if (baseOffset == 0) { cpuSeries.TrackerFormatString = "Offset: {2:0}\n{0}: {4:0}"; } var Table = from t in analysis.Points where ApplicationList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.ApplicationName) && HostList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.HostName) && DatabaseList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.DatabaseName) && LoginList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.LoginName) group t by new { offset = t.OffsetMinutes } into grp orderby grp.Key.offset select new { offset_minutes = grp.Key.offset, cpu = grp.Sum(t => t.SumCpuUs) }; foreach (var p in Table) { double xValue = 0; if (baseOffset > 0) { xValue = DateTimeAxis.ToDouble(DateTimeAxis.ToDateTime(baseOffset).AddMinutes(p.offset_minutes)); } else { xValue = p.offset_minutes; } cpuSeries.Points.Add(new DataPoint(xValue, p.cpu)); } return(cpuSeries); }
private DatabaseList GetDatabases(Boolean refresh) { if (_databases.IsNull() || refresh) { _databases = DatabaseManagerTest.GetAllDatabases(); } return(_databases); }
//public ScriptConfigCtrl(ref SqlSyncBuildData.ScriptRow scriptConfig, string[] databaseList) //{ // InitializeComponent(); // this.scriptConfig = scriptConfig; // this.databaseList = databaseList; // SetUp(); //} public void SetConfigData(ref SqlSyncBuildData.ScriptRow scriptConfig, DatabaseList databaseList, List <string> tagList, bool tagRequired) { this.scriptConfig = scriptConfig; this.databaseList = databaseList; this.tagList = tagList; this.tagRequired = tagRequired; SetUp(); }
public ConfigurationViaQueryForm(ConnectionData connData, DatabaseList dbList) : this() { if (connData.SQLServerName != null && connData.SQLServerName.Length > 0) { this.connData = connData; } this.databaseList = dbList; this.showPreviewButton = true; }
public static void Disconnect() { if (_mongoClient != null) { _mongoClient = null; } Databases = null; }
private void loadDatabase(byte[] data) { var db = new DatabaseList(data); if (db.Slot.Count > 0) { Database.Add(db); } }
private void ObjectValidation_Load(object sender, System.EventArgs e) { DatabaseList dbs = SqlSync.DbInformation.InfoHelper.GetDatabaseList(connData); for (int i = 0; i < dbs.Count; i++) { ddDatabaseList.Items.Add(dbs[i].DatabaseName); } this.settingsControl1.Server = this.connData.SQLServerName; }
private void BindDatabaseListDropDown(DatabaseList databaseList) { this.ddDatabase.Items.Clear(); for (int i = 0; i < databaseList.Count; i++) { this.ddDatabase.Items.Add(databaseList[i].DatabaseName); } this.ddDatabase.SelectedIndex = 0; ddDatabase_SelectionChangeCommitted(null, EventArgs.Empty); }
private void ServerList_SelectedIndexChanged(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; server = ServerList.Text; procedures.Clear(); SPSQL.Clear(); SPTextBox.Text = string.Empty; AllProceduresCheckbox.Checked = false; if (!string.IsNullOrEmpty(server)) { DatabaseList.Enabled = ServerList.SelectedIndex != -1; DatabaseList.Text = string.Empty; DatabaseList.Items.Clear(); // Setup database list. var connectionString = @"Server=" + server + ";Initial Catalog=master;Integrated Security=SSPI"; using (var conn = new SqlConnection(connectionString)) { try { conn.Open(); var sql = @""; using (var cmd = new SqlCommand("SELECT name FROM master..sysdatabases WHERE name LIKE '%_App'", conn)) { using (var result = cmd.ExecuteReader()) { if (result.HasRows) { while (result.Read()) { DatabaseList.Items.Add(result["name"]); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } finally { conn.Close(); this.Cursor = Cursors.Default; } } DatabaseList.Focus(); } }
private void Window_Initialized ( object sender, EventArgs e ) { string initialDatabase = null; using (IrbisConnection connection = GetConnection()) { IniFile iniFile = connection.IniFile; string listFile = "dbnam1.mnu"; if (!ReferenceEquals(iniFile, null)) { iniFile.GetValue("MAIN", "DBNNAMECAT", "dbnam1.mnu"); string ext = System.IO.Path.GetExtension(listFile); if (string.IsNullOrEmpty(ext)) { listFile += ".mnu"; } initialDatabase = iniFile.GetValue("MAIN", "CURDBN", null); } databases = connection.ListDatabases(listFile); foreach (DatabaseInfo database in databases) { DatabaseList.Items.Add(database); } } int initialIndex = 0; if (!string.IsNullOrEmpty(initialDatabase)) { for (int i = 0; i < databases.Length; i++) { if (initialDatabase.SameString(databases[i].Name)) { initialIndex = i; break; } } } if (initialIndex >= 0 && initialIndex < databases.Length) { DatabaseList.SelectedIndex = initialIndex; object selectedItem = DatabaseList.SelectedItem; if (!ReferenceEquals(selectedItem, null)) { DatabaseList.ScrollIntoView(selectedItem); } } }
private NewBuildScriptForm(DatabaseList databaseList, List <string> tagList, string lastDatabase, string baseFilePath) { this.InitializeComponent(); this.tagList = tagList; this.baseFilePath = baseFilePath; this.ddInfer.SelectedIndex = 0; this.ddDatabaseList.SetData(databaseList, lastDatabase); for (int i = 0; i < this.tagList.Count; i++) { cbTag.Items.Add(this.tagList[i]); } }
private void AddNewServerItem(string serverName, DatabaseList dbList) { ListViewItem item = new ListViewItem(serverName); ServerData dat = new ServerData(); dat.ServerName = serverName; dat.Databases = dbList; item.Tag = dat; lstServers.Items.Add(item); SwitchSelectedServer(item.Index); }
public void DatabasesTest() { ServerData target = new ServerData(); DatabaseList expected = new DatabaseList(); expected.Add(new DatabaseItem()); DatabaseList actual; target.Databases = expected; actual = target.Databases; Assert.AreEqual(expected, actual); Assert.AreEqual(1, actual.Count); }
private void KeyBox_TextChanged ( object sender, TextChangedEventArgs e ) { TextBox textBox = sender as TextBox; if (ReferenceEquals(textBox, null)) { return; } string text = textBox.Text.Trim(); if (string.IsNullOrEmpty(text)) { return; } DatabaseInfo found = null; foreach (DatabaseInfo database in databases) { string name = database.Name; if (!string.IsNullOrEmpty(name)) { if (Contains(name, text)) { found = database; break; } } string description = database.Description; if (!string.IsNullOrEmpty(description)) { if (Contains(description, text)) { found = database; break; } } } if (!ReferenceEquals(found, null)) { DatabaseList.SelectedItem = found; DatabaseList.ScrollIntoView(found); } }
/// <summary> /// Method to return an item sent in as a ModelViewModelType as a ModelType /// </summary> /// <typeparam name="ModelType">The type to be returned</typeparam> /// <typeparam name="ModelViewModelType">The type to get the value from</typeparam> /// <param name="Instance">The current instance needed to get the right item</param> /// <returns>The sent in item as the desired model type</returns> public ModelType GetSelectedItemAsModelType <ModelType, ModelViewModelType>(ModelViewModelType Instance) { // casting the database result to a queryable list var ModelTypeList = DatabaseList.Cast <ModelType>().ToList(); // casting the view model version to a queryable list var ModelViewModelList = CurrentList.Cast <ModelViewModelType>().ToList(); // getting the index of the chosen item int index = ModelViewModelList.IndexOf(Instance); // return the same item but as a Model Type return(ModelTypeList[index]); }
public static async Task <DatabaseList> SetListDescription(TwitterList list) { var dbl = new DatabaseList { Id = list.Id, UserId = list.User.Id, Name = list.Name, FullName = list.FullName, Slug = list.Slug }; await Database.ListCrud.InsertAsync(dbl).ConfigureAwait(false); return(dbl); }
public ActionResult SearchSubmit() { try { var str = Request["str"]; DatabaseList da = DatabaseList.GetData(); var list = CompontInfoManage.GetTaskInfo(da, 0, ""); var res = CompontInfoManage.SearchSubmit(list, str, false); return(Json(res, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Content(ex.Message)); } }
public MultiDbRunForm(ConnectionData connData, List <string> defaultDatabases, DatabaseList databaseList, string buildZipFileName, string projectFilePath, ref SqlSyncBuildData buildData) : this() { //perform real copy to prevent data slipping back into main form string[] tmp = new string[defaultDatabases.Count]; defaultDatabases.CopyTo(tmp); this.defaultDatabases = new List <string>(tmp); this.databaseList = databaseList; this.server = connData.SQLServerName; this.DialogResult = DialogResult.Cancel; this.buildZipFileName = buildZipFileName; this.buildData = buildData; this.projectFilePath = projectFilePath; this.connData = connData; }
private void mnuChangeSqlServer_Click(object sender, EventArgs e) { ConnectionForm frmConnect = new ConnectionForm("Sql Build Manager"); DialogResult result = frmConnect.ShowDialog(); if (result == DialogResult.OK) { this.connData = frmConnect.SqlConnection; this.databaseList = frmConnect.DatabaseList; this.lblServer.Text = this.connData.SQLServerName; this.SetDatabaseList(frmConnect.SqlConnection.SQLServerName, ""); } }
public void ReadDatabases() { using (SqlConnection connection = new SqlConnection(GetSqlConString())) { SqlCommand command = new SqlCommand("select NAME from SYS.DATABASES", connection); command.Connection.Open(); using (var oReader = command.ExecuteReader()) { while (oReader.HasRows && oReader.Read()) { DatabaseList.Add((string)oReader["NAME"]); } } } }
public void SquareBracketOperator() { Int32 databaseIndex; DatabaseList newDatabaseList, oldDatabaseList; oldDatabaseList = GetDatabases(true); newDatabaseList = new DatabaseList(); for (databaseIndex = 0; databaseIndex < oldDatabaseList.Count; databaseIndex++) { newDatabaseList.Add(oldDatabaseList[oldDatabaseList.Count - databaseIndex - 1]); } for (databaseIndex = 0; databaseIndex < oldDatabaseList.Count; databaseIndex++) { Assert.AreEqual(newDatabaseList[databaseIndex], oldDatabaseList[oldDatabaseList.Count - databaseIndex - 1]); } }
private void changeSqlServerConnectionToolStripMenuItem_Click(object sender, EventArgs e) { ConnectionForm frmConnect = new ConnectionForm("Build File Reconstructor"); DialogResult result = frmConnect.ShowDialog(); if (result == DialogResult.OK) { this.connData = frmConnect.SqlConnection; this.settingsControl1.Server = this.connData.SQLServerName; this.dbList = frmConnect.DatabaseList; ddDatabases.Items.Clear(); ddDatabases.Items.AddRange(dbList.ToArray()); //bgWorker.RunWorkerAsync(); } }
private Series LoadBatchesSeries(WorkloadAnalysis analysis, OxyColor color) { if (analysis == null) { return(null); } LineSeries batchesSeries = new LineSeries() { StrokeThickness = 2, MarkerSize = 3, MarkerStroke = OxyColor.Parse("#FF0000"), //Red MarkerType = MarkerType.None, CanTrackerInterpolatePoints = false, TrackerFormatString = "Offset: {2:0}\n{0}: {4:0}", Title = analysis.Name, Color = color, Smooth = false }; var Table = from t in analysis.Points where ApplicationList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.ApplicationName) && HostList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.HostName) && DatabaseList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.DatabaseName) && LoginList.Where(f => f.IsChecked).Select(f => f.Name).Contains(t.LoginName) group t by new { offset = t.OffsetMinutes } into grp orderby grp.Key.offset select new { offset_minutes = grp.Key.offset, execution_count = grp.Sum(t => t.ExecutionCount / ((t.DurationMinutes == 0 ? 1 : t.DurationMinutes) * 60)) }; foreach (var p in Table) { batchesSeries.Points.Add(new DataPoint(p.offset_minutes, p.execution_count)); } return(batchesSeries); }
internal static void LoadDatabaseInfo() { DatabaseList dbList = ConfigHelper.LoadDatabaseListFile(); if (dbList != null && dbList.DatabaseInstances != null && dbList.DatabaseInstances.Length > 0) { List <string> tmp = new List <string>(dbList.DatabaseInstances.Length); foreach (var db in dbList.DatabaseInstances) { if (tmp.Contains(db.Name)) { throw new ApplicationException("Duplidated database name '" + db.Name + "' in configuration file '" + ConfigHelper.DatabaseListFilePath + "'."); } tmp.Add(db.Name); ConnectionStringManager.SetConnectionString(db.Name, Decrypt(db.ConnectionString), db.Type); } } }
public DatabaseStoreTests() { var mongoClientMock = new Mocks.MongoClient(); DatabaseList = new DatabaseList(mongoClientMock); }
public static void Connect(IMongoClient client) { _mongoClient = client; Databases = new DatabaseList(client); }
private void loadDatabase(byte[] data) { var db = new DatabaseList(data); if (db.Slot.Count > 0) Database.Add(db); }