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));
}
}
