public ActionResult Create(Student student)
        {
            if (ModelState.IsValid)
            {
                int id = db.StudentDbSet.Count(s => (s.DepartmentID == student.DepartmentID)
                    && (s.AdmissionDate.Year == student.AdmissionDate.Year)) + 1;
                Department aDepartment
                    = db.DepartmentDbSet.Where(d => d.DepartmentID == student.DepartmentID).FirstOrDefault();
                student.RegNo = aDepartment.DeptCode + student.AdmissionDate.Year.ToString();
                if (id < 10)
                    student.RegNo += "00" + id.ToString();
                else
                    student.RegNo += "0" + id.ToString();

                db.StudentDbSet.Add(student);
                if (db.SaveChanges() > 0)
                    ViewBag.Message = "Success" + student.RegNo;

                ViewBag.DepartmentID = new SelectList(db.DepartmentDbSet, "DepartmentID", "DeptCode", student.DepartmentID);
                return View(student);
            }

            ViewBag.DepartmentID = new SelectList(db.DepartmentDbSet, "DepartmentID", "DeptCode", student.DepartmentID);
            return View(student);
        }
 public ActionResult Edit(Student student)
 {
     if (ModelState.IsValid)
     {
         db.Entry(student).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     ViewBag.DepartmentID = new SelectList(db.DepartmentDbSet, "DepartmentID", "DeptCode", student.DepartmentID);
     return View(student);
 }