public static Student[] FetchStudents() { LearningKOEntities dbEntities = new LearningKOEntities(); var data = (from item in dbEntities.Students orderby item.StudentId select item).Take(5); return(data.ToArray()); }
public static string DeleteStudent(Student data) { try { var dbContext = new LearningKOEntities(); var student = dbContext.Students.FirstOrDefault (userId => userId.StudentId == data.StudentId); if (student != null) { if (student != null) { dbContext.Students.Remove(student); dbContext.SaveChanges(); } } return("Data deleted from database!"); } catch (Exception ex) { return("Error: " + ex.Message); } }
public static string SaveStudents(Student[] data) { try { var dbContext = new LearningKOEntities(); var studentList = from dbStududent in dbContext.Students select dbStududent; foreach (Student userDetails in data) { var student = new Student(); if (userDetails != null) { student.StudentId = userDetails.StudentId; student.FirstName = userDetails.FirstName; student.LastName = userDetails.LastName; student.Address = userDetails.Address; student.Age = userDetails.Age; student.Gender = userDetails.Gender; student.Batch = userDetails.Batch; student.Class = userDetails.Class; student.School = userDetails.School; student.Domicile = userDetails.Domicile; } Student stud = (from st in studentList where st.StudentId == student.StudentId select st).FirstOrDefault(); if (stud == null) { dbContext.Students.Add(student); } dbContext.SaveChanges(); } return("Data saved to database!"); } catch (Exception ex) { return("Error: " + ex.Message); } }