public Organisation GetOrgByUser(string username)
{
UserEntity userentity = Users.FirstOrDefault(p => p.Username == username);
OrgEntity orgentity = Orgs.FirstOrDefault(p => p.Id == userentity.orgID);
return(FromEntity.ToOrg(orgentity));
}
public PageContent AddNewPage(Page page, string text, string editedBy, DateTime editedOn, DateTime projectStart, DateTime projectEnd, bool projectEstimatedTime, string projectStatus, string projectLanguage, int orgID)
{
PageEntity pageEntity = new PageEntity();
ToEntity.FromPage(page, pageEntity);
pageEntity.Id = 0;
UnitOfWork.Add(pageEntity);
UnitOfWork.SaveChanges();
PageContentEntity pageContentEntity = new PageContentEntity()
{
Id = Guid.NewGuid(),
Page = pageEntity,
Text = text,
EditedBy = editedBy,
EditedOn = editedOn,
VersionNumber = 1,
ProjectStart = projectStart,
ProjectEnd = projectEnd,
ProjectEstimatedTime = projectEstimatedTime,
ProjectStatus = projectStatus,
ProjectLanguage = projectLanguage,
orgID = orgID,
};
UnitOfWork.Add(pageContentEntity);
UnitOfWork.SaveChanges();
PageContent pageContent = FromEntity.ToPageContent(pageContentEntity);
pageContent.Page = FromEntity.ToPage(pageEntity);
return(pageContent);
}
public Organisation GetOrgByUser(Guid userId)
{
UserEntity userentity = Users.FirstOrDefault(p => p.Id == userId);
OrgEntity orgentity = Orgs.FirstOrDefault(p => p.Id == userentity.orgID);
return(FromEntity.ToOrg(orgentity));
}
public PageContent AddNewPage(Page page, string text, string editedBy, DateTime editedOn)
{
PageEntity pageEntity = new PageEntity();
ToEntity.FromPage(page, pageEntity);
pageEntity.Id = 0;
UnitOfWork.Add(pageEntity);
UnitOfWork.SaveChanges();
PageContentEntity pageContentEntity = new PageContentEntity()
{
Id = Guid.NewGuid(),
Page = pageEntity,
Text = text,
EditedBy = editedBy,
EditedOn = editedOn,
VersionNumber = 1,
};
UnitOfWork.Add(pageContentEntity);
UnitOfWork.SaveChanges();
PageContent pageContent = FromEntity.ToPageContent(pageContentEntity);
pageContent.Page = FromEntity.ToPage(pageEntity);
return(pageContent);
}
/// <summary>
/// This updates an existing set of text and is used for page rename updates.
/// To add a new version of a page, use AddNewPageContentVersion
/// </summary>
/// <param name="content"></param>
public void UpdatePageContent(PageContent content)
{
PageContentEntity entity = UnitOfWork.FindById <PageContentEntity>(content.Id);
if (entity != null)
{
ToEntity.FromPageContent(content, entity);
UnitOfWork.SaveChanges();
content = FromEntity.ToPageContent(entity);
}
}
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 User GetUserByEmail(string email, bool?isActivated = null)
{
UserEntity entity;
if (isActivated.HasValue)
{
entity = Users.FirstOrDefault(x => x.Email == email && x.IsActivated == isActivated);
}
else
{
entity = Users.FirstOrDefault(x => x.Email == email);
}
return(FromEntity.ToUser(entity));
}
public User GetUserById(Guid id, bool?isActivated = null)
{
UserEntity entity;
if (isActivated.HasValue)
{
entity = Users.FirstOrDefault(x => x.Id == id && x.IsActivated == isActivated);
}
else
{
entity = Users.FirstOrDefault(x => x.Id == id);
}
return(FromEntity.ToUser(entity));
}
public Relationship AddNewRel(Relationship rel, int reltypeid, string username, int orgID, int pageID, string reltext)
{
RelEntity relEntity = new RelEntity();
ToEntity.FromRelationship(rel, relEntity);
relEntity.username = username;
relEntity.orgId = orgID;
relEntity.pageId = pageID;
relEntity.relDateTime = DateTime.Now;
UnitOfWork.Add(relEntity);
UnitOfWork.SaveChanges();
Relationship newrel = FromEntity.ToRel(relEntity);
return(newrel);
}
public PageContent AddNewPageContentVersion(Page page, string text, string editedBy, DateTime editedOn, int version, DateTime projectStart, DateTime projectEnd, bool projectEstimatedTime, string projectStatus, string projectLanguage, int orgID)
{
if (version < 1)
{
version = 1;
}
PageEntity pageEntity = UnitOfWork.FindById <PageEntity>(page.Id);
if (pageEntity != null)
{
// Update the content
PageContentEntity pageContentEntity = new PageContentEntity()
{
Id = Guid.NewGuid(),
Page = pageEntity,
Text = text,
EditedBy = editedBy,
EditedOn = editedOn,
VersionNumber = version,
ProjectStart = projectStart,
ProjectEnd = projectEnd,
ProjectEstimatedTime = projectEstimatedTime,
ProjectStatus = projectStatus,
ProjectLanguage = projectLanguage,
orgID = orgID,
};
UnitOfWork.Add(pageContentEntity);
UnitOfWork.SaveChanges();
// The page modified fields
pageEntity.ModifiedOn = editedOn;
pageEntity.ModifiedBy = editedBy;
UnitOfWork.SaveChanges();
// Turn the content database entity back into a domain object
PageContent pageContent = FromEntity.ToPageContent(pageContentEntity);
pageContent.Page = FromEntity.ToPage(pageEntity);
return(pageContent);
}
Log.Error("Unable to update page content for page id {0} (not found)", page.Id);
return(null);
}
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 Page SaveOrUpdatePage(Page page)
{
PageEntity entity = UnitOfWork.FindById <PageEntity>(page.Id);
if (entity == null)
{
entity = new PageEntity();
ToEntity.FromPage(page, entity);
UnitOfWork.Add(entity);
UnitOfWork.SaveChanges();
page = FromEntity.ToPage(entity);
}
else
{
ToEntity.FromPage(page, entity);
UnitOfWork.SaveChanges();
page = FromEntity.ToPage(entity);
}
return(page);
}
public Relationship SaveOrUpdateRel(Relationship rel)
{
RelEntity entity = UnitOfWork.FindById <RelEntity>(rel.Id);
if (entity == null)
{
entity = new RelEntity();
ToEntity.FromRelationship(rel, entity);
UnitOfWork.Add(entity);
UnitOfWork.SaveChanges();
rel = FromEntity.ToRel(entity);
}
else
{
ToEntity.FromRelationship(rel, entity);
UnitOfWork.SaveChanges();
rel = FromEntity.ToRel(entity);
}
return(rel);
}
public User SaveOrUpdateUser(User user)
{
UserEntity entity = UnitOfWork.FindById <UserEntity>(user.Id);
if (entity == null)
{
// Turn the domain object into a database entity
entity = new UserEntity();
ToEntity.FromUser(user, entity);
UnitOfWork.Add(entity);
UnitOfWork.SaveChanges();
user = FromEntity.ToUser(entity);
}
else
{
ToEntity.FromUser(user, entity);
UnitOfWork.SaveChanges();
}
return(user);
}
public Relationship SaveOrUpdateRel(Relationship rel)
{
RelEntity entity = UnitOfWork.FindById <RelEntity>(rel.id);
if (entity == null)
{
entity = new RelEntity();
ToEntity.FromRelationship(rel, entity);
UnitOfWork.Add(entity);
UnitOfWork.SaveChanges();
rel = FromEntity.ToRel(entity);
}
else
{
rel.orgID = GetUserByUsername(rel.username).orgID;
ToEntity.FromRelationship(rel, entity);
UnitOfWork.SaveChanges();
rel = FromEntity.ToRel(entity);
}
return(rel);
}
public User GetUserByPasswordResetKey(string key)
{
UserEntity entity = Users.FirstOrDefault(x => x.PasswordResetKey == key);
return(FromEntity.ToUser(entity));
}
public IEnumerable <Page> FindPagesContainingTag(string tag)
{
IEnumerable <PageEntity> entities = Pages.Where(p => p.Tags.ToLower().Contains(tag.ToLower())); // Lightspeed doesn't support ToLowerInvariant
return(FromEntity.ToPageList(entities));
}
public IEnumerable <PageContent> GetPageContentByEditedBy(string username)
{
List <PageContentEntity> entities = PageContents.Where(p => p.EditedBy == username).ToList();
return(FromEntity.ToPageContentList(entities));
}
public User GetUserByUsername(string username)
{
UserEntity entity = Users.FirstOrDefault(x => x.Username == username);
return(FromEntity.ToUser(entity));
}
public PageContent GetPageContentById(Guid id)
{
PageContentEntity entity = PageContents.FirstOrDefault(p => p.Id == id);
return(FromEntity.ToPageContent(entity));
}
public PageContent GetPageContentByPageIdAndVersionNumber(int id, int versionNumber)
{
PageContentEntity entity = PageContents.FirstOrDefault(p => p.Page.Id == id && p.VersionNumber == versionNumber);
return(FromEntity.ToPageContent(entity));
}
public Page GetPageByTitle(string title)
{
PageEntity entity = Pages.FirstOrDefault(p => p.Title.ToLower() == title.ToLower());
return(FromEntity.ToPage(entity));
}
public PageContent GetLatestPageContent(int pageId)
{
PageContentEntity entity = PageContents.Where(x => x.Page.Id == pageId).OrderByDescending(x => x.EditedOn).FirstOrDefault();
return(FromEntity.ToPageContent(entity));
}
public IEnumerable <PageContent> FindPageContentsByPageId(int pageId)
{
List <PageContentEntity> entities = PageContents.Where(p => p.Page.Id == pageId).ToList();
return(FromEntity.ToPageContentList(entities));
}
public Page GetPageById(int id)
{
PageEntity entity = Pages.FirstOrDefault(p => p.Id == id);
return(FromEntity.ToPage(entity));
}
public User GetUserByUsernameOrEmail(string username, string email)
{
UserEntity entity = Users.FirstOrDefault(x => x.Username == username || x.Email == email);
return(FromEntity.ToUser(entity));
}
public IEnumerable <Page> FindPagesModifiedBy(string username)
{
List <PageEntity> entities = Pages.Where(p => p.ModifiedBy == username).ToList();
return(FromEntity.ToPageList(entities));
}
public IEnumerable <PageContent> AllPageContents()
{
List <PageContentEntity> entities = PageContents.ToList();
return(FromEntity.ToPageContentList(entities));
}
public IEnumerable <Page> AllPages()
{
List <PageEntity> entities = Pages.ToList();
return(FromEntity.ToPageList(entities));
}
public IEnumerable <User> FindAllAdmins()
{
List <UserEntity> entities = Users.Where(x => x.IsAdmin).ToList();
return(FromEntity.ToUserList(entities));
}