示例#1
0
        public ActionResult Edit([Bind(Include = "ApplyId,CertificationID,StudentID,Comments,StatusID")] tbl_Apply tbl_Apply)
        {
            if (ModelState.IsValid)
            {
                db.Entry(tbl_Apply).State = EntityState.Modified;
                db.SaveChanges();

                return(RedirectToAction("Index"));
            }
            List <SelectListItem> li = new List <SelectListItem>
            {
                new SelectListItem()
                {
                    Text = "Request", Value = "1"
                },
                new SelectListItem()
                {
                    Text = "Approved", Value = "2"
                },
                new SelectListItem()
                {
                    Text = "Cancelled", Value = "3"
                }
            };

            ViewBag.CertificationID = new SelectList(db.tbl_Certification, "CertificationID", "CertificationName", tbl_Apply.CertificationID);
            //ViewBag.StatusID = new SelectList(db.tbl_Status, "StatusID", "Status", tbl_Apply.StatusID);
            ViewBag.StatusID  = new SelectList(li, "Value", "Text");
            ViewBag.StudentID = new SelectList(db.tbl_Student, "StudentID", "FirstName", tbl_Apply.StudentID);
            return(View(tbl_Apply));
        }
示例#2
0
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(View("Notfound"));
            }
            tbl_Apply tbl_Apply = db.tbl_Apply.Find(id);

            if (tbl_Apply == null)
            {
                return(View("Notfound"));
            }
            return(View(tbl_Apply));
        }
示例#3
0
        public ActionResult Create([Bind(Include = "ApplyId,CertificationID,StudentID,Comments,StatusID")] tbl_Apply tbl_Apply)
        {
            if (ModelState.IsValid)
            {
                tbl_Apply.StatusID = 1;
                db.tbl_Apply.Add(tbl_Apply);
                db.SaveChanges();

                return(Content("<html><body><script>alert('Applied successfully'); window.location.href = '/tbl_Apply/MyIndex';</script></body></html>"));
            }

            ViewBag.CertificationID = new SelectList(db.tbl_Certification, "CertificationID", "CertificationName", tbl_Apply.CertificationID);
            ViewBag.StatusID        = new SelectList(db.tbl_Status, "StatusID", "Status", 1, tbl_Apply.tbl_Status.Status);
            ViewBag.StudentID       = new SelectList(db.tbl_Student, "StudentID", "FirstName", tbl_Apply.StudentID);
            return(View(tbl_Apply));
        }
示例#4
0
        public ActionResult DeleteConfirmed(int id)
        {
            tbl_Apply tbl_Apply = db.tbl_Apply.Find(id);

            db.tbl_Apply.Remove(tbl_Apply);
            db.SaveChanges();
            int a = Convert.ToInt32(Session["UserID"]);

            if (a == 0)
            {
                return(RedirectToAction("MyIndex"));
            }
            else
            {
                return(RedirectToAction("Index"));
            }
        }
示例#5
0
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_Apply tbl_Apply = db.tbl_Apply.Find(id);

            if (tbl_Apply == null)
            {
                return(View("Notfound"));
            }
            ViewBag.CertificationID = new SelectList(db.tbl_Certification, "CertificationID", "CertificationName", tbl_Apply.CertificationID);
            ViewBag.StatusID        = new SelectList(db.tbl_Status, "StatusID", "Status", tbl_Apply.StatusID);
            ViewBag.StudentID       = new SelectList(db.tbl_Student, "StudentID", "FirstName", tbl_Apply.StudentID);
            return(View(tbl_Apply));
        }
        public ActionResult ApplyCertification(tbl_Apply u)
        {
            try
            {
                if (u.ApplyId != 0)
                {
                    if (ModelState.IsValid)
                    {
                        tbl_Apply user = new tbl_Apply
                        {
                            ApplyId         = u.ApplyId,
                            CertificationID = u.CertificationID,
                            StudentID       = u.StudentID,
                            StatusID        = u.StatusID,
                        };

                        Context.tbl_Apply.Add(user);

                        Context.SaveChanges();
                    }
                    else
                    {
                        return(View());
                    }
                }
                else
                {
                    return(View());
                }
                ViewBag.Message = "Successfully Added";
                return(RedirectToAction("ApplysList"));
            }
            catch (Exception)
            {
                return(RedirectToAction("CertificationLis2"));
            }
        }