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