public QueryResult<CommoditySupplierListingViewModel> Query(QueryCommoditySupplier query)
{
var queryResult = _commoditySupplierRepository.Query(query);
var result = new QueryResult<CommoditySupplierListingViewModel>();
result.Data = queryResult.Data.Select(Map).ToList();
result.Count = queryResult.Count;
return result;
}
public ActionResult ListCommoditySuppliers(Boolean? showInactive, int page = 1, int itemsperpage = 10, string srchParam = "")
{
try
{
if (itemsperpage != null)
{
ViewModelBase.ItemsPerPage = itemsperpage;
}
bool showinactive = false;
if (showInactive != null)
showinactive = (bool) showInactive;
ViewBag.showInactive = showinactive;
if (TempData["msg"] != null)
{
ViewBag.msg = TempData["msg"].ToString();
TempData["msg"] = null;
}
ViewBag.srchParam = srchParam;
int currentPageIndex = page < 0 ? 0 : page - 1;
int take = itemsperpage;
int skip = take*currentPageIndex;
var query=new QueryCommoditySupplier(){ShowInactive = showinactive,Name = srchParam, Skip = skip, Take = take};
var ls = _commoditySupplierViewModelBuilder.Query(query);
var data = ls.Data;
var count = ls.Count;
return View(data.ToPagedList(currentPageIndex, ViewModelBase.ItemsPerPage, count));
}
catch (Exception ex)
{
_log.Debug("Failed to list hubs " + ex.Message);
_log.Error("Failed to list hubs" + ex.ToString());
return View();
}
}
protected override void Load(bool isFirstLoad = false)
{
Application.Current.Dispatcher.BeginInvoke(
new Action(
delegate
{
if (isFirstLoad)
Setup();
using (var c = NestedContainer)
{
var query = new QueryCommoditySupplier();
query.Skip = ItemsPerPage*(CurrentPage-1);
query.Take = ItemsPerPage;
query.ShowInactive = ShowInactive;
if (!string.IsNullOrWhiteSpace(SearchText))
query.Name = SearchText;
var rawList = Using<ICommoditySupplierRepository>(c).Query(query);
var data = rawList.Data.OfType<CommoditySupplier>();
_pagedCommoditySuppliers = new PagenatedList<CommoditySupplier>(data.AsQueryable(),
CurrentPage,
ItemsPerPage,
rawList.Count,true);
CommoditySuppliersList.Clear();
int rownumber = 0;
_pagedCommoditySuppliers.Select((n, i) => Map(n, i + 1)).ToList().ForEach(
n =>
{
if (n != null)
CommoditySuppliersList.Add(new VMCommoditySupplier
{
SupplierId = n.CommoditySupplier.Id,
CostCenterCode = n.CommoditySupplier.CostCentreCode ?? "",
Name = n.CommoditySupplier.Name??"",
AccountName = n.CommoditySupplier.AccountName??"",
AccountNo = n.CommoditySupplier.AccountNo??"",
Bank =n.CommoditySupplier.BankId!=Guid.Empty? Using<IBankRepository>(c).GetById(n.CommoditySupplier.BankId).Name:"",
BankBranch =n.CommoditySupplier.BankBranchId!=Guid.Empty? Using<IBankBranchRepository>(c).GetById( n.CommoditySupplier.BankBranchId).Name:"",
Status=n.CommoditySupplier._Status,
Action=n.CommoditySupplier._Status==EntityStatus.Active?"Deactivate":"Activate",
RowNumber=++rownumber
});
});
UpdatePagenationControl();
}
}));
}