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