public void Initialise(string connect)
{
m_log.InfoFormat("[NHIBERNATE] Initializing NHibernateRexLegacyData");
Assembly assembly = GetType().Assembly;
manager = new NHibernateManager(connect, "RexLegacyData", assembly);
Inizialized = true;
}
static void Main(string[] args)
{
NHibernateManager.Initialize(ShowSql.FormattedSql);
NHibernateManager.UpdateSchema();
//NHibernateManager.CreateSchema();
//NHibernateManager.GenerateScriptFile("C:\\scripts", true);
//NHibernateManager.DropSchema();
}
public void ValidateCredentials()
{
using (ISession session = NHibernateManager.OpenSession())
{
MailAccount correctMailAccount = MailAccount.FindByAddress(this.Entity.Address, session, false);
if (!CryptoHelper.PasswordsMatch(correctMailAccount.Entity.Password, this.Entity.Password))
{
throw new InvalidAuthenticationException("Las credenciales ingresadas no son validas, usuario:" + this.Entity.Address);
}
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
VariablesAplicacion.LoadOnInit();
Menu.CreateRolesMenu();
NHibernateManager.GetInstance().CerrarSessionInicioAplicacion();
CustomModelBindersConfig.RegisterCustomModelBinders();
}
/// <summary>
/// 创建工厂实例
/// </summary>
/// <param name="dataManager">数据管理者</param>
/// <returns>数据接口</returns>
public static IData Create(string dataManager)
{
IData data;
switch (dataManager.ToLower())
{
case "nhibernate":
data = new NHibernateManager();
break;
default:
throw new DataException("没有具体的数据管理者！");
}
return data;
}
private static void Save(List <Mail> mails)
{
ISession session = NHibernateManager.OpenSession();
ITransaction tran = session.BeginTransaction();
foreach (Mail mailToSave in mails)
{
Address newAddress = new Address(mailToSave.Entity.From);
newAddress.SaveOrUpdate(session); //si fija si ya existe adentro
mailToSave.SetFrom(newAddress.Entity);
session.SaveOrUpdate(mailToSave.Entity);
}
tran.Commit();
session.Flush();
session.Close();
}
private static void ToLightweightAgentStatus <T>(string sqlStatement, Action <IAgentStatus> loopingDelegate, Func <T> newInstance) where T : IAgentStatus
{
var reader = NHibernateManager.ExecuteReader(sqlStatement);
while (reader.Read())
{
var time = reader.GetDateTime(0);
var extNo = reader.GetString(1);
var agentAcdid = reader.GetString(2);
var option = reader[3];
//loopingDelegate(new T().SetProperties(time, extNo, agentAcdid, option)); old
loopingDelegate(newInstance().SetProperties(time, extNo, agentAcdid, option));
}
NHibernateManager.CloseReader(reader);
}
public MailAccount Clone()
{
MailAccount mailAccountClone;
MailAccountEntity entity;
using (ISession session = NHibernateManager.OpenSession())
{
entity = MailAccount.FindByAddress(this.Entity.Address, session, false).Entity;
mailAccountClone = new MailAccount(entity);
if (this.IsConnected())
{
mailAccountClone.ConnectFull(session);
}
session.Close();
}
return(mailAccountClone);
}
public void Init()
{
SuperInit();
// If we manage to connect to the database with the user
// and password above it is our test database, and run
// these tests. If anything goes wrong, ignore these
// tests.
try
{
db = new NHibernateUserData();
db.Initialise(connect);
database = ((NHibernateUserData)db).Manager;
}
catch (Exception e)
{
m_log.Error(e.ToString());
Assert.Ignore();
}
}
public void Init()
{
SuperInit();
// If we manage to connect to the database with the user
// and password above it is our test database, and run
// these tests. If anything goes wrong, ignore these
// tests.
try
{
string connect = "SQLiteDialect;SQLite20Driver;Data Source=" + Path.GetTempFileName() + ".db;Version=3";
db = new NHibernateRegionData();
db.Initialise(connect);
database = ((NHibernateRegionData)db).Manager;
}
catch (Exception e)
{
m_log.Error(e.ToString());
Assert.Ignore();
}
}
public void Init()
{
SuperInit();
// If we manage to connect to the database with the user
// and password above it is our test database, and run
// these tests. If anything goes wrong, ignore these
// tests.
try
{
string connect = "MsSql2005Dialect;SqlClientDriver;Data Source=127.0.0.1;Network Library=DBMSSOCN;Initial Catalog=opensim-nunit;User ID=opensim-nunit;Password=opensim-nunit";
db = new NHibernateAssetData();
db.Initialise(connect);
database = ((NHibernateAssetData)db).Manager;
}
catch (Exception e)
{
m_log.Error(e.ToString());
Assert.Ignore();
}
}
public void LogData <T>(IDataContent <T> data)
{
Log log = new Log();
log.ErrorMessage = data.Message;
log.Status = data.Status;
log.LogDate = DateTime.Now;
log.HttpHeader = data.Headers;
try
{
ISession session = NHibernateManager.BeginSessionTransaction();
LogDAO.Instance.Save(log, session);
NHibernateManager.CommitTransactionAndClose();
}
catch (Exception e)
{
NHibernateManager.RollBackTransaction();
throw new Exception(e.Message);
}
}
public async Task <IList <T> > FindAll(string orderByProperty = null, int?maxResults = null)
{
using var session = NHibernateManager.OpenSession();
var criteria = session.CreateCriteria(typeof(T));
if (!string.IsNullOrWhiteSpace(orderByProperty))
{
criteria.AddOrder(Order.Asc(orderByProperty));
}
else
{
criteria.AddOrder(Order.Asc("Id"));
}
if (maxResults.HasValue)
{
criteria.SetMaxResults(maxResults.Value);
}
return(await criteria.ListAsync <T>());
}
public async Task <IList <T> > FindAllByProperty(string property, object value, string orderByProperty = null, int?maxResults = null)
{
using var session = NHibernateManager.OpenSession();
var criteria = session.CreateCriteria(typeof(T));
if (!string.IsNullOrWhiteSpace(orderByProperty))
{
criteria.AddOrder(Order.Asc(orderByProperty));
}
else
{
criteria.AddOrder(Order.Asc("Id"));
}
criteria.Add(value == null || value.ToString() == "null" ? Restrictions.IsNull(property) : Restrictions.Eq(property, value));
if (maxResults.HasValue)
{
criteria.SetMaxResults(maxResults.Value);
}
return(await criteria.ListAsync <T>());
}
