public dynamic GetAllocateSupplierOrderList([FromBody] Newtonsoft.Json.Linq.JObject param) { DateTime date = System.DateTime.Now; dynamic objresponse = null; dynamic lstResult = new List <dynamic>(); dynamic lstResultAdd = new List <dynamic>(); List <dynamic> lstFinalresult = new List <dynamic>(); dynamic obj = param; int productID = obj.data.productID; DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var SupplierOrderIDList = _repositoryWrapper.Supplierorder.FindByCondition(x => x.inactive == true).Select(x => x.supplierOrderID).ToList(); for (int i = 0; i < SupplierOrderIDList.Count; i++) { string SupplierOrderID = SupplierOrderIDList[i]; var SupplierOrderDetail = _repositoryWrapper.Supplierorder.GetAllocateOrderList(SupplierOrderID, param); var productName = _repositoryWrapper.Product.GetProductName(obj); foreach (var item in SupplierOrderDetail) { int ProductID = item.ProductID; // int CustomerID = item.CustomerID; SupplierorderRepository.SupplierOrderDetailData result = new SupplierorderRepository.SupplierOrderDetailData(); result.SupplierOrderID = SupplierOrderID; result.SupplierName = item.SupplierName; result.ArrivalDate = item.arrivaldate; result.ProductName = _repositoryWrapper.Product.FindByCondition(x => x.productID == ProductID).Select(x => x.productName).FirstOrDefault(); // result.Status = item.status == 1 ? "New" : item.status == 2 ? "Pending" : "Delivered"; result.Shipment = item.Shipment; result.ProductID = item.ProductID; // result.Week3 = item.Week3; // result.Week4 = item.Week4; result.Liter = item.Liter; lstResult.Add(result); } lstResultAdd = _repositoryWrapper.Supplierorder.GetProductNameForSupplierOrder(productName, lstResult); if (lstResultAdd != null) { lstFinalresult.Add(lstResultAdd); lstResult = new List <dynamic>(); } } //lstFinalresult=lstFinalresult.Where(x =>x.productID==productID).ToList(); DataSourceResult list = lstFinalresult.ToDataSourceResult(request); if (list == null) { objresponse = new { data = "", dataFoundRowsCount = 0 }; } else { objresponse = new { data = list.Data, total = list.Total } }; return(objresponse); }
public dynamic GetAllCustomerOrderList([FromBody] Newtonsoft.Json.Linq.JObject param) { dynamic objresponse = null; dynamic lstResult = new List <dynamic>(); dynamic lstResultAdd = new List <dynamic>(); List <dynamic> lstFinalresult = new List <dynamic>(); dynamic obj = param; int productID = obj.data.productID; DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var CustomerOrderIDList = _repositoryWrapper.CustomerOrder.FindByCondition(x => x.inactive == true).Select(x => x.customerOrderID).ToList(); for (int i = 0; i < CustomerOrderIDList.Count; i++) { string CustomerOrderID = CustomerOrderIDList[i]; var CustomerOrderDetail = _repositoryWrapper.CustomerOrder.GetAllCustomerOrderList(CustomerOrderID, param); var productName = _repositoryWrapper.Product.GetProductName(obj); foreach (var item in CustomerOrderDetail) { int ProductID = item.ProductID; int CustomerID = item.CustomerID; CustomerOrderRepository.CustomerOrderDetailData result = new CustomerOrderRepository.CustomerOrderDetailData(); result.CustomerOrderID = CustomerOrderID; result.OrderMonth = item.ordermonth.ToString("MMMM yyyy"); result.CustomerName = _repositoryWrapper.Customer.FindByCondition(x => x.customerID == CustomerID).Select(x => x.customername).FirstOrDefault(); result.ProductName = _repositoryWrapper.Product.FindByCondition(x => x.productID == ProductID).Select(x => x.productName).FirstOrDefault(); result.Status = item.status == 1 ? "New" : item.status == 2 ? "Pending" : "Delivered"; result.Week1 = item.Week1; result.Week2 = item.Week2; result.Week3 = item.Week3; result.Week4 = item.Week4; result.Total = item.Total; lstResult.Add(result); } lstResultAdd = _repositoryWrapper.CustomerOrder.GetProductNameForCustomerOrder(productName, lstResult); if (lstResultAdd != null) { lstFinalresult.Add(lstResultAdd); lstResult = new List <dynamic>(); } } //lstFinalresult=lstFinalresult.Where(x =>x.productID==productID).ToList(); DataSourceResult list = lstFinalresult.ToDataSourceResult(request); if (list == null) { objresponse = new { data = "", dataFoundRowsCount = 0 }; } else { objresponse = new { data = list.Data, total = list.Total } }; return(objresponse); }
public dynamic GetGainLossData([FromBody] Newtonsoft.Json.Linq.JObject param) { dynamic objresponse = null; dynamic obj = param; List <dynamic> mainQuery = new List <dynamic>(); string SupplierOrderID = obj.data; DataSourceRequest request = KendoDataSourceRequestUtil.Parse(param); var movement = _repositoryWrapper.MovementTransaction.GetMovementProductData(SupplierOrderID); mainQuery = _repositoryWrapper.CustomerAssign.GetGainLossData(param, movement); DataSourceResult list = mainQuery.ToDataSourceResult(request); if (mainQuery == null) { objresponse = new { data = "", dataFoundRowsCount = 0 }; } else { objresponse = new { data = list.Data, total = list.Total }; } return(objresponse); }