/// <summary>
/// Method to read configurations and register services
/// </summary>
private static void Startup()
{
var configurationBuilder = new ConfigurationBuilder()
.AddJsonFile("appsettings.json");
IConfiguration configs = configurationBuilder.Build();
// Bind configurations to models
UserDetailsConfiguration userDetailsConfiguration = configs.GetSection("UserDetailsConfiguration").Get <UserDetailsConfiguration>();
ConsoleText consoleTexts = configs.GetSection("ConsoleTexts").Get <ConsoleText>();
ConnectionStringInfo connectionStringInfo = configs.GetSection("ConnectionStringInfo").Get <ConnectionStringInfo>();
var services = new ServiceCollection();
// Singleton services and objects
services.AddSingleton(s => connectionStringInfo);
services.AddSingleton <IFileService, FileService>();
services.AddSingleton <ITextLineUtilityService, TextLineUtilityService>();
services.AddSingleton(userDetailsConfiguration);
services.AddSingleton(consoleTexts);
// Transient services
services.AddTransient <IApplication, Application>();
// Scoped services;
services.AddScoped <IUserDetailsService, UserDetailsService>();
services.AddScoped <IBlobServiceFactory, BlobServiceFactory>();
_serviceProvider = services.BuildServiceProvider(true);
}
public RestaurantUnitOfWork(string connectionString = null)
{
if (connectionString == null)
{
_context = new RestaurantContext(ConnectionStringInfo.Get());
}
else
{
_context = new RestaurantContext(connectionString);
}
UrunDal = new UrunDal(_context);
TanimDal = new TanimDal(_context);
PorsiyonDal = new PorsiyonDal(_context);
EkMalzemeDal = new EkMalzemeDal(_context);
MusteriDal = new MusteriDal(_context);
TelefonDal = new TelefonDal(_context);
AdresDal = new AdresDal(_context);
AdisyonDal = new AdisyonDal(_context);
EkMalzemeHareketDal = new EkMalzemeHareketDal(_context);
GarsonDal = new GarsonDal(_context);
MasaDal = new MasaDal(_context);
UrunHareketDal = new UrunHareketDal(_context);
OdemeTuruDal = new OdemeTuruDal(_context);
OdemeHareketDal = new OdemeHareketDal(_context);
UrunNotDal = new UrunNotDal(_context);
}
public void TestDecompositionToString()
{
string cnn = "Data Source=theMachine,1434;Initial Catalog=version3;User id=sa;Password=polux;Pooling=False";
ConnectionStringInfo info = new ConnectionStringInfo(cnn);
string res = info.ToString();
AssertAreEqual(res, "Serveur = theMachine,1434; Base = version3", "Base");
}
public void Create_ConnectionStringInfo()
{
var test = new ConnectionStringInfo(false, @"c:\test\temp.db3");
Assert.False(test.IsInMemory);
Assert.Equal(@"c:\test\temp.db3", test.FileName);
Assert.True(test.IsValid);
}
public SqlMonitor(string tableName, Expression <Func <T, bool> > filter = null, DmlTriggerType monitorType = DmlTriggerType.All)
{
tableDependency = new SqlTableDependency <T>(ConnectionStringInfo.Get(), tableName, filter: new SqlTableDependencyFilter <T>(filter), notifyOn: monitorType);
tableDependency.Stop();
tableDependency.OnChanged += Changed;
tableDependency.OnError += Error;
tableDependency.Start();
}
public FrmAnaMenu()
{
InitializeComponent();
DevExpress.LookAndFeel.UserLookAndFeel.Default.SkinName = "Dark Side";
if (!ConnectionStringInfo.Check())
{
FrmSetupConnection form = new FrmSetupConnection();
form.ShowDialog();
}
}
public EditConnectionStringWindowSavedEventArgs(String name, String connectionString, Int32 timeZone)
{
var ci = new ConnectionStringInfo();
ci.Name = name;
ci.ConnectionString = connectionString;
if (String.IsNullOrEmpty(ci.Name) == true)
{
ci.Name = ci.ConnectionString;
}
ci.TimeZone = timeZone;
this.ConnectionStringInfo = ci;
}
public void TestDecompositionPort()
{
string cnn = "Data Source=theMachine,1434;Initial Catalog=version_db3;User id=sa;Password=polux;Pooling=False";
ConnectionStringInfo info = new ConnectionStringInfo(cnn);
AssertAreEqual(info.Base, "version_db3", "Base");
AssertAreEqual(info.Serveur, "theMachine,1434", "Serveur");
AssertAreEqual(info.Port, "1434", "Port du serveur");
AssertAreEqual(info.ServeurOnly, "theMachine", "ServeurOnly");
AssertAreEqual(info.IntegratedSecurity, false, "Sécurité intégrée");
AssertAreEqual(info.User, "sa", "User");
AssertAreEqual(info.Pass, "polux", "Mot de passe");
}
public void TestDecompositionSSPI()
{
string cnn = "Data Source=localhost;Initial Catalog=version_db3;integrated Security=SSPI;Pooling=False";
ConnectionStringInfo info = new ConnectionStringInfo(cnn);
AssertAreEqual(info.Base, "version_db3", "Base");
AssertAreEqual(info.Serveur, "localhost", "Serveur");
AssertAreEqual(info.Port, "[default]", "Port du serveur");
AssertAreEqual(info.ServeurOnly, "localhost", "ServeurOnly");
AssertAreEqual(info.IntegratedSecurity, true, "Sécurité intégrée");
AssertAreEqual(info.User, string.Empty, "User");
AssertAreEqual(info.Pass, string.Empty, "Mot de passe");
}
public void TestGetSqlCmdParam()
{
string cnn = "Data Source=theMachine,1434;Initial Catalog=version;User id=sa;Password=polux;Pooling=False";
ConnectionStringInfo info = new ConnectionStringInfo(cnn);
string res = info.GetSqlCmdParam();
AssertAreEqual(res, " -S \"theMachine,1434\" -d \"version\" -U \"sa\" -P \"polux\"", "GetSqlCmdParam");
cnn = "Data Source=theMachine,1434;Initial Catalog=version;integrated Security=SSPI;Pooling=False";
info = new ConnectionStringInfo(cnn);
res = info.GetSqlCmdParam();
AssertAreEqual(res, " -S \"theMachine,1434\" -d \"version\" -E", "GetSqlCmdParam");
}
public void TestConnectionOk()
{
using (ConnectionParam cnn = new ConnectionParam(myconnectionString))
{
AssertAreEqual(cnn.ConnexionString, myconnectionString, "La chaine de connexion");
AssertAreEqual(cnn.TimeOut, 0, "Le timeOut");
AssertAreEqual(cnn.Connection, null, "La connexion");
AssertAreEqual(cnn.Transaction, null, "La transaction");
ConnectionStringInfo infos = new ConnectionStringInfo(myconnectionString);
AssertAreEqual(cnn.Infos().ToString(), infos.ToString(), "COnnexion info");
}
}
void InitializeConnectionStringDesignTimeValues()
{
Debug.Assert(toConnectionStringInfo == null);
if (toConnectionStringInfo != null)
{
return;
}
toConnectionStringInfo = new Dictionary <string, ConnectionStringInfo>(StringComparer.Ordinal);
var configFile = type.Module.Location + ".config";
if (!File.Exists(configFile))
{
return;
}
try {
var doc = XDocument.Load(configFile, LoadOptions.None);
var prefix = type.ReflectionFullName + ".";
foreach (var e in doc.XPathSelectElements("/configuration/connectionStrings/add"))
{
var name = (string)e.Attribute("name");
if (name == null || !name.StartsWith(prefix, StringComparison.Ordinal))
{
continue;
}
var connectionString = (string)e.Attribute("connectionString");
var providerName = (string)e.Attribute("providerName");
if (connectionString == null || providerName == null)
{
continue;
}
var info = new ConnectionStringInfo {
String = connectionString,
ProviderName = providerName,
};
var propName = name.Substring(prefix.Length);
if (!toConnectionStringInfo.ContainsKey(propName))
{
toConnectionStringInfo[propName] = info;
}
}
}
catch {
}
}
// Read all connection strings found in the App.config
private void ReadAllConnectionStrings()
{
_connectionStringInfos = new List <ConnectionStringInfo>();
var connectionStringSettings = ConfigurationManager.ConnectionStrings;
if (connectionStringSettings != null)
{
foreach (ConnectionStringSettings setting in connectionStringSettings)
{
string providerName = setting.ProviderName;
var serverType = DbServerType.MsSql;
bool validProviderFound = false;
if (!string.IsNullOrEmpty(providerName))
{
if (string.Compare(providerName, DbServerProviderName.MsSql, StringComparison.CurrentCultureIgnoreCase) == 0)
{
serverType = DbServerType.MsSql;
validProviderFound = true;
}
else if (string.Compare(providerName, DbServerProviderName.Sqlite, StringComparison.CurrentCultureIgnoreCase) == 0)
{
serverType = DbServerType.Sqlite;
validProviderFound = true;
}
else if (string.Compare(providerName, DbServerProviderName.MySql, StringComparison.CurrentCultureIgnoreCase) == 0)
{
serverType = DbServerType.MySql;
validProviderFound = true;
}
else if (string.Compare(providerName, DbServerProviderName.Postgres, StringComparison.CurrentCultureIgnoreCase) == 0)
{
serverType = DbServerType.Postgres;
validProviderFound = true;
}
}
if (validProviderFound)
{
var connectionStringInfo = new ConnectionStringInfo();
connectionStringInfo.DbServerType = serverType;
connectionStringInfo.Name = setting.Name;
connectionStringInfo.ProviderName = providerName;
connectionStringInfo.ConnectionString = setting.ConnectionString;
_connectionStringInfos.Add(connectionStringInfo);
}
}
}
}
public EditConnectionStringWindow(ConnectionStringInfo info)
{
InitializeComponent();
for (int i = 0; i < 24; i++)
{
this.TimeZoneComboBox.Items.Add(i - 11);
}
if (info != null)
{
this.NameTextBox.Text = info.Name;
this.ConnectionStringTextBox.Text = info.ConnectionString;
this.TimeZoneComboBox.SelectedValue = info.TimeZone;
}
AValue.ConfigData.EditConnectionStringWindow.Initialize(this);
}
//private IDbTransaction _transaction;
public BaseRepository(string dbName)
{
_entityInfo = EntityInfo <TEntity> .Create();
if (dbName.IsEmpty())
{
throw new Exception(nameof(dbName));
}
_connectionInfo = ConnectionStringInfo.GetConnectionByName(dbName);
if (_connectionInfo == null)
{
throw new Exception("Can not get connection info");
}
_connection = new MySqlConnection(_connectionInfo.Value);
_connection.EnsureOpen();
//_transaction = _connection.BeginTransaction();
}
private void WriteInTextBoxes(string connectionString)
{
ConnectionStringInfo conString = new ConnectionStringInfo(connectionString);
txtDataSource.Text = conString.DataSource;
txtInitialCatalog.Text = conString.InitialCatalog;
if (conString.IntegratedSecurity)
{
ctlIntegratedSecurity.SelectedIndex = 1;
txtUserID.Text = "";
txtPassword.Text = "";
}
else
{
ctlIntegratedSecurity.SelectedIndex = 0;
txtUserID.Text = conString.UserID;
txtPassword.Text = conString.Password;
}
}
public static void InitTest()
{
var _connectionInfo = ConnectionStringInfo.GetConnectionByName("db_kinta");
if (_connectionInfo == null)
{
throw new Exception("Can not get connection info");
}
var con = new MySqlConnection(_connectionInfo.Value);
con.EnsureOpen();
using (con)
{
using (var ts = con.BeginTransaction())
{
}
}
//con.state = close after run out of using
}
public void TestLaunchISQL()
{
if (this.activeLaunchISQL)
{
string cnn = "Data Source=localhost;Initial Catalog=version_db3;integrated Security=SSPI;Pooling=False";
ConnectionStringInfo info = new ConnectionStringInfo(cnn);
string res = info.LaunchIsql(string.Empty, null);
AssertAreEqual(res, "Chemin d'accès non configuré", "GetSqlCmdParam Vide");
res = info.LaunchIsql("ssms.exe", null);
AssertAreEqual(res, string.Empty, "GetSqlCmdParam environnement vide");
res = info.LaunchIsql("ssms.exe", @"C:\Projets\BaseSaverSolution\BaseSaverTest\Demo.sql");
AssertAreEqual(res, string.Empty, "GetSqlCmdParam avec fichier Demo ouvert");
res = info.LaunchIsql("sqlwb.exe", @"C:\Projets\BaseSaverSolution\BaseSaverTest\Demo.sql");
AssertAreEqual(res, "Le fichier spécifié est introuvable", "GetSqlCmdParam avec sqlWb");
res = info.LaunchIsql("isql.exe", @"C:\Projets\BaseSaverSolution\BaseSaverTest\Demo.sql");
AssertAreEqual(res, "Le fichier spécifié est introuvable", "GetSqlCmdParam avec sqlWb");
}
}
public void TestDecompositionKo()
{
string cnn = "Data Source=localhost;Initial Catalog=version";
ConnectionStringInfo info = new ConnectionStringInfo(cnn);
AssertAreEqual(info.Base, "version", "Base");
AssertAreEqual(info.Serveur, "localhost", "Serveur");
AssertAreEqual(info.Port, "[default]", "Port du serveur");
AssertAreEqual(info.ServeurOnly, "localhost", "ServeurOnly");
AssertAreEqual(info.IntegratedSecurity, false, "Sécurité intégrée");
AssertAreEqual(info.User, string.Empty, "User");
AssertAreEqual(info.Pass, string.Empty, "Mot de passe");
cnn = "bonjour; les gens;";
info = new ConnectionStringInfo(cnn);
AssertAreEqual(info.Base, string.Empty, "Base");
AssertAreEqual(info.Serveur, string.Empty, "Serveur");
AssertAreEqual(info.Port, string.Empty, "Port du serveur");
AssertAreEqual(info.ServeurOnly, string.Empty, "ServeurOnly");
AssertAreEqual(info.IntegratedSecurity, false, "Sécurité intégrée");
AssertAreEqual(info.User, string.Empty, "User");
AssertAreEqual(info.Pass, string.Empty, "Mot de passe");
}
void InitializeConnectionStringDesignTimeValues() {
Debug.Assert(toConnectionStringInfo == null);
if (toConnectionStringInfo != null)
return;
toConnectionStringInfo = new Dictionary<string, ConnectionStringInfo>(StringComparer.Ordinal);
var configFile = type.Module.Location + ".config";
if (!File.Exists(configFile))
return;
try {
var doc = XDocument.Load(configFile, LoadOptions.None);
var prefix = type.ReflectionFullName + ".";
foreach (var e in doc.XPathSelectElements("/configuration/connectionStrings/add")) {
var name = (string)e.Attribute("name");
if (name == null || !name.StartsWith(prefix, StringComparison.Ordinal))
continue;
var connectionString = (string)e.Attribute("connectionString");
var providerName = (string)e.Attribute("providerName");
if (connectionString == null || providerName == null)
continue;
var info = new ConnectionStringInfo {
String = connectionString,
ProviderName = providerName,
};
var propName = name.Substring(prefix.Length);
if (!toConnectionStringInfo.ContainsKey(propName))
toConnectionStringInfo[propName] = info;
}
}
catch {
}
}
// private readonly URLInfo _urlInfo;
public BlobServiceFactory(ConnectionStringInfo connectionStringInfo)
{
_connectionStringInfo = connectionStringInfo;
// _urlInfo = urlInfo;
}
public void GetAndSetSensitiveSiteConfigs()
{
RunWebsiteTestScenario(
(siteName, resourceGroupName, whpName, locationName, webSitesClient, resourcesClient) =>
{
#region Get/Set Application settings
const string settingName = "Application Setting1", settingValue = "Setting Value 1";
var appSetting = new NameValuePair()
{
Name = settingName, Value = settingValue
};
var appSettingsResponse = webSitesClient.WebSites.UpdateAppSettings(
resourceGroupName,
siteName,
null,
new WebSiteNameValueParameters(new List <NameValuePair>()
{
appSetting
}, locationName));
Assert.NotNull(appSettingsResponse.Resource);
Assert.NotNull(appSettingsResponse.Resource.Properties);
var appSettings = appSettingsResponse.Resource.Properties;
Assert.Single(appSettings.Where(a => a.Name == settingName && a.Value == settingValue));
appSettingsResponse = webSitesClient.WebSites.GetAppSettings(resourceGroupName,
siteName, null);
Assert.NotNull(appSettingsResponse.Resource);
Assert.NotNull(appSettingsResponse.Resource.Properties);
appSettings = appSettingsResponse.Resource.Properties;
Assert.Single(appSettings.Where(a => a.Name == settingName && a.Value == settingValue));
#endregion Get/Set Application settings
#region Get/Set Metadata
const string metadataName = "Metadata 1", metadataValue = "Metadata Value 1";
var metadata = new NameValuePair()
{
Name = metadataName, Value = metadataValue
};
var metadataResponse = webSitesClient.WebSites.UpdateMetadata(
resourceGroupName,
siteName,
null,
new WebSiteNameValueParameters()
{
Location = locationName,
Properties = new List <NameValuePair> {
metadata
}
});
Assert.NotNull(metadataResponse.Resource);
Assert.NotNull(metadataResponse.Resource.Properties);
var metadatas = metadataResponse.Resource.Properties;
Assert.Single(metadatas.Where(m => m.Name == metadataName && m.Value == metadataValue));
metadataResponse = webSitesClient.WebSites.GetMetadata(resourceGroupName,
siteName, null);
Assert.NotNull(metadataResponse.Resource);
Assert.NotNull(metadataResponse.Resource.Properties);
metadatas = metadataResponse.Resource.Properties;
Assert.Single(metadatas.Where(m => m.Name == metadataName && m.Value == metadataValue));
#endregion Get/Set Metadata
#region Get/Set Connection strings
const string connectionString = "ConnectionString 1", connectionStringValue = "ConnectionString Value 1";
var connectionStringInfo = new ConnectionStringInfo()
{
ConnectionString = connectionString,
Name = connectionStringValue,
Type = DatabaseServerType.MySql
};
var connectionStringResponse = webSitesClient.WebSites.UpdateConnectionStrings(
resourceGroupName,
siteName,
null,
new WebSiteUpdateConnectionStringsParameters()
{
Location = locationName,
Properties = new List <ConnectionStringInfo>()
{
{ connectionStringInfo }
}
});
Assert.NotNull(connectionStringResponse);
Assert.NotNull(connectionStringResponse.Resource.Properties);
var connectionStrings = connectionStringResponse.Resource.Properties;
Assert.Single(connectionStrings.Where(c => c.Name == connectionStringInfo.Name && c.ConnectionString == connectionStringInfo.ConnectionString && c.Type == connectionStringInfo.Type));
connectionStringResponse = webSitesClient.WebSites.GetConnectionStrings(resourceGroupName,
siteName, null);
Assert.NotNull(connectionStringResponse);
Assert.NotNull(connectionStringResponse.Resource.Properties);
connectionStrings = connectionStringResponse.Resource.Properties;
Assert.Single(connectionStrings.Where(c => c.Name == connectionStringInfo.Name && c.ConnectionString == connectionStringInfo.ConnectionString && c.Type == connectionStringInfo.Type));
#endregion Get/Set Connection strings
#region Get Publishing credentials
var credentialsResponse = webSitesClient.WebSites.GetPublishingCredentials(resourceGroupName, siteName, null);
Assert.NotNull(credentialsResponse.Resource);
Assert.NotNull(credentialsResponse.Resource.Properties);
Assert.Equal("$" + siteName, credentialsResponse.Resource.Properties.PublishingUserName);
Assert.NotNull(credentialsResponse.Resource.Properties.PublishingPassword);
#endregion Get Publishing credentials
#region Get Publishing profile XML
var publishingProfileResponse = webSitesClient.WebSites.GetPublishProfile(resourceGroupName, siteName, null);
Assert.NotEmpty(publishingProfileResponse.PublishProfiles);
#endregion Get Publishing profile XML
webSitesClient.WebSites.Delete(resourceGroupName, siteName, null, new WebSiteDeleteParameters()
{
DeleteAllSlots = true,
DeleteMetrics = true
});
webSitesClient.WebHostingPlans.Delete(resourceGroupName, whpName);
});
}
public void Create_InMemoryIsValid()
{
var test = new ConnectionStringInfo(true, string.Empty);
Assert.True(test.IsValid);
}
