public IQueryable <Text> FindAllByGHLocationID(long id)
 {
     try
     {
         return(_tr.FindAllByGHLocationID(id));
     }
     catch (Exception ex)
     {
         Log.Error(ex.Message, ex);
         return(null);
     }
 }