Skip to content
Snippets Groups Projects
Select Git revision
  • 52cec7fad47cfd11e0ae012790914257145bd9fd
  • master default protected
  • dev protected
  • Issue/3003-stsInstitute
  • gitkeep
  • Issue/2449-GuidPidSlugToProjectSettings
  • Issue/2309-docs
  • Fix/xxxx-updateDependencies
  • Issue/2364-testingKpiParser
  • Issue/2287-guestRole
  • Test/xxxx-pipelineTriggers
  • Issue/2102-gitLabResTypeRCV
  • Issue/2278-gitlabToS
  • Issue/2101-gitLabResTypeUi
  • Issue/1788-extractionCronjob
  • Issue/2183-kpiGeneratorResource
  • Issue/2222-resourceDateCreated
  • Issue/2221-projectDateCreated
  • Issue/1321-pidEnquiryOverhaul
  • Issue/1999-gitlabResourcesLib
  • Issue/1951-quotaImplementation
  • v2.22.0
  • v2.20.0
  • v2.19.1
  • v2.19.0
  • v2.18.0
  • v2.17.0
  • v2.16.2
  • v2.16.1
  • v2.16.0
  • v2.15.0
  • v2.14.0
  • v2.13.0
  • v2.12.1
  • v2.12.0
  • v2.11.1
  • v2.11.0
  • v2.10.1
  • v2.10.0
  • v2.9.1
  • v2.9.0
41 results

ProjectModel.cs

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    ProjectModel.cs 21.05 KiB
    using Coscine.Database.DataModel;
    using Coscine.Database.ReturnObjects;
    using Coscine.Database.Util;
    using LinqKit;
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Linq.Expressions;
    using System.Text.RegularExpressions;
    
    namespace Coscine.Database.Models
    {
        public class ProjectModel : DatabaseModel<Project>
        {
            public bool IsDeleted(Guid id)
            {
                return DatabaseConnection.ConnectToDatabase((db) =>
                {
                    return
                        (from tableEntry in GetITableFromDatabase(db)
                         where tableEntry.Id == id
                                && tableEntry.Deleted == true
                         select tableEntry).Count() == 1;
                });
            }
    
            public override Project GetById(Guid id)
            {
                var expression = GetIdFromObject();
                return DatabaseConnection.ConnectToDatabase((db) =>
                {
                    return
                        (from tableEntry in GetITableFromDatabase(db).AsExpandable()
                         where expression.Invoke(tableEntry) == id
                            && tableEntry.Deleted == false
                         select tableEntry).FirstOrDefault();
                });
            }
    
            public Project GetBySlug(String slug)
            {
                return GetWhere((tableEntry) => tableEntry.Slug == slug);
            }
    
            public Project GetByIdIncludingDeleted(Guid id)
            {
                var expression = GetIdFromObject();
                return DatabaseConnection.ConnectToDatabase((db) =>
                {
                    return
                        (from tableEntry in GetITableFromDatabase(db).AsExpandable()
                         where expression.Invoke(tableEntry) == id
                         select tableEntry).FirstOrDefault();
                });
            }
    
            public override Project GetWhere(Expression<Func<Project, bool>> whereClause)
            {
                return DatabaseConnection.ConnectToDatabase((db) =>
                {
                    return
                        (from tableEntry in GetITableFromDatabase(db).AsExpandable()
                         where whereClause.Invoke(tableEntry)
                            && tableEntry.Deleted == false
                         select tableEntry).FirstOrDefault();
                });
            }
    
            public override IEnumerable<Project> GetAll()
            {