/// <summary>
/// Save all activities to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
SupportTicketInformationTDS supportTicketInformationChanges = (SupportTicketInformationTDS)Data.GetChanges();
if (supportTicketInformationChanges != null)
{
if (supportTicketInformationChanges.ActivityInformation.Rows.Count > 0)
{
SupportTicketInformationActivityInformationGateway supportTicketInformationActivityInformationGateway = new SupportTicketInformationActivityInformationGateway(supportTicketInformationChanges);
foreach (SupportTicketInformationTDS.ActivityInformationRow row in (SupportTicketInformationTDS.ActivityInformationDataTable)supportTicketInformationChanges.ActivityInformation)
{
// Insert new activity
if ((!row.Deleted) && (!row.InDataBase))
{
// new values
int supportTicketId = row.SupportTicketID;
int refId = row.RefID;
int employeeId = supportTicketInformationActivityInformationGateway.GetEmployeeID(supportTicketId, refId);
string type_ = supportTicketInformationActivityInformationGateway.GetType_(supportTicketId, refId);
DateTime dateTime_ = supportTicketInformationActivityInformationGateway.GetDateTime_(supportTicketId, refId);
string comment = supportTicketInformationActivityInformationGateway.GetComment(supportTicketId, refId);
SupportTicketSupportTicketActivity supportTicketSupportTicketActivity = new SupportTicketSupportTicketActivity(null);
supportTicketSupportTicketActivity.InsertDirect(supportTicketId, refId, type_, dateTime_, employeeId, comment, row.Deleted, row.COMPANY_ID);
}
// Update activities
if ((!row.Deleted) && (row.InDataBase))
{
int supportTicketId = row.SupportTicketID;
int refId = row.RefID;
bool originalDeleted = false;
int originalCompanyId = companyId;
// original values
int originalEmployeeId = supportTicketInformationActivityInformationGateway.GetEmployeeID(supportTicketId, refId);
string originalType_ = supportTicketInformationActivityInformationGateway.GetType_(supportTicketId, refId);
DateTime originalDateTime_ = supportTicketInformationActivityInformationGateway.GetDateTime_(supportTicketId, refId);
string originalComment = supportTicketInformationActivityInformationGateway.GetComment(supportTicketId, refId);
// new values
int newEmployeeId = supportTicketInformationActivityInformationGateway.GetEmployeeIDOriginal(supportTicketId, refId);
string newComment = supportTicketInformationActivityInformationGateway.GetCommentOriginal(supportTicketId, refId);
SupportTicketSupportTicketActivity supportTicketSupportTicketActivity = new SupportTicketSupportTicketActivity(null);
supportTicketSupportTicketActivity.UpdateDirect(supportTicketId, refId, originalType_, originalDateTime_, originalEmployeeId, originalComment, originalDeleted, originalCompanyId, supportTicketId, refId, originalType_, originalDateTime_, newEmployeeId, newComment, originalDeleted, originalCompanyId);
}
// Deleted activity
if ((row.Deleted) && (row.InDataBase))
{
SupportTicketSupportTicketActivity supportTicketSupportTicketActivity = new SupportTicketSupportTicketActivity(null);
supportTicketSupportTicketActivity.DeleteDirect(row.SupportTicketID, row.RefID, row.COMPANY_ID);
}
}
}
}
}
