public ActionResult GridView1PartialAddNew(iys.ModelProject.CHAPTER item) { var model = db.CHAPTERS; //if (ModelState.IsValid) //{ try { item.CHAPTER_CODE = 0; item.RES_CODE = 0; item.VISIBLE = true; item.ROW_NO = 0; // item.DURATION = TimeSpan.Zero; item.CREATE_USER = getCurrentUserName(); item.CREATE_DATE = DateTime.Now; item.LAST_UPDATE = DateTime.Now; item.LAST_UPDATE_USER = getCurrentUserName(); model.Add(item); db.SaveChanges(); } catch (Exception e) { ViewData["EditError"] = e.Message; } //} //else // ViewData["EditError"] = "Please, correct all errors."; return(PartialView("_GridView1Partial", model.ToList())); }
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")); } }