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