private void BindGridQuestion()
{
int? getChaptersPerDay = 0;
int lessonCompleted = 0;
int iSkip = 0;
string username = hdnusername.Value;
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
var newuser = DataServiceWord.NewUser(username);
if (newuser == 0)
{
imgPrevious.Visible = false;
getChaptersPerDay = DataServiceWord.GetTopicsPerChapter(lessonCompleted + 1);
iSkip = 0;
}
else
{
//skip sum coursemst topic and take nect lesson
//iSkip=
//getChaptersPerDay
}
grdWord.DataSource = DataServiceWord.LoadChapters(getChaptersPerDay);
grdWord.DataBind();
}
}
public static Int32 NewUser(string username)
{
Int32 result = 0;
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
result = db.Beg_WordResult.Where(x => x.Username == username).ToList().Count;
}
return result;
}
public static int? GetTopicsPerChapter(Int32 lessoncompleted)
{
int? result = 0;
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
result = db.Beg_WordCourse.Where(x => x.Lesson == lessoncompleted).Select(x => x.Topics).SingleOrDefault();
}
return result;
}
public static int? GetNumQuestTaken(string username, int? getChaptersPerDay)
{
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
List<int?> result1 = db.Beg_WordUserTest.Where(x => x.Username == username).Select(x => x.BegWordTestId).ToList();
List<int> result2 = db.Beg_WordTest.Select(x => x.Id).ToList();
var differences = result2.Where(i => !result1.Contains(i)).ToList();
int diff = differences[0];
return diff;
}
}
public static List<LearningWord> LoadChapters(int? getchaptersperday)
{
List<LearningWord> resultList;
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
resultList = db.Beg_Word.Join(db.Beg_WordTranslate, x => x.Id, y => y.BegWordId, (x, y) => new { x, y })
.Join(db.Beg_WordFiles, a => a.x.Id, b => b.BegWordId, (a, b) => new { a, b })
.Take(Convert.ToInt32(getchaptersperday))
.Select(xy => new LearningWord()
{
BegPrId = xy.a.x.Id,
CapitalLetters = xy.a.x.Word,
Kannada = xy.a.y.Kannada,
Hindi = xy.a.y.Hindi,
Play = xy.b.Play
}).ToList();
}
return resultList;
}
protected void OnClick_Next(object sender, EventArgs e)
{
//UpdateTimer.Enabled = true;
int? getChaptersPerDay = 0;
int? getNumQuestTaken = 0;
int lessonCompleted = 0;
int iSkip = 0;
int i;
ViewState["questnum"] = 0;
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
var newuser = DataServiceWord.NewUser(hdnusername.Value);
if (newuser == 0)
{
getChaptersPerDay = DataServiceWord.GetTopicsPerChapter(lessonCompleted + 1);
getNumQuestTaken = DataServiceWord.GetNumQuestTaken(hdnusername.Value, getChaptersPerDay);
ViewState["questnum"] = getNumQuestTaken;
imgPrevious.Visible = false;
iSkip = 0;
}
else
{
ViewState["questnum"] = Convert.ToInt32(ViewState["questnum"]) + 1;
//skip sum coursemst topic and take nect lesson
//iSkip=
//getChaptersPerDay
}
List<DataServiceWord.LearningQuiz> quest = DataServiceWord.LoadQuiz(Convert.ToInt32(ViewState["questnum"]));
lblQuest.Text = quest[0].QuestionNum + " " + quest[0].Question;
hdnAn.Value = Convert.ToString(quest[0].An);
hdnMainQuestid.Value = Convert.ToString(quest[0].BegPrId);
hdnTestQuestid.Value = Convert.ToString(quest[0].IdTestquiz);
hdnTestQuestDay.Value = Convert.ToString(quest[0].IdquizDay);
}
grdWord.Visible = false;
BindGridQuiz(getChaptersPerDay, Convert.ToInt32(hdnMainQuestid.Value));
btnsubmit.Visible = true;
}
public static bool ResultPassorFail(string testday, string username)
{
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
bool res = false;
var results = db.Beg_WordUserTest.AsNoTracking().Where(x => x.Day == testday && x.Username == username).ToList();
foreach (var result in results)
{
if (result.Answer == result.Question)
{
res = true;
}
else
{
res = false;
break;
}
}
return res;
}
}
public static bool SendBacktoSameCourse(string testday, string username)
{
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
using (var trans = db.Database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
try
{
var removeusertest = db.Beg_WordUserTest.Where(x => x.Username == username && x.Day == testday).ToList();
db.Beg_WordUserTest.RemoveRange(removeusertest);
db.SaveChanges();
trans.Commit();
return false;
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
}
}
public static int GetquestAnswered(string testid, string username)
{
int? result;
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
result =
db.Beg_WordUserTest.AsNoTracking()
.Where(x => x.Username == username && x.Day == testid.ToString())
.ToList()
.Count();
}
return result.GetValueOrDefault();
}
public static int GetCoursemst(int testid)
{
int? result;
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
//var getquestioninfo = db.Beg_Test.SingleOrDefault(x => x.Id == testid);
result = db.Beg_WordCourse.AsNoTracking().Where(x => x.Lesson == testid).Select(x => x.Topics).SingleOrDefault();
}
return result.GetValueOrDefault();
}
public static void AnswerGiven(int testid, string username, int begid)
{
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
using (var trans = db.Database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
try
{
var getquestioninfo = db.Beg_WordTest.SingleOrDefault(x => x.Id == testid);
var getAnstext = db.Beg_Word.SingleOrDefault(x => x.Id == begid);
var testgiven = new Beg_WordUserTest()
{
BegWordId = getquestioninfo.BegWordId,
Username = username,
BegWordTestId = testid,
Day = getquestioninfo.Day,
Question = getquestioninfo.Question,
QuestionNumber = getquestioninfo.QuestionNumber,
Answer = getAnstext.Word
};
db.Beg_WordUserTest.Add(testgiven);
db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
}
}
public static List<LearningWord> LoadQuizWithRandomSet(int? getchaptersperday, Int32 id, string username)
{
// int? nam=0;
List<LearningWord> resultList = null;
List<LearningWord> resultRandomList = null;
List<LearningWord> resultList1 = null;
Int32 i = 0;
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
List<int?> randomnum = RandomService.GenerateRandom();
var testid = db.Beg_WordUserTest.Where(x => x.Username == username).Select(x => x.BegWordTestId).Distinct().ToList();
//takequestion
resultList =
db.Beg_WordTest.AsNoTracking()
.Join(db.Beg_WordTranslate, x => x.BegWordId, y => y.BegWordId, (x, y) => new { x, y })
.Join(db.Beg_WordFiles, a => a.x.BegWordId, b => b.BegWordId, (a, b) => new { a, b })
// .Take(Convert.ToInt32(getchaptersperday))
.Where(x => x.a.x.BegWordId == id).Take(1)
.Select(xy => new LearningWord()
{
idName = xy.a.x.Id,
BegPrId = xy.a.x.BegWordId,
Kannada = xy.a.y.Kannada,
Hindi = xy.a.y.Hindi,
Play = xy.b.Play
}).ToList();
// nam = resultList[0].idName;
resultRandomList =
db.Beg_Word.Join(db.Beg_WordTranslate, x => x.Id, y => y.BegWordId, (x, y) => new { x, y })
.Join(db.Beg_WordFiles, a => a.x.Id, b => b.BegWordId, (a, b) => new { a, b })
.Join(db.Beg_WordTest, aa => aa.a.x.Id, bb => bb.BegWordId, (aa, bb) => new { aa, bb })
.Take(Convert.ToInt32(getchaptersperday))
.Where(xx => randomnum.Contains(xx.aa.a.x.Id))
.Select(xy => new LearningWord()
{
idName = xy.bb.Id,
BegPrId = xy.aa.a.x.Id,
Kannada = xy.aa.a.y.Kannada,
Hindi = xy.aa.a.y.Hindi,
Play = xy.aa.b.Play
}).ToList();
resultList1 = resultList.Union(resultRandomList).ToList();
}
return resultList1;
}
public static List<LearningQuiz> LoadQuiz(int? getchaptersperday)
{
//4 quest
//gets first record
//List<Learning> randomList = LoadChapters(getchaptersperday);
List<LearningQuiz> resultList;
//randomList = randomList.Where(x => RandomService.GenerateRandom().Contains(x.BegPrId )).ToList();
using (dbExtranetEntitiesWord db = new dbExtranetEntitiesWord())
{
//load question
resultList =
db.Beg_WordTest.AsNoTracking().Join(db.Beg_WordTranslate, x => x.Id, y => y.BegWordId, (x, y) => new { x, y })
.Join(db.Beg_WordFiles, a => a.x.Id, b => b.BegWordId, (a, b) => new { a, b })
.Where(x => x.a.x.Id == getchaptersperday)
.Select(xy => new LearningQuiz()
{
IdTestquiz = xy.a.x.Id,
IdquizDay = xy.a.x.Day,
QuestionNum = xy.a.x.QuestionNumber,
Question = xy.a.x.Question,
An = xy.a.x.Answer,
BegPrId = xy.a.x.BegWordId
}).ToList();
}
return resultList;
}
