New: Column "Date Created" added to the Resource Table

coscine/issues#2222

src/Database/Models/ResourceModel.cs

@@ -86,7 +86,7 @@ namespace Coscine.Database.Models
             }
         }
 
-        public Resource StoreFromObject(ResourceObject resourceObject)
+        public Resource StoreFromObject(ResourceObject resourceObject, User user)
         {
             if (!resourceObject.Disciplines.Any() || resourceObject.ResourceTypeOption == null)
             {
@@ -104,7 +104,8 @@ namespace Coscine.Database.Models
                 VisibilityId = resourceObject.Visibility.Id,
                 ApplicationProfile = resourceObject.ApplicationProfile,
                 FixedValues = resourceObject.FixedValues != null ? resourceObject.FixedValues.ToString() : "{}",
-                Creator = resourceObject.Creator
+                // DateCreated is skipped here. Value set automatically by the database.
+                Creator = user.Id
             };
             if (resourceObject.License != null)
             {
@@ -288,14 +289,10 @@ namespace Coscine.Database.Models
             {
                 resource.LicenseId = null;
             }
-
-            // the application profile can not be altered after creation
-            // resource.ApplicationProfile = resourceObject.ApplicationProfile;
-
             resource.FixedValues = resourceObject.FixedValues != null ? resourceObject.FixedValues.ToString() : "{}";
-
-            // the resource creator can not be altered after creation
-            // resource.Creator = resourceObject.Creator;
+            // Application Profile can not be altered after creation
+            // Resource DateCreated can not be altered after creation
+            // Creator can not be altered after creation
 
             SetDisciplines(resource, resourceObject.Disciplines);
 
@@ -441,6 +438,7 @@ namespace Coscine.Database.Models
                 resourceTypeOptionObject == null ? new JObject() : JObject.FromObject(resourceTypeOptionObject),
                 resource.ApplicationProfile,
                 JToken.Parse(resource.FixedValues ?? "{}"),
+                resource.DateCreated,
                 resource.Creator,
                 resource.Archived == "1"
             );