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