public ActionResult UpdteQuestions(string index) { //Updating questions with Ajax ////////////////////////////// int indx = Convert.ToInt32(index); currentThemeId = indx; /////////////////////////////////////////////////////////////////////////////////////////// List <FilterQuestions> data = null; using (DiplomeEntities db = new DiplomeEntities()) { data = (from quest in db.AllQuestions join theme in db.Themes on quest.Theme_id equals theme.id where theme.id == indx select new FilterQuestions { Id = quest.Id, Theme_Questions = quest.Question }).ToList(); } return(PartialView("_question", data)); }
public void CreateQuestion(string Id)///////////////////////////////////////////////////////////////////////////////// { int indx = Convert.ToInt32(Id); List <QuestAnswers> data = null; using (DiplomeEntities db = new DiplomeEntities()) { data = (from quest in db.AllQuestions join answ in db.AllAnswers on quest.Id equals answ.AllQuest_Id where quest.Id == indx select new QuestAnswers { Subject = quest.Question, Questions = answ.Answers, RightId = answ.right_Answ_id }).ToList(); } questId = indx; //Question Id Session["myquestions"] = data; }
public ActionResult Index(string email, string password) { //string email = "*****@*****.**"; //string password = "******"; List <FilterQuestions> quens = null; List <Lectures> lections = null; List <Themes> themes = null; using (DiplomeEntities db = new DiplomeEntities()) { if (db.Proffesors.ToList().Exists(prof => prof.Email == email && prof.Password == password)) { var prof = db.Proffesors.Single(p => p.Email == email); Session["prof"] = prof.Name + " " + prof.Surname; quens = (from quest in db.AllQuestions join theme in db.Themes on quest.Theme_id equals theme.id join lessn in db.Lessons on theme.Lesson_id equals lessn.Id where lessn.Id == prof.Id select new FilterQuestions { Theme_Questions = quest.Question }).ToList(); lections = (from lecture in db.Lessons where lecture.Proffesor_Id == prof.Id select new Lectures { _Lectures = lecture.Lectures, id = lecture.Id }).ToList(); themes = (from theme in db.Themes join lecture in db.Lessons on theme.Lesson_id equals lecture.Id where lecture.Proffesor_Id == prof.Id && theme.Lesson_id == lecture.Id select new Themes { _Themes = theme.Lect_themes, id = theme.id }).ToList(); Session["lections"] = lections; Session["themes"] = themes; //Session["date"] = null; return(RedirectToAction("DayStatic")); } else { ModelState.AddModelError("Error", "Wrong login or password"); } }//Calling Dispose method return(View("LoginProf")); }
public ActionResult Statistics() { //////////////////////////////////////////// List <StatiscticsModel> statistics = new List <StatiscticsModel>(); List <StatisticLists> studentStats = new List <StatisticLists>(); List <string> test; using (DiplomeEntities db = new DiplomeEntities()) { statistics = (from stud_answ in db.Stud_Answers join student in db.Students on stud_answ.stud_id equals student.Id //where stud_answ.theme_id == currentThemeId group stud_answ by new { student.Name, student.Surname, stud_answ.answer_data } into gr orderby gr.Key.Name, gr.Key.Surname select new StatiscticsModel { Name = gr.Key.Name + " " + gr.Key.Surname, Percent = gr.Average(g => g.answer_percent), Date = gr.Key.answer_data }).ToList(); test = (from stati in statistics group stati by new { stati.Name } into g select g.Key.Name).ToList(); } foreach (var item in test) { StatisticLists st = new StatisticLists(); st.Name = item; List <double> percents = (from stati in statistics where stati.Name == item select stati.Percent).ToList(); List <DateTime> datas = (from stati in statistics where stati.Name == item select stati.Date).ToList(); st.Percents = percents; st.Datas = datas; studentStats.Add(st); } var stat = JsonConvert.SerializeObject(studentStats); Session["Statistics"] = stat; return(View()); }
public ActionResult Chart() { List <string> smartNames = new List <string>(); List <string> badNames = new List <string>(); List <string> alwaysSmart = new List <string>(); int answersCount; using (DiplomeEntities db = new DiplomeEntities()) { answersCount = db.StudAnswers_live.Select(s => s.Question_Id).Distinct().Count(); smartNames = (from student in db.Students join stud_answersLive in db.StudAnswers_live on student.Id equals stud_answersLive.Stud_Id where stud_answersLive.Stud_Answer == 1 && stud_answersLive.Question_Id == AdminController.questId select student.Name + " " + student.Surname).ToList(); badNames = (from student1 in db.Students join stud_answersLive in db.StudAnswers_live on student1.Id equals stud_answersLive.Stud_Id where stud_answersLive.Stud_Answer == 0 && stud_answersLive.Question_Id == AdminController.questId select student1.Name + " " + student1.Surname).ToList(); alwaysSmart = (from student2 in db.Students join stud_answersLive in db.StudAnswers_live on student2.Id equals stud_answersLive.Stud_Id where stud_answersLive.Stud_Answer == 1 group stud_answersLive by new { stud_answersLive.Stud_Answer, student2.Name, student2.Surname } into g where (g.Sum(p => p.Stud_Answer)) == answersCount select g.Key.Name + "" + g.Key.Surname).ToList(); } var smrtNames = JsonConvert.SerializeObject(smartNames); var bdNames = JsonConvert.SerializeObject(badNames); var alwSmart = JsonConvert.SerializeObject(alwaysSmart); return(Json(new[] { smrtNames, bdNames, alwSmart })); }
public ActionResult _updtTheme(string index) { //Updating themes with Ajax ////////////////////////////// int indx = Convert.ToInt32(index); List <Themes> themes = null; using (DiplomeEntities db = new DiplomeEntities()) { themes = (from theme in db.Themes join lecture in db.Lessons on theme.Lesson_id equals lecture.Id where theme.Lesson_id == indx select new Themes { _Themes = theme.Lect_themes, id = theme.id }).ToList(); } Session["themes"] = themes; string indxx = (themes.First(x => x.id == x.id)).id.ToString(); return(PartialView("_DropDowns", themes)); }
public void Answers(string userAnswer, string userId, string rightIndex, string selectedIndex) //Stugel { string htmlTags = string.Empty; int userAnswerr = Convert.ToInt32(userAnswer); // change int userID = Convert.ToInt32(userId); int rightindex = Convert.ToInt32(rightIndex); int slctindex = Convert.ToInt32(selectedIndex); StudAnswers_live studAnswLive = new StudAnswers_live() { Stud_Id = userID, Question_Id = AdminController.questId, Stud_Answer = userAnswerr, Data = DateTime.UtcNow.Date }; Stud_Answers stud_Answers = new Stud_Answers() { stud_id = userID, theme_id = AdminController.currentThemeId, answer_percent = userAnswerr == 1 ? 100 : 0, answer_data = DateTime.UtcNow.Date }; using (DiplomeEntities db = new DiplomeEntities()) { db.StudAnswers_live.Add(studAnswLive); db.Stud_Answers.Add(stud_Answers); db.SaveChanges(); } htmlTags += "<div class='col-sm-3 col-xs'> <div class='card card-3'>"; htmlTags += "<p>Arman Amrazyan</p>"; #region IF-ELSE if (userAnswerr == 1) { for (int i = 0; i < 4; i++) { if (i == rightindex) { htmlTags += "<div class='test test-gr'></div>"; } else { htmlTags += "<div class='test'></div>"; } } } else { for (int i = 0; i < 4; i++) { if (i == rightindex) { htmlTags += "<div class='test test-gr'></div>"; continue; } if (i == slctindex) { htmlTags += "<div class='test test-red'></div>"; continue; } htmlTags += "<div class='test'></div>"; } } #endregion htmlTags += "</div> </div>"; OnlineStudentAnswersST.StudList.Add(htmlTags); }