public Student GetOneStudent(int id) { Student s = null; using (db5ba730478f594a8c890aa55700666a55Entities context = new db5ba730478f594a8c890aa55700666a55Entities()) { s = context.Students.Where(c => c.StudentID == id).FirstOrDefault(); } return s; }
public List<Student> GetAllStudent() { List<Student> list = new List<Student>(); using (db5ba730478f594a8c890aa55700666a55Entities context = new db5ba730478f594a8c890aa55700666a55Entities()) { list = context.Students.ToList(); } return list; }
public void CreateStudent(Student student) { int result = 0; using (db5ba730478f594a8c890aa55700666a55Entities context = new db5ba730478f594a8c890aa55700666a55Entities()) { context.Students.Add(student); result = context.SaveChanges(); } //return result > 0; }
public void DeleteStudent(int id) { int result = 0; using (db5ba730478f594a8c890aa55700666a55Entities context = new db5ba730478f594a8c890aa55700666a55Entities()) { Student s = GetOneStudent(id); if (s != null) { context.Students.Remove(s); result = context.SaveChanges(); } } //return result > 0; }
public void UpdateStudent(Student student) { /* int result = 0; using (db5ba730478f594a8c890aa55700666a55Entities context = new db5ba730478f594a8c890aa55700666a55Entities()) { Student s = GetOneStudent(student.StudentID); if (s != null) { s.Lastname = student.Lastname; s.Firstname = student.Firstname; s.MI = student.MI; context.Students.Add(student); context.SaveChanges(); } }*/ //return result > 0; using (var ctx = new db5ba730478f594a8c890aa55700666a55Entities()) { var stud = (from s in ctx.Students where s.StudentID == student.StudentID select s).FirstOrDefault(); stud.Lastname = student.Lastname; stud.Firstname = student.Firstname; stud.MI = student.MI; int num = ctx.SaveChanges(); } }