public List <Ticket> SelectLimit(int offset, int limit)
{
try
{
using (var db = new HelpDeskDbContext())
{
var sql = from o in db.Tickets where o.DetailCategory.StartsWith("Transfer Asset") && o.StatusTicket != "Closed" select o;
return(sql.OrderBy(o => o.StartDate).Skip(offset).Take(limit).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public Ticket Select(string ticketId)
{
try
{
using (var db = new HelpDeskDbContext())
{
var sql = from o in db.Tickets where o.TicketId == ticketId select o;
return(sql.Single());
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <Ticket> SelectAll()
{
try
{
using (var db = new HelpDeskDbContext())
{
var sql = from o in db.Tickets where o.DetailCategory.StartsWith("Transfer Asset") && o.StatusTicket != "Closed" select o;
return(sql.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}