public void DeleteStudent(int id) { var db = new OOPCSEntities(); var @student = db.PM20530.Find(id); db.PM20530.Remove(@student); db.SaveChanges(); }
public void UpdateStudent(int id, string code, string name, string hometown, string gender) { var db = new OOPCSEntities(); var oldStudent = db.PM20530.Find(id); oldStudent.Code = code; oldStudent.Name = name; oldStudent.Hometown = hometown; bool isFemale = true; if (gender == "Female") { isFemale = false; } else { isFemale = true; } oldStudent.Gender = isFemale; db.Entry(oldStudent).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public void CreateStudent(string code, string name, string hometown, string gender) { var newstudent = new PM20530(); newstudent.Code = code; newstudent.Name = name; newstudent.Hometown = hometown; bool isFemale = true; if (gender == "Female") { isFemale = false; } else { isFemale = true; } var db = new OOPCSEntities(); newstudent.Gender = isFemale; db.PM20530.Add(newstudent); db.SaveChanges(); }
public PM20530 GetStudent(int id) { var db = new OOPCSEntities(); return(db.PM20530.Find(id)); }
public PM20530[] GetStudent() { var db = new OOPCSEntities(); return(db.PM20530.ToArray()); }