public void create(Unswer unswer, int questionId) { if (unswer.IsRight) { SqlLiteSimpleExecute.execute(queryConfigurator.createUnswer(questionId)); unswer.Id = DataSetConverter.fromDsToSingle.toInt.convert(SqlLiteSimpleExecute. execute(queryConfigurator.getObjectIdInDevelopStatus(DbTypes.unswer))); SqlLiteSimpleExecute.execute(queryConfigurator.setUnswerContent(unswer.Id, EncryptWorker.getInstance().encrypt(unswer.Content))); SqlLiteSimpleExecute.execute(queryConfigurator.setUnswerType(unswer.Id, UnswerTypes.rightUnswer)); } else { SqlLiteSimpleExecute.execute(queryConfigurator.createUnswer(questionId)); unswer.Id = DataSetConverter.fromDsToSingle.toInt.convert(SqlLiteSimpleExecute. execute(queryConfigurator.getObjectIdInDevelopStatus(DbTypes.unswer))); SqlLiteSimpleExecute.execute(queryConfigurator.setUnswerContent(unswer.Id, EncryptWorker.getInstance().encrypt(unswer.Content))); SqlLiteSimpleExecute.execute(queryConfigurator.setUnswerType(unswer.Id, UnswerTypes.unswer)); } SqlLiteSimpleExecute.execute(queryConfigurator.setApproveStatusToObject( DbTypes.unswer)); }
public void create(Question question, int testId) { SqlLiteSimpleExecute.execute(queryConfigurator.createQuestion(testId)); question.Id = DataSetConverter.fromDsToSingle.toInt.convert(SqlLiteSimpleExecute. execute(queryConfigurator.getObjectIdInDevelopStatus(DbTypes.question))); SqlLiteSimpleExecute.execute(queryConfigurator.setQuestionContent(question.Id, EncryptWorker.getInstance().encrypt(question.QuestionsContent))); SqlLiteSimpleExecute.execute(queryConfigurator.setQuestionType(question.Id, question.QuestionsType)); for (int i = 0; i < question.Unswers.Count; i++) { unswerManipalator.create(question.Unswers.ElementAt(i), question.Id); } SqlLiteSimpleExecute.execute(queryConfigurator.setApproveStatusToObject( DbTypes.question)); }
public void create(Test test, int subjectId) { SqlLiteSimpleExecute.execute(queryConfigurator.createTest( EncryptWorker.getInstance().encrypt(test.Name), subjectId)); int id = DataSetConverter.fromDsToSingle.toInt.convert(SqlLiteSimpleExecute. execute(queryConfigurator.getObjectIdInDevelopStatus(DbTypes.test))); SqlLiteSimpleExecute.execute(queryConfigurator. setTestsQuestionsNumber(id, test.QuestionsNumber)); SqlLiteSimpleExecute.execute(queryConfigurator. setTestsRequeredUnswersNumber(id, test.RequeredUnswersNumber)); for (int i = 0; i < test.Questions.Count; i++) { questionManipulator.create(test.Questions.ElementAt(i), id); } SqlLiteSimpleExecute.execute(queryConfigurator.setApproveStatusToObject( DbTypes.test)); }