예제 #1
0
        public async Task OnGetAsync(string Searchstring)
        {
            TableListModel model = new TableListModel();

            var movies = from m in _context.Movie
                         select m;

            if (!String.IsNullOrEmpty(Searchstring))
            {
                movies = movies.Where(s => s.Title.Contains(Searchstring));
            }

            Movie = await movies.ToListAsync();
        }
        public TableListModel GetTableListModel(long id)
        {
            var result = new TableListModel();

            result.Table   = _tableManager.GetById(id);
            result.Columns = _columnManager.List(x => x.TableId == id).OrderBy(x => x.ListOrder).ToList();


            var q = $"SELECT {result.Table.Name}.Id AS Id,";

            foreach (var item in result.Columns.Where(x => x.ShowInList))
            {
                switch (item.ColumnType)
                {
                case ColumnType.SelectList:
                    q += $"{item.TargetTable}.{item.TargetTableTextColumn} AS {item.Name},";
                    break;

                default:
                    q += $"{result.Table.Name}.{item.Name} AS {item.Name},";
                    break;
                }
            }

            q  = q.Trim(',');
            q += $" FROM {result.Table.Name}\n";

            if (result.Columns.Any(x => x.ShowInList && x.ColumnType == ColumnType.SelectList))
            {
                foreach (var item in result.Columns.Where(x => x.ShowInList && x.ColumnType == ColumnType.SelectList))
                {
                    q += $"LEFT JOIN {item.TargetTable} ON {item.TargetTable}.Id={result.Table.Name}.{item.Name} \n";
                }
            }

            if (result.Table.MultipleLanguage)
            {
                q += $" WHERE {result.Table.Name}.LanguageId=" + App.Common.Language.Id;
            }

            result.Entries = new SqlProvider().List(q);
            return(result);
        }
 private static Func <Reservation, bool> ReservationsByTableInfoPredicate(TableListModel tableListModel) => x => x.SelectedTable.ID == tableListModel.ID;
 public ObservableCollection <ReservationListModel> GetReservationsByTableInfoList(TableListModel tableListModel) => GetReservationsCollection(ReservationsByTableInfoPredicate(tableListModel), Mapper.MapEntityToListModel);