コード例 #1
0
        /// PUT api/Questions/questionId
        /// <summary>
        ///     UPDATE's a question. 
        ///     Order logic: -1 = make order first, -2 = no change in order, -3 = make order last,
        ///     Anything else is the questionId the current question should go after
        /// </summary>
        public HttpResponseMessage PutQuestions(int id, Questions questions)
        {
            // figure out the org's ID based up the fileId passed in
            var orgsFile = db.File.FirstOrDefault(f => f.id == questions.fileId);
            File orgsFileParsed = (File)orgsFile;
            db.Entry(orgsFile).State = EntityState.Detached;

            // org Id
            int orgsId = orgsFileParsed.orgsId;

            if (Auth.FB.IsOrgAdmin(orgsId))
            {

                if (ModelState.IsValid)
                {

                    // order logic
                    int currentPosition = 0;

                    // make order first, then save the question
                    if (questions.order == -1)
                    {

                        Questions currentQuestion = db.Questions.Find(id);
                        currentPosition = currentQuestion.order;
                        db.Entry(currentQuestion).State = EntityState.Detached;

                        // for each question in the collection up to the current postion, increment 1 then save to the db
                        IEnumerable<Questions> questionCollection = db.Questions.Where(q => q.fileId == questions.fileId).OrderBy(o => o.order);
                        Questions tempQuestion;
                        for (int i = 0; i < currentPosition - 1; i++)
                        {

                            // increment by 1
                            tempQuestion = questionCollection.ElementAt(i);
                            tempQuestion.order = tempQuestion.order + 1;

                            // save db
                            //db.Entry(tempQuestion).State = EntityState.Modified;
                            db.Entry(tempQuestion).CurrentValues.SetValues(tempQuestion);

                            db.SaveChanges();

                            db.Entry(tempQuestion).State = EntityState.Detached;

                        }

                        // set the new position for the question passed in
                        questions.order = 1;

                        db.Entry(questions).State = EntityState.Modified;

                        try
                        {
                            db.SaveChanges();
                        }
                        catch (DbUpdateConcurrencyException)
                        {
                            return Request.CreateResponse(HttpStatusCode.NotFound);
                        }

                        return Request.CreateResponse(HttpStatusCode.OK);

                    }
                    // do not change order, then save to the database
                    else if (questions.order == -2)
                    {

                        Questions q = db.Questions.Find(id);
                        questions.order = q.order;
                        db.Entry(q).State = EntityState.Detached;

                        db.Entry(questions).State = EntityState.Modified;

                        try
                        {
                            db.SaveChanges();
                        }
                        catch (DbUpdateConcurrencyException)
                        {
                            return Request.CreateResponse(HttpStatusCode.NotFound);
                        }

                        return Request.CreateResponse(HttpStatusCode.OK);

                    }
                    // make order last, then save the question to the database
                    else if (questions.order == -3)
                    {

                        // Get the current position of the question
                        Questions currentQuestion = db.Questions.Find(id);
                        currentPosition = currentQuestion.order;
                        db.Entry(currentQuestion).State = EntityState.Detached;

                        // for each question in the collection from the current postion (plus one) to the last position, decrement 1 then save to the db
                        IEnumerable<Questions> questionCollection = db.Questions.Where(q => q.fileId == questions.fileId).OrderBy(o => o.order);
                        Questions tempQuestion;
                        int lastPosition = questionCollection.Last().order;
                        for (int i = currentPosition; i < lastPosition; i++) // currentPostion is a zero based array on the questionsCollection
                        {

                            // decrement by 1
                            tempQuestion = questionCollection.ElementAt(i);
                            tempQuestion.order = tempQuestion.order - 1;

                            // save db
                            db.Entry(tempQuestion).CurrentValues.SetValues(tempQuestion);
                            db.SaveChanges();
                            db.Entry(tempQuestion).State = EntityState.Detached;
                        }

                        // make order last
                        tempQuestion = questionCollection.Where(qu => qu.id == questions.id).First();
                        tempQuestion.order = lastPosition;
                        tempQuestion.created_at = questions.created_at;
                        tempQuestion.updated_at = questions.updated_at;
                        tempQuestion.question = questions.question;

                        // save db
                        db.Entry(tempQuestion).CurrentValues.SetValues(tempQuestion);
                        try
                        {
                            db.SaveChanges();
                        }
                        catch (DbUpdateConcurrencyException)
                        {
                            return Request.CreateResponse(HttpStatusCode.NotFound);
                        }

                        return Request.CreateResponse(HttpStatusCode.OK);

                    }
                    // make an order swap, then save to the database
                    else
                    {

                        // The passed in questions.order is really the questionId where the current question should go after

                        // Get the current position of the question
                        Questions currentQuestion = db.Questions.Find(id);
                        currentPosition = currentQuestion.order;
                        db.Entry(currentQuestion).State = EntityState.Detached;

                        // for each question in the collection from the current postion (plus one) to the last position, decrement 1 then save to the db
                        IEnumerable<Questions> questionCollection = db.Questions.Where(q => q.fileId == questions.fileId).OrderBy(o => o.order);
                        Questions tempQuestion;

                        // Get the newPosition for the question to go after
                        int newPosition = questionCollection.Where(qq => qq.id == questions.order).First().order;

                        // Sort Logic for the swap

                        // question is being moved down the stack then save to db
                        if (currentPosition < newPosition)
                        {

                            for (int i = currentPosition; i < newPosition; i++) // currentPostion is a one-based array compared to questionsCollection which is a zero-based array
                            {

                                // decrement by 1
                                tempQuestion = questionCollection.ElementAt(i);
                                tempQuestion.order = tempQuestion.order - 1;

                                // save db
                                db.Entry(tempQuestion).CurrentValues.SetValues(tempQuestion);
                                db.SaveChanges();
                                db.Entry(tempQuestion).State = EntityState.Detached;
                            }

                            // put current question in it's new position
                            tempQuestion = questionCollection.Where(qu => qu.id == questions.id).First();
                            tempQuestion.order = newPosition;
                            tempQuestion.created_at = questions.created_at;
                            tempQuestion.updated_at = questions.updated_at;
                            tempQuestion.question = questions.question;

                            // save db
                            db.Entry(tempQuestion).CurrentValues.SetValues(tempQuestion);
                            try
                            {
                                db.SaveChanges();
                            }
                            catch (DbUpdateConcurrencyException)
                            {
                                return Request.CreateResponse(HttpStatusCode.NotFound);
                            }

                            return Request.CreateResponse(HttpStatusCode.OK);

                        }
                        // question is being moved up the stack, then save to db
                        else if (newPosition < currentPosition)
                        {

                            for (int i = newPosition; i < currentPosition - 1; i++) // currentPostion is a one-based array compared to questionsCollection which is a zero-based array
                            {

                                // increment by 1
                                tempQuestion = questionCollection.ElementAt(i);
                                tempQuestion.order = tempQuestion.order + 1;

                                // save db
                                db.Entry(tempQuestion).CurrentValues.SetValues(tempQuestion);
                                db.SaveChanges();
                                db.Entry(tempQuestion).State = EntityState.Detached;
                            }

                            // put current question in it's new position
                            tempQuestion = questionCollection.Where(qu => qu.id == questions.id).First();
                            tempQuestion.order = newPosition + 1;
                            tempQuestion.created_at = questions.created_at;
                            tempQuestion.updated_at = questions.updated_at;
                            tempQuestion.question = questions.question;

                            // save db
                            db.Entry(tempQuestion).CurrentValues.SetValues(tempQuestion);
                            try
                            {
                                db.SaveChanges();
                            }
                            catch (DbUpdateConcurrencyException)
                            {
                                return Request.CreateResponse(HttpStatusCode.NotFound);
                            }

                            return Request.CreateResponse(HttpStatusCode.OK);
                        }
                        // no order change, but save db
                        else
                        {
                            // put current question in it's new position
                            tempQuestion = questionCollection.Where(qu => qu.id == questions.id).First();
                            tempQuestion.created_at = questions.created_at;
                            tempQuestion.updated_at = questions.updated_at;
                            tempQuestion.question = questions.question;

                            // save db
                            db.Entry(tempQuestion).CurrentValues.SetValues(tempQuestion);
                            try
                            {
                                db.SaveChanges();
                            }
                            catch (DbUpdateConcurrencyException)
                            {
                                return Request.CreateResponse(HttpStatusCode.NotFound);
                            }

                            return Request.CreateResponse(HttpStatusCode.OK);
                        }

                    }

                }
                else
                {
                    return Request.CreateResponse(HttpStatusCode.BadRequest);
                }

            }
            else
            {
                throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Unauthorized));
            }
        }
コード例 #2
0
        /// POST api/Questions
        /// <summary>
        /// CREATE's a new question
        /// </summary>
        public HttpResponseMessage PostQuestions(Questions questions)
        {
            // figure out the org's ID based up the fileId passed in
            var orgsFile = db.File.FirstOrDefault(f => f.id == questions.fileId);
            File orgsFileParsed = (File)orgsFile;
            // org Id
            int orgsId = orgsFileParsed.orgsId;

            if (Auth.FB.IsOrgAdmin(orgsId))
            {

                try
                {
                    // Order Logic
                    Questions lastQuestion = db.Questions.Where(q => q.fileId == questions.fileId).OrderByDescending(o => o.order).FirstOrDefault();
                    if (lastQuestion != null) // add 1 for last question
                    {
                        questions.order = lastQuestion.order + 1;
                    }
                    else // this is the first question in the file
                    {
                        questions.order = 1;
                    }

                    if (ModelState.IsValid)
                    {
                        db.Questions.Add(questions);
                        db.SaveChanges();

                        HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, questions);
                        response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = questions.id }));
                        return response;
                    }
                    else
                    {
                        return Request.CreateResponse(HttpStatusCode.BadRequest);
                    }
                }
                catch (Exception e)
                {
                    throw e;
                }

            }
            else
            {
                throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Unauthorized));
            }
        }