// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadAllByEmployeeId
/// </summary>
/// <param name="employeeId">employeeId</param>
/// <param name="companyId">companyId</param>
public void LoadAllByEmployeeId(int employeeId, int companyId)
{
EmployeeInformationNoteInformationGateway employeeInformationNoteInformationGateway = new EmployeeInformationNoteInformationGateway(Data);
employeeInformationNoteInformationGateway.LoadAllByEmployeeId(employeeId, companyId);
}
/// <summary>
/// Save all employee notes to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
EmployeeInformationTDS employeeInformationChanges = (EmployeeInformationTDS)Data.GetChanges();
if (employeeInformationChanges.NoteInformation.Rows.Count > 0)
{
EmployeeInformationNoteInformationGateway employeeInformationNoteInformationGateway = new EmployeeInformationNoteInformationGateway(employeeInformationChanges);
foreach (EmployeeInformationTDS.NoteInformationRow row in (EmployeeInformationTDS.NoteInformationDataTable)employeeInformationChanges.NoteInformation)
{
// Insert new Notes
if ((!row.Deleted) && (!row.InDatabase))
{
EmployeeNotes employeeNotes = new EmployeeNotes(null);
employeeNotes.InsertDirect(row.EmployeeID, row.RefID, row.Subject, row.UserID, row.DateTime_, row.Note, row.Deleted, row.COMPANY_ID);
}
// Update Notes
if ((!row.Deleted) && (row.InDatabase))
{
int employeeId = row.EmployeeID;
int refId = row.RefID;
bool originalDeleted = row.Deleted;
int originalCompanyId = companyId;
// original values
string originalSubject = employeeInformationNoteInformationGateway.GetSubjectOriginal(employeeId, refId);
int originalUserId = employeeInformationNoteInformationGateway.GetUserIdOriginal(employeeId, refId);
DateTime originalDateTime_ = employeeInformationNoteInformationGateway.GetDateTime_Original(employeeId, refId);
string originalNote = employeeInformationNoteInformationGateway.GetNoteOriginal(employeeId, refId);
// new values
string newSubject = employeeInformationNoteInformationGateway.GetSubject(employeeId, refId);
string newNote = employeeInformationNoteInformationGateway.GetNote(employeeId, refId);
EmployeeNotes employeeNote = new EmployeeNotes(null);
employeeNote.UpdateDirect(employeeId, refId, originalSubject, originalUserId, originalDateTime_, originalNote, originalDeleted, originalCompanyId, employeeId, refId, newSubject, originalUserId, originalDateTime_, newNote, originalDeleted, originalCompanyId);
}
// Deleted notes
if ((row.Deleted) && (row.InDatabase))
{
EmployeeNotes employeeNote = new EmployeeNotes(null);
employeeNote.DeleteDirect(row.EmployeeID, row.RefID, row.COMPANY_ID);
}
}
}
}