public static void delete(int? assignmentID, SchedulerContext dbcontext) { if (assignmentID == null) { return; } Assignment a = dbcontext.Assignments.Find(assignmentID); dbcontext.Assignments.Remove(a); dbcontext.SaveChanges(); }
public static void delete(int? assignmentID) { if (assignmentID == null) { return; } using (var sc = new SchedulerContext()) { Assignment a = sc.Assignments.Find(assignmentID); sc.Assignments.Remove(a); sc.SaveChanges(); } }
public static void delete(int? personID) { if (personID == null) { return; } using (var sc = new SchedulerContext()) { Person p = sc.Persons.Find(personID); // also remove any assignments associated with person p //p.Assignments = Assignment.getAssignmentsByPersonID(p.ID); //foreach (Assignment assignment in p.Assignments) //{ // Assignment.delete(assignment.ID); //} sc.Persons.Remove(p); sc.SaveChanges(); } }
public static void delete(int? eveID) { if (eveID == null) { return; } using (var sc = new SchedulerContext()) { Event p = sc.Events.Find(eveID); // also remove assignments associated with event p //p.Assignments = Assignment.getAssignmentsByEvent(p.ID); //foreach (Assignment assignment in p.Assignments) //{ // sc.Assignments.Remove(assignment); // sc.SaveChanges(); //} sc.Events.Remove(p); sc.SaveChanges(); } }
public void save() { if (this.ID <= 0) { //new person if (this.FirstName != null && this.FirstName.Length > 0 && this.LastName != null && this.LastName.Length > 0 && this.Email != null && this.Email.Length > 0) { using (var sc = new SchedulerContext()) { sc.Persons.Add(this); sc.SaveChanges(); } } } else { //update existing if (this.FirstName != null && this.FirstName.Length > 0 && this.LastName != null && this.LastName.Length > 0 && this.Email != null && this.Email.Length > 0) { using (var sc = new SchedulerContext()) { sc.Persons.Attach(this); sc.Entry(this).State = EntityState.Modified; sc.SaveChanges(); } } } }
public void save() { if (this.ID <= 0) { //new person if (this.Name != null && this.Name.Length > 0 && this.Room != null && this.Room.Length > 0 && this.EventDate != null && this.StartTime != null && this.EndTime != null) { using (var sc = new SchedulerContext()) { sc.Events.Add(this); sc.SaveChanges(); } } } else { //update existing if (this.Name != null && this.Name.Length > 0 && this.Room != null && this.Room.Length > 0 && this.EventDate != null && this.StartTime != null && this.EndTime != null) { using (var sc = new SchedulerContext()) { sc.Events.Attach(this); sc.Entry(this).State = EntityState.Modified; sc.SaveChanges(); } } } }