public void InsertCourse(Entities.Cours objCourse) { using (var model = new UPCModelEntities()) { model.Courses.Add(objCourse); model.SaveChanges(); } }
public List <Entities.Career> GetAllCareers() { UPCModelEntities UPCModel = new UPCModelEntities(); List <Career> careers = (from c in UPCModel.Careers //where c.Name.Contains("ing") select c).ToList(); return(careers); }
public List <Cours> GetAllCourses() { using (var model = new UPCModelEntities()) { var courses = from c in model.Courses.Include("Career") select c; return(courses.ToList()); } }
public Cours GetCourseById(int courseId) { using (var model = new UPCModelEntities()) { var course = from c in model.Courses where c.Id == courseId select c; return(course.FirstOrDefault()); } }
public void DeleteCourse(int courseId) { using (var model = new UPCModelEntities()) { Cours objCourse = model.Courses.Find(courseId); if (objCourse != null) { model.Courses.Remove(objCourse); model.SaveChanges(); } } }
public void UpdateCourse(Cours objCourse) { using (var model = new UPCModelEntities()) { var original = model.Courses.Find(objCourse.Id); if (original != null) { model.Entry(original).CurrentValues.SetValues(objCourse); model.SaveChanges(); } } }