protected override Project GetEntity(MSTQAContext entityContext, int id)
{
var query = (from e in entityContext.Projects
where e.ProjectId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
public IEnumerable <LookupItem> GetProjectTypeLookup()
{
using (MSTQAContext entityContext = new MSTQAContext())
{
return(entityContext.ProjectTypes.AsNoTracking()
.Select(f =>
new LookupItem
{
Id = f.Id,
DisplayMember = f.ProjectTypeName
})
.ToList());
}
}
protected override Project UpdateEntity(MSTQAContext entityContext, Project entity)
{
return((from e in entityContext.Projects
where e.ProjectId == entity.ProjectId
select e).FirstOrDefault());
}
protected override IEnumerable <Project> GetEntities(MSTQAContext entityContext)
{
return(from e in entityContext.Projects
select e);
}
protected override Project AddEntity(MSTQAContext entityContext, Project entity)
{
return(entityContext.Projects.Add(entity));
}
