public static Boolean TestAccount(DatabaseAccountToken token, Boolean testMapping = false)
{
try
{
Configuration configuration = new Configuration();
configuration.SetProperty(NHibernate.Cfg.Environment.ConnectionString, token.ConnectionString);
configuration.SetProperty(NHibernate.Cfg.Environment.ConnectionDriver, String.Format("NHibernate.Driver.{0}", token.DatabaseDriver));
configuration.SetProperty(NHibernate.Cfg.Environment.Dialect, String.Format("NHibernate.Dialect.{0}", token.DatabaseDialect));
if (testMapping)
{
configuration.AddXml(token.Mapping);
using (ISessionFactory sessionFactory = configuration.BuildSessionFactory())
{
using (ISession session = sessionFactory.OpenSession())
{
return(session.IsConnected);
}
}
}
else
{
using (ISessionFactory sessionFactory = configuration.BuildSessionFactory())
{
using (ISession session = sessionFactory.OpenSession())
{
return(session.IsConnected);
}
}
}
}
catch (Exception ex)
{
return(false);
}
}
public ISessionFactory GetSessionFactory(DatabaseAccountToken token)
{
ISessionFactory sessionFactory;
bool isSessionFactoryGot = sesionFactoryDictionary.TryGetValue(token.TokenId, out sessionFactory);
if (isSessionFactoryGot)
{
return sessionFactory;
}
else
{
if (token != null)
{
Add(token);
isSessionFactoryGot = sesionFactoryDictionary.TryGetValue(token.TokenId, out sessionFactory);
}
if (isSessionFactoryGot)
{
return sessionFactory;
}
else
{
throw new Exception("Can't create sessionFactory");
}
}
}
public static Boolean TestAccount(DatabaseAccountToken token, Boolean testMapping = false)
{
try
{
Configuration configuration = new Configuration();
configuration.SetProperty(NHibernate.Cfg.Environment.ConnectionString, token.ConnectionString);
configuration.SetProperty(NHibernate.Cfg.Environment.ConnectionDriver, String.Format("NHibernate.Driver.{0}", token.DatabaseDriver));
configuration.SetProperty(NHibernate.Cfg.Environment.Dialect, String.Format("NHibernate.Dialect.{0}", token.DatabaseDialect));
if (testMapping)
{
configuration.AddXml(token.Mapping);
using (ISessionFactory sessionFactory = configuration.BuildSessionFactory())
{
using (ISession session = sessionFactory.OpenSession())
{
return session.IsConnected;
}
}
}
else
{
using (ISessionFactory sessionFactory = configuration.BuildSessionFactory())
{
using (ISession session = sessionFactory.OpenSession())
{
return session.IsConnected;
}
}
}
}
catch (Exception ex)
{
return false;
}
}
public ISessionFactory GetSessionFactory(DatabaseAccountToken token)
{
ISessionFactory sessionFactory;
bool isSessionFactoryGot = sesionFactoryDictionary.TryGetValue(token.TokenId, out sessionFactory);
if (isSessionFactoryGot)
{
return(sessionFactory);
}
else
{
if (token != null)
{
Add(token);
isSessionFactoryGot = sesionFactoryDictionary.TryGetValue(token.TokenId, out sessionFactory);
}
if (isSessionFactoryGot)
{
return(sessionFactory);
}
else
{
throw new Exception("Can't create sessionFactory");
}
}
}
public IAccountToken Convert(Token token)
{
DatabaseAccountToken targetToken = new DatabaseAccountToken();
targetToken.TokenId = token.TokenId;
targetToken.TokenName = token.TokenName;
if (token.Tokens != null)
{
targetToken.Mapping = (from tok in token.Tokens
where tok.Key == "Mapping"
select tok.Value).SingleOrDefault();
targetToken.Password = (from tok in token.Tokens
where tok.Key == "Password"
select tok.Value).SingleOrDefault();
targetToken.ConnectionString = (from tok in token.Tokens
where tok.Key == "ConnectionString"
select tok.Value).SingleOrDefault();
targetToken.UserName = (from tok in token.Tokens
where tok.Key == "UserName"
select tok.Value).SingleOrDefault();
targetToken.DataSource = (from tok in token.Tokens
where tok.Key == "DataSource"
select tok.Value).SingleOrDefault();
String dialect = (from tok in token.Tokens
where tok.Key == "DatabaseDialect"
select tok.Value).SingleOrDefault();
DatabaseDialect dbDialect;
Enum.TryParse(dialect, out dbDialect);
targetToken.DatabaseDialect = dbDialect;
String Driver = (from tok in token.Tokens
where tok.Key == "DatabaseDriver"
select tok.Value).SingleOrDefault();
DatabaseDriver dbDriver;
Enum.TryParse(Driver, out dbDriver);
targetToken.DatabaseDriver = dbDriver;
}
return(targetToken);
}
public Token Convert(IAccountToken token)
{
Token targetToken = new Token();
DatabaseAccountToken paramToken = (DatabaseAccountToken)token;
targetToken.TokenId = paramToken.TokenId;
targetToken.TokenName = paramToken.TokenName;
targetToken.Tokens.Add("ConnectionString", paramToken.ConnectionString);
targetToken.Tokens.Add("UserName", paramToken.UserName);
targetToken.Tokens.Add("Password", paramToken.Password);
targetToken.Tokens.Add("DataSource", paramToken.DataSource);
targetToken.Tokens.Add("Mapping", paramToken.Mapping);
targetToken.Tokens.Add("DatabaseDriver", paramToken.DatabaseDriver.ToString());
targetToken.Tokens.Add("DatabaseDialect", paramToken.DatabaseDialect.ToString());
return(targetToken);
}
public IAccountSettings TestAccount(IAccountSettings accountnForTest)
{
DatabaseAccountSettings accountForTestDB = (DatabaseAccountSettings)accountnForTest;
DatabaseAccountToken tokenForTest = accountForTestDB.Tokens.FirstOrDefault();
Boolean result = false;
if (tokenForTest != null)
{
if (tokenForTest.Mapping == null)
{
result = ClientNHibernateSessionFactory.TestAccount(tokenForTest);
}
else
{
result = ClientNHibernateSessionFactory.TestAccount(tokenForTest, true);
}
}
accountForTestDB.TestResult = result;
return(accountForTestDB);
}
public IAccountSettings Convert(ServiceAccount serviceAccount)
{
DatabaseAccountSettings target = new DatabaseAccountSettings();
target.ID = serviceAccount.ServiceAccountId;
target.Name = serviceAccount.ServiceAccountName;
target.Source = serviceAccount.Source;
target.MinUpdateTime = serviceAccount.MinUpdateTime * 60000;
target.AccountVersion = serviceAccount.AccountVersion;
target.Tokens = new List<DatabaseAccountToken>();
if (serviceAccount.Tokens.Count > 0)
{
foreach (Token token in serviceAccount.Tokens)
{
DatabaseAccountToken targetToken = new DatabaseAccountToken();
targetToken = (DatabaseAccountToken)targetToken.Convert(token);
target.Tokens.Add(targetToken);
}
}
return target;
}
public IAccountSettings Convert(ServiceAccount serviceAccount)
{
DatabaseAccountSettings target = new DatabaseAccountSettings();
target.ID = serviceAccount.ServiceAccountId;
target.Name = serviceAccount.ServiceAccountName;
target.Source = serviceAccount.Source;
target.MinUpdateTime = serviceAccount.MinUpdateTime * 60000;
target.AccountVersion = serviceAccount.AccountVersion;
target.Tokens = new List <DatabaseAccountToken>();
if (serviceAccount.Tokens.Count > 0)
{
foreach (Token token in serviceAccount.Tokens)
{
DatabaseAccountToken targetToken = new DatabaseAccountToken();
targetToken = (DatabaseAccountToken)targetToken.Convert(token);
target.Tokens.Add(targetToken);
}
}
return(target);
}
public void Add(DatabaseAccountToken configFile)
{
try
{
if (sesionFactoryDictionary.ContainsKey(configFile.TokenId))
{
return;
}
else
{
Configuration configuration = new Configuration();
configuration.SetProperty(NHibernate.Cfg.Environment.ConnectionString, configFile.ConnectionString);
configuration.SetProperty(NHibernate.Cfg.Environment.ConnectionDriver, String.Format("NHibernate.Driver.{0}", configFile.DatabaseDriver));
configuration.SetProperty(NHibernate.Cfg.Environment.Dialect, String.Format("NHibernate.Dialect.{0}", configFile.DatabaseDialect));
configuration.AddXml(configFile.Mapping);
sesionFactoryDictionary.Add(configFile.TokenId, configuration.BuildSessionFactory());
}
}
catch (Exception ex)
{
log.Error("Can't create sessionFactory", ex);
}
}
public void Add(DatabaseAccountToken configFile)
{
try
{
if (sesionFactoryDictionary.ContainsKey(configFile.TokenId))
{
return;
}
else
{
Configuration configuration = new Configuration();
configuration.SetProperty(NHibernate.Cfg.Environment.ConnectionString, configFile.ConnectionString);
configuration.SetProperty(NHibernate.Cfg.Environment.ConnectionDriver, String.Format("NHibernate.Driver.{0}", configFile.DatabaseDriver));
configuration.SetProperty(NHibernate.Cfg.Environment.Dialect, String.Format("NHibernate.Dialect.{0}", configFile.DatabaseDialect));
configuration.AddXml(configFile.Mapping);
sesionFactoryDictionary.Add(configFile.TokenId, configuration.BuildSessionFactory());
}
}
catch (Exception ex)
{
log.Error("Can't create sessionFactory", ex);
}
}
public IAccountToken Convert(Token token)
{
DatabaseAccountToken targetToken = new DatabaseAccountToken();
targetToken.TokenId = token.TokenId;
targetToken.TokenName = token.TokenName;
if (token.Tokens != null)
{
targetToken.Mapping = (from tok in token.Tokens
where tok.Key == "Mapping"
select tok.Value).SingleOrDefault();
targetToken.Password = (from tok in token.Tokens
where tok.Key == "Password"
select tok.Value).SingleOrDefault();
targetToken.ConnectionString = (from tok in token.Tokens
where tok.Key == "ConnectionString"
select tok.Value).SingleOrDefault();
targetToken.UserName = (from tok in token.Tokens
where tok.Key == "UserName"
select tok.Value).SingleOrDefault();
targetToken.DataSource = (from tok in token.Tokens
where tok.Key == "DataSource"
select tok.Value).SingleOrDefault();
String dialect = (from tok in token.Tokens
where tok.Key == "DatabaseDialect"
select tok.Value).SingleOrDefault();
DatabaseDialect dbDialect;
Enum.TryParse(dialect, out dbDialect);
targetToken.DatabaseDialect = dbDialect;
String Driver = (from tok in token.Tokens
where tok.Key == "DatabaseDriver"
select tok.Value).SingleOrDefault();
DatabaseDriver dbDriver;
Enum.TryParse(Driver, out dbDriver);
targetToken.DatabaseDriver = dbDriver;
}
return targetToken;
}
