コード例 #1
0
ファイル: LearningPathDal.cs プロジェクト: TrainingTracker/TT
 public int AddCourseSubtopic(CourseSubtopic subtopicToAdd)
 {
     try
     {
         using (var context = new TrainingTrackerEntities())
         {
             EntityFramework.CourseSubtopic newSubtopicEntity = new EntityFramework.CourseSubtopic
             {
                 Name        = subtopicToAdd.Name,
                 CourseId    = subtopicToAdd.CourseId,
                 Description = subtopicToAdd.Description,
                 SortOrder   = context.CourseSubtopics.Where(c => c.CourseId == subtopicToAdd.CourseId).Count() + 1,
                 AddedBy     = subtopicToAdd.AddedBy,
                 IsActive    = subtopicToAdd.IsActive,
                 CreatedOn   = subtopicToAdd.CreatedOn
             };
             context.CourseSubtopics.Add(newSubtopicEntity);
             context.SaveChanges();
             return(newSubtopicEntity.Id);
         }
     }
     catch (Exception ex)
     {
         LogUtility.ErrorRoutine(ex);
         return(0);
     }
 }
コード例 #2
0
ファイル: LearningPathDal.cs プロジェクト: TrainingTracker/TT
        public bool UpdateCourseSubtopic(CourseSubtopic subtopicToUpdate)
        {
            try
            {
                using (var context = new TrainingTrackerEntities())
                {
                    var subtopicEntityToUpdate = context.CourseSubtopics.Find(subtopicToUpdate.Id);
                    if (subtopicEntityToUpdate == null)
                    {
                        return(false);
                    }

                    subtopicEntityToUpdate.Name        = subtopicToUpdate.Name;
                    subtopicEntityToUpdate.Description = subtopicToUpdate.Description;
                    subtopicEntityToUpdate.CourseId    = subtopicToUpdate.CourseId;

                    context.SaveChanges();
                    return(true);
                }
            }
            catch (Exception ex)
            {
                LogUtility.ErrorRoutine(ex);
                return(false);
            }
        }
コード例 #3
0
ファイル: ModelMapper.cs プロジェクト: TrainingTracker/TT
        /// <summary>
        /// Map custom entity class CourseSubtopic object to EF generated class CourseSubtopic object
        /// </summary>
        /// <param name="objectToMap">Custom entity CourseSubtopic object</param>
        /// <returns>EF generated course object if inputted parameter objectToMap is not null otherwise returns null</returns>
        public EFModel.CourseSubtopic MapToEfCourseSubtopic(CommonModel.CourseSubtopic objectToMap)
        {
            if (objectToMap == null)
            {
                return(null);
            }

            return(new EFModel.CourseSubtopic
            {
                Id = objectToMap.Id,
                CourseId = objectToMap.CourseId,
                Name = objectToMap.Name,
                Description = objectToMap.Description,
                AddedBy = objectToMap.AddedBy,
                SortOrder = objectToMap.SortOrder,
                IsActive = objectToMap.IsActive,
                CreatedOn = objectToMap.CreatedOn
            });
        }