protected void btFind_Click(object sender, EventArgs e) { DateTime? from = ctrlDatePickerRequestFrom.SelectedDate; DateTime? to = ctrlDatePickerRequestTo.SelectedDate; int orderId = 0; int.TryParse(txtOrderId.Text, out orderId); int custId = 0; int.TryParse(ctrlCustomerSelect.CustomerId, out custId); int productId = 0; int.TryParse(ddlProducts.SelectedValue, out productId); int manufactureId = 0; int.TryParse(ctrlManufactureSelect.CustomerId, out manufactureId); List<int> printingTypeIds = ctrlPrintingTypeSelect.SelectedValues; int manuRequestStatus = 0; int.TryParse(ddlManufactureStatus.SelectedValue, out manuRequestStatus); int businessManId = 0; int.TryParse(ddlBusinessMan.SelectedValue, out businessManId); int designerId = 0; int.TryParse(ddlDesigners.SelectedValue, out designerId); ManufactureRequestSearch manuSearchObj = new ManufactureRequestSearch() { From = from, To = to, OrderId = orderId, CustomerId = custId, ProductId = productId, ManufactureId = manufactureId, PrintTypeIds = printingTypeIds, ManufactureRequestStatus = (ManufactureRequestStatusEnum)manuRequestStatus, BusinessManId = businessManId, DesignerId = designerId }; List<ManufactureRequestBO> manus = this.OrderService.GetManufactureRequests(manuSearchObj); grvManufactureRequest.DataSource = manus; grvManufactureRequest.DataBind(); }
public List<ManufactureRequestBO> GetManufactureRequests(ManufactureRequestSearch manuSearchObj) { return orderDao.GetManufactureRequests(manuSearchObj); }
public List<ManufactureRequestBO> GetManufactureRequests(ManufactureRequestSearch manuSearchObj) { using (var context = new InThuDoEntities()) { var query = from m in context.ManufactureRequests join ds in context.DesignRequests on m.DesignRequestId equals ds.DesignRequestId join oi in context.OrderItems on ds.OrderItemId equals oi.OrderItemId join o in context.Orders on oi.OrderId equals o.OrderId where (m.Deleted == false || m.Deleted == null) && (ds.Deleted == false || ds.Deleted == null) && (oi.Deleted == false || oi.Deleted == null) && (o.Deleted == false || o.Deleted == null) & (manuSearchObj.From == null || manuSearchObj.From <= m.CreatedOn) && (manuSearchObj.To == null || manuSearchObj.To >= m.CustomerApprovedDate || manuSearchObj.To >= m.EndDate || manuSearchObj.To >= m.BeginDate) && (manuSearchObj.CustomerId == 0 || manuSearchObj.CustomerId == o.CustomerId) && (manuSearchObj.ProductId == 0 || manuSearchObj.ProductId == oi.ProductId)&& (manuSearchObj.DesignerId ==0 || manuSearchObj.DesignerId == ds.DesignerId)&& (manuSearchObj.BusinessManId ==0 || manuSearchObj.BusinessManId == o.UserId)&& (manuSearchObj.ManufactureId == 0 || manuSearchObj.ManufactureId == m.ManufactureId)&& (manuSearchObj.PrintTypeIds.Count ==0 || manuSearchObj.PrintTypeIds.Contains(oi.PrintingTypeId))&& (manuSearchObj.OrderId ==0 || manuSearchObj.OrderId == o.OrderId) select m; List<ManufactureRequestBO> manuRequests = this.MapManufactureRequestList(query); if (manuSearchObj.ManufactureRequestStatus != 0) { manuRequests = manuRequests.Where(m => m.ManufactureRequestStatus == manuSearchObj.ManufactureRequestStatus).ToList(); } return manuRequests; } }