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); }