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;
 }
 public ApproveBadgeItemDTO Update(ApproveBadgeItemDTO data)
 {
     using (var ctx = new Entities())
     {
         ctx.Database.Connection.Open();
         ctx.Configuration.ValidateOnSaveEnabled = false;
         var saveBadge = LoadData(data);
         ctx.Badges.Attach(saveBadge);
         var objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
         objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeApprovedById");
         objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeStatusId");
         objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeApprovedDate");
         ctx.SaveChanges();
     }
     return data;
 }