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(); } }