public JsonResult AddStudents(string[][] studentsArry) { StudentContextClass db = new StudentContextClass(); if (studentsArry != null && studentsArry.Length > 0) { List <Student> students = new List <Student>(); for (int i = 0; i < studentsArry.Length; i++) { Student stu = new Student { Name = studentsArry[i][1], RegistrationNumb = studentsArry[i][2] }; students.Add(stu); students.TrimExcess(); } List <Student> oldStudentsList; using (db) { oldStudentsList = (from s in db.Students select s).ToList(); students.RemoveAll(x => oldStudentsList.Exists(y => y.Name == x.Name || y.RegistrationNumb == x.RegistrationNumb)); db.Students.AddRange(students); db.SaveChanges(); } return(Json(new { success = true, responseText = "New Data added to Database Successfully!" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, responseText = "Something Went Wrong!" }, JsonRequestBehavior.AllowGet)); }
public JsonResult UpdateStudent(Student student) { StudentContextClass db = new StudentContextClass(); try { using (db) { Student oldStudent = db.Students.Find(student.Id); if (oldStudent != null) { oldStudent.Name = student.Name; oldStudent.RegistrationNumb = student.RegistrationNumb; db.Entry(oldStudent).State = EntityState.Modified; db.SaveChanges(); } return(Json(new { msg = "Successfully Update <b><u>" + student.Name + "</u></b> Data", err = 0 }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { msg = "Cannot Update Data to Server! Try Again Later", err = 1 }, JsonRequestBehavior.AllowGet)); } }
// Fully Server Sourced DataTable Workout public JsonResult GetDataToDataTables(DataTablesParam param) { int pageNo = 1; int totalCount = 0; if (param.iDisplayStart >= param.iDisplayLength) { pageNo = (param.iDisplayStart / param.iDisplayLength) + 1; } StudentContextClass db = new StudentContextClass(); List <Student> list; using (db) { if (param.sSearch != null) { totalCount = (from s in db.Students.Where(x => x.Name.Contains(param.sSearch) || x.RegistrationNumb.Contains(param.sSearch)) select s).Count(); list = (from s in db.Students .Where(x => x.Name.Contains(param.sSearch) || x.RegistrationNumb.Contains(param.sSearch)) .OrderBy(x => x.Id) .Skip((pageNo - 1) * param.iDisplayLength) .Take(param.iDisplayLength) select s).ToList(); } else { totalCount = db.Students.Count(); list = (from s in db.Students .OrderBy(x => x.Id) .Skip((pageNo - 1) * param.iDisplayLength) .Take(param.iDisplayLength) select s).ToList(); } } return(Json(new { aaData = list, sEcho = param.sEcho, iTotalDisplayRecords = totalCount, iTotalRecords = totalCount } , JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteStudent(int studentId) { StudentContextClass db = new StudentContextClass(); if (studentId != 0) { Student stu = (from s in db.Students where s.Id == studentId select s).FirstOrDefault(); if (stu != null) { using (db) { db.Students.Remove(stu); db.SaveChanges(); } return(Json(new { success = true, responseText = "Data " + stu.Name + " Deleted from Database Succesfully!" }, JsonRequestBehavior.AllowGet)); } } return(Json(new { success = false, responseText = "Cannot Delete Data" }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetData() { try { StudentContextClass db = new StudentContextClass(); using (db) { List <Student> students = (from s in db.Students select s).ToList(); if (students.Count > 0) { return(Json(students, JsonRequestBehavior.AllowGet)); } else { return(Json(new { msg = "No Data Found!", err = 1 }, JsonRequestBehavior.AllowGet)); } } } catch (Exception e) { return(Json(new { msg = "Cannot Fetch Data From Database. SERVER Error", err = 1 }, JsonRequestBehavior.AllowGet)); } }