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