Ejemplo n.º 1
0
        public List<User> RetrieveNewUsers()
        {
            using (CollectContext context = new CollectContext())
            {
                try
                {
                    DateTime hierMemeHeure = DateTime.Now.AddDays(-1d);

                    var nouveauxInscrits = from u in context.Users
                                           where u.CreationDate > hierMemeHeure
                                               //&& !u.IsCanal // [12/05/2014] temps 4 : on récupère désormais tous les inscrits optins
                                           && u.IsOffreGroupCanal
                                           orderby u.CreationDate descending
                                           select u;

                    return nouveauxInscrits.ToList();

                }
                catch (Exception e)
                {
                    Program.Log("Probleme base de données : " + e.Message + " (" + e.StackTrace + ")");
                    return new List<User>();
                }
            }
        }
Ejemplo n.º 2
0
        public StdResult<AnswerChoice> SetAnswer(User u, int questionNumber, int answerChosen)
        {
            using (CollectContext context = new CollectContext())
            {
                if(!context.Users.Any(user => user.Id == u.Id))
                    return StdResult<AnswerChoice>.BadResult("User introuvable en base.");

                var query = context.AnswerChoices.Where(answerChoice => answerChoice.User.Id == u.Id && answerChoice.QuestionNumber == questionNumber);
                bool alreadyAnswered = query.Any();
                AnswerChoice ac = null;
                if (query.Any())
                {
                    ac = query.FirstOrDefault();
                    ac.AnswerChosen = answerChosen;
                }
                else
                {
                    ac = new AnswerChoice
                    {
                        UserId = u.Id,
                        AnswerChosen = answerChosen,
                        QuestionNumber = questionNumber
                    };
                    context.AnswerChoices.Add(ac);

                    context.SaveChanges();
                    u.AnswerChoices.Add(ac);
                }

                context.SaveChanges();
                return StdResult<AnswerChoice>.OkResultInstance(ac);
            }
        }
        public StdResult<InstantGagnant> WinInstantGagnant(User MainUser)
        {
            using (CollectContext context = new CollectContext())
            {
                DateTime now = DateTime.Now;
                var query = from ig in context.InstantsGagnants
                            where now > ig.StartDateTime
                            && !ig.Won
                            orderby ig.StartDateTime
                            select ig;
                if (query.Any<InstantGagnant>())
                {
                    InstantGagnant ig = query.First<InstantGagnant>();

                    ig.UserId = MainUser.Id;
                    ig.Won = true;
                    ig.WonDate = DateTime.Now;
                    MainUser.InstantsGagnantWon.Add(ig);
                    context.SaveChanges();
                    return StdResult<InstantGagnant>.OkResultInstance(ig);
                }
                else
                    return StdResult<InstantGagnant>.BadResult("Pas d'instant gagnant disponible");
            }
        }
 public static int GetTradeDoublerSequenceNumber()
 {
     using (CollectContext context = new CollectContext())
     {
         var sequenceNumber = (from seq in context.TradeDoublerIndex
                              where seq.Id == 1
                              select seq).FirstOrDefault();
         return sequenceNumber != null ? sequenceNumber.Value : 0;
     }
 }
        public StdResult<InstantGagnant> AddInstantGagnant(InstantGagnant instance)
        {
            using (CollectContext context = new CollectContext())
            {
                context.InstantsGagnants.Add(instance);
                context.SaveChanges();

                return StdResult<InstantGagnant>.OkResultInstance(instance);
            }
        }
Ejemplo n.º 6
0
        public StdResult<List<AnswerChoice>> GetUsersAnswers(User u)
        {
            using (CollectContext context = new CollectContext())
            {
                if (!context.Users.Any(user => user.Id == u.Id))
                    return StdResult<List<AnswerChoice>>.BadResult("User introuvable en base.");

                var query = context.AnswerChoices.Where(answerChoice => answerChoice.User.Id == u.Id);
                bool alreadyAnswered = query.Any();

                return StdResult<List<AnswerChoice>>.OkResultInstance(query.ToList());
            }
        }
Ejemplo n.º 7
0
        public List<User> RetrieveNewUsersSince(DateTime since)
        {
            using (CollectContext context = new CollectContext())
            {
                var nouveauxInscrits = from u in context.Users
                                       where u.CreationDate > since
                                       //&& !u.IsCanal
                                       && u.IsOffreGroupCanal
                                       orderby u.CreationDate descending
                                       select u;

                return nouveauxInscrits.ToList();
            }
        }
        public static void SetTradeDoublerSequenceNumber(int value)
        {
            using (CollectContext context = new CollectContext())
            {
                var sequenceNumber = (from seq in context.TradeDoublerIndex
                                      where seq.Id == 1
                                      select seq).FirstOrDefault();
                if (sequenceNumber != null)
                {
                    sequenceNumber.Value = value;

                    context.SaveChanges();
                }
            }
        }
        public StdResult<InstantGagnant> DeleteInstantsGagnant()
        {
            using (CollectContext context = new CollectContext())
            {
                foreach (User user in context.Users)
                {
                    user.InstantsGagnantWon = null;
                }

                foreach (InstantGagnant ig in context.InstantsGagnants)
                {
                    context.InstantsGagnants.Remove(ig);
                }
                context.SaveChanges();

                return StdResult<InstantGagnant>.OkResult;
            }
        }
        public StdResult<InstantGagnant> GetCurrentInstantGagnant()
        {
            using (CollectContext context = new CollectContext())
            {
                DateTime now = DateTime.Now;
                var query = from ig in context.InstantsGagnants
                            where now > ig.StartDateTime
                            && !ig.Won
                            orderby ig.StartDateTime
                            select ig;
                if (query.Any<InstantGagnant>())
                {
                    InstantGagnant ig = query.First<InstantGagnant>();
                    return StdResult<InstantGagnant>.OkResultInstance(ig);
                }
                else
                    return StdResult<InstantGagnant>.BadResult("Pas d'instant gagnant disponible");

            }
        }