public void DeleteSurveyQuestion(SurveyQuestion question)
        {
            var query = from surveyquestion in db.SurveyQuestions
                        select surveyquestion;

            query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
            query = query.OrderBy("SortOrder", false);

            List<SurveyQuestion> surveyquestions = query.ToList();

            bool found = false;
            foreach (SurveyQuestion sq in surveyquestions)
            {
                if (found)
                {
                    sq.SortOrder -= 1;
                    db.Entry(sq).State = EntityState.Modified;
                }
                if (sq.SurveyQuestionID == question.SurveyQuestionID)
                {
                    found = true;
                    db.SurveyQuestions.Remove(sq);
                }
            }

            db.SaveChanges();
        }
        public void DeleteSurveyQuestion(SurveyQuestion question)
        {
            var query = from surveyquestion in db.SurveyQuestions
                        select surveyquestion;

            query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
            query = query.OrderBy("SortOrder", false);

            List <SurveyQuestion> surveyquestions = query.ToList();

            bool found = false;

            foreach (SurveyQuestion sq in surveyquestions)
            {
                if (found)
                {
                    sq.SortOrder      -= 1;
                    db.Entry(sq).State = EntityState.Modified;
                }
                if (sq.SurveyQuestionID == question.SurveyQuestionID)
                {
                    found = true;
                    db.SurveyQuestions.Remove(sq);
                }
            }

            db.SaveChanges();
        }
        public void CreateSurveyQuestion(SurveyQuestion question)
        {
            // Get the maximum sort order
            var query = from surveyquestion in db.SurveyQuestions
                        select surveyquestion;

            query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
            query = query.OrderBy("SortOrder", true);

            List<SurveyQuestion> surveyquestions = query.ToList();

            int maxsortorder = 0;
            if (surveyquestions.Count > 0)
                maxsortorder = surveyquestions[0].SortOrder;

            question.SortOrder = maxsortorder + 1;
            db.SurveyQuestions.Add(question);
            db.SaveChanges();
        }
Exemplo n.º 4
0
        public void CreateSurveyQuestion(SurveyQuestion question)
        {
            // Get the maximum sort order
            var query = from surveyquestion in db.SurveyQuestions
                        select surveyquestion;

            query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
            query = query.OrderBy("SortOrder", true);

            List <SurveyQuestion> surveyquestions = query.ToList();

            int maxsortorder = 0;

            if (surveyquestions.Count > 0)
            {
                maxsortorder = surveyquestions[0].SortOrder;
            }

            question.SortOrder = maxsortorder + 1;
            db.SurveyQuestions.Add(question);
            db.SaveChanges();
        }
Exemplo n.º 5
0
        public SurveyQuestion GetSurveyQuestion(int id)
        {
            SurveyQuestion surveyquestion = db.SurveyQuestions.Find(id);

            return(surveyquestion);
        }
Exemplo n.º 6
0
 public void UpdateSurveyQuestion(SurveyQuestion surveyquestion)
 {
     db.Entry(surveyquestion).State = EntityState.Modified;
     db.SaveChanges();
 }
Exemplo n.º 7
0
        public void MoveSurveyQuestion(SurveyQuestion question, bool ismoveup)
        {
            var query = from surveyquestion in db.SurveyQuestions
                        select surveyquestion;

            query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
            query = query.OrderBy("SortOrder", false);

            List <SurveyQuestion> surveyquestions = query.ToList();

            // Get the current and max sort orders
            int currentsortorder = question.SortOrder;
            int maxsortorder     = 1;

            foreach (SurveyQuestion sq in surveyquestions)
            {
                if (sq.SortOrder > maxsortorder)
                {
                    maxsortorder = sq.SortOrder;
                }
            }

            // Adjust the appropriate sort orders
            foreach (SurveyQuestion sq in surveyquestions)
            {
                if (ismoveup)
                {
                    if (sq.SurveyQuestionID == question.SurveyQuestionID) // move current question up
                    {
                        if (currentsortorder > 1)
                        {
                            question.SortOrder -= 1;
                        }
                    }
                    else // find the previous item and increment it
                    {
                        if (sq.SortOrder == currentsortorder - 1)
                        {
                            sq.SortOrder      += 1;
                            db.Entry(sq).State = EntityState.Modified;
                        }
                    }
                }
                else
                {
                    if (sq.SurveyQuestionID == question.SurveyQuestionID) // move current question down
                    {
                        if (currentsortorder < maxsortorder)
                        {
                            question.SortOrder += 1;
                        }
                    }
                    else // find the next item and decrement it
                    {
                        if (sq.SortOrder == currentsortorder + 1)
                        {
                            sq.SortOrder      -= 1;
                            db.Entry(sq).State = EntityState.Modified;
                        }
                    }
                }
            }

            db.SaveChanges();
        }
        public void MoveSurveyQuestion(SurveyQuestion question, bool ismoveup)
        {
            var query = from surveyquestion in db.SurveyQuestions
                        select surveyquestion;
            query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
            query = query.OrderBy("SortOrder", false);

            List<SurveyQuestion> surveyquestions = query.ToList();

            // Get the current and max sort orders
            int currentsortorder = question.SortOrder;
            int maxsortorder = 1;
            foreach (SurveyQuestion sq in surveyquestions)
            {
                if (sq.SortOrder > maxsortorder)
                    maxsortorder = sq.SortOrder;
            }

            // Adjust the appropriate sort orders
            foreach (SurveyQuestion sq in surveyquestions)
            {
                if (ismoveup)
                {
                    if (sq.SurveyQuestionID == question.SurveyQuestionID) // move current question up
                    {
                        if (currentsortorder > 1)
                            question.SortOrder -= 1;
                    }
                    else // find the previous item and increment it
                    {
                        if (sq.SortOrder == currentsortorder - 1)
                        {
                            sq.SortOrder += 1;
                            db.Entry(sq).State = EntityState.Modified;
                        }
                    }
                }
                else
                {
                    if (sq.SurveyQuestionID == question.SurveyQuestionID) // move current question down
                    {
                        if (currentsortorder < maxsortorder)
                            question.SortOrder += 1;
                    }
                    else // find the next item and decrement it
                    {
                        if (sq.SortOrder == currentsortorder + 1)
                        {
                            sq.SortOrder -= 1;
                            db.Entry(sq).State = EntityState.Modified;
                        }
                    }
                }
            }

            db.SaveChanges();
        }
 public void UpdateSurveyQuestion(SurveyQuestion surveyquestion)
 {
     db.Entry(surveyquestion).State = EntityState.Modified;
     db.SaveChanges();
 }