public int Update(Project entity, int newManager, int oldManager) { try { var project = db.Projects.Find(entity.ProjectID); if (project == null) { return(-1); } project.ProjectName = entity.ProjectName; project.StartDate = entity.StartDate; project.EndDate = entity.EndDate; db.SaveChanges(); //update lai manager ben bang project member ProjectMemberDao pr = new ProjectMemberDao(); if (newManager != oldManager) { return(pr.UpdateManager(oldManager, newManager, entity.ProjectID)); } return(1); } catch { return(0); } }
public bool Delete(int projectID) { try { var remove = db.Projects.Find(projectID); var checkFirst = new ProjectMemberDao().DeleteByProject(projectID); var checkSecond = new ProjectSkillDao().DeleteByProject(projectID); db.Projects.Remove(remove); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public List <UserChat> GetUsersChatProject(int projectID, int accID) { var listUserInProject = new ProjectMemberDao().ListByProjectActive(projectID).Select(x => x.MemberID); var listConnect = db.UserConnections.Select(x => x.UserID).ToList(); var result = (from a in db.Accounts join b in db.Users on a.UserId equals b.UserId where (a.AccountId != accID && listUserInProject.Contains(b.UserId)) select new { accountID = a.AccountId, userName = b.UserName, Image = b.UserImage, isOnline = listConnect.Contains(a.AccountId) == true }).AsEnumerable().Select(x => new UserChat() { accountID = x.accountID, userName = x.userName, Image = x.Image, isOnline = x.isOnline }); return(result.ToList()); }