static void InitlizationTest()
{
try
{
NHibernateBase nHibernateBase = new NHibernateBase();
nHibernateBase.Initilize("NHibernate.GuitarStore");
System.Console.WriteLine("NHibernate.GuitarStore assembly Initialized.");
System.Console.ReadLine();
}
catch (Exception ex)
{
string message = ex.Message;
while (ex.InnerException != null)
{
message += "\r - InnerException: " + ex.InnerException.Message;
ex = ex.InnerException;
}
System.Console.WriteLine();
System.Console.WriteLine("***** ERROR *****");
System.Console.WriteLine(message);
System.Console.WriteLine();
System.Console.ReadLine();
}
}
private static void Main(string[] args)
{
try
{
var NHB = new NHibernateBase();
NHB.Initialize("NHibernate.GuitarStore");
System.Console.WriteLine("NHibernate.GuitarStore assembly initialized.");
System.Console.ReadLine();
IList<Inventory> list1 = NHibernateBase.StatelessSession.CreateQuery("from Inventory").List<Inventory>();
IList<Inventory> list2 = NHibernateBase.Session.CreateCriteria(typeof (Inventory)).List<Inventory>();
IQueryable<Inventory> linq = (from l in NHibernateBase.Session.Query<Inventory>() select l);
}
catch (Exception ex)
{
string Message = ex.Message;
if (ex.InnerException != null)
Message += " - InnerException: " + ex.InnerException.Message;
System.Console.WriteLine();
System.Console.WriteLine("***** ERROR *****");
System.Console.WriteLine(Message);
System.Console.WriteLine();
System.Console.ReadLine();
}
}
public void AddToCart(Album album, string shoppingCartId)
{
using (var session = NHibernateBase.OpentSession())
{
using (var tx = session.BeginTransaction())
{
Cart cartItem = session.QueryOver <Cart>()
.Where(c => c.CartId == shoppingCartId)
.And(c => c.Album.Id == album.Id)
.SingleOrDefault();
if (cartItem == null)
{
cartItem = new Cart
{
Album = album,
CartId = shoppingCartId,
Count = 1,
DateCreated = DateTime.Now
};
session.Save(cartItem);
}
else
{
cartItem.Count++;
session.Update(cartItem);
}
tx.Commit();
}
}
}
public int RemoveFromCart(int id, string shoppingCartId)
{
using (var session = NHibernateBase.OpentSession())
{
using (var tx = session.BeginTransaction())
{
var cartItem = session.QueryOver <Cart>()
.Where(c => c.Id == id && c.CartId == shoppingCartId)
.JoinQueryOver(c => c.Album)
.SingleOrDefault();
int itemCount = 0;
if (cartItem != null)
{
if (cartItem.Count > 1)
{
cartItem.Count--;
itemCount = cartItem.Count;
session.Update(cartItem);
}
else
{
session.Delete(cartItem);
}
tx.Commit();
}
return(itemCount);
}
}
}
static void Main(string[] args)
{
try
{
var nHibernateBase = new NHibernateBase();
nHibernateBase.Initialize("NHibernate.GuitarStore");
System.Console.WriteLine("NHibernte.GuitarStore assembly initialised.");
var list1 = NHibernateBase.StatelessSession.CreateCriteria("Inventory").List<Inventory>();
var list2 = NHibernateBase.Session.CreateCriteria(typeof (Inventory)).List<Inventory>();
IQueryable<Inventory> linq = NHibernateBase.Session.Query<Inventory>().Select(i => i);
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " - InnerException: " + ex.InnerException.Message;
}
System.Console.WriteLine();
System.Console.WriteLine("***** ERROR *****");
System.Console.WriteLine(message);
System.Console.WriteLine();
}
}
public IList <Album> GetAlbumsByGenre(string genre)
{
using (var session = NHibernateBase.OpentSession())
{
var queryOver = GetQueryOverByArtistOrGenre(genre);
return(queryOver.GetExecutableQueryOver(session).List());
}
}
public Genre GetGenreByName(string name)
{
using (var session = NHibernateBase.OpentSession())
{
var queryOver = GetQueryForGenre(name);
return(queryOver.GetExecutableQueryOver(session).SingleOrDefault());
}
}
public MainWindow()
{
InitializeComponent();
// test to be sure that Nhibernate can load the mapping files.
NHibernateBase nHibernateBase = new NHibernateBase();
nHibernateBase.Initilize("NHibernate.GuitarStore");
}
public Album GetAlbumWithGenreById(int id)
{
var queryOver = GetQueryOverByArtistOrGenre("", "", id);
using (var session = NHibernateBase.OpentSession())
{
return(queryOver.GetExecutableQueryOver(session).SingleOrDefault());
}
}
public IList <Album> GetAllAlbums()
{
var queryOver = GetQueryOverByArtistOrGenre();
using (var session = NHibernateBase.OpentSession())
{
return(queryOver.GetExecutableQueryOver(session).List());
}
}
public Cart GetUniqueCartWithAlbumByCartId(int id)
{
var query = GetQueryOverByCartId("", id);
using (var session = NHibernateBase.OpentSession())
{
return(query.GetExecutableQueryOver(session).SingleOrDefault());
}
}
public IList <Cart> GetCartItems(string shoppingCartId)
{
var queryOver = GetQueryOverByCartId(shoppingCartId);
using (var session = NHibernateBase.OpentSession())
{
return(queryOver.GetExecutableQueryOver(session).List());
}
}
public IList <Album> GetNewestAlbums()
{
using (var session = NHibernateBase.OpentSession())
{
var queryOver = GetQueryOverByArtistOrGenre();
return(queryOver.OrderBy(album => album.DateCreated).Asc()
.Take(Settings.Default.AlbumCount)
.GetExecutableQueryOver(session)
.List());
}
}
public int GetCount(string shoppingCartId)
{
using (var session = NHibernateBase.OpentSession())
{
int?count = session.QueryOver <Cart>()
.Where(c => c.CartId == shoppingCartId)
.SelectList(list => list
.SelectSum(c => c.Count))
.SingleOrDefault <int>();
return((int)count);
}
}
private void PopulateComboBox()
{
var nhb = new NHibernateBase();
IList<Guitar> guitarTypes = nhb.ExecuteCriteria<Guitar>();
foreach (var item in guitarTypes)
{
var guitar = new Guitar{ Id = item.Id, Type = item.Type};
cboBoxGuitarTypes.DisplayMemberPath = "Type";
cboBoxGuitarTypes.SelectedValuePath = "Id";
cboBoxGuitarTypes.Items.Add(guitar);
}
}
public bool CheckIfUserHasOrders(int orderId, string username)
{
using (var session = NHibernateBase.OpentSession())
{
Order order = session.QueryOver <Order>()
.Where(o => o.Id == orderId)
.And(o => o.Username == username)
.SingleOrDefault();
return(order != null);
}
}
public void MigrateCart(string username, string shoppingCartId)
{
using (var session = NHibernateBase.OpentSession())
{
var shoppingCart = session.QueryOver <Cart>().Where(c => c.CartId == shoppingCartId).List();
foreach (Cart cart in shoppingCart)
{
cart.CartId = username;
session.Update(cart);
}
}
}
static void QueriesToBeCalled()
{
NHibernateBase nHibernateBase = new NHibernateBase();
nHibernateBase.Initilize("NHibernate.GuitarStore");
System.Console.WriteLine("NHibernate.GuitarStore assembly Initialized.");
IList<Inventory> list1 = NHibernateBase.StatelessSession.CreateCriteria("Inventory").List<Inventory>();
IList<Inventory> list2 = NHibernateBase.Session.CreateCriteria(typeof (Inventory)).List<Inventory>();
IQueryable<Inventory> linq =
(from l in NHibernateBase.Session.Query<Inventory>() select l);
}
public decimal GetTotal(string shoppingCartId)
{
using (var session = NHibernateBase.OpentSession())
{
IQuery query = session.CreateQuery(
"select Sum(album.Price * cart.Count)" +
"from Cart as cart inner join cart.Album as album where cart.CartId = :cartId");
query.SetParameter("cartId", shoppingCartId);
var total = query.UniqueResult <decimal>();
return(total);
}
}
public void EmptyCart(string shoppingCartId)
{
using (var session = NHibernateBase.OpentSession())
{
using (session.BeginTransaction())
{
var cartItems = session.QueryOver <Cart>().Where(c => c.CartId == shoppingCartId).List();
foreach (var cartItem in cartItems)
{
session.Delete(cartItem);
}
}
}
}
static void Main(string[] args)
{
var hibernateBase = new NHibernateBase();
hibernateBase.Initialize("NHibernate.GuitarStore");
Console.WriteLine("NHibernate.GuitarStore assembly initialized.");
//var inventories = NHibernateBase.Session.CreateCriteria(typeof(Inventory)).List<Inventory>();
//foreach (var inventory in inventories)
//{
// Console.WriteLine(inventory.Model + ": " + inventory.Price);
//}
//var queryable = (from l in NHibernateBase.Session.Query<Inventory>() select l).Skip(10).ToList();
//foreach (var inventory in queryable)
//{
// Console.WriteLine(inventory.Model + ": " + inventory.Received);
//}
try
{
var core = new CategoryCore();
var categories = core.ExecuteICriteria();
foreach (var category in categories)
{
Console.WriteLine(category.Id + ": " + category.Name);
}
}
catch (Exception err)
{
CallError(err);
}
//Console.ReadLine();
try
{
var a = new InventoryCore();
var inventories = a.ExecuteICriteria<Inventory>();
foreach (var inventory in inventories)
{
Console.WriteLine(inventory.MODEL + ": " + inventory.PRICE);
}
}
catch (Exception err)
{
CallError(err);
}
Console.WriteLine("End");
Console.ReadLine();
}
public IList GetGenreandAlbums()
{
using (var session = NHibernateBase.OpentSession())
{
IList result;
using (var tx = session.BeginTransaction())
{
IQuery query = session.CreateQuery(
"from Genre as genre " +
"inner join genre.Albums as album");
result = query.List();
tx.Commit();
}
return(result);
}
}
public MainWindow()
{
InitializeComponent();
var nhb = new NHibernateBase();
nhb.Initialize("NHibernate.GuitarStore");
}
public ProductRepository()
{
NHibernateBase nHibernate = new NHibernateBase();
nHibernate.Initialize();
}
private void PopulateComboBox()
{
NHibernateBase nhb = new NHibernateBase();
// get all the guitar types from the DB.
IList<Guitar> guitarTypes = nhb.ExecuteICriteria<Guitar>();
// clear all items from the combo box.
this.guitarTypesComboBox.Items.Clear();
// add them to the combo box.
foreach (var item in guitarTypes)
{
Guitar guitar = new Guitar {Id = item.Id, Type = item.Type};
guitarTypesComboBox.DisplayMemberPath = "Type";
guitarTypesComboBox.SelectedValuePath = "Id";
guitarTypesComboBox.Items.Add(guitar);
}
}
public OrderRepository()
{
NHibernateBase nHibernate = new NHibernateBase();
nHibernate.Initialize();
}
public BaseApi()
{
NHibernateBase nHibernate = new NHibernateBase();
nHibernate.Initialize();
}
