private BadgeEditDTO LoadReturnData(Badge badge)
 {
     var returnValue = new BadgeEditDTO
     {
         Id = badge.BadgeId,
         Name = badge.BadgeName,
         Tagline = badge.BadgeTagLine,
         Description = badge.BadgeDescription,
         Type = (Common.Enums.BadgeType)badge.BadgeTypeId,
         ImagePath = badge.BadgePath,
         Created = badge.BadgeCreated,
         EffectiveStartDate = badge.BadgeEffectiveStart,
         EffectiveEndDate = badge.BadgeEffectiveEnd,
         Priority = badge.BadgePriority,
         MultipleAwardsPossible = badge.MultipleAwardPossible,
         DisplayOnce = badge.DisplayOnce,
         ManagementApprovalRequired = badge.ManagementApprovalRequired,
         ActivityPointsAmount = badge.ActivityPointsAmount,
         AwardValueAmount = badge.BadgeAwardValueAmount,
         ApprovedById = badge.BadgeApprovedById ?? 0,
         ApprovedDate = badge.BadgeApprovedDate,
         BadgeStatus = (Common.Enums.BadgeStatus)badge.BadgeStatusId,
         CreateEmployeeId = badge.CreateEmployeeId,
         BadgeActivities = new List<BadgeActivityEditDTO>()
     };
     foreach (var badgeActivity in badge.BadgeActivities)
     {
         returnValue.BadgeActivities.Add(new BadgeActivityEditDTO
         {
             BadgeActivityId = badgeActivity.BadgeActivityId,
             ActivityId = badgeActivity.ActivityId
         });
     }
     return returnValue;
 }
 private static Badge LoadData(BadgeEditDTO data)
 {
     var badgeEntity = new Badge
     {
         BadgeId = data.Id,
         BadgeName = data.Name,
         BadgeTagLine = data.Tagline,
         BadgeDescription = data.Description,
         BadgeTypeId = (int)data.Type,
         BadgePath = data.ImagePath,
         BadgeCreated = data.Created,
         BadgeEffectiveStart = data.EffectiveStartDate,
         BadgeEffectiveEnd = data.EffectiveEndDate,
         BadgePriority = data.Priority,
         MultipleAwardPossible = data.MultipleAwardsPossible,
         DisplayOnce = data.DisplayOnce,
         ManagementApprovalRequired = data.ManagementApprovalRequired,
         ActivityPointsAmount = data.ActivityPointsAmount,
         BadgeAwardValueAmount = data.AwardValueAmount,
         BadgeApprovedById = data.ApprovedById == 0 ? null : (int?)data.ApprovedById,
         BadgeStatusId = (int)data.BadgeStatus,
         BadgeApprovedDate = data.ApprovedDate,
         CreateEmployeeId = data.CreateEmployeeId
     };
     return badgeEntity;
 }
 public void Delete(int badgeId)
 {
     using (var ctx = new Entities())
     {
         ctx.Database.Connection.Open();
         var badgeActivities = ctx.BadgeActivities.Where(ba => ba.BadgeId == badgeId).ToList();
         ctx.BadgeActivities.RemoveRange(badgeActivities);
         ctx.SaveChanges();
         
         var deleteBadge = new Badge
         {
             BadgeId = badgeId
         };
         ctx.Badges.Attach(deleteBadge);
         ctx.Badges.Remove(deleteBadge);
         ctx.SaveChanges();
     }
 }
 private static Badge LoadData(ApproveBadgeItemDTO data)
 {
     var badge = new Badge
     {
         BadgeId = data.BadgeId,
         BadgeApprovedById = data.ApprovedById == 0 ? null : (int?)data.ApprovedById,
         BadgeStatusId = (int)data.BadgeStatus,
         BadgeApprovedDate = data.ApprovedDate
     };
     return badge;
 }