public void SaveEarnedBadges(IQueryable<BadgeAwardDTO> badges)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var badgeAwards = new List<BadgeAward>();
foreach (var badge in badges)
{
var saveBadge = LoadData(badge);
ctx.BadgeAwards.Add(saveBadge);
badgeAwards.Add(saveBadge);
}
ctx.SaveChanges();
foreach (var badgeAward in badgeAwards)
{
var queueItem = new QueueItem
{
BadgeAwardId = badgeAward.BadgeAwardId,
QueueItemCreated = badgeAward.AwardDate
};
ctx.QueueItems.Add(queueItem);
}
ctx.SaveChanges();
}
}
public QueueEventLogDTO Add(QueueEventLogDTO item)
{
using (Entities context = new Entities())
{
QueueEventLog addedItem = context.QueueEventLogs.Add(
new QueueEventLog
{
Message = item.Message,
QueueEventCreated = item.QueueEventCreated,
QueueEventId = item.QueueEventId,
BadgeAwardId = item.BadgeAwardId
});
context.SaveChanges();
return new QueueEventLogDTO
{
Message = addedItem.Message,
QueueEventCreated = addedItem.QueueEventCreated,
QueueEventId = addedItem.QueueEventId,
QueueEventLogId = addedItem.QueueEventLogId,
BadgeAwardId = addedItem.BadgeAwardId
};
}
}
public CustomIdentityDTO SaveIdentity(AuthorizeLogOnDTO customIdentity)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var employee = ctx.Employees.SingleOrDefault(e => e.ADName == customIdentity.UserName);
if (employee == null)
{
employee = new Employee();
LoadEmployee(employee, customIdentity);
employee.AwardPayoutThreshold = EmployeeConstants.DefaultAwardPayoutThreshold;
ctx.Employees.Add(employee);
}
else
{
LoadEmployee(employee, customIdentity);
}
ctx.SaveChanges();
AttachAndSavePermission(ctx, employee.EmployeeId, Common.Enums.PermissionType.User);
return new CustomIdentityDTO
{
Id = employee.EmployeeId,
ADName = employee.ADName
};
}
}
public BadgeAwardEditDTO Update(BadgeAwardEditDTO data)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var saveBadgeAward = ctx.BadgeAwards.Where(ba => ba.BadgeAwardId == data.Id).Single();
saveBadgeAward.AwardAmount = data.AwardAmount;
ctx.SaveChanges();
}
return data;
}
public ActivityEditDTO Insert(ActivityEditDTO data)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var saveActivity = LoadData(data);
ctx.Activities.Add(saveActivity);
ctx.SaveChanges();
data.Id = saveActivity.ActivityId;
}
return data;
}
public SubmitActivityDTO Insert(SubmitActivityDTO data)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var saveActivitySubmission = LoadData(data);
ctx.ActivitySubmissions.Add(saveActivitySubmission);
ctx.SaveChanges();
data.Id = saveActivitySubmission.ActivitySubmissionId;
}
return data;
}
private void AttachAndSavePermission(Entities ctx, int employeeId, Common.Enums.PermissionType permissionType)
{
if (!ctx.EmployeePermissions.Any(ep => ep.EmployeeId == employeeId &&
ep.PermissionId == (int)permissionType))
{
var permission = new EmployeePermission
{
EmployeeId = employeeId,
PermissionId = (int)permissionType
};
ctx.EmployeePermissions.Add(permission);
ctx.SaveChanges();
}
}
public AccountInfoEditDTO Update(AccountInfoEditDTO data)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
ctx.Configuration.ValidateOnSaveEnabled = false;
var saveEmployee = LoadData(data);
ctx.Employees.Attach(saveEmployee);
var objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
objectState.GetObjectStateEntry(saveEmployee).SetModifiedProperty("AwardPayoutThreshold");
ctx.SaveChanges();
}
return data;
}
public QueueItemDTO Add(QueueItemDTO item)
{
using (Entities context = new Entities())
{
QueueItem addedItem = context.QueueItems.Add(new QueueItem
{
BadgeAwardId = item.BadgeAwardId,
QueueItemCreated = DateTime.Now
});
context.SaveChanges();
return new QueueItemDTO(addedItem.QueueItemId, addedItem.BadgeAwardId, addedItem.QueueItemCreated);
}
}
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;
}
public ActivityEditDTO Update(ActivityEditDTO data)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var saveActivity = LoadData(data);
ctx.Activities.Attach(saveActivity);
var objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
objectState.GetObjectStateEntry(saveActivity).SetModifiedProperty("ActivityName");
objectState.GetObjectStateEntry(saveActivity).SetModifiedProperty("ActivityDescription");
objectState.GetObjectStateEntry(saveActivity).SetModifiedProperty("RequiresApproval");
objectState.GetObjectStateEntry(saveActivity).SetModifiedProperty("CreateEmployeeId");
ctx.SaveChanges();
data.Id = saveActivity.ActivityId;
}
return data;
}
public IEnumerable<ApproveActivityItemDTO> Update(IEnumerable<ApproveActivityItemDTO> data)
{
var list = data.ToList();
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
ctx.Configuration.ValidateOnSaveEnabled = false;
foreach (var item in list)
{
var saveSubmission = LoadData(item);
ctx.ActivitySubmissions.Attach(saveSubmission);
var objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
objectState.GetObjectStateEntry(saveSubmission).SetModifiedProperty("ActivitySubmissionId");
objectState.GetObjectStateEntry(saveSubmission).SetModifiedProperty("SubmissionStatusId");
}
ctx.SaveChanges();
}
return list.Where(i => i.Status == ActivitySubmissionStatus.AwaitingApproval);
}
public QueueItemDTO Update(QueueItemDTO item)
{
using (Entities context = new Entities())
{
QueueItem itemToUpdate = new QueueItem
{
QueueItemId = item.QueueItemId,
BadgeAwardId = item.BadgeAwardId,
QueueItemCreated = item.QueueItemCreated
};
context.QueueItems.Attach(itemToUpdate);
context.Entry(itemToUpdate).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return Get(item.QueueItemId);
}
}
public SubmitActivityDTO Update(SubmitActivityDTO data)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var saveActivitySubmission = LoadData(data);
ctx.ActivitySubmissions.Attach(saveActivitySubmission);
var objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
objectState.GetObjectStateEntry(saveActivitySubmission).SetModifiedProperty("ActivityId");
objectState.GetObjectStateEntry(saveActivitySubmission).SetModifiedProperty("EmployeeId");
objectState.GetObjectStateEntry(saveActivitySubmission).SetModifiedProperty("SubmissionStatusId");
objectState.GetObjectStateEntry(saveActivitySubmission).SetModifiedProperty("SubmissionApprovedById");
objectState.GetObjectStateEntry(saveActivitySubmission).SetModifiedProperty("SubmissionDate");
objectState.GetObjectStateEntry(saveActivitySubmission).SetModifiedProperty("SubmissionDescription");
ctx.SaveChanges();
data.Id = saveActivitySubmission.ActivitySubmissionId;
}
return data;
}
public QueueEventLogDTO Update(QueueEventLogDTO item)
{
using (Entities context = new Entities())
{
QueueEventLog itemToUpdate = new QueueEventLog
{
Message = item.Message,
QueueEventCreated = item.QueueEventCreated,
QueueEventId = item.QueueEventId,
QueueEventLogId = item.QueueEventLogId,
BadgeAwardId = item.BadgeAwardId
};
context.QueueEventLogs.Attach(itemToUpdate);
context.Entry(itemToUpdate).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return Get(item.QueueEventLogId);
}
}
public IEnumerable<PointsReportItemDTO> Update(IEnumerable<PointsReportItemDTO> data)
{
var workingData = data.ToList();
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
ctx.Configuration.ValidateOnSaveEnabled = false;
foreach (var pointsReportItem in workingData.Where(t => t.PaidOut))
{
foreach (var id in pointsReportItem.BadgeAwardIds)
{
var badgeAward = LoadData(id, pointsReportItem);
ctx.BadgeAwards.Attach(badgeAward);
var objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
objectState.GetObjectStateEntry(badgeAward).SetModifiedProperty("PaidCompletedById");
objectState.GetObjectStateEntry(badgeAward).SetModifiedProperty("PaidDate");
objectState.GetObjectStateEntry(badgeAward).SetModifiedProperty("PaidOut");
}
}
ctx.SaveChanges();
}
return workingData.Where(t => !t.PaidOut);
}
public BadgeEditDTO Update(BadgeEditDTO data)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var saveBadge = LoadData(data);
ctx.Badges.Attach(saveBadge);
var objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeName");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeTagLine");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeDescription");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeTypeId");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgePath");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeCreated");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeEffectiveStart");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeEffectiveEnd");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgePriority");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("MultipleAwardPossible");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("DisplayOnce");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("ManagementApprovalRequired");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("ActivityPointsAmount");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeAwardValueAmount");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeApprovedById");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeApprovedDate");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgeStatusId");
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("CreateEmployeeId");
AttachChildren(ctx, data, saveBadge.BadgeId);
ctx.SaveChanges();
data.Id = saveBadge.BadgeId;
this.SaveToBlobStorage(data);
saveBadge.BadgePath = data.ImagePath;
objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgePath");
ctx.SaveChanges();
var badge = GetRefreshedBadgeInfo(ctx, saveBadge.BadgeId);
data = LoadReturnData(badge);
}
return data;
}
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();
}
}
public BadgeEditDTO Insert(BadgeEditDTO data)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var saveBadge = LoadData(data);
ctx.Badges.Add(saveBadge);
ctx.SaveChanges();
AttachChildren(ctx, data, saveBadge.BadgeId);
ctx.SaveChanges();
data.Id = saveBadge.BadgeId;
this.SaveToBlobStorage(data);
saveBadge.BadgePath = data.ImagePath;
var objectState = ((IObjectContextAdapter)ctx).ObjectContext.ObjectStateManager;
objectState.GetObjectStateEntry(saveBadge).SetModifiedProperty("BadgePath");
ctx.SaveChanges();
var badge = GetRefreshedBadgeInfo(ctx, saveBadge.BadgeId);
data = LoadReturnData(badge);
}
return data;
}
public void SaveManagerInfo(AuthorizeLogOnDTO customIdentity)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var employee = ctx.Employees.SingleOrDefault(e => e.ADName == customIdentity.UserName);
if (employee != null)
{
var manager1 = ctx.Employees.SingleOrDefault(e => e.ADName == customIdentity.Manager1ADName);
if (manager1 != null)
{
employee.ApprovingManagerId1 = manager1.EmployeeId;
}
var manager2 = ctx.Employees.SingleOrDefault(e => e.ADName == customIdentity.Manager2ADName);
if (manager2 != null)
{
employee.ApprovingManagerId2 = manager2.EmployeeId;
}
}
ctx.SaveChanges();
}
}
public void SetTerminationDate(string employeeADName, System.DateTime? termDate)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var employee = ctx.Employees.SingleOrDefault(e => e.ADName == employeeADName);
if (employee != null)
{
employee.EmploymentEndDate = termDate;
}
ctx.SaveChanges();
}
}
public void Delete(int id)
{
using (Entities context = new Entities())
{
QueueEventLog item = context
.QueueEventLogs
.SingleOrDefault(e => e.QueueEventLogId == id);
if (item == null)
{
throw new NotFoundException(string.Format("QueueEventLog with Id {0} could not be found so it was not deleted", id));
}
context.QueueEventLogs.Remove(item);
context.SaveChanges();
}
}
public void Delete(int activitySubmissionId)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var deleteActivitySubmission = new ActivitySubmission
{
ActivitySubmissionId = activitySubmissionId
};
ctx.ActivitySubmissions.Attach(deleteActivitySubmission);
ctx.ActivitySubmissions.Remove(deleteActivitySubmission);
ctx.SaveChanges();
}
}