public ActionResult TransferList()
{
SalePointProductAddList request = new SalePointProductAddList();
List <SalePoint> SalePointList = new List <SalePoint>();
SalePointList = AgroExpressDBAccess.GetallEnabledSalePoint();
request.salepointlist = SalePointList.Select(x => new SelectListItem
{
Value = x.PKSalePointID.ToString(),
Text = x.SalePointName
});
var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct();
request.product = ProductInf.Select(x => new SelectListItem
{
Value = x.PKProductId.ToString(),
Text = x.ProductName
});
request.EntryDateMax = System.DateTime.Now;
request.EntryDateMin = request.EntryDateMax.AddMonths(-1);
request.SearchResult = AgroExpressDBAccess.GetSellPointProductAdd(request.EntryDateMin, request.EntryDateMax).OrderBy(a => a.Date).ToList();
return(View(request));
}
public ActionResult TransferList(SalePointProductAddList request)
{
List <SalePoint> SalePointList = new List <SalePoint>();
SalePointList = AgroExpressDBAccess.GetallEnabledSalePoint();
request.salepointlist = SalePointList.Select(x => new SelectListItem
{
Value = x.PKSalePointID.ToString(),
Text = x.SalePointName
});
var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct();
request.product = ProductInf.Select(x => new SelectListItem
{
Value = x.PKProductId.ToString(),
Text = x.ProductName
});
if (ModelState.IsValid)
{
var result = AgroExpressDBAccess.GetSellPointProductAdd(request.EntryDateMin, request.EntryDateMax).OrderBy(a => a.Date).ToList();
if (request.ProductId != null)
{
result = result.Where(a => a.ProductId == request.ProductId).ToList();
}
if (request.SalePointId != null)
{
result = result.Where(a => a.SalePointId == request.SalePointId).ToList();
}
if (request.StockAmountMin != null)
{
result = result.Where(a => a.Amount >= request.StockAmountMin).ToList();
}
if (request.StockAmountMAx != null)
{
result = result.Where(a => a.Amount <= request.StockAmountMAx).ToList();
}
request.SearchResult = result.OrderBy(a => a.salepoint.SalePointName).ToList();
}
return(View(request));
}
