public List <ProjectItem> GetAssignationDetails() { using (var db = new PMSmartEntities()) { var result = db.Projects.Include(x => x.Contacts).ToList(); return(result.Select(x => new ProjectItem { ProjectId = x.ProjectId, Name = x.Name, Description = x.Description, Contacts = x.Contacts.Select(y => new ContactItem { ContactId = y.ContactId, FirstName = y.FirstName, LastName = y.LastName, ProjectId = y.ProjectId }) .OrderBy(o => o.ContactId) .ToList() }) .OrderBy(o => o.ProjectId) .ToList()); } }
public int Create(ProjectItem item) { var project = Mapper.Map <ProjectItem, Project>(item); using (var db = new PMSmartEntities()) { db.Projects.Add(project); db.SaveChanges(); return(project.ProjectId); } }
public List <ProjectItem> GetProjects() { using (var db = new PMSmartEntities()) { var result = db.Projects.Select(x => x) .OrderBy(o => o.ProjectId) .ToList(); return(Mapper.Map <List <ProjectItem> >(result)); } }
public int Update(ProjectItem item) { var updatedProject = Mapper.Map <ProjectItem, Project>(item); using (var db = new PMSmartEntities()) { db.Projects.Attach(updatedProject); db.Entry(updatedProject).State = EntityState.Modified; db.SaveChanges(); return(updatedProject.ProjectId); } }