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