Example #1
0
        public ActionResult DeleteConfirmed(int id)
        {
            TblGrade tblGrade = db.TblGrades.Find(id);

            db.TblGrades.Remove(tblGrade);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Example #2
0
        public ActionResult Edit([Bind(Include = "GradeId,SchoolId,LearnerId,GradeName,GradeMark,GradeStartDate,GradeEndDate")] TblGrade tblGrade)
        {
            if (ModelState.IsValid)
            {
                db.Entry(tblGrade).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.LearnerId = new SelectList(db.TblLearners.Where(a => a.SchoolId == tblGrade.SchoolId), "LearnerId", "LearnerCode", tblGrade.LearnerId);
            ViewBag.SchoolId  = new SelectList(db.TblSchools.Where(a => a.SchoolId == tblGrade.SchoolId), "SchoolId", "SchoolCode", tblGrade.SchoolId);

            return(View(tblGrade));
        }
Example #3
0
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TblGrade tblGrade = db.TblGrades.Find(id);

            if (tblGrade == null)
            {
                return(HttpNotFound());
            }
            return(View(tblGrade));
        }
Example #4
0
        public ActionResult Edit(int?id)
        {
            Uri currentUrl = Request.UrlReferrer;

            if (currentUrl == null)
            {
                return(HttpNotFound());
            }

            HttpCookie usesrCookie = Request.Cookies["UserInformation"];

            if (usesrCookie == null)
            {
                return(RedirectToAction("LoginHomeIndex", "PCMSLogin"));
            }

            int?school = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[1]);

            //Get UserID
            int?userID = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[3]);

            if (db.TblUsers.Find(userID) != null)
            {
                ViewBag.UserName = db.TblUsers.Find(userID).UserName;
            }
            else if (db.TblSystemAdmins.Find(userID) != null)
            {
                ViewBag.UserName = "******";
            }
            else
            {
                ViewBag.UserName = "";
            }

            bool check = false;

            int userId = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[3]);

            if (userId == db.TblSystemAdmins.FirstOrDefault().UserId)
            {
                check = true;
            }

            ViewBag.PCMS = check;

            var School = db.TblSchools.Find(school);

            if (School != null)
            {
                ViewBag.SchoolCode = School.SchoolCode;
                ViewBag.SchoolName = School.SchoolName;
            }
            else
            {
                ViewBag.SchoolCode = null;
                ViewBag.SchoolName = null;
            }

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TblGrade tblGrade = db.TblGrades.Find(id);

            if (tblGrade == null)
            {
                return(HttpNotFound());
            }

            ViewBag.LearnerId = new SelectList(db.TblLearners.Where(a => a.SchoolId == school), "LearnerId", "LearnerName", tblGrade.LearnerId);
            ViewBag.School    = new SelectList(db.TblSchools.Where(a => a.SchoolId == school), "SchoolId", "SchoolName", tblGrade.SchoolId);
            ViewBag.SchoolId  = tblGrade.SchoolId;

            return(View(tblGrade));
        }