Skip to content
Snippets Groups Projects

New: Columns "Date Created" and "Creator" added to the Project Table

Merged Petar Hristov requested to merge Issue/2221-projectDateCreated into dev

Files

+ 20
9
@@ -144,9 +144,11 @@ namespace Coscine.Database.Models
@@ -144,9 +144,11 @@ namespace Coscine.Database.Models
PrincipleInvestigators = projectObject.PrincipleInvestigators,
PrincipleInvestigators = projectObject.PrincipleInvestigators,
GrantId = projectObject.GrantId,
GrantId = projectObject.GrantId,
Slug = GenerateSlug(projectObject),
Slug = GenerateSlug(projectObject),
VisibilityId = projectObject.Visibility.Id,
VisibilityId = projectObject.Visibility.Id,
 
// DateCreated is skipped here. Value set automatically by the database.
 
Creator = user.Id,
};
};
 
Insert(project);
Insert(project);
try
try
{
{
@@ -378,7 +380,8 @@ namespace Coscine.Database.Models
@@ -378,7 +380,8 @@ namespace Coscine.Database.Models
SetDisciplines(project, projectObject.Disciplines);
SetDisciplines(project, projectObject.Disciplines);
SetOrganizations(project, projectObject.Organizations);
SetOrganizations(project, projectObject.Organizations);
project.VisibilityId = projectObject.Visibility.Id;
project.VisibilityId = projectObject.Visibility.Id;
// Project creator can not be altered after creation
 
// Project DateCreated can not be altered after creation
return Update(project);
return Update(project);
}
}
@@ -405,13 +408,21 @@ namespace Coscine.Database.Models
@@ -405,13 +408,21 @@ namespace Coscine.Database.Models
project.Visibility = visibilityModel.GetById(project.VisibilityId.Value);
project.Visibility = visibilityModel.GetById(project.VisibilityId.Value);
}
}
return new ProjectObject(project.Id, project.Description, project.DisplayName, project.StartDate, project.EndDate, project.Keywords,
return new ProjectObject(project.Id,
project.ProjectName, project.PrincipleInvestigators, project.GrantId,
project.Description,
disciplines,
project.DisplayName,
organizations,
project.StartDate,
project.Visibility == null ? null : new VisibilityObject(project.Visibility.Id, project.Visibility.DisplayName),
project.EndDate,
project.Slug,
project.Keywords,
parentId);
project.ProjectName, project.PrincipleInvestigators, project.GrantId,
 
disciplines,
 
organizations,
 
project.Visibility == null ? null : new VisibilityObject(project.Visibility.Id, project.Visibility.DisplayName),
 
project.Slug,
 
project.DateCreated,
 
parentId,
 
project.Creator
 
);
}
}
public List<Project> ListToRootProject(Project project, User user)
public List<Project> ListToRootProject(Project project, User user)
Loading