public async Task <Tuple <int, List <ConditionDTO> > > LoadAsyncCount( int skip = -1, int take = -1, ConditionSearchViewModel model = null) { var query = Entities.ProjectTo <ConditionDTO>(); if (!string.IsNullOrEmpty(model.Title)) { query = query.Where(x => x.Title.Contains(model.Title)); } if (!string.IsNullOrEmpty(model.Name)) { query = query.Where(x => x.Name.Contains(model.Name)); } int Count = query.Count(); query = query.OrderByDescending(x => x.Id); if (skip != -1) { query = query.Skip((skip - 1) * take); } if (take != -1) { query = query.Take(take); } return(new Tuple <int, List <ConditionDTO> >(Count, await query.ToListAsync())); }
/// <summary> /// Search Icon Tap /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tbxSearch_ActionIconTapped(object sender, EventArgs e) { if (!string.IsNullOrEmpty(tbxSearch.Text) || !string.IsNullOrWhiteSpace(tbxSearch.Text)) { App.ConditionSearchName = tbxSearch.Text; this.Focus(); ConditionSearchViewModel searchViewModel = new ConditionSearchViewModel(); searchViewModel.FillList(); this.DataContext = searchViewModel; } }
public async Task <IActionResult> Index(ConditionSearchViewModel searchModel) { var model = await _conditionRepository.LoadAsyncCount( this.CurrentPage, this.PageSize, searchModel); this.TotalNumber = model.Item1; ViewBag.SearchModel = searchModel; return(View(model.Item2)); }
/// <summary> /// Search Key Up /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tbxSearch_KeyUp(object sender, System.Windows.Input.KeyEventArgs e) { if (e.Key.Equals(Key.Enter)) { if (!string.IsNullOrEmpty(tbxSearch.Text) || !string.IsNullOrWhiteSpace(tbxSearch.Text)) { App.ConditionSearchName = tbxSearch.Text; this.Focus(); ConditionSearchViewModel searchViewModel = new ConditionSearchViewModel(); searchViewModel.FillList(); this.DataContext = searchViewModel; } } }
/// <summary> /// Constructor /// </summary> /// <param name="_objConditionSearchViewModel"></param> public ConditionSearchModel(ConditionSearchViewModel _objConditionSearchViewModel) { this.objConditionSearchViewModel = _objConditionSearchViewModel; RequestData(); }