Esempio n. 1
0
        /// <summary>
        /// Get all assessments for the provided entity
        /// The returned entities are just the base
        /// </summary>
        /// <param name="parentUid"></param>
        /// <returns></returnsThisEntity
        public static List <AssessmentProfile> GetAll(Guid parentUid, int relationshipTypeId = 1)
        {
            List <AssessmentProfile> list   = new List <AssessmentProfile>();
            AssessmentProfile        entity = new AssessmentProfile();

            Entity parent = EntityManager.GetEntity(parentUid);

            LoggingHelper.DoTrace(7, string.Format("EntityAssessments_GetAll: parentUid:{0} entityId:{1}, e.EntityTypeId:{2}", parentUid, parent.Id, parent.EntityTypeId));

            try
            {
                using (var context = new EntityContext())
                {
                    List <DBEntity> results = context.Entity_Assessment
                                              .Where(s => s.EntityId == parent.Id && s.RelationshipTypeId == relationshipTypeId)
                                              .OrderBy(s => s.Assessment.Name)
                                              .ToList();

                    if (results != null && results.Count > 0)
                    {
                        foreach (DBEntity item in results)
                        {
                            entity = new AssessmentProfile();

                            //need to distinguish between on a detail page for conditions and assessment detail
                            //would usually only want basics here??
                            //17-05-26 mp- change to MapFromDB_Basic
                            if (item.Assessment != null && item.Assessment.EntityStateId > 1)
                            {
                                AssessmentManager.MapFromDB_Basic(item.Assessment, entity,
                                                                  true); //includingCosts-not sure
                                                                         //add competencies
                                AssessmentManager.MapFromDB_Competencies(entity);
                                list.Add(entity);
                            }
                        }
                    }
                    return(list);
                }
            }
            catch (Exception ex)
            {
                LoggingHelper.LogError(ex, thisClassName + string.Format(".EntityAssessments_GetAll. Guid: {0}, parentType: {1} ({2}), ", parentUid, parent.EntityType, parent.EntityBaseId));
            }
            return(list);
        }
Esempio n. 2
0
        public static ThisEntity Get(int parentId, int assessmentId)
        {
            ThisEntity entity = new ThisEntity();

            if (parentId < 1 || assessmentId < 1)
            {
                return(entity);
            }
            try
            {
                using (var context = new EntityContext())
                {
                    EM.Entity_Assessment from = context.Entity_Assessment
                                                .SingleOrDefault(s => s.AssessmentId == assessmentId && s.EntityId == parentId);

                    if (from != null && from.Id > 0)
                    {
                        entity.Id                 = from.Id;
                        entity.AssessmentId       = from.AssessmentId;
                        entity.EntityId           = from.EntityId;
                        entity.RelationshipTypeId = from.RelationshipTypeId;
                        entity.ProfileSummary     = from.Assessment.Name;
                        //to.Credential = from.Credential;
                        entity.Assessment = new AssessmentProfile();
                        AssessmentManager.MapFromDB_Basic(from.Assessment, entity.Assessment,
                                                          false       //includeCosts - propose to use for credential editor
                                                          );

                        if (IsValidDate(from.Created))
                        {
                            entity.Created = ( DateTime )from.Created;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                LoggingHelper.LogError(ex, thisClassName + ".Get");
            }
            return(entity);
        }        //