public ActionResult _FilterPost(SaleDeliveryOrderFilterViewModel vm)
{
List <SaleDeliveryOrderLineViewModel> temp = _SaleDeliveryOrderLineService.GetSaleOrderLineForMultiSelect(vm).ToList();
SaleDeliveryMasterDetailModel svm = new SaleDeliveryMasterDetailModel();
svm.SaleDeliveryOrderLineViewModel = temp;
return(PartialView("_Results", svm));
}
public ActionResult _CreateMultiple(int id, int bid)
{
SaleDeliveryOrderFilterViewModel vm = new SaleDeliveryOrderFilterViewModel();
vm.SaleDeliveryOrderHeaderId = id;
vm.BuyerId = bid;
return(PartialView("_Filters", vm));
}
public IEnumerable <SaleDeliveryOrderLineViewModel> GetSaleOrderLineForMultiSelect(SaleDeliveryOrderFilterViewModel svm)
{
string[] ProductIdArr = null;
if (!string.IsNullOrEmpty(svm.ProductId))
{
ProductIdArr = svm.ProductId.Split(",".ToCharArray());
}
else
{
ProductIdArr = new string[] { "NA" };
}
string[] SaleOrderIdArr = null;
if (!string.IsNullOrEmpty(svm.SaleOrderId))
{
SaleOrderIdArr = svm.SaleOrderId.Split(",".ToCharArray());
}
else
{
SaleOrderIdArr = new string[] { "NA" };
}
string[] ProductGroupIdArr = null;
if (!string.IsNullOrEmpty(svm.ProductGroupId))
{
ProductGroupIdArr = svm.ProductGroupId.Split(",".ToCharArray());
}
else
{
ProductGroupIdArr = new string[] { "NA" };
}
var temp = (from p in db.ViewSaleOrderBalanceForCancellation
join product in db.Product on p.ProductId equals product.ProductId into table2
from tab2 in table2.DefaultIfEmpty()
where (string.IsNullOrEmpty(svm.ProductId) ? 1 == 1 : ProductIdArr.Contains(p.ProductId.ToString())) &&
(svm.BuyerId == 0 ? 1 == 1 : p.BuyerId == svm.BuyerId) &&
(string.IsNullOrEmpty(svm.SaleOrderId) ? 1 == 1 : SaleOrderIdArr.Contains(p.SaleOrderHeaderId.ToString())) &&
(string.IsNullOrEmpty(svm.ProductGroupId) ? 1 == 1 : ProductGroupIdArr.Contains(tab2.ProductGroupId.ToString())) &&
p.BalanceQty > 0
select new SaleDeliveryOrderLineViewModel
{
BalanceQty = p.BalanceQty,
Qty = p.BalanceQty,
SaleOrderDocNo = p.SaleOrderNo,
ProductName = tab2.ProductName,
ProductId = p.ProductId,
SaleDeliveryOrderHeaderId = svm.SaleDeliveryOrderHeaderId,
SaleOrderLineId = p.SaleOrderLineId,
UnitDecimalPlaces = tab2.Unit.DecimalPlaces,
});
return(temp);
}
