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));
        }