public bool SaveStudentDetails(Student Stu)
{
bool result = false;
using (StudentInformationEntities _entity = new StudentInformationEntities())
{
_entity.Students.Add(Stu);
_entity.SaveChanges();
result = true;
}
return(result);
}
public bool DeleteStudentDetails(Student Stu) // DeleteStudentDetails method to delete record from table
{
bool result = false;
using (StudentInformationEntities _entity = new StudentInformationEntities())
{
Student _student = _entity.Students.Where(x => x.StudentId == Stu.StudentId).Select(x => x).FirstOrDefault();
_entity.Students.Remove(_student);
_entity.SaveChanges();
result = true;
}
return(result);
}
public bool UpdateStudentDetails(Student Stu) // UpdateStudentDetails method for update a existing Record
{
bool result = false;
using (StudentInformationEntities _entity = new StudentInformationEntities())
{
Student _student = _entity.Students.Where(x => x.StudentId == Stu.StudentId).Select(x => x).FirstOrDefault();
_student.Name = Stu.Name;
_student.Class = Stu.Class;
_entity.SaveChanges();
result = true;
}
return(result);
}
public void Display()
{
using (StudentInformationEntities _entity = new StudentInformationEntities())
{
List <Student> _studentList = new List <Student>();
_studentList = _entity.Students.Select(x => new Student
{
StudentId = x.StudentId,
Name = x.Name,
Class = x.Class,
TeacherId = x.TeacherId
}).ToList();
dataGridView1.DataSource = _studentList;
}
}
