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 static ActivitySubmission LoadData(SubmitActivityDTO data)
{
var activitySubmission = new ActivitySubmission
{
ActivitySubmissionId = data.Id,
ActivityId = data.ActivityId,
EmployeeId = data.EmployeeId,
SubmissionStatusId = (int)data.Status,
SubmissionApprovedById = data.ApprovedById == 0 ? null : (int?)data.ApprovedById,
SubmissionDate = data.ActivitySubmissionDate,
SubmissionDescription = data.Notes
};
return activitySubmission;
}
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;
}
