//To save complete quiz in one go
public bool quizAnswer(List <QuizResultModel> quizRData)
{
bool result = false;
Stopwatch st = new Stopwatch();
using (myProjectEntities context = new myProjectEntities())
{
for (int i = 0; i < quizRData.Count; i++)
{
Mapper.CreateMap <QuizResultModel, tblQuizResult>();
tblQuizResult newQuizR = Mapper.Map <QuizResultModel, tblQuizResult>(quizRData[i]);
context.tblQuizResults.Add(newQuizR);
}
int q = context.SaveChanges();
//Mapper.CreateMap<QuizResultModel, tblQuizResult>();
//List<tblQuizResult> newQuizR = Mapper.Map<List<QuizResultModel>, List<tblQuizResult>>(quizRData);
//st.Restart();
//context.tblQuizResults.AddRange(newQuizR);
//st.Stop();
//st.Restart();
//context.SaveChanges();
//st.Stop();
}
return(result);
}
public DataSet getAllModuleByTerm(string term)
{
DataSet ds = new DataSet();
using (myProjectEntities context = new myProjectEntities())
{
List <tblDepartmentModule> depModules = context.tblDepartmentModules.Where(w => w.term == term).ToList();
foreach (tblDepartmentModule dep in depModules)
{
List <tblQuizDetail> qDetail = context.tblQuizDetails.Where(q => q.FK_ModuleId == dep.PK_Module_id).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("quiz");
dt.Columns.Add("marks");
foreach (tblQuizDetail item in qDetail)
{
tblQuizResult r = context.tblQuizResults.Where(q => q.FK_QuizId == item.PK_Quiz_id).FirstOrDefault();
if (r != null)
{
var totalMarks = context.tblQuizResults.Where(q => q.FK_QuizId == item.PK_Quiz_id).Select(q => q.marks).AsEnumerable();
float d = float.Parse(totalMarks.Aggregate((a, b) => a + b).ToString());
float s = (float)item.quiz_weightage;
float per = d / s * 100;
dt.Rows.Add(item.quiz_title, per);
}
}
if (dt.Rows.Count > 0)
{
ds.Tables.Add(dt);
}
}
}
return(ds);
}
//try enter
public bool quizAnswerSave(QuizResultModel quizRData)
{
bool result = false;
Stopwatch st = new Stopwatch();
using (myProjectEntities context = new myProjectEntities())
{
Mapper.CreateMap <QuizResultModel, tblQuizResult>();
tblQuizResult newQuizR = Mapper.Map <QuizResultModel, tblQuizResult>(quizRData);
context.tblQuizResults.Add(newQuizR);
int q = context.SaveChanges();
}
return(result);
}
//Save individual question of the quiz
public bool startQuiz(QuizResultModel quizRData)
{
bool result = false;
using (myProjectEntities context = new myProjectEntities())
{
Mapper.CreateMap <QuizResultModel, tblQuizResult>();
tblQuizResult newQuizR = Mapper.Map <QuizResultModel, tblQuizResult>(quizRData);
context.tblQuizResults.Add(newQuizR);
//context.Entry(newQuizR).State = EntityState.Modified;
int q = context.SaveChanges();
if (q > 0)
{
result = true;
}
}
return(result);
}
