private IEnumerable <MpiHeader_Test> GetMyProducts(string searchString)
{
var pds = MpiRepo.GetProducts();
return(from t in pds
where
t.NAME.ToLower().Contains(searchString.ToLower())
orderby t.HCAUNIVERSE
select t);
}
public JsonResult AutoComplete(string prefix)
{
var mgrs = MpiRepo.FillManagers();
var locs = (from x in mgrs
where x.ManagerName.ToLower().StartsWith(prefix.ToLower())
select new
{
label = x.ManagerName,
val = x.ManagerId
}).ToList();
return(Json(locs));
}
public object Index(string searchParam, string sortOrder, string q, int page = 1, int pageSize = 25)
{
ViewBag.searchQuery = string.IsNullOrEmpty(q) ? "" : q;
page = page > 0 ? page : 1;
pageSize = pageSize > 0 ? pageSize : 25;
ViewBag.CodeSortParam = sortOrder == "code" ? "code_desc" : "code";
ViewBag.NameSortParam = sortOrder == "name" ? "name_desc" : "name";
ViewBag.CurrentSort = sortOrder;
var productreturns =
from r in MpiRepo.GetAllReturns()
group r by new { r.Code }
into g
select new
{
cd = g.Key.Code,
RRD = g.Max(x => x.Rtndate),
};
var products = MpiRepo.GetProducts();
var resultproducts = from r in productreturns
join s in products on r.cd equals s.CODE
select new MyHeader
{
Code = s.CODE,
Name = s.NAME,
HCAUniverse = s.HCAUNIVERSE,
RRD = r.RRD,
PBMID = s.PrimaryBMID
};
var pageNumber = page; // if no page was specified in the querystring, default to the first page (1)
// will only contain 25 products max because of the pageSize
switch (sortOrder)
{
case "name":
resultproducts = resultproducts.OrderBy(x => x.Name);
break;
case "code":
resultproducts = resultproducts.OrderBy(x => x.Code);
break;
case "name_desc":
resultproducts = resultproducts.OrderByDescending(x => x.Name);
break;
case "code_desc":
resultproducts = resultproducts.OrderByDescending(x => x.Code);
break;
}
if (!string.IsNullOrEmpty(searchParam))
{
resultproducts = from t in resultproducts
where
t.Name.ToLower().Contains(searchParam.ToLower()) |
t.Code.ToLower().Contains(searchParam.ToLower())
select t;
}
var onePageOfProducts = resultproducts.ToPagedList(pageNumber, pageSize);
ViewBag.OnePageOfProducts = onePageOfProducts;
return(View());
}
