public Question load(int id) { Question question = new Question(); question.Id = id; question.QuestionsContent = EncryptWorker.getInstance().decrypt( DataSetConverter.fromDsToSingle.toString.convert( SqlLiteSimpleExecute.execute(queryConfigurator.loadQuestionContent(id)))); int[] unswersIds = DataSetConverter.fromDsToBuf.toIntBuf.convert( SqlLiteSimpleExecute.execute(queryConfigurator.loadQuestionUnswersIds(id))); question.Unswers = new List <Unswer>(); for (int i = 0; i < unswersIds.Count(); i++) { question.Unswers.Add(unswerManipalator.load(unswersIds[i])); } int questionTypeId = DataSetConverter.fromDsToSingle.toInt.convert( SqlLiteSimpleExecute.execute(queryConfigurator.loadQuestionTypeId(id))); string questionType = DataSetConverter.fromDsToSingle.toString.convert( SqlLiteSimpleExecute.execute(queryConfigurator.getObjectName(questionTypeId))); if (questionType.Equals(QuestionTypes.multiplyAnswer.getType())) { question.QuestionsType = QuestionTypes.multiplyAnswer; return(question); } if (questionType.Equals(QuestionTypes.singleAnswer.getType())) { question.QuestionsType = QuestionTypes.singleAnswer; return(question); } throw new ParamsTypesExceptions(); }
public Subject getSubjectFromBD(int id) { string name = DataSetConverter.fromDsToSingle.toString.convert(SqlLiteSimpleExecute. execute(queryConfigurator.getObjectName(id))); return(subjectManipulator.load(name, true, true)); }
public Unswer load(int id) { Unswer unswer = new Unswer(); unswer.Id = id; string lastQuery = ""; try { lastQuery = queryConfigurator.loadUnswerContent(id); unswer.Content = EncryptWorker.getInstance().decrypt( DataSetConverter.fromDsToSingle.toString.convert(SqlLiteSimpleExecute. execute(queryConfigurator.loadUnswerContent(id)))); lastQuery = queryConfigurator.loadUnswerTypeId(id); int typeId = DataSetConverter.fromDsToSingle.toInt.convert(SqlLiteSimpleExecute. execute(queryConfigurator.loadUnswerTypeId(id))); lastQuery = queryConfigurator.getObjectName(typeId); string type = DataSetConverter.fromDsToSingle.toString.convert(SqlLiteSimpleExecute. execute(queryConfigurator.getObjectName(typeId))); if (type.Equals(DbObjects.rightUnswer.getName())) { unswer.IsRight = true; return(unswer); } if (type.Equals(DbObjects.unswer.getName())) { unswer.IsRight = false; return(unswer); } } catch (СonversionError err) { throw new СonversionError("Ошибка при обработке запроса:" + lastQuery + ". Обратитесь к администратору"); } throw new ParamsTypesExceptions(); }