public ActionResult getContentDocumant(int DocumentCode) { using (iysContext db = new iysContext()) { string user = User.Identity.Name; int DocumentCodeBefore = DocumentCode - 1; USER_QUIZ_STATUS quiz = db.USER_QUIZ_STATUSS.Where(x => x.USER_CODE == user).Where(x => x.DOCUMENT_CODE == DocumentCodeBefore).FirstOrDefault(); docDetail d = new docDetail(); if (quiz != null || DocumentCode == 1 || User.IsInRole("Admin")) { DOCUMENT doc = db.DOCUMENTS.Find(DocumentCode); d.sure = Convert.ToInt32(doc.DURATION.Substring(0, 2)) * 60 + Convert.ToInt32(doc.DURATION.Substring(3, 2)); if (doc.DOCUMENT_TYPE == 5)//video { d.path = doc.PATH; } else if (doc.DOCUMENT_TYPE == 6) { d.path = String.Format("<embed src=\"../dersler/{0}\" width=\"600\" height=\"480\">", doc.PATH); } d.hata = 0; } else { d.path = "Bu Dersi Almaya hakkınız yok!.."; d.sure = 0; d.hata = 1; } return(Json(d, JsonRequestBehavior.AllowGet)); } // return "<embed src=\"/Content/pdfd.pdf\" width=\"500\" height=\"375\">"; }
public ActionResult Index() { ViewData["Options"] = new ImageSliderSlideShowDemoOptions(); using (var ctx = new iysContext()) { return(View()); } }
/// <summary> /// tüm Dersleri getirir /// </summary> /// <returns></returns> public static Dictionary <int, string> getCourse() { using (iysContext db = new iysContext()) { return((from d in db.COURSES select new { Key = d.COURSE_CODE, Value = d.COURSE_NAME }).ToDictionary(t => t.Key, t => t.Value)); } }
public ActionResult MasterDetail() { iysContext db = new iysContext(); var model = from d in db.COURSES select d; return(View(model)); }
public ActionResult MasterDetailMasterPartial() { iysContext db = new iysContext(); var model = from d in db.COURSES select d; return(PartialView("MasterDetailMasterPartial", model.ToArray())); }
// // GET: /AdminPanel/ public ActionResult Index() { iysContext db = new iysContext(); var model = from d in db.COURSES select d; return(View(model.ToArray())); }
/// <summary> /// seçilen soruyu getiri /// </summary> /// <returns></returns> public static Dictionary <int, string> getQuestions() { using (iysContext db = new iysContext()) { return((from d in db.QUESTIONS select new { Key = d.QUESTION_CODE, Value = d.DESCRIPTION }).ToDictionary(t => t.Key, t => t.Value)); } }
public ActionResult Exam(int documenCode) { using (iysContext db = new iysContext()) { ViewBag.ExamName = db.DOCUMENTS.Find(documenCode).DOCUMENT_NAME; List <QUESTION> doc = db.QUESTIONS.Where(x => x.DOCUMENT_CODE == documenCode).ToList(); return(View(doc)); } }
/// <summary> /// seçilen soruyu getiri /// </summary> /// <returns></returns> public static Dictionary <int, string> getType(int gruopDes) { using (iysContext db = new iysContext()) { return((from d in db.GROUPS where d.GROUP_CODE == gruopDes select new { Key = d.ID, Value = d.EXP_TR }).ToDictionary(t => t.Key, t => t.Value)); } }
public static string getDocumentString(int documentCode) { using (iysContext db = new iysContext()) { string a = (from d in db.DOCUMENTS where d.DOCUMENT_CODE == documentCode select d.DOCUMENT_NAME).First().ToString(); return(a); } }
public static string getLessonString(int lessonCode) { using (iysContext db = new iysContext()) { string a = (from d in db.LESSONS where d.LESSON_CODE == lessonCode select d.LESSON_NAME).First().ToString(); return(a); } }
/// <summary> /// seçilen dersin bölümlerini getirir /// </summary> /// <returns></returns> public static string getChapterString(int chapterCode) { using (iysContext db = new iysContext()) { string a = (from d in db.CHAPTERS where d.CHAPTER_CODE == chapterCode select d.CHAPTER_NAME).First().ToString(); return(a); } }
/// <summary> /// seçilen dersin bölümlerini getirir /// </summary> /// <returns></returns> public static Dictionary <int, string> getChapter(int course) { using (iysContext db = new iysContext()) { Dictionary <int, string> a = (from d in db.CHAPTERS where d.COURSE_CODE == course select new { Key = d.CHAPTER_CODE, Value = d.CHAPTER_NAME }).ToDictionary(t => t.Key, t => t.Value); return(a); } }
/// <summary> /// seçilen dersin bölümlerini getirir /// </summary> /// <returns></returns> public static Dictionary <int, string> getLesson(int course, int chapter) { using (iysContext db = new iysContext()) { Dictionary <int, string> a = (from d in db.LESSONS where d.COURSE_CODE == course && d.CHAPTER_CODE == chapter select new { Key = d.LESSON_CODE, Value = d.LESSON_NAME }).ToDictionary(t => t.Key, t => t.Value); return(a); } }
/// <summary> /// session daki user bilgilerini getirir /// </summary> /// <returns>user code</returns> public int getCurrentUserName() { int username = -1; using (iysContext db = new iysContext()) { string userId = User.Identity.Name; username = db.USERDETAILS.Where(x => x.NICK_NAME == userId).Select(x => x.USER_CODE).SingleOrDefault(); } return(username); }
public ActionResult MasterDetailDetailPartial(string customerID) { ViewData["COURSE_CODE"] = customerID; int cID = Convert.ToInt32(customerID); iysContext db = new iysContext(); var model = from d in db.CHAPTERS where d.COURSE_CODE == cID select d; return(PartialView("MasterDetailDetailPartial", model.ToArray())); }
public ActionResult ExamChoose(int DOCUMENT_CODE, int count) { using (iysContext db = new iysContext()) { USER_QUIZ_STATUS quiz = new USER_QUIZ_STATUS(); quiz.DOCUMENT_CODE = DOCUMENT_CODE; quiz.DATE = DateTime.Now; quiz.USER_CODE = User.Identity.Name; db.USER_QUIZ_STATUSS.Add(quiz); db.SaveChanges(); List <QUESTION> sorular = db.QUESTIONS.Where(x => x.DOCUMENT_CODE == DOCUMENT_CODE).ToList(); int dogruCevap = 0; for (int i = 0; i < count; i++) { USER_ANSWER answer = new USER_ANSWER(); string question_code = Request.Form["item_QUESTION_CODE_" + i.ToString()].ToString(); string chose = Request.Form[question_code].ToString(); answer.QUESTION_CODE = Convert.ToInt32(question_code); answer.CHOOSE = chose; answer.QUIZ_CODE = quiz.QUIZ_CODE; answer.USER_CODE = User.Identity.Name; db.USER_ANSWERS.Add(answer); //doğre cevap bul if (chose.Equals(sorular.Where(x => x.QUESTION_CODE == answer.QUESTION_CODE).FirstOrDefault().rightChoose)) { dogruCevap++; } } quiz.GRADE = (dogruCevap * 100) / count; db.USER_QUIZ_STATUSS.Attach(quiz); db.Entry(quiz).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } }