Exemple #1
0
        private void initProblems()
        {
            // Get the list of existing problems from our XML data file
            string            problemsDataFile   = Path.Combine(dataDir, "Problems.xml");
            string            problemsSchemaFile = Path.Combine(schemaDir, "Problems.xsd");
            ProblemCollection problems           = new ProblemCollection(problemsDataFile, problemsSchemaFile);

            // Persist the problems in the database
            ISession     session     = null;
            ITransaction transaction = null;

            try {
                session     = factory.OpenSession();
                transaction = session.BeginTransaction();
                foreach (Problem p in problems)
                {
                    P_Problem p_prob = new P_Problem(p.Name);
                    p_prob.Name = p.Name;
                    session.Save(p_prob);
                }
                transaction.Commit();
            } catch {
                if (transaction != null)
                {
                    transaction.Rollback();
                }
                throw;
            } finally {
                if (session != null)
                {
                    session.Close();
                }
            }
        }
Exemple #2
0
        public P_Problem[] ListAllProblems()
        {
            ISession  session   = factory.OpenSession();
            ICriteria criterion = session.CreateCriteria(typeof(P_Problem));

            System.Collections.IList problemList = criterion.List();
            P_Problem[] answer = new P_Problem[problemList.Count];
            for (int i = 0; i < problemList.Count; i++)
            {
                answer[i] = (P_Problem)problemList[i];
            }
            return(answer);
        }
Exemple #3
0
        public int SetProblem(int userId, string problemName)
        {
            int answer = 0;

            ISession     session     = null;
            ITransaction transaction = null;

            try {
                session     = factory.OpenSession();
                transaction = session.BeginTransaction();

                P_User user = session.Load <P_User>(userId);

                // If the user has no open Episode, or if the open Episode is for a different problem, we need
                // to generate a new Episode
                if (user.OpenEpisode == null || user.OpenEpisode.Problem.Name != problemName)
                {
                    ICriteria criterion = session.CreateCriteria(typeof(P_Problem));
                    criterion.Add(Expression.Eq("Name", problemName));
                    P_Problem problem = criterion.UniqueResult <P_Problem>();

                    P_Episode episode = new P_Episode(problem);
                    user.AddEpisode(episode);
                    session.Save(problem);
                    session.Save(episode);
                    answer = problem.Id;
                }
                else
                {
                    // requested problem is already associate with the user's open episode, do nothing
                    answer = user.OpenEpisode.Problem.Id;
                }

                transaction.Commit();
            } catch {
                if (transaction != null)
                {
                    transaction.Rollback();
                    throw;
                }
            } finally {
                if (session != null)
                {
                    session.Close();
                }
            }
            return(answer);
        }
Exemple #4
0
 public P_Episode(P_Problem problem)
 {
     this.problem = problem;
     this.isOpen  = true;
 }