public ActionResult _FilterPostOrders(SaleDispatchReturnLineFilterViewModel vm) { List <SaleDispatchReturnLineViewModel> temp = _SaleDispatchReturnLineService.GetSaleOrderForFilters(vm).ToList(); SaleDispatchReturnMasterDetailModel svm = new SaleDispatchReturnMasterDetailModel(); svm.SaleDispatchReturnLineViewModel = temp; return(PartialView("_OrderResults", svm)); }
public ActionResult _ForOrders(int id, int sid) { SaleDispatchReturnLineFilterViewModel vm = new SaleDispatchReturnLineFilterViewModel(); vm.SaleDispatchReturnHeaderId = id; vm.BuyerId = sid; return(PartialView("_OrderFilters", vm)); }
public IEnumerable <SaleDispatchReturnLineViewModel> GetSaleOrderForFilters(SaleDispatchReturnLineFilterViewModel vm) { string[] ProductIdArr = null; if (!string.IsNullOrEmpty(vm.ProductId)) { ProductIdArr = vm.ProductId.Split(",".ToCharArray()); } else { ProductIdArr = new string[] { "NA" }; } string[] SaleOrderIdArr = null; if (!string.IsNullOrEmpty(vm.SaleOrderHeaderId)) { SaleOrderIdArr = vm.SaleOrderHeaderId.Split(",".ToCharArray()); } else { SaleOrderIdArr = new string[] { "NA" }; } string[] ProductGroupIdArr = null; if (!string.IsNullOrEmpty(vm.ProductGroupId)) { ProductGroupIdArr = vm.ProductGroupId.Split(",".ToCharArray()); } else { ProductGroupIdArr = new string[] { "NA" }; } var temp = (from p in db.ViewSaleDispatchBalance join l in db.SaleDispatchLine on p.SaleDispatchLineId equals l.SaleDispatchLineId into linetable from linetab in linetable.DefaultIfEmpty() join t in db.SaleDispatchHeader on p.SaleDispatchHeaderId equals t.SaleDispatchHeaderId into table from tab in table.DefaultIfEmpty() join t1 in db.SaleDispatchLine on p.SaleDispatchLineId equals t1.SaleDispatchLineId into table1 from tab1 in table1.DefaultIfEmpty() join t2 in db.PackingLine on tab1.PackingLineId equals t2.PackingLineId into InvoiceTab from PackTab in InvoiceTab.DefaultIfEmpty() join product in db.Product on p.ProductId equals product.ProductId into table2 from tab2 in table2.DefaultIfEmpty() where (string.IsNullOrEmpty(vm.ProductId) ? 1 == 1 : ProductIdArr.Contains(p.ProductId.ToString())) && (string.IsNullOrEmpty(vm.SaleOrderHeaderId) ? 1 == 1 : SaleOrderIdArr.Contains(p.SaleOrderHeaderId.ToString())) && (string.IsNullOrEmpty(vm.ProductGroupId) ? 1 == 1 : ProductGroupIdArr.Contains(tab2.ProductGroupId.ToString())) && p.BalanceQty > 0 select new SaleDispatchReturnLineViewModel { Dimension1Name = PackTab.Dimension1.Dimension1Name, Dimension2Name = PackTab.Dimension2.Dimension2Name, GoodsReceiptBalQty = p.BalanceQty, Qty = p.BalanceQty, SaleDispatchHeaderDocNo = tab.DocNo, SaleOrderDocNo = PackTab.SaleOrderLine == null ?"" :PackTab.SaleOrderLine.SaleOrderHeader.DocNo, ProductName = tab2.ProductName, ProductId = p.ProductId, SaleDispatchReturnHeaderId = vm.SaleDispatchReturnHeaderId, SaleDispatchLineId = p.SaleDispatchLineId, UnitId = tab2.UnitId, //UnitConversionMultiplier = PackTab.UnitConversionMultiplier??0, DealUnitId = PackTab.DealUnitId, unitDecimalPlaces = tab2.Unit.DecimalPlaces, DealunitDecimalPlaces = PackTab.DealUnit.DecimalPlaces, } ); return(temp); }