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();
}
}
