public void AddProgramCourse(ProgramCourses programCourses) { using (var context = new StarTEDContext()) { context.ProgramCourses.Add(programCourses); context.SaveChanges(); } }
public void AddCourse(Courses course) { using (var context = new StarTEDContext()) { context.Courses.Add(course); context.SaveChanges(); } }
public int Rentals_Add(Rentals item) { using (var context = new StarTEDContext()) { context.Rentals.Add(item); context.SaveChanges(); return(item.RentalID); } }
public void DeleteClubActivity(int id) { using (var context = new StarTEDContext()) { var exisiting = context.ClubActivities.Find(id); context.ClubActivities.Remove(exisiting); context.SaveChanges(); } }
public void UpdateClubActivity(ClubActivity item) { using (var context = new StarTEDContext()) { var exisiting = context.Entry(item); exisiting.State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public int AddClubActivity(ClubActivity item) { using (var context = new StarTEDContext()) { ClubActivity addeditem = context.ClubActivities.Add(item); context.SaveChanges(); return(addeditem.ActivityID); } }
public int Rentals_Update(Rentals item) { using (var context = new StarTEDContext()) { //Staging context.Entry(item).State = System.Data.Entity.EntityState.Modified; //Commit and Feedback (rows affected) return(context.SaveChanges()); } }
public void RemoveCourse(Courses course) { using (var context = new StarTEDContext()) { var entity = context.Courses.Where(t => t.CourseID == course.CourseID).FirstOrDefault(); if (entity == null) { return; } context.Courses.Remove(entity); context.SaveChanges(); } }
public void RemoveProgramCourse(ProgramCourses programCourses) { using (var context = new StarTEDContext()) { var id = programCourses.ProgramCourseID; var entity = context.ProgramCourses.Where(t => t.ProgramCourseID == id).FirstOrDefault(); if (entity == null) { return; } context.ProgramCourses.Remove(entity); context.SaveChanges(); } }
public void UpdateCourse(Courses course) { using (var context = new StarTEDContext()) { var entity = context.Courses.Where(t => t.CourseID == course.CourseID).FirstOrDefault(); if (entity == null) { return; } entity.CourseName = course.CourseName; entity.Credits = course.Credits; entity.Description = course.Description; entity.Term = course.Term; entity.TotalHours = course.TotalHours; entity.Tuition = course.Tuition; context.SaveChanges(); } }
public void UpdateProgramCourse(ProgramCourses programCourse) { using (var context = new StarTEDContext()) { var entity = context.ProgramCourses.Where(t => t.ProgramCourseID == programCourse.ProgramCourseID).FirstOrDefault(); if (entity == null) { return; } entity.Active = programCourse.Active; entity.Comments = programCourse.Comments; entity.CourseID = programCourse.CourseID; entity.ProgramCourseID = programCourse.ProgramCourseID; entity.ProgramID = programCourse.ProgramID; entity.Required = programCourse.Required; entity.SectionLimit = programCourse.SectionLimit; context.SaveChanges(); } }
public int Rentals_Delete(int productid) { using (var context = new StarTEDContext()) { //Physical Delete //the physical removal of a record from the database ////locate the instance of the entity to be removed var existing = context.Rentals.Find(productid); ////optional check to see if it is there ////if not throw an exception. ////this process can also be handled on the web form during feedback if (existing == null) { throw new Exception("Record has already been removed from database"); } ////Stage context.Rentals.Remove(existing); ////Commmit and feedback return(context.SaveChanges()); } }