public Test load(int testId, bool loadAllQuestions, bool loadOnlyTestNames) { Test test = new Test(); test.Id = testId; test.Name = EncryptWorker.getInstance().decrypt( DataSetConverter.fromDsToSingle.toString. convert(SqlLiteSimpleExecute.execute(queryConfigurator.loadTestName(testId)))); if (!loadOnlyTestNames) { test.QuestionsNumber = DataSetConverter.fromDsToSingle.toInt. convert(SqlLiteSimpleExecute. execute(queryConfigurator.loadTestQuestionCount(testId))); test.RequeredUnswersNumber = DataSetConverter.fromDsToSingle.toInt. convert(SqlLiteSimpleExecute.execute(queryConfigurator. loadTestRequiredQuestionCount(testId))); int[] questionsIds = DataSetConverter.fromDsToBuf.toIntBuf.convert( SqlLiteSimpleExecute.execute(queryConfigurator.loadTestQuestionIds(testId))); if (loadAllQuestions) { test.Questions = questionsGetter.get(questionsIds); } else { test.Questions = questionsGetter.get(questionsIds, test.QuestionsNumber); } } return(test); }
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 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(Subject subject) { SqlLiteSimpleExecute.execute(queryConfigurator.createSubject( EncryptWorker.getInstance().encrypt(subject.Name))); for (int i = 0; i < subject.Tests.Count; i++) { testManipulator.create(subject.Tests.ElementAt(i), subject.Id); } SqlLiteSimpleExecute.execute(queryConfigurator.setApproveStatusToObject( DbTypes.subject)); }
public void update(Subject subject) { SqlLiteSimpleExecute.execute(queryConfigurator.updateSubjectName( subject.Id, EncryptWorker.getInstance().encrypt(subject.Name))); for (int i = 0; i < subject.Tests.Count; i++) { try { testManipulator.update(subject.Tests.ElementAt(i), subject.Id); } catch (ObjectIsNotExistYet ex) { testManipulator.create(subject.Tests.ElementAt(i), subject.Id); } } }
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 Subject load(string name, bool loadOnlySubjectAndTestNamesWithoutChilds, bool loadAllQuestions) { Subject sub = new Subject(); sub.Id = DataSetConverter.fromDsToSingle.toInt.convert(SqlLiteSimpleExecute. execute(queryConfigurator.getSubjectId(name))); sub.Name = EncryptWorker.getInstance().decrypt(name); int[] testIds = DataSetConverter.fromDsToBuf.toIntBuf.convert(SqlLiteSimpleExecute. execute(queryConfigurator.loadSubjectTestIds(sub.Id))); for (int i = 0; i < testIds.Length; i++) { sub.Tests.Add(testManipulator.load(testIds[i], loadAllQuestions, loadOnlySubjectAndTestNamesWithoutChilds)); } return(sub); }
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)); }
public void update(Test test, int subjectId) { if (DataSetConverter.fromDsToSingle.toInt.convert( SqlLiteSimpleExecute.execute(queryConfigurator.countOfObject(test.Id))) == 0) { throw new ObjectIsNotExistYet(); } SqlLiteSimpleExecute.execute(queryConfigurator.updateTestsSubject( test.Id, subjectId)); SqlLiteSimpleExecute.execute(queryConfigurator.updateTestName( test.Id, EncryptWorker.getInstance().encrypt(test.Name))); int id = test.Id; SqlLiteSimpleExecute.execute(queryConfigurator. updateTestsQuestionsNumber(id, test.QuestionsNumber)); SqlLiteSimpleExecute.execute(queryConfigurator. updateTestsRequeredUnswersNumber(id, test.RequeredUnswersNumber)); for (int i = 0; i < test.Questions.Count; i++) { try { if (test.Questions.ElementAt(i).IsDeleted) { test.Questions.ElementAt(i).delete(); } else { questionManipulator.update(test.Questions.ElementAt(i)); } } catch (ObjectIsNotExistYet ex) { questionManipulator.create(test.Questions.ElementAt(i), test.Id); } } }
public void update(Unswer unswer) { if (DataSetConverter.fromDsToSingle.toInt.convert( SqlLiteSimpleExecute.execute(queryConfigurator.countOfObject(unswer.Id))) == 0) { throw new ObjectIsNotExistYet(); } if (unswer.IsRight) { SqlLiteSimpleExecute.execute(queryConfigurator.updateUnswerContent( unswer.Id, EncryptWorker.getInstance().encrypt(unswer.Content))); SqlLiteSimpleExecute.execute(queryConfigurator.updateUnswerType( unswer.Id, DbObjects.rightUnswer)); } else { SqlLiteSimpleExecute.execute(queryConfigurator.updateUnswerContent( unswer.Id, EncryptWorker.getInstance().encrypt(unswer.Content))); SqlLiteSimpleExecute.execute(queryConfigurator.updateUnswerType( unswer.Id, DbObjects.unswer)); } }
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(); }
public void init() { // //Exceptions init // ConcreteExceptionHandlerInitializer.initThisExceptionHandler( ExceptionHandler.Realization.ExceptionHandler.getInstance()); try { // //Config tabs // form.tabControl1Elem.Appearance = TabAppearance.FlatButtons; form.tabControl1Elem.ItemSize = new Size(0, 1); form.tabControl1Elem.SizeMode = TabSizeMode.Fixed; form.tabControl1Elem.TabStop = false; // //Config tables // form.dataGridView1Elem.RowHeadersVisible = false; form.dataGridView2Elem.RowHeadersVisible = false; // //Config other views components // form.textBox11Elem.ReadOnly = true; // //Security component // SecurityModel securityModel = new SecurityModel(); components.securityController = new SecurityController(securityModel); AutorizationSecurityView securityView = new AutorizationSecurityView(form, securityModel); EncryptConfig conf = new EncryptConfig(new byte[] { 0x7c, 0x26, 0xf0, 0xc6, 0x77, 0xaa, 0xba, 0x6a, 0x66, 0x7b, 0x56, 0x0f, 0x98, 0x43, 0xba, 0x2d, 0xbb, 0x06, 0x0a, 0xef, 0xad, 0x32, 0x88, 0xb0, 0x5d, 0xfb, 0xfe, 0x98, 0xa7, 0xa7, 0xa5, 0x1a }); EncryptWorker.getInstance().setConfig(conf); // //goTest component // GoTestModel goTestModel = new GoTestModel(); components.goTestController = new GoTestController(goTestModel); components.questionsViewAdapter = new GoTestAdapter(); components.updateSubjectViewAdapter = new GoTestAdapter(); components.сreateSubjectViewAdapter = new GoTestAdapter(); components.testingViewAdapter = new GoTestAdapter(); components.deletingSubjectViewAdapter = new GoTestAdapter(); components.deletingTestViewAdapter = new GoTestAdapter(); // //Navigator // Navigator.Navigator.getInstance().addView(securityView); Navigator.Navigator.getInstance().addView(new CreateAdminView(form)); Navigator.Navigator.getInstance().addView(new AdminMenuView(form)); Navigator.Navigator.getInstance().addView(new StudentMenuView(form)); Navigator.Navigator.getInstance().addView(new ChangePasswordView(form)); Navigator.Navigator.getInstance().addView(new DeleteSubjectView(form, components.deletingSubjectViewAdapter, goTestModel)); Navigator.Navigator.getInstance().addView(new DeleteTestView(form, components.deletingTestViewAdapter, goTestModel)); Navigator.Navigator.getInstance().addView(new UpdateTestView(form, components.questionsViewAdapter, goTestModel)); Navigator.Navigator.getInstance().addView(new UpdateSubjectView(form, components.updateSubjectViewAdapter, goTestModel)); Navigator.Navigator.getInstance().addView(new TestingView(form, components.testingViewAdapter, goTestModel)); Navigator.Navigator.getInstance().addView(new ProcessingTestingView(form, components.testingViewAdapter, goTestModel)); Navigator.Navigator.getInstance().addView(new ResultTestingView(form, goTestModel)); Navigator.Navigator.getInstance().addView(new CreateSubjectView(form, components.сreateSubjectViewAdapter)); CreateTestView createTestView = new CreateTestView(form, components.questionsViewAdapter, goTestModel); goTestModel.subscribe(createTestView); Navigator.Navigator.getInstance().addView(createTestView); Navigator.Navigator.getInstance().addView(new QuestionsView(form, components.questionsViewAdapter, goTestModel)); Navigator.Navigator.getInstance().navigateTo("AutorizationSecurityView"); // //ReadConfig // ConfigReader.getInstance().read(); // //Check database // components.securityController.checkDataBase(); form.button1Elem.Visible = true; form.button8Elem.Visible = true; /* * // * //ТОЛЬКО ДЛЯ ОТЛАДКИ, ПОТОМ УБРАТЬ * // * form.textBox1Elem.Text = "Admin"; * form.textBox2Elem.Text = "1234"; */ } catch (Exception ex) { form.button1Elem.Visible = false; form.button8Elem.Visible = false; ExceptionHandler.Realization.ExceptionHandler.getInstance().processing(ex); } }
public void update(Question question) { if (DataSetConverter.fromDsToSingle.toInt.convert( SqlLiteSimpleExecute.execute(queryConfigurator.countOfObject(question.Id))) == 0) { throw new ObjectIsNotExistYet(); } SqlLiteSimpleExecute.execute(queryConfigurator.updateQuestionContent(question.Id, EncryptWorker.getInstance().encrypt(question.QuestionsContent))); int rightUnswersCount = 0; for (int i = 0; i < question.Unswers.Count; i++) { if (question.Unswers.ElementAt(i).IsRight) { rightUnswersCount++; } } if ((question.QuestionsType.getType().Equals(QuestionTypes.singleAnswer)) & (rightUnswersCount == 0 | rightUnswersCount > 1)) { throw new QuestionTypeException(); } if (question.QuestionsType.getType().Equals(QuestionTypes.multiplyAnswer) & rightUnswersCount < 2) { throw new QuestionTypeException(); } if (question.QuestionsType.getType().Equals(DbObjects.multiplyAnswer.getName())) { SqlLiteSimpleExecute.execute(queryConfigurator.updateQuestionType(question.Id, DbObjects.multiplyAnswer)); } else { SqlLiteSimpleExecute.execute(queryConfigurator.updateQuestionType(question.Id, DbObjects.singleAnswer)); } for (int i = 0; i < question.Unswers.Count; i++) { try { if (question.Unswers.ElementAt(i).IsDeleted) { question.Unswers.ElementAt(i).delete(); } else { unswerManipalator.update(question.Unswers.ElementAt(i)); } } catch (ObjectIsNotExistYet ex) { unswerManipalator.create(question.Unswers.ElementAt(i), question.Id); } } }