public MsSqlCloudFoundryService(IConfiguration configuration, IDatabaseBuilder databaseBuilder) { this.configuration = configuration; this.databaseBuilder = databaseBuilder; Service = new MsSqlService(); Id = Service.Id; }
public MsSqlTests() { _loggerMock = new Mock <ILogService>(); _repoMock = new Mock <IMsSqlRepository>(); _msSqlService = new MsSqlService(_loggerMock.Object, _repoMock.Object); _fixture = new Fixture(); }
private void btn_Refresh_Click(object sender, EventArgs e) { btn_Refresh.Enabled = false; try { string connectionString = string.Concat("data source=", txb_Server.Text, ";user id=", txb_Username.Text, ";password=", txb_Password.Text); IAdoService adoService = new MsSqlService(); cbb_Database.DataSource = adoService.GetAllDatabase(connectionString); } catch (Exception ex) { MessageBox.Show(ex.Message); } btn_Refresh.Enabled = true; }
private void Awake() { Debug.Log(Application.persistentDataPath); Current = this; StartCoroutine(LoadStyle()); Sql = new MsSqlService(); Image = new ImageService(); Excel = new ExcelService(); Application.logMessageReceived += (string condition, string stackTrace, LogType type) => { if (type == LogType.Error) { #if !UNITY_EDITOR Desktop.OpenNew <DialogForm>().SetDialog(() => Application.Quit(), "系统内部错误", condition); #endif } }; }
public async Task <bool> ContainsAsync(string keyword = "") { return(await Task <bool> .Factory.StartNew(() => { lock (_lockerFilter) { _filterList = new List <VirtualListItem>(); if (string.IsNullOrEmpty(keyword)) { return false; } var lowerKeyword = keyword.ToLower(); var players = MsSqlService.SearchPlayerForClkTag(lowerKeyword); foreach (var player in players) { if (_list.ContainsKey(player.Id)) { continue; } var rus = $"{player.FirstnameRus} {player.LastnameRus}"; var eng = $"{player.FirstnameEng} {player.LastnameEng}"; var rusTrans = Transliteration.Front(rus); var sub = GetSubText(rus, lowerKeyword) ?? (GetSubText(eng, lowerKeyword) ?? GetSubText(rusTrans, lowerKeyword)); if (sub == null) { return false; } var item = new VirtualListItem(player.Id, sub.Value.origin, player); item.UpdateColorText(sub.Value.left, sub.Value.centr, sub.Value.right); _filterList.Add(item); } return _filterList.Count > 0; } })); }
public async Task <bool> ContainsAsync(string keyword = "") { return(await Task <bool> .Factory.StartNew(() => { lock (_lockerFilter) { _filterList = new List <VirtualListItem>(); if (string.IsNullOrEmpty(keyword)) { return false; } var lowerKeyword = keyword.ToLower(); var gender = Interlocked.Read(ref _gender); var teams = MsSqlService.SearchTeamsForClkTag(lowerKeyword, (int)gender); foreach (var teamData in teams) { var rus = teamData.NameRus; var eng = teamData.NameEng; var rusTrans = Transliteration.Front(rus); var sub = GetSubText(rus, lowerKeyword) ?? (GetSubText(eng, lowerKeyword) ?? GetSubText(rusTrans, lowerKeyword)); if (sub == null) { continue; } var item = new VirtualListItem(teamData.Id, sub.Value.origin, teamData); item.UpdateColorText(sub.Value.left, sub.Value.centr, sub.Value.right); _filterList.Add(item); } return _filterList.Count > 0; } })); }
public async Task InitAsync() { await Task.Factory.StartNew(() => { MsSqlService.GetUserList(); _indexSearchStringList = new SearchStringList(true); _list = new ConcurrentDictionary <int, VirtualListItem>(); for (var index = 0; index < Uniso.InStat.User.List.Count; index++) { Uniso.InStat.User item = Uniso.InStat.User.List[index]; if (!string.IsNullOrEmpty(item.Login)) { var user = new User(index, item.Login); _list.TryAdd(index, user); _indexSearchStringList.Add(user.ToString()); } } }); await ContainsAsync(); }
public EnterpriseSql(string _connectionString) { _mssqlService = new MsSqlService(_connectionString); }
static void Main(string[] args) { try { var argList = ReadArgs(args); if (argList == null) { return; } var dbType = GetSwitchInput(argList, "-t", "Database Type:\n1. SQL Server\n2. MySQL\n3. PostgreSQL", new Dictionary <string, string> { { "1", _msSql }, { "2", _mySql }, { "3", _postgreSql } }); var connectionString = GetInput(argList, "-c", "ConnectionString:", optional: true); var skip = !string.IsNullOrWhiteSpace(connectionString); var setting = new DatabaseSettingModel { ConnectionString = connectionString, DbType = dbType, HostString = GetInput(argList, "-s", "Server name or IP address:", skip: skip), DatabaseName = GetInput(argList, "-d", "Database name:", skip: skip && dbType == _msSql), UserName = GetInput(argList, "-u", "Username:"******"-p", "Password:"******"Can't get any table info"); } IExporter exporter = new HtmlExporter(); var stream = exporter.Export(setting, tableInfos); stream.Seek(0, SeekOrigin.Begin); using (var fileStream = new FileStream($"{setting.DatabaseName}.html", FileMode.Create)) { stream.CopyTo(fileStream); } } catch (Exception e) { Console.WriteLine(e.ToString()); System.Threading.Thread.Sleep(5000); } }
public DoctorsController(MsSqlService service) { _service = service; }
private void cbDatabase_DropDownOpened(object sender, EventArgs e) { cbDatabase.ItemsSource = new List <string> { "<Loading databases>" }; var sel = Enum.Parse <ConnectionProvider>(cbProvider.SelectedItem.ToString()); try { switch (sel) { case ConnectionProvider.MsSql: var conInfo = new MsSqlConnectionInfo { Server = txtServer.Text, Port = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text), TrustedConnection = chkIntegratedSecurity.IsChecked.Value, Username = txtUsername.Text, Password = txtPassword.Password }; var mssql = new MsSqlService(); cbDatabase.ItemsSource = mssql.LoadDatabase(conInfo); break; case ConnectionProvider.PostgreSql: var npgInfo = new NpgConnectionInfo { Server = txtServer.Text, Port = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text), TrustedConnection = chkIntegratedSecurity.IsChecked.Value, Username = txtUsername.Text, Password = txtPassword.Password }; var npgsql = new NpgService(); cbDatabase.ItemsSource = npgsql.LoadDatabase(npgInfo); break; case ConnectionProvider.MySql: if (chkIntegratedSecurity.IsChecked == true) { throw new InvalidOperationException("Integrated Security doesnt supported by MySql Server"); } var myInfo = new MySqlConnectionInfo { Server = txtServer.Text, Port = Convert.ToInt32(string.IsNullOrWhiteSpace(txtPort.Text) ? "-1" : txtPort.Text), Username = txtUsername.Text, Password = txtPassword.Password }; var mysql = new MySqlService(); cbDatabase.ItemsSource = mysql.LoadDatabase(myInfo); break; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }