//Create Questions for quiz. This is awesome public int CreateQuestion(questionModel quesData) { int result = 0; using (myProjectEntities context = new myProjectEntities()) { Mapper.CreateMap <questionModel, tblQuizQuestion>(); tblQuizQuestion newQues = Mapper.Map <questionModel, tblQuizQuestion>(quesData); List <tblQuizOption> newOpt = new List <tblQuizOption>(); Mapper.CreateMap <optionModel, tblQuizOption>(); foreach (optionModel opt in quesData.optionModel) { tblQuizOption o = Mapper.Map <optionModel, tblQuizOption>(opt); newOpt.Add(o); } newQues.tblQuizOptions = newOpt.ToList(); context.tblQuizQuestions.Add(newQues); //Execute the add function int q = context.SaveChanges(); if (q > 0) { result = newQues.PK_Question_id; //set return to true } } return(result); }
//Get individual options of the question public optionModel GetOptionById(int optId) { using (myProjectEntities context = new myProjectEntities()) { tblQuizOption pro = context.tblQuizOptions.Where(q => q.PK_Option_id == optId).FirstOrDefault(); Mapper.CreateMap <tblQuizOption, optionModel>(); optionModel result = Mapper.Map <tblQuizOption, optionModel>(pro); return(result); } }
//Create Options public bool CreateOption(optionModel optionData) { bool result = false; using (myProjectEntities context = new myProjectEntities()) { Mapper.CreateMap <optionModel, tblQuizOption>(); tblQuizOption newOpt = Mapper.Map <optionModel, tblQuizOption>(optionData); context.tblQuizOptions.Add(newOpt); //Execute the add function int q = context.SaveChanges(); if (q == 1) { result = true; //set return to true } } return(result); }
//Update Options public bool UpdateOption(optionModel optionData) { bool result = false; using (myProjectEntities context = new myProjectEntities()) { Mapper.CreateMap <optionModel, tblQuizOption>(); tblQuizOption s = Mapper.Map <optionModel, tblQuizOption>(optionData); context.Entry(s).State = EntityState.Modified; int q = context.SaveChanges(); if (q == 1) { result = true; } return(result); } }
//Updated public int Question_Create(questionModel quesData) { int result = 0; using (myProjectEntities context = new myProjectEntities()) { Mapper.CreateMap <questionModel, tblQuizQuestion>(); tblQuizQuestion newQues = Mapper.Map <questionModel, tblQuizQuestion>(quesData); if (quesData.question_type == "Optional" || quesData.question_type == "Multiple Choice")//Check is not options { List <tblQuizOption> newOpt = new List <tblQuizOption>(); Mapper.CreateMap <optionModel, tblQuizOption>(); foreach (optionModel opt in quesData.optionModel) { tblQuizOption o = Mapper.Map <optionModel, tblQuizOption>(opt); newOpt.Add(o); } newQues.tblQuizOptions = newOpt.ToList(); } context.tblQuizQuestions.Add(newQues); //Execute the add function int q = context.SaveChanges(); if (q > 0) { result = newQues.PK_Question_id; //set return to true } tblQuizDetail quizDetail = context.tblQuizDetails.Where(a => a.PK_Quiz_id == newQues.FK_Quiz_id).FirstOrDefault(); quizDetail.quiz_weightage = quizDetail.quiz_weightage + (float)newQues.marks; context.Entry(quizDetail).State = EntityState.Modified; context.SaveChanges(); } return(result); }