public ActionResult DeleteConfirmed(int id)
        {
            AssignRoll assignRoll = db.AssignRoll.Find(id);

            db.AssignRoll.Remove(assignRoll);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            AssignRoll assignRoll = db.AssignRoll.Find(id);

            if (assignRoll == null)
            {
                return(HttpNotFound());
            }
            return(View(assignRoll));
        }
Пример #3
0
        public ActionResult DeleteConfirmed(int id)
        {
            Admission admsn = db.Admission.Where(x => x.StudentId == id).SingleOrDefault();

            if (admsn != null)
            {
                db.Admission.Remove(admsn);
                db.SaveChanges();
            }

            Guardian grdn = db.Guardian.Where(x => x.StudentId == id).SingleOrDefault();

            if (grdn != null)
            {
                db.Guardian.Remove(grdn);
                db.SaveChanges();
            }

            int      arId = db.AssignRoll.Where(x => x.StudentId == id).Select(x => x.Id).SingleOrDefault();
            ExamMark em   = db.ExamMark.Where(x => x.AssignRollId == arId).SingleOrDefault();

            if (em != null)
            {
                db.ExamMark.Remove(em);
                db.SaveChanges();
            }


            AssignRoll ar = db.AssignRoll.Where(x => x.StudentId == id).SingleOrDefault();

            if (ar != null)
            {
                db.AssignRoll.Remove(ar);
                db.SaveChanges();
            }

            Student student = db.Student.Find(id);

            db.Student.Remove(student);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Create(AssignRoll assignRoll)
        {
            if (ModelState.IsValid)
            {
                db.AssignRoll.Add(assignRoll);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            var studentClass = db.StudentClass.Select(c => new
            {
                Id   = c.Id,
                Name = c.ClassName.Name + " || " + c.Shift.Name + " ||" + c.Section.Name
            }).OrderBy(o => o.Name).ToList();

            ViewBag.SessionId      = new SelectList(db.Session, "Id", "Name");
            ViewBag.StudentClassId = new SelectList(studentClass, "Id", "Name");
            ViewBag.StudentId      = new SelectList(db.Student, "Id", "Name");
            return(View(assignRoll));
        }
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            AssignRoll assignRoll = db.AssignRoll.Find(id);

            if (assignRoll == null)
            {
                return(HttpNotFound());
            }
            var studentClass = db.StudentClass.Select(c => new
            {
                Id   = c.Id,
                Name = c.ClassName.Name + " || " + c.Shift.Name + " ||" + c.Section.Name
            }).OrderBy(o => o.Name).ToList();

            ViewBag.SessionId      = new SelectList(db.Session, "Id", "Name", assignRoll.SessionId);
            ViewBag.StudentClassId = new SelectList(studentClass, "Id", "Name", assignRoll.StudentClassId);
            ViewBag.StudentId      = new SelectList(db.Student, "Id", "Name", assignRoll.StudentId);
            return(View(assignRoll));
        }