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; }