private void save_config_button_Click(object sender, EventArgs e) { toolstripStatusLabelValue = "Try to save configuration ..."; #region Loki - Create MySQL Connection String var sb = new MySqlConnectionStringBuilder(); //Host if (String.IsNullOrEmpty(mysql_host_textbox.Text)) { addWrongValueErrorHandler(mysql_host_textbox, "The value of \"Server Address\" in \"MySQL Database settings\" is not set."); return; } sb.Server = mysql_host_textbox.Text; //Port if (String.IsNullOrEmpty(mysql_port_textbox.Text)) { addWrongValueErrorHandler(mysql_port_textbox, "The value of \"Port\" in \"MySQL Database settings\" is not allowed."); return; } sb.Port = Convert.ToUInt16(mysql_port_textbox.Text); //Database Name if (String.IsNullOrEmpty(mysql_database_name_textbox.Text)) { addWrongValueErrorHandler(mysql_database_name_textbox, "The value of \"Database Name\" in \"MySQL Database settings\" is not set."); return; } sb.Database = mysql_database_name_textbox.Text; //Username if (String.IsNullOrEmpty(mysql_username_textbox.Text)) { addWrongValueErrorHandler(mysql_username_textbox, "The value of \"Username\" in \"MySQL Database settings\" is not set."); return; } sb.UserID = mysql_username_textbox.Text; //Password sb.Password = mysql_password_textbox.Text; //Treat tiny as boolean sb.TreatTinyAsBoolean = false; //Set generated connection string var t = sb.ConnectionString; //Just for fun: Test the connection // mysql_test_button_Click(null, null); #endregion ConnectionStringService.SetString(sb.UserID, sb.Password, sb.Server, sb.Database, sb.Port); Close(); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddMvc(); services.AddScoped <FileStore, FileStore>(); services.AddScoped <SearchSQLProductService, SearchSQLProductService>(); services.AddScoped <SearchBlobService, SearchBlobService>(); services.AddScoped <ConnectionStringService, ConnectionStringService>(); var csService = ConnectionStringService.GetInstanceAsync().Result; services.AddSingleton <ConnectionStringService>(csService); //var connection = @"Server=mysqlvmlabel.westeurope.cloudapp.azure.com,1433;Database=AdventureWorks2012;user id=volha_viktarava;password=123456qwerty!@;Trusted_Connection=True;ConnectRetryCount=0"; //var connection = @"data source=mysqlvmlabel.westeurope.cloudapp.azure.com,1433;initial catalog=AdventureWorks2012;integrated security=false;user id=volha_viktarava;password=123456qwerty!@;MultipleActiveResultSets=True;"; //var connection = // @"data source=localhost;initial catalog = AdventureWorks2012; persist security info = True;Integrated Security = SSPI;"; // personal subscription //var connection = // @"Server= adventureworks2server.database.windows.net,1433;Initial Catalog=AdventureWorks2;Persist Security Info=False;User ID=volha_viktarava;Password=123456qwerty!@;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; //// epam subscription //var connection = // @"Server=tcp:adventureworksserver12.database.windows.net,1433;Initial Catalog=AdventureWorks;Persist Security Info=False;User ID=volha_viktarava;Password=123456qwerty!@;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; //var conn = // @"Server=tcp:adventure-worksserver.database.windows.net,1433;Initial Catalog=AdventureWorks;Persist Security Info=False;User ID=volha-viktarava;Password=123456qwerty!@;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; services.AddDbContext <AdventureWorksDbContext>(options => options.UseSqlServer(csService.Message)); services.AddSwaggerGen(c => c.SwaggerDoc("v1", new Info { Title = "My API", Version = "v1" })); }
private string GetConnectionString(string odsConnectionStringTemplate, string odsInstanceName, ApiMode apiMode) { var mockConnectionStringBuilderAdapterFactory = new Mock <IConnectionStringBuilderAdapterFactory>(); mockConnectionStringBuilderAdapterFactory.Setup(x => x.Get()).Returns(new SqlConnectionStringBuilderAdapter()); var service = new ConnectionStringService(GetConnectionStringsAccessor(odsConnectionStringTemplate), mockConnectionStringBuilderAdapterFactory.Object); return(service.GetConnectionString(odsInstanceName, apiMode)); }
public RegistrationTests(DatabaseFixture fixture) { this.connectionStringService = new ConnectionStringService(ConnectionString.Value); this.fixture = fixture; UserHelper.CleanByUserName(RegistrationTestUser1); UserHelper.CleanByUserName(RegistrationTestUser2); this.connectionForTest = new NpgsqlConnection(ConnectionString.Value); }
public void TestUpdatePassword() { ConnectionStringService connectionStringService = new ConnectionStringService(ConnectionString.Value); SecurityService securityService = new SecurityService(); UserService userService = new UserService(connectionStringService, securityService, IOptionsHelper.Get()); var response = userService.UpdatePassword("992296994", securityService.HashUserNameAndPassword("992296994", "Deeps@123")); Assert.True(response.IsSuccess); }
private bool ProbeSpectrumDatabase() { string spectrumDatabaseString = ConnectionStringService.GetConnectionString("Spectrum"); SQLControl sql = new SQLControl(spectrumDatabaseString); //sql.AddParam("@jobNumber", _jobNumber); //sql.AddParam("@costType", "L"); sql.ExecQuery("SELECT * FROM JC_TRANSACTION_HISTORY_MC WHERE Job_Number = ' 2190302'"); if (sql.HasException()) { return(false); } else { return(true); } }
public void TestAuthenticate() { ConnectionStringService connectionStringService = new ConnectionStringService(ConnectionString.Value); SecurityService securityService = new SecurityService(); UserService userService = new UserService(connectionStringService, securityService, IOptionsHelper.Get()); var response = userService.Authenticate("mladmin", "ML@Vkt0rY"); Assert.True(response.IsSuccess); Assert.NotNull(response.Data); Assert.NotNull(response.Data.user.token); Assert.True(response.Data.user.token.Length > 0); //no need to test the saved user //var savedUser = userService.Get(user.id); //Assert.Equal(savedUser.token, user.token); }
/// <summary> /// Returns true if the job number is found in the estimating database. Only one estimate record is allowed per job number. /// </summary> /// <param name="jobNumber"></param> /// <returns></returns> public bool IsDuplicateJobNumber(string jobNumber) { using (SQLControl sql = new SQLControl(ConnectionStringService.GetConnectionString("Estimate"))) { sql.AddParam("@jobNumber", jobNumber); sql.ExecQuery("SELECT * FROM EstimateHeader WHERE JobNumber = @jobNumber"); if (sql.HasException()) { throw new Exception("Error in SQLControl class while attempting to detect duplicate job numbers."); } if (sql.DBDT.Rows.Count == 0) { return(false); } else { return(true); } }; }