public IEnumerable <Ticket> GetTop100Tickets(int?locationNumber, int?ticketReference, int?titanCompanyId, string toDate, string fromDate)
{
TeamworksArchiveContext dbContext = new TeamworksArchiveContext();
var CustomerServiceTickets = dbContext.Ticket;
var filteredResults = from tickets in CustomerServiceTickets
select tickets;
if (locationNumber != null)
{
filteredResults = filteredResults.Where(tickets => tickets.CentreNumber == locationNumber);
}
if (ticketReference != null)
{
filteredResults = filteredResults.Where(tickets => tickets.TicketReference == ticketReference);
}
if (titanCompanyId != null)
{
filteredResults = filteredResults.Where(tickets => tickets.TitanCompanyId == titanCompanyId);
}
if (fromDate != null)
{
//var epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
filteredResults = filteredResults.Where(tickets => tickets.CreateDate >= Convert.ToDateTime(fromDate));
}
if (toDate != null)
{
//var epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
filteredResults = filteredResults.Where(tickets => tickets.CreateDate < Convert.ToDateTime(toDate));
}
return(filteredResults.Take(100).OrderBy(o => o.CreateDate).ToList());
}
public IEnumerable <TicketComment> GetTicketComments(int ticketReference)
{
TeamworksArchiveContext dbContext = new TeamworksArchiveContext();
var CustomerServiceTickets = dbContext.TicketComment;
var filteredResults = from ticketComments in CustomerServiceTickets
select ticketComments;
filteredResults = filteredResults.Where(ticketComments => ticketComments.TicketReference == ticketReference);
return(filteredResults.ToList());
}
