private void ConfigureNHibernate(IKernel container)
{
#if EXPLODEDB
//recreate Schema
var sessionFactory = Fluently.Configure()
.Database(
MsSqlConfiguration.MsSql2008.ConnectionString(
c => c.FromConnectionStringWithKey("owDbConn")))
.CurrentSessionContext("web")
.ExposeConfiguration(cfg => new SchemaUpdate(cfg).Execute(false, true))
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <sysBaseRuleset>())
.BuildSessionFactory();
//seed data
#if SEED_DATA
var session = sessionFactory.OpenSession();
nwdbRepository nwRepo = new nwdbRepository(session);
nwRepo.SeedMockData();
#endif
#else
var sessionFactory = Fluently.Configure()
.Database(
MsSqlConfiguration.MsSql2008.ConnectionString(
c => c.FromConnectionStringWithKey("owDbConn")))
.CurrentSessionContext("web")
.ExposeConfiguration(cfg => new SchemaUpdate(cfg).Execute(false, true))
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <sysBaseRuleset>())
.BuildSessionFactory();
#endif
//Bind Created or Updated to Ninject
container.Bind <ISessionFactory>().ToConstant(sessionFactory);
}
public sysDocuments(hostUser logon, hostChar ch, nwdbRepository repo, nwdbConnection nw)
{
this.Logon = logon;
this.Character = ch;
this.Repository = repo;
this.Database = nw;
initData();
}
public void nwDB_SeedRepo()
{
nwdbConnection nw2 = new nwdbConnection(true);
sessionFactory = nw.Factory;
repo = new nwdbRepository(sessionFactory.OpenSession());
repo.SeedMockData();
}
public frmUserManager()
{
InitializeComponent();
nw = new nwdbConnection();
//Update
//nw = new nwdbConnection();
sessionFactory = nw.Factory;
repo = new nwdbRepository(sessionFactory.OpenSession());
sess = repo.GetSession();
stm = new sysTreeManager();
bs_hostUser.DataSource = sess.QueryOver <hostUser>().List();
bs_userType.DataSource = sess.QueryOver <hostUserType>().List();
}
private void FrmLogon_Load(object sender, EventArgs e)
{
Debug.Print("LOAD FIRED");
//Create&Drop
if (nw == null)
{
nw = new nwdbConnection();
}
sessionFactory = nw.Factory;
if (repo == null)
{
repo = new nwdbRepository(sessionFactory.OpenSession());
}
sess = repo.GetSession();
//this.btnLogin_Click(this, null);
}
protected void DropCreateDB(string dbname, string username, string password)
{
nw = new nwdbConnection(true, dbname, username, password);
sessionFactory = nw.Factory;
repo = new nwdbRepository(sessionFactory.OpenSession());
}
static void Main()
{
var nw = new nwdbConnection();
var sessionFactory = nw.Factory;
var repo = new nwdbRepository(sessionFactory.OpenSession());
// retreive all dmgtypes and display them
//var sorttypes = session.CreateCriteria(typeof(ConstSysStatisticSortGroup))
// .List<ConstSysStatisticSortGroup>();
//campTree nwt;
/*
* nwdbDataType nws;
* ConstSysItemFamily nwf;
* ConstSysItemClass nwc;
* nws = new ConstSysDmgType();
* WritePretty(nws.asList(session), "Damage Type");
* nws = new ConstSysAoeType();
* WritePretty(nws.asList(session), "Aoe Type");
* nws = new ConstSysCheckResult();
* WritePretty(nws.asList(session), "Check Result");
* nws = new ConstSysRange();
* WritePretty(nws.asList(session), "Ranges");
* nws = new ConstSysSchool();
* WritePretty(nws.asList(session), "Schools");
* nws = new ConstSysStatisticSortGroup();
* WritePretty(nws.asList(session), "Stat groups");
* nws = new ConstSysFrequency();
* WritePretty(nws.asList(session), "Frequency");
*
* Debug.WriteLine("Start" );
* nwf = repo.FindOrNew(typeof(ConstSysItemFamily), "Items", "General") as ConstSysItemFamily;
*
* Debug.WriteLine("Armor Family returned" + nwf.toString());
* nwf.LongName = "Armor + Shields";
* session.SaveOrUpdate(nwf);
*
*
*
* // WritePretty(nwf.asList(session), "Item Family");
* nwc = repo.FindOrNew(typeof(ConstSysItemClass), "Amulets", "Amulets, Necklaces") as ConstSysItemClass;
*
*
* var records = repo.asList(nwc);
* foreach (nwdbDataType r in records)
* {
* Debug.Print("Amulet Report:" + r.toString());
* }
*
*
* //WritePretty(nwc.asList(session), "Item Class");
* nwc.item_family = nwf;
* //int r = nwf.FindIDByName(session, "Armor");
* //Debug.WriteLine("Armor returned" + r as string);
* //Debug.WriteLine("Set ItemClass Family to" +nwc.item_family.toString());
* session.SaveOrUpdate(nwc);
* */
//add a dmttype
//ConstSysDmgType c = new ConstSysDmgType("Piercing","Piercing Damage");
//repo.Add(typeof(hostChar), new hostChar("Brian", "Brian Walter","*****@*****.**"));
//hostChar c = repo.FindbyID(typeof(hostChar), 1) as hostChar;
//Debug.WriteLine(c.ToString());
//session.SaveOrUpdate(c);
//transaction.Commit();
//int did = repo.FindIDByLongName(typeof(hostChar), "Derek Willow2");
//hostChar d = repo.FindbyID(typeof(hostChar), did) as hostChar;
//Debug.WriteLine(d.ToString());
Debug.Print("Calling List of hostChar");
IList <nwdbDataType> il = repo.asList(typeof(hostChar));
foreach (nwdbDataType item in il)
{
Debug.Print(item.ToString());
}
}
