public static List <TicketLogRecord> TicketLog(Guid OrgId, int DeptId, int TktId, string TktPseudoId, int page, int limit) { TicketLogRecords _recs = new TicketLogRecords(bigWebApps.bigWebDesk.Data.Tickets.SelectTicketLog(OrgId, DeptId, TktId)); foreach (TicketLogRecord _rec in _recs.List) { _rec.TktPseudoId = TktPseudoId; } return(_recs.Skip(page * limit).Take(limit).ToList()); }
public void TicketFactory(Guid OrgId, int DeptId, int TktId) { m_Row = bigWebApps.bigWebDesk.Data.Tickets.SelectOne(OrgId, DeptId, TktId); if (m_Row == null) { throw new HttpError(HttpStatusCode.NotFound, "key not found"); } m_Row["intSLAResponseUsed"] = !m_Row.IsNull("dtSLAResponse") ? bigWebApps.bigWebDesk.Data.Tickets.SelectTicketSLATime(OrgId, DeptId, DateTime.UtcNow, (DateTime)m_Row["dtSLAResponse"]) : 0; InitTicket(m_Row); if (this.DaysOldInMinutes == 0) { this.DaysOldInMinutes = bigWebApps.bigWebDesk.Data.Tickets.SelectTicketSLATime(OrgId, DeptId, DateTime.UtcNow, (DateTime)m_Row["CreateTime"]); } OrganizationId = OrgId; DepartmentID = DeptId; TktId = this.Id; Users = TicketAssignments.TicketUsers(OrgId, DeptId, TktId); Technicians = TicketAssignments.TicketTechnicians(OrgId, DeptId, TktId); TicketLogs = TicketLogRecords.TicketLog(OrgId, DeptId, TktId, m_Row["PseudoId"].ToString(), 0, int.MaxValue); Assets = Models.Assets.TicketAssets(OrgId, DeptId, TktId); }