private void LoadData(SubmitActivityDTO data) { using (this.BypassPropertyChecks) { this.Id = data.Id; this.ActivityId = data.ActivityId; this.ActivitySubmissionDate = data.ActivitySubmissionDate; this.ApprovedById = data.ApprovedById; this.Notes = data.Notes; this.Status = data.Status; this.EmployeeId = data.EmployeeId; } }
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, AwardValue = data.AwardValue }; return(activitySubmission); }
private SubmitActivityDTO UnloadData() { using (this.BypassPropertyChecks) { var returnValue = new SubmitActivityDTO { Id = this.Id, ActivityId = this.ActivityId, ActivitySubmissionDate = this.ActivitySubmissionDate, ApprovedById = this.ApprovedById, Notes = this.Notes, Status = this.Status, EmployeeId = this.EmployeeId, AwardValue = this.AwardValue }; return(returnValue); } }
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); }