public ActionResult _FilterPost(SaleDeliveryOrderCancelFilterViewModel vm) { List <SaleDeliveryOrderCancelLineViewModel> temp = _SaleDeliveryOrderCancelLineService.GetSaleDeliveryOrderLineForMultiSelect(vm).ToList(); SaleDeliveryOrderCancelMasterDetailModel svm = new SaleDeliveryOrderCancelMasterDetailModel(); svm.SaleDeliveryOrderCancelViewModels = temp; return(PartialView("_Results", svm)); }
public ActionResult _ForOrder(int id, int sid) { SaleDeliveryOrderCancelFilterViewModel vm = new SaleDeliveryOrderCancelFilterViewModel(); vm.SaleDeliveryOrderCancelHeaderId = id; vm.BuyerId = sid; return(PartialView("_Filters", vm)); }
public IEnumerable <SaleDeliveryOrderCancelLineViewModel> GetSaleDeliveryOrderLineForMultiSelect(SaleDeliveryOrderCancelFilterViewModel 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.SaleDeliveryOrderId)) { SaleOrderIdArr = svm.SaleDeliveryOrderId.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.ViewSaleDeliveryOrderBalance join sol in db.SaleOrderLine on p.SaleOrderLineId equals sol.SaleOrderLineId join product in db.Product on sol.ProductId equals product.ProductId into table2 from tab2 in table2.DefaultIfEmpty() join t in db.SaleDeliveryOrderLine on p.SaleDeliveryOrderLineId equals t.SaleDeliveryOrderLineId into table1 from tab1 in table1.DefaultIfEmpty() join t2 in db.SaleDeliveryOrderHeader on tab1.SaleDeliveryOrderHeaderId equals t2.SaleDeliveryOrderHeaderId where (string.IsNullOrEmpty(svm.ProductId) ? 1 == 1 : ProductIdArr.Contains(sol.ProductId.ToString())) && (svm.BuyerId == 0 ? 1 == 1 : p.BuyerId == svm.BuyerId) && (string.IsNullOrEmpty(svm.SaleDeliveryOrderId) ? 1 == 1 : SaleOrderIdArr.Contains(p.SaleDeliveryOrderHeaderId.ToString())) && (string.IsNullOrEmpty(svm.ProductGroupId) ? 1 == 1 : ProductGroupIdArr.Contains(tab2.ProductGroupId.ToString())) && p.BalanceQty > 0 && p.BuyerId == svm.BuyerId orderby t2.DocDate, t2.DocNo, tab1.Sr select new SaleDeliveryOrderCancelLineViewModel { BalanceQty = p.BalanceQty, Qty = 0, SaleDeliveryOrderDocNo = p.SaleDeliveryOrderNo, ProductName = tab2.ProductName, ProductId = sol.ProductId, SaleDeliveryOrderCancelHeaderId = svm.SaleDeliveryOrderCancelHeaderId, SaleDeliveryOrderLineId = p.SaleDeliveryOrderLineId, unitDecimalPlaces = tab2.Unit.DecimalPlaces, DealunitDecimalPlaces = sol.DealUnit.DecimalPlaces, } ); return(temp); }