/// <summary>
/// Save support tickets
/// </summary>
/// <param name="creationDate">creationDate</param>
/// <param name="companyId">companyId</param>
public int? Save(DateTime creationDate, int companyId)
{
int newSupportTicketId = 0;
SupportTicketAddTDS supportTicketAddChanges = (SupportTicketAddTDS)Data.GetChanges();
if (supportTicketAddChanges.BasicInformation.Rows.Count > 0)
{
foreach (SupportTicketAddTDS.BasicInformationRow row in (SupportTicketAddTDS.BasicInformationDataTable)supportTicketAddChanges.BasicInformation)
{
int categoryId = row.CategoryID;
string subject = ""; if (!row.IsSubjectNull()) subject = row.Subject;
string comment = ""; if (!row.IsCommentNull()) comment = row.Comment;
DateTime? dueDate = null; if (!row.IsDueDateNull()) dueDate = row.DueDate;
int employeeId = 0; if (!row.IsTeamMemberIDNull()) employeeId = row.TeamMemberID;
bool deleted = row.Deleted;
string state = row.State;
int createdById = row.CreatedByID;
int refId = 1;
string type_ = row.Type_;
// ... Insert the support ticket
SupportTicketSupportTicket supportTicketSupportTicket = new SupportTicketSupportTicket(null);
newSupportTicketId = supportTicketSupportTicket.InsertDirect(categoryId, subject, creationDate, createdById, state, dueDate, deleted, companyId);
// ... Insert first Activity (Default Assignation - first Activity)
SupportTicketSupportTicketActivity supportTicketSupportTicketActivity = new SupportTicketSupportTicketActivity(null);
supportTicketSupportTicketActivity.InsertDirect(newSupportTicketId, refId, type_, creationDate, employeeId, comment, row.Deleted, companyId);
}
}
return newSupportTicketId;
}
