private static void SaveAuthModelInDB(InstallerDatas install) { //string nonQuery = @"insert into web_api_credentials (client_id,client_secret,access_token,refresh_token,redirect_url,server_url) values // ('{0}','{1}','{2}','{3}','{4}','{5}')"; //SqlCommand command = new SqlCommand(String.Format(nonQuery, authParams.ClientId, authParams.ClientSecret, // authParams.authModel.AccessToken, authParams.authModel.RefreshToken, authParams.RedirectUrl, authParams.ServerUrl)); DBContextFactory.SetConnection(install.ConnectionString); string nonQuery = @"insert into web_api_credentials (clientName,publicToken,secretToken,storeaddress) values ('{0}','{1}','{2}','{3}')"; SqlCommand command = new SqlCommand(String.Format(nonQuery, install.authParameters.ClientName, install.authParameters.PublicToken, install.authParameters.SecretToken, install.authParameters.StoreAddress)); DBContextFactory.DBContext.BeginTransaction(); int result = DBContextFactory.DBContext.NonQuery(command); if (result < 0) { DBContextFactory.DBContext.RollbackTransaction(); } else { DBContextFactory.DBContext.CommitTransaction(); } }
public static DataSettings DatabaseIsInstalled() { var settings = DatabaseManager.LoadSettings(); if (settings != null && !String.IsNullOrEmpty(settings.DataConnectionString)) { DBContextFactory.SetConnection(settings.DataConnectionString); } return(settings); }
public static bool CheckTableExistence(string connectionString, string tableName) { bool exists; try { exists = true; DBContextFactory.SetConnection(connectionString); DBContextFactory.DBContext.OpenConnection(); DBContextFactory.DBContext.NonQuery("select 1 from " + tableName + " where 1 = 0"); DBContextFactory.DBContext.CloseConnection(); } catch (Exception e) { exists = false; DBContextFactory.DBContext.CloseConnection(); } return(exists); }
public Syncer() { dataSettings = DatabaseManager.LoadSettings(); if (String.IsNullOrWhiteSpace(DBContextFactory.ConnectionString)) { DBContextFactory.SetConnection(dataSettings.DataConnectionString); } if (dbContext == null) { dbContext = DBContextFactory.DBContext; } if (textInfo == null) { textInfo = new CultureInfo("fr-FR", false).TextInfo; } if (OptionsMercator == null) { OptionsMercator = new OptionsMercator(); } }