public ActionResult _ForOrder(int id, int sid) { RequisitionCancelFilterViewModel vm = new RequisitionCancelFilterViewModel(); vm.RequisitionCancelHeaderId = id; vm.PersonId = sid; return(PartialView("_Filters", vm)); }
public ActionResult _FilterPost(RequisitionCancelFilterViewModel vm) { List <RequisitionCancelLineViewModel> temp = _RequisitionCancelLineService.GetRequisitionLineForOrders(vm).ToList(); RequisitionCancelListModel svm = new RequisitionCancelListModel(); svm.RequisitionCancelViewModels = temp; return(PartialView("_Results", svm)); }
public IEnumerable <RequisitionCancelLineViewModel> GetRequisitionLineForOrders(RequisitionCancelFilterViewModel 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.RequisitionId)) { SaleOrderIdArr = svm.RequisitionId.Split(",".ToCharArray()); } else { SaleOrderIdArr = new string[] { "NA" }; } string[] CostCenterIdArr = null; if (!string.IsNullOrEmpty(svm.CostCenterId)) { CostCenterIdArr = svm.CostCenterId.Split(",".ToCharArray()); } else { CostCenterIdArr = new string[] { "NA" }; } string[] ProductGroupIdArr = null; if (!string.IsNullOrEmpty(svm.ProductGroupId)) { ProductGroupIdArr = svm.ProductGroupId.Split(",".ToCharArray()); } else { ProductGroupIdArr = new string[] { "NA" }; } string[] Dimension1IdArr = null; if (!string.IsNullOrEmpty(svm.Dimension1Id)) { Dimension1IdArr = svm.Dimension1Id.Split(",".ToCharArray()); } else { Dimension1IdArr = new string[] { "NA" }; } string[] Dimension2IdArr = null; if (!string.IsNullOrEmpty(svm.Dimension2Id)) { Dimension2IdArr = svm.Dimension2Id.Split(",".ToCharArray()); } else { Dimension2IdArr = new string[] { "NA" }; } var Query = (from p in db.ViewRequisitionBalance join product in db.Product on p.ProductId equals product.ProductId into table2 from tab2 in table2.DefaultIfEmpty() join t in db.RequisitionLine on p.RequisitionLineId equals t.RequisitionLineId into table1 from tab1 in table1.DefaultIfEmpty() join t2 in db.RequisitionHeader on tab1.RequisitionHeaderId equals t2.RequisitionHeaderId where p.BalanceQty > 0 && p.PersonId == svm.PersonId orderby t2.DocDate, t2.DocNo select new { BalanceQty = p.BalanceQty, Qty = 0, RequisitionDocNo = p.RequisitionNo, ProductName = tab2.ProductName, ProductId = p.ProductId, RequisitionCancelHeaderId = svm.RequisitionCancelHeaderId, RequisitionLineId = p.RequisitionLineId, unitDecimalPlaces = tab2.Unit.DecimalPlaces, UnitId = tab2.UnitId, UnitName = tab2.Unit.UnitName, Dimension1Name = tab1.Dimension1.Dimension1Name, Dimension2Name = tab1.Dimension2.Dimension2Name, Specification = tab1.Specification, //ForFilters PersonId = p.PersonId, RequisitionHeaderId = p.RequisitionHeaderId, CostCenterId = p.CostCenterId, ProductGorupId = tab2.ProductGroupId, Dimension1Id = tab1.Dimension1Id, Dimension2Id = tab1.Dimension2Id, } ); if (!string.IsNullOrEmpty(svm.ProductId)) { Query = Query.Where(m => ProductIdArr.Contains(m.ProductId.ToString())); } if (svm.PersonId != 0) { Query = Query.Where(m => m.PersonId == svm.PersonId); } if (!string.IsNullOrEmpty(svm.RequisitionId)) { Query = Query.Where(m => SaleOrderIdArr.Contains(m.RequisitionHeaderId.ToString())); } if (!string.IsNullOrEmpty(svm.CostCenterId)) { Query = Query.Where(m => CostCenterIdArr.Contains(m.CostCenterId.ToString())); } if (!string.IsNullOrEmpty(svm.ProductGroupId)) { Query = Query.Where(m => ProductGroupIdArr.Contains(m.ProductGorupId.ToString())); } if (!string.IsNullOrEmpty(svm.Dimension1Id)) { Query = Query.Where(m => Dimension1IdArr.Contains(m.Dimension1Id.ToString())); } if (!string.IsNullOrEmpty(svm.Dimension2Id)) { Query = Query.Where(m => Dimension2IdArr.Contains(m.Dimension2Id.ToString())); } return(Query.Select(m => new RequisitionCancelLineViewModel { BalanceQty = m.BalanceQty, Qty = 0, RequisitionDocNo = m.RequisitionDocNo, ProductName = m.ProductName, ProductId = m.ProductId, RequisitionCancelHeaderId = m.RequisitionCancelHeaderId, RequisitionLineId = m.RequisitionLineId, unitDecimalPlaces = m.unitDecimalPlaces, UnitId = m.UnitId, UnitName = m.UnitName, Dimension1Name = m.Dimension1Name, Dimension2Name = m.Dimension2Name, Specification = m.Specification, })); }