public List <Student> GetAll() { using (StudentMgtSystemEntities context = new StudentMgtSystemEntities()) { List <Student> li = new List <Student>(); try { var userlist = context.Students.ToList(); foreach (var item in userlist) { Student s1 = new Student(); s1.FirstName = item.FirstName; s1.LastName = item.LastName; s1.StudentId = item.StudentId; s1.Major = item.Major; s1.GPA = item.GPA; li.Add(s1); } return(li); } catch (Exception ex) { Console.WriteLine(ex.Message); return(li); } } }
public Student GetById(int id) { using (StudentMgtSystemEntities context = new StudentMgtSystemEntities()) { Student obj = new Student(); try { obj = context.Students.FirstOrDefault(u => u.StudentId == id); return(obj); } catch (Exception ex) { Console.WriteLine(ex.Message); return(obj); } } }
public bool Add(Student students) { using (StudentMgtSystemEntities context = new StudentMgtSystemEntities()) { try { context.Students.Add(students); context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } } return(true); }
public bool Delete(int id) { using (StudentMgtSystemEntities context = new StudentMgtSystemEntities()) { try { var s1 = context.Students.FirstOrDefault(u => u.StudentId == id); context.Entry(s1).State = EntityState.Deleted; context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } } return(true); }
public bool Update(Student students) { using (StudentMgtSystemEntities context = new StudentMgtSystemEntities()) { try { context.Students.Attach(students); context.Entry(students).State = EntityState.Modified; context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } } return(true); }