public JsonResult StudentSave(int?ID, StudentInfoModelView model) { if (ModelState.IsValid) { StudentInfo student = new StudentInfo(); if (model.ID > 0) { student = db.StudentInfoes.Find(model.ID); } student.Name = model.Name; if (model.ID > 0) { student.DepartmentID = model.DepartmentID; student.Year = model.Year; db.StudentInfoes.Attach(student); db.Entry(student).State = EntityState.Modified; } else { student.DepartmentID = model.DepartmentID; student.Year = model.Year; db.StudentInfoes.Add(student); } db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } else { return(Json("Error", JsonRequestBehavior.AllowGet)); } //if (ModelState.IsValid) //{ // StudentInfo student = new StudentInfo(); // if(ID!=null) // { // student = db.StudentInfoes.Find(model.ID); // } // student.Name = model.Name; // student.DepartmentID = model.DepartmentID; // student.Year = model.Year; // if (ID != null) // { // db.Entry(student).State = EntityState.Modified; // } // else // { // db.StudentInfoes.Add(student); // } // db.SaveChanges(); // return Json("Success", JsonRequestBehavior.AllowGet); //} //else //{ // return Json("Error", JsonRequestBehavior.AllowGet); //} }
public ActionResult TableViewEdit(StudentInfoModelView model) { StudentInfo student = db.StudentInfoes.Where(m => m.ID == model.ID).FirstOrDefault(); student.Name = model.Name; student.DepartmentID = model.DepartmentID; student.Year = model.Year; db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return(Redirect("TableView/StudentInfoes")); }
public ActionResult StudentCreatePopUp(int?id) { StudentInfoModelView model = new StudentInfoModelView(); if (id != null) { StudentInfo student = db.StudentInfoes.Where(m => m.ID == id).FirstOrDefault(); model.ID = student.ID; model.Name = student.Name; model.DepartmentID = student.DepartmentID; model.Year = student.Year; ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepartmentName", model.DepartmentID); } else { ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepartmentName"); } return(PartialView(model)); }
public ActionResult studentDetails(int?id) { StudentInfoModelView model = new StudentInfoModelView(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentInfo student = db.StudentInfoes.Where(m => m.ID == id).FirstOrDefault(); Department dpt = db.Departments.Where(m => m.DepartmentID == student.DepartmentID).First(); model.ID = student.ID; model.Name = student.Name; model.DepartmentID = student.DepartmentID; model.Year = student.Year; model.dptName = dpt.DepartmentName; ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepartmentName"); return(PartialView(model)); }
public ActionResult DepartmentPartialView(int?deptid) { if (deptid == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { var studentCount = db.StudentInfoes.Where(m => m.DepartmentID == deptid).Count(); Department data = db.Departments.Where(m => m.DepartmentID == deptid).FirstOrDefault(); StudentInfoModelView model = new StudentInfoModelView(); model.DepartmentID = data.DepartmentID; model.dptName = data.DepartmentName; model.countStudent = studentCount; model.departmentCode = Convert.ToInt32(data.DepartmentCode); // model.dptName = db.Departments.Where(n => n.DepartmentID == model.DepartmentID).Select(s => s.DepartmentName).FirstOrDefault(); return(PartialView(model)); } }