public void SetContributeApprovedInProject(int projectid, int id)
{
var rel = Rels.FirstOrDefault(x => x.id == id && x.pageId == projectid && x.relTypeId == 4);
rel.Approved = true;
UnitOfWork.SaveChanges();
}
public bool IsContributeApproved(int projectid, int id)
{
if (Rels.Any(x => x.id == id && x.pageId == projectid && x.relTypeId == 4 && x.Approved == true))
{
return(true);
}
return(false);
}
public bool IsContributePending(int projectid, Guid userId)
{
if (Rels.Any(x => x.UserId == userId && x.pageId == projectid && x.relTypeId == 4 && x.Pending == true))
{
return(true);
}
return(false);
}
public void UnWatchProject(int projectid, Guid userId)
{
if (IsWatched(projectid, userId))
{
Rels.Remove(x => x.UserId == userId && x.pageId == projectid && x.relTypeId == 3);
UnitOfWork.SaveChanges();
}
}
public Relationship RelToUserToPage(int pageID, string username)
{
Relationship _RelToUserToPage = new Relationship();
RelEntity entity = Rels.FirstOrDefault(r => r.username == username && r.pageId == pageID);
if (entity != null && entity.pageId != 0)
{
_RelToUserToPage = FromEntity.ToRel(entity);
}
return(_RelToUserToPage);
}
public List <Relationship> FindPageRelationships(int pageID)
{
List <RelEntity> entities = Rels.Where(p => p.pageId == pageID).ToList();
foreach (var relEntity in entities)
{
if (string.IsNullOrEmpty(relEntity.username))
{
var user = GetUserById(relEntity.UserId);
if (user != null)
{
relEntity.username = user.Username;
}
}
}
return(FromEntity.ToRelList(entities));
}
public bool RelToUserToPage(int pageID)
{
bool _RelToUserToPage = false;
RelEntity entity = Rels.FirstOrDefault(p => p.username == pageID.ToString());
_RelToUserToPage = true;
if (entity != null)
{
if (entity.pageId == pageID)
{
_RelToUserToPage = true;
}
}
return(_RelToUserToPage);
}
public IEnumerable <Relationship> FindRelsCreatedBy(string username)
{
List <RelEntity> entities = Rels.Where(p => p.username == username).ToList();
return(FromEntity.ToRelList(entities));
}
public IEnumerable <Relationship> FindAllRels()
{
List <RelEntity> entities = Rels.ToList();
return(FromEntity.ToRelList(entities));
}
public IEnumerable <Relationship> GetRelByUserId(Guid userid)
{
List <RelEntity> entities = Rels.Where(p => p.UserId == userid).ToList();
return(FromEntity.ToRelList(entities));
}
//public IEnumerable<Relationship> GetRelByPageAndUsername(int pageid, string username)
//{
// List<RelEntity> entities = Rels.Where(p => p.pageId == pageid && p.username == username).ToList();
// return FromEntity.ToRelList(entities);
//}
//public IEnumerable<Relationship> GetRelByUsername(string username)
//{
// List<RelEntity> entities = Rels.Where(p => p.username == username).ToList();
// return FromEntity.ToRelList(entities);
//}
public IEnumerable <Relationship> GetRelByPageAndUserId(int pageid, Guid userid)
{
List <RelEntity> entities = Rels.Where(p => p.pageId == pageid && p.UserId == userid).ToList();
return(FromEntity.ToRelList(entities));
}
public Relationship GetRelById(int id)
{
RelEntity entity = Rels.FirstOrDefault(p => p.id == id);
return(FromEntity.ToRel(entity));
}
public bool IsWatched(int projectid, Guid userId)
{
return(Rels.Any(x => x.UserId == userId && x.pageId == projectid && x.relTypeId == 3));
}
public List <Relationship> FindPageRelationships(int pageID)
{
List <RelEntity> entities = Rels.Where(p => p.pageId == pageID).ToList();
return(FromEntity.ToRelList(entities));
}
