public JsonResult Delete(int Qid) { bool result = false; QuesDetail Active1; OptionDetail Active2; using (mocktestEntities1 db = new mocktestEntities1()) { Active1 = db.QuesDetails.Where(a => a.QuesDetailId == Qid).FirstOrDefault <QuesDetail>(); Active2 = db.OptionDetails.Where(a => a.QuesDetailId == Qid).FirstOrDefault <OptionDetail>(); } if (Active1 != null && Active2 != null) { Active1.Active = false; Active2.Active = false; } using (mocktestEntities1 db2 = new mocktestEntities1()) { db2.Entry(Active1).State = System.Data.Entity.EntityState.Modified; db2.Entry(Active2).State = System.Data.Entity.EntityState.Modified; db2.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(createOption option) { OptionDetail Op = new OptionDetail(); QuesDetail ques = new QuesDetail(); using (var ctx = new mocktestEntities1()) { ctx.Configuration.LazyLoadingEnabled = false; Op = ctx.OptionDetails.Where(s => s.QuesDetailId == option.Qid).FirstOrDefault <OptionDetail>(); ques = ctx.QuesDetails.Where(a => a.QuesDetailId == option.Qid).FirstOrDefault <QuesDetail>(); } ques.Question = option.question.EditQuestion; ques.OpCorrect = option.question.optionCorrect; Op.OpOne = option.optionOne; Op.OpTwo = option.optionTwo; Op.OpThree = option.optionThree; Op.OpFour = option.optionFour; using (mocktestEntities1 selectStatement = new mocktestEntities1()) { selectStatement.Entry(ques).State = System.Data.Entity.EntityState.Modified; selectStatement.Entry(Op).State = System.Data.Entity.EntityState.Modified; selectStatement.SaveChanges(); } return(Json(JsonRequestBehavior.AllowGet)); }
public ActionResult ChangePassword(SignUp sgnp) { user current = new user(); string emId = Session["EmailId"].ToString(); using (var ctx = new mocktestEntities1()) { current = ctx.users.Where(a => a.EmailId == emId).FirstOrDefault <user>(); } current.Password = sgnp.Password; using (mocktestEntities1 db = new mocktestEntities1()) { db.Entry(current).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(PartialView()); }
public ActionResult EditConfSub(Int32 SubEditId, string SubName) { bool result = false; SubTopic Name; using (mocktestEntities1 db = new mocktestEntities1()) { Name = db.SubTopics.Where(a => a.SubTopicId == SubEditId).FirstOrDefault <SubTopic>(); } if (Name != null) { Name.Name = SubName; } using (mocktestEntities1 db2 = new mocktestEntities1()) { db2.Entry(Name).State = System.Data.Entity.EntityState.Modified; db2.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteSub(Int32 SubDelId) { SubTopic Active; bool result = false; using (mocktestEntities1 db = new mocktestEntities1()) { Active = db.SubTopics.Where(a => a.SubTopicId == SubDelId).FirstOrDefault <SubTopic>(); } if (Active != null) { Active.Active = false; } using (mocktestEntities1 db2 = new mocktestEntities1()) { db2.Entry(Active).State = System.Data.Entity.EntityState.Modified; db2.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }