public void Update(Card card)
{
using (var session = NHibernateHelper.OpenSession())
using (var transaction = session.BeginTransaction())
{
session.Update(card);
transaction.Commit();
}
}
public void CandFindCard()
{
var card = new Card { Name = "White Knight", CastingCost = "WW", Type = "Creature - Knight" };
ICardRepository repository = new CardRepository();
repository.Add(card);
var fromDb = repository.FindCard("White");
Assert.IsNotNull(fromDb);
Assert.AreNotEqual(fromDb.Count, 0);
}
public ICollection<Pick> GetPicksByCard(Card card)
{
using (ISession session = NHibernateHelper.OpenSession())
{
var picks = session
.CreateCriteria(typeof(Pick))
.Add(Restrictions.Eq("Card", card))
.List<Pick>();
return picks;
}
}
public Pick GetPick(Draft draft, Member member, Card card)
{
using (ISession session = NHibernateHelper.OpenSession())
{
var pick = session
.CreateCriteria(typeof(Pick))
.Add(Restrictions.Eq("Member", member))
.Add(Restrictions.Eq("Draft", draft))
.Add(Restrictions.Eq("Card", card))
.UniqueResult<Pick>();
return pick;
}
}
public FuturePick FuturePickCard(Draft draft, Member member, Card card)
{
var pick = new FuturePick() { Draft = draft, Member = member, Card = card };
using (ISession session = NHibernateHelper.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(pick);
transaction.Commit();
}
return pick;
}
public void CanAddCard()
{
var card = new Card {Name = "White Knight", CastingCost = "WW", Type = "Creature - Knight"};
ICardRepository repository = new CardRepository();
repository.Add(card);
// use session to try to load the product);
using (var session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Card>(card.Id);
// Test that the color was successfully inserted
Assert.IsNotNull(fromDb);
Assert.AreNotSame(card, fromDb);
Assert.AreEqual(card.Name, fromDb.Name);
Assert.AreEqual(card.CastingCost, fromDb.CastingCost);
Assert.AreEqual(card.Type, fromDb.Type);
}
}
public Pick PickCard(Draft draft, Member member, Card card)
{
var pick = new Pick() { Draft = draft, Member = member, Card = card, CreatedDate = DateTime.Now};
using (ISession session = NHibernateHelper.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(pick);
transaction.Commit();
}
return pick;
}
public void RemovePick(Draft draft, Member member, Card card)
{
var pick = GetPick(draft, member, card);
RemovePick(pick);
}
