public void Update(SelectableChart question)
        {
            var questionXml = DBNull.Value;

            if (this.connection == null)
            {
                this.connection = new ConnectionProvider();
            }

            this.connection.Db.Items_Update(question.Id, question.QuestionText, question.Notes, string.Empty);

            this.connection.Db.Answers_ByQuestionId_Delete(question.Id);

            foreach (var column in question.Columns)
            {
                var columnXml = new SelectableChart_ColumnXmlModel
                {
                    Id       = column.id,
                    Label    = column.label,
                    Selected = column.selected,
                    Value    = column.value
                };
                var columnXmlSerialized = Serializer.Serialize(columnXml);
                this.connection.Db.Answers_Insert(question.Id, "", null, 0, 0, "", columnXmlSerialized);
            }
            this.connection.Db.SaveChanges();
        }
        public void Create(SelectableChart question)
        {
            var questionXml = DBNull.Value;

            if (this.connection == null)
            {
                this.connection = new ConnectionProvider();
            }

            var questionId = new ObjectParameter("Questionid", typeof(int));

            this.connection.Db.Items_Insert(question.QuestionTypeId, question.QuestionText, question.Notes, string.Empty, questionId);

            question.Id = (int)questionId.Value;

            foreach (var column in question.Columns)
            {
                var columnXml = new SelectableChart_ColumnXmlModel
                {
                    Id       = column.id,
                    Label    = column.label,
                    Selected = column.selected,
                    Value    = column.value
                };
                var columnXmlSerialized = Serializer.Serialize(columnXml);
                this.connection.Db.Answers_Insert(question.Id, "", null, 0, 0, "", columnXmlSerialized);
            }
            this.connection.Db.SaveChanges();
        }