//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);
}
