Ejemplo n.º 1
0
        public static void MapFromDB(DBEntityItem from, ThisEntityItem to, bool includingItems = true)
        {
            to.Id       = from.Id;
            to.ParentId = from.EntityFrameworkId;
            to.RowId    = from.RowId;

            to.Name              = StripJqueryTag(from.Name);
            to.Description       = from.Description;
            to.TargetName        = from.TargetName;
            to.TargetDescription = from.TargetDescription;
            to.TargetUrl         = from.TargetUrl;
            to.CodedNotation     = from.CodedNotation;

            if (IsValidDate(from.AlignmentDate))
            {
                to.AlignmentDate = (( DateTime )from.AlignmentDate).ToShortDateString();
            }
            else
            {
                to.AlignmentDate = "";
            }

            if (IsValidDate(from.Created))
            {
                to.Created = ( DateTime )from.Created;
            }
            to.CreatedById = from.CreatedById == null ? 0 : ( int )from.CreatedById;
            if (IsValidDate(from.LastUpdated))
            {
                to.LastUpdated = ( DateTime )from.LastUpdated;
            }
            to.LastUpdatedById = from.LastUpdatedById == null ? 0 : ( int )from.LastUpdatedById;
            to.LastUpdatedBy   = SetLastUpdatedBy(to.LastUpdatedById, from.Account_Modifier);
        }
Ejemplo n.º 2
0
        }        //

        /// <summary>
        /// Get a competency record
        /// </summary>
        /// <param name="profileId"></param>
        /// <returns></returns>
        public static ThisEntityItem Entity_Competency_Get(int profileId)
        {
            ThisEntityItem entity = new ThisEntityItem();

            if (profileId == 0)
            {
                return(entity);
            }
            try
            {
                using (var context = new EntityContext())
                {
                    DBEntityItem item = context.Entity_CompetencyFrameworkItem
                                        .SingleOrDefault(s => s.Id == profileId);

                    if (item != null && item.Id > 0)
                    {
                        MapFromDB(item, entity, true);
                    }
                }
            }
            catch (Exception ex)
            {
                LoggingHelper.LogError(ex, thisClassName + ".Entity_Competency_Get");
            }
            return(entity);
        }        //
Ejemplo n.º 3
0
        public IEnumerable <WeatherForecast> WeatherForecasts()
        {
            DBController connection = new DBController();
            DBEntityItem item       = connection.GetItemTextByID(1111);

            return(Enumerable.Range(0, 5).Select(index => new WeatherForecast
            {
                DateFormatted = DateTime.Now.AddDays(index).ToString("d"),
                TemperatureC = 0,
                Summary = index == 0 ? item.question.entity_text : item.answers[index - 1].entity_text
            }));
        }
Ejemplo n.º 4
0
        /// <summary>
        /// Delete a competency
        /// </summary>
        /// <param name="recordId"></param>
        /// <param name="statusMessage"></param>
        /// <returns></returns>
        public bool Entity_Competency_Delete(int recordId, ref string statusMessage)
        {
            bool isOK = true;

            using (var context = new EntityContext())
            {
                DBEntityItem p = context.Entity_CompetencyFrameworkItem.FirstOrDefault(s => s.Id == recordId);
                if (p != null && p.Id > 0)
                {
                    context.Entity_CompetencyFrameworkItem.Remove(p);
                    int count = context.SaveChanges();
                }
                else
                {
                    statusMessage = string.Format("The record was not found: {0}", recordId);
                    isOK          = false;
                }
            }
            return(isOK);
        }
Ejemplo n.º 5
0
        }         //

        public static void MapToDB(ThisEntityItem from, DBEntityItem to)
        {
            //want to ensure fields from create are not wiped
            //to.Id = from.Id;
            to.EntityFrameworkId = from.ParentId;
            to.Name              = StripJqueryTag(from.Name);
            to.Description       = from.Description;
            to.TargetName        = from.TargetName;
            to.TargetDescription = from.TargetDescription;
            to.TargetUrl         = from.TargetUrl;
            to.CodedNotation     = from.CodedNotation;

            if (IsValidDate(from.AlignmentDate))
            {
                to.AlignmentDate = DateTime.Parse(from.AlignmentDate);
            }
            else
            {
                to.AlignmentDate = null;
            }
        }
Ejemplo n.º 6
0
        /// <summary>
        /// Add/Update a competency
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="parentUid"></param>
        /// <param name="userId"></param>
        /// <param name="messages"></param>
        /// <returns></returns>
        public bool Entity_Competency_Save(ThisEntityItem entity,
                                           int userId,
                                           ref SaveStatus status)
        {
            bool isValid     = true;
            int  intialCount = messages.Count;

            if (entity.ParentId == 0)
            {
                status.AddWarning("Error: the parent identifier was not provided.");
            }

            if (messages.Count > intialCount)
            {
                return(false);
            }

            int count = 0;

            DBEntityItem efEntity = new DBEntityItem();

            using (var context = new EntityContext())
            {
                bool isEmpty = false;

                if (ValidateProfile(entity, ref isEmpty, ref status) == false)
                {
                    return(false);
                }
                if (isEmpty)
                {
                    status.AddWarning("The Competency Profile is empty. ");
                    return(false);
                }

                if (entity.Id == 0)
                {
                    //add
                    efEntity = new DBEntityItem();
                    MapToDB(entity, efEntity);

                    efEntity.Created     = efEntity.LastUpdated = DateTime.Now;
                    efEntity.CreatedById = efEntity.LastUpdatedById = userId;
                    efEntity.RowId       = Guid.NewGuid();

                    context.Entity_CompetencyFrameworkItem.Add(efEntity);

                    count = context.SaveChanges();

                    entity.Id    = efEntity.Id;
                    entity.RowId = efEntity.RowId;
                    if (count == 0)
                    {
                        status.AddWarning(string.Format(" Unable to add Profile: {0} <br\\> ", string.IsNullOrWhiteSpace(entity.Name) ? "no description" : entity.Description));
                    }
                }
                else
                {
                    efEntity = context.Entity_CompetencyFrameworkItem.SingleOrDefault(s => s.Id == entity.Id);
                    if (efEntity != null && efEntity.Id > 0)
                    {
                        entity.RowId = efEntity.RowId;
                        //update
                        MapToDB(entity, efEntity);
                        //has changed?
                        if (HasStateChanged(context))
                        {
                            efEntity.LastUpdated     = System.DateTime.Now;
                            efEntity.LastUpdatedById = userId;

                            count = context.SaveChanges();
                        }
                    }
                }
            }

            return(isValid);
        }