/// <summary>
/// Update Supervisor list
/// </summary>
private async Task UpdateSupervisorAsync()
{
SupervisorList = await RegistryHelper.GetSupervisorListAsync();
Page = "1";
_pagedSupervisorList = SupervisorList.GetPaged(int.Parse(Page), CommonHelper.PageLength, SupervisorList.Error);
CommonHelper.Spinner = "";
}
/// <summary>
/// Update application list
/// </summary>
private async Task UpdateApplicationAsync()
{
ApplicationList = await RegistryHelper.GetApplicationListAsync();
Page = "1";
_pagedApplicationList = ApplicationList.GetPaged(int.Parse(Page), CommonHelper.PageLength, ApplicationList.Error);
CommonHelper.CheckErrorOrEmpty(_pagedApplicationList, ref _tableView, ref _tableEmpty);
CommonHelper.Spinner = string.Empty;
}
public PagedResult<T> UpdatePage<T>(Func<PagedResult<T>, Task<PagedResult<T>>> getList,
int page, PagedResult<T> list, ref PagedResult<T> pagedList) where T : class {
var newList = list;
if (!string.IsNullOrEmpty(list.ContinuationToken) && page > pagedList.PageCount) {
list = Task.Run(async () => await getList(newList)).Result;
}
pagedList = list.GetPaged(page, PageLength, null);
return list;
}
/// <summary>
/// OnAfterRenderAsync
/// </summary>
/// <param name="firstRender"></param>
protected override async Task OnAfterRenderAsync(bool firstRender)
{
if (firstRender)
{
GatewayList = await RegistryHelper.GetGatewayListAsync();
Page = "1";
_pagedGatewayList = GatewayList.GetPaged(int.Parse(Page), CommonHelper.PageLength, GatewayList.Error);
CommonHelper.Spinner = string.Empty;
CommonHelper.CheckErrorOrEmpty(_pagedGatewayList, ref _tableView, ref _tableEmpty);
StateHasChanged();
_gatewayEvent = await RegistryServiceEvents.SubscribeGatewayEventsAsync(
ev => InvokeAsync(() => GatewayEvent(ev)));
}
}
public PagedResult <Toy> GetToysPaged(int pageSize, int page, int order, string match, int category)
{
if (order == 1)
{
return(PagedResult <Toy> .GetPaged(Context.Table.Include(x => x.Category).Where(x => x.Name.ToLower().Contains(match.ToLower()) && (x.CategoryId == category || x.Category == null || category <= 0)).OrderBy(x => x.Price), page, pageSize));
}
else if (order == 2)
{
return(PagedResult <Toy> .GetPaged(Context.Table.Include(x => x.Category).Where(x => x.Name.ToLower().Contains(match.ToLower()) && (x.CategoryId == category || x.Category == null || category <= 0)).OrderByDescending(x => x.Price), page, pageSize));
}
else
{
return(PagedResult <Toy> .GetPaged(Context.Table.Include(x => x.Category).Where(x => x.Name.ToLower().Contains(match.ToLower()) && (x.CategoryId == category || x.Category == null || category <= 0)), page, pageSize));
}
}
public ViewResult ProjectList(string notification, int pageNumber = 1, int pageSize = 25, int filter = 0)
{
TempData["currentFilter"] = filter;
var projects = _dbProject.GetInclude(x => x.Client, y => y.DefinedByUser).Where(x => x.Deleted == false).AsQueryable();
switch (filter)
{
case 0:
projects = _dbProject.GetInclude(x => x.Client, y => y.DefinedByUser).Where(x => x.Deleted == false).AsQueryable();
break;
case 1:
projects = _dbProject.GetInclude(x => x.Client, y => y.DefinedByUser).Where(x => x.Deleted == true).AsQueryable();
break;
case 2:
projects = _dbProject.GetInclude(x => x.Client, y => y.DefinedByUser).AsQueryable();
break;
default:
projects = _dbProject.GetInclude(x => x.Client, y => y.DefinedByUser).Where(x => x.Deleted == false).AsQueryable();
break;
}
var Result = PagedResult <Projects> .GetPaged(projects, pageNumber, pageSize);
var finalResult = Result.Results.ToList();
//Parameters
ViewData["pagenumber"] = pageNumber;
ViewData["pagesize"] = pageSize;
ViewData["totalRecords"] = projects.Count();
if (notification != null)
{
ViewData["nvm"] = NotificationHandler.DeserializeMessage(notification);
return(View(finalResult));
}
return(View(finalResult));
}//end ProjectList
public ViewResult CategoryList(string notification, int pageNumber = 1, int pageSize = 25, int filter = 0)
{
TempData["currentFilter"] = filter;
var catList = _dbCategory.GetInclude(x => x.Parent).Where(x => x.Status == true).AsQueryable();
switch (filter)
{
case 0:
catList = _dbCategory.GetInclude(x => x.Parent).Where(x => x.Status == true).AsQueryable();
break;
case 1:
catList = _dbCategory.GetInclude(x => x.Parent).Where(x => x.Status == false).AsQueryable();
break;
case 2:
catList = _dbCategory.GetInclude(x => x.Parent).AsQueryable();
break;
default:
catList = _dbCategory.GetInclude(x => x.Parent).Where(x => x.Status == true).AsQueryable();
break;
}
var Result = PagedResult <Category> .GetPaged(catList, pageNumber, pageSize);
var finalResult = Result.Results.ToList();
//Parameters
ViewData["pagenumber"] = pageNumber;
ViewData["pagesize"] = pageSize;
ViewData["totalRecords"] = catList.Count();
if (notification != null)
{
ViewData["nvm"] = NotificationHandler.DeserializeMessage(notification);
return(View(finalResult));
}
return(View(finalResult));
}//end CategoryList
public PagedResult <T> ReadPage(int page, int pageSize)
{
return(PagedResult <T> .GetPaged(Context.Table.AsQueryable <T>(), page, pageSize));
}
//Inject DataBase--End
#endregion
#region Search Products
public IActionResult Search(string name, int categoryId = -1, int sortBy = 1, int pageNumber = 1, int pageSize = 12)
{
//Filter Name
name = name ?? "";
var products = _db.ProductAbstract
.Include(x => x.Category)
.Include(x => x.Brand)
.Include(x => x.ProductImage)
.Include(x => x.ProductFeature)
.Where(x =>
x.Name.Contains(name) || x.LatinName.ToLower().Contains(name.ToLower()) ||
x.Category.Name.Contains(name) ||
x.Brand.Name.Contains(name)
);
//Filter Category
string FilteredCategory = null;
if (categoryId != -1)
{
products = products.Where(e => e.CategoryId == categoryId);
FilteredCategory = dbCategory.GetAll().Where(e => e.Id == categoryId).FirstOrDefault().Name;
ViewData["FilteredCategory"] = FilteredCategory;
}
//Sort
switch (sortBy)
{
case 1: //newest
products = products.OrderByDescending(x => x.RegDateTime);
break;
case 2: //cheapest
products = products.OrderBy(x => x.BasePrice);
break;
case 3: //mostExpensive
products = products.OrderByDescending(x => x.BasePrice);
break;
case 4: //Name
products = products.OrderByDescending(x => x.Name);
break;
default:
products = products.OrderByDescending(x => x.RegDateTime);
break;
}
//Pagging
var finalResult = PagedResult <ProductAbstract> .GetPaged(products, pageNumber, pageSize);
//Parameters
ViewData["pagenumber"] = pageNumber;
ViewData["pagesize"] = pageSize;
ViewData["totalRecords"] = products.Count();
ViewData["searchedName"] = name;
ViewData["FilteredCategoryId"] = categoryId;
ViewData["sortBy"] = sortBy;
ViewData["IsFilterExist"] = false;
ViewData["dbCategory"] = dbCategory.GetAll().Where(e => e.Status == true).ToList();
if (name != "" || FilteredCategory != null)
{
ViewData["IsFilterExist"] = true;
}
//Result
var result = finalResult.Results.ToList();
return(View(result));
}
