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();
}
