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();
}
}
}
