public int GetDraftPosition(Draft draft, Member member)
{
var draftMemberPositions = GetDraftMemberPositionByDraftMember(draft, member);
if (draftMemberPositions == null)
return -1;
return draftMemberPositions.Position;
}
public void Update(Member member)
{
using (ISession session = NHibernateHelper.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Update(member);
transaction.Commit();
}
}
public ICollection<DraftMemberPositions> GetDraftPositionsByMember(Member member)
{
using (ISession session = NHibernateHelper.OpenSession())
{
var draftMemberPositions = session
.CreateCriteria(typeof(DraftMemberPositions))
.Add(Restrictions.Eq("Member", member))
.List<DraftMemberPositions>();
return draftMemberPositions;
}
}
public DraftMemberPositions GetDraftMemberPositionByDraftMember(Draft draft, Member member)
{
using (ISession session = NHibernateHelper.OpenSession())
{
var draftMemberPositions = session
.CreateCriteria(typeof(DraftMemberPositions))
.Add(Restrictions.Eq("Member", member))
.Add(Restrictions.Eq("Draft", draft))
.UniqueResult<DraftMemberPositions>();
return draftMemberPositions;
}
}
public void AddMemberToDraft(Draft draft, Member member, int position)
{
var draftMemberPositions = new DraftMemberPositions
{Draft = draft, Member = member, Position = position};
using (ISession session = NHibernateHelper.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(draftMemberPositions);
transaction.Commit();
}
}
public ICollection<Pick> GetPicksByDraftAndMember(Draft draft, Member member)
{
using (ISession session = NHibernateHelper.OpenSession())
{
var picks = session
.CreateCriteria(typeof(Pick))
.Add(Restrictions.Eq("Draft", draft))
.Add(Restrictions.Eq("Member", member))
.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 CannotAddIdenticalEmails()
{
var member = new Member { Email = "[email protected]", FullName = "Kalle Ada", Password = "******" };
IMemberRepository repository = new MemberRepository();
try
{
repository.Add(member);
}
catch (GenericADOException)
{
return;
}
Assert.Fail("Should not be able to add two emails of same sort");
}
public FuturePick GetNextFuturePick(Draft draft, Member member)
{
using (ISession session = NHibernateHelper.OpenSession())
{
var pick = session
.CreateCriteria(typeof (FuturePick))
.Add(Restrictions.Eq("Member", member))
.Add(Restrictions.Eq("Draft", draft))
.AddOrder(Order.Asc("CreatedDate"))
.List<FuturePick>();
if (pick.Count > 0)
return pick[0];
return null;
}
}
public void CanAddNewMember()
{
var member = new Member {Email = "*****@*****.**", FullName = "Magnus", Password = "******", UserName = "******"};
IMemberRepository repository = new MemberRepository();
repository.Add(member);
// use session to try to load the product
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Member>(member.Id);
// Test that the product was successfully inserted
Assert.IsNotNull(fromDb);
Assert.AreNotSame(member, fromDb);
Assert.AreEqual(member.FullName, fromDb.FullName);
Assert.AreEqual(member.Email, fromDb.Email);
Assert.AreEqual(member.Password, fromDb.Password);
}
}
public bool CreateUser(string username, string email, string password, string fullname)
{
IMemberRepository mr = new MemberRepository();
string passwordHash = FormsAuthentication.HashPasswordForStoringInConfigFile(
password+username, "sha1");
var member = new Member {UserName = username, Email = email, Password = passwordHash, FullName = fullname};
try
{
mr.Add(member);
}
catch
{
return false;
}
return true;
}
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);
}
public void RemoveMemberFromDraft(Draft draft, Member member)
{
var draftMemberPositions = GetDraftMemberPositionByDraftMember(draft, member);
using (ISession session = NHibernateHelper.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Delete(draftMemberPositions);
transaction.Commit();
}
}
public void UpdatePosition(Draft draft, Member member, int position)
{
var draftMemberPositions = GetDraftMemberPositionByDraftMember(draft, member);
draftMemberPositions.Position = position;
using (ISession session = NHibernateHelper.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Update(draftMemberPositions);
transaction.Commit();
}
}
