Class TicketHelper

Inheritance

object

TicketHelper

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM.Ticket

Assembly: SoDataBase.dll

Syntax

public static class TicketHelper

Methods

AddRestrictionToOwnCategories(Select, TicketTableInfo, int)

Declaration

public static void AddRestrictionToOwnCategories(Select sql, TicketTableInfo ti, int userId)

Parameters

Type	Name	Description
Select	sql
TicketTableInfo	ti
int	userId

DemandAdminPermissionsAsync(CancellationToken)

Declaration

public static Task DemandAdminPermissionsAsync(CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
CancellationToken	cancellationToken

Returns

Type	Description
Task

GetFacadeAssociateId(int)

Maps ejUserId to associateId required by C++ code via facade.

Declaration

public static int GetFacadeAssociateId(int ejUserId)

Parameters

Type	Name	Description
int	ejUserId	ejUserId

Returns

Type	Description
int

GetIconHint(string, TicketBaseStatus, DateTime)

Selects icon for a ticket based on its state

Declaration

public static string GetIconHint(string icon, TicketBaseStatus ticketStatus, DateTime deadline)

Parameters

Type	Name	Description
string	icon
TicketBaseStatus	ticketStatus	Ticket's status
DateTime	deadline	Deadline of the ticket

Returns

Type	Description
string

GetMailInFilterAddressAsync(int, CancellationToken)

Declaration

public static Task<string> GetMailInFilterAddressAsync(int filterId, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	filterId
CancellationToken	cancellationToken

Returns

Type	Description
Task<string>

GetNextInQueueAsync(CancellationToken)

Declaration

public static Task<int> GetNextInQueueAsync(CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
CancellationToken	cancellationToken

Returns

Type	Description
Task<int>

GetTicketBaseStatusAsync(int, CancellationToken)

Get TicketBaseStatus from TicketStatus. Example: TicketStatus "Resolved" may have a TicketBaseStatus "Closed".

Declaration

public static Task<TicketBaseStatus> GetTicketBaseStatusAsync(int ticketStatus, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	ticketStatus	TicketStatus int from TicketStatus table
CancellationToken	cancellationToken

Returns

Type	Description
Task<TicketBaseStatus>	TicketBaseStatus(enum) of provided TicketStatus

GetTicketChangeDataAsync(int, CancellationToken)

Declaration

public static Task<TicketChangeData> GetTicketChangeDataAsync(int ticketId, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	ticketId
CancellationToken	cancellationToken

Returns

Type	Description
Task<TicketChangeData>

GetTicketCustomersAsync(int, int, CancellationToken)

Get ticket customer rows.

Declaration

public static Task<TicketCustomersRows> GetTicketCustomersAsync(int ticketId, int customerId = 0, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	ticketId	TicketId to return customers for
int	customerId	Optional customer id
CancellationToken	cancellationToken

Returns

Type	Description
Task<TicketCustomersRows>	TicketCustomersRows object

GetTicketDataAsync(int, CancellationToken)

Declaration

public static Task<TicketData> GetTicketDataAsync(int ticketId, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	ticketId
CancellationToken	cancellationToken

Returns

Type	Description
Task<TicketData>

GetTicketSecurityLevelAsync(int, CancellationToken)

Gets TicketSecurityLevel depending on TicketTypeId. If the ticketTypeId == 0 default ticket type is used

Declaration

public static Task<TicketSecurityLevel> GetTicketSecurityLevelAsync(int ticketTypeId = 0, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	ticketTypeId
CancellationToken	cancellationToken

Returns

Type	Description
Task<TicketSecurityLevel>	Resolved TicketSecurityLevel

GetTicketStatusRecordDataAsync(short, CancellationToken)

Declaration

public static Task<TicketStatusRecordData> GetTicketStatusRecordDataAsync(short ticketStatusId, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
short	ticketStatusId
CancellationToken	cancellationToken

Returns

Type	Description
Task<TicketStatusRecordData>

HasUpdateRight(TicketData)

Declaration

public static bool HasUpdateRight(TicketData data)

Parameters

Type	Name	Description
TicketData	data

Returns

Type	Description
bool

NotifyNewTicketAsync(int)

Declaration

public static Task NotifyNewTicketAsync(int ticketEntityId)

Parameters

Type	Name	Description
int	ticketEntityId

Returns

Type	Description
Task

ResolveTicketIdAsync(int, CancellationToken)

Ticket can be connected (merged) to another ticket. This method traverses through its connection(s) and returns proper ticketId

Declaration

public static Task<int> ResolveTicketIdAsync(int ticketId, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	ticketId	Potentially correct ticketId
CancellationToken	cancellationToken

Returns

Type	Description
Task<int>	Correct ticketId. Returns 0 in case ticket does not exists

UpdateEjMessageSearchTitleAsync(int, string, CancellationToken)

Declaration

public static Task UpdateEjMessageSearchTitleAsync(int ticketId, string title, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	ticketId
string	title
CancellationToken	cancellationToken

Returns

Type	Description
Task

UpdateLastChangedAsync(TicketRow, bool, CancellationToken)

Update Ticket LastChanged field. This function will set the ticket's last_changed timestamp to now. The read_status will be set to yellow if it is green. If it is red, it will not be changed.

Declaration

public static Task UpdateLastChangedAsync(this TicketRow ticketRow, bool noNewInfo, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
TicketRow	ticketRow	TicketRow object
bool	noNewInfo	Indicates if ticket has changed
CancellationToken	cancellationToken

Returns

Type	Description
Task

UpdateRepliedAtAsync(TicketRow, DateTime, CancellationToken)

Update Ticket RepliedAt field. This function will calculate and set repliedAt, timeToReply and realTimeToReply fields.

Declaration

public static Task UpdateRepliedAtAsync(this TicketRow ticketRow, DateTime repliedAt, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
TicketRow	ticketRow	TicketRow object
DateTime	repliedAt	RepliedAt datetime
CancellationToken	cancellationToken

Returns

Type	Description
Task

UpdateTicketStatisticsFromMessagesAsync(int, CancellationToken)

Update number of messages, replies and timespent for ticket

Declaration

public static Task UpdateTicketStatisticsFromMessagesAsync(int ticketId, CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
int	ticketId	Ticket id
CancellationToken	cancellationToken

Returns

Type	Description
Task