public IEnumerable <sp_BookedTickets_Result> Get(int?id) { try { var res = db.sp_BookedTickets(id).ToList(); if (res == null) { throw new Exception("NO Tickets booked"); } else { return(db.sp_BookedTickets(id).ToList()); } //return db.ProjectInfoes.ToList(); } catch (Exception ex) { throw ex; } }