public List <OrderViewModel> Search(OrderSearchModel searchModel)
        {
            var accounts = _accountContext.Accounts.Select(x => new { x.Id, x.Fullname }).ToList();
            var query    = _context.Orders.Select(x => new OrderViewModel
            {
                Id              = x.Id,
                AccountId       = x.AccountId,
                DiscountAmount  = x.DiscountAmount,
                IsCanceled      = x.IsCanceled,
                IsPaid          = x.IsPaid,
                IssueTrackingNo = x.IssueTrackingNo,
                PayAmount       = x.PayAmount,
                PaymentMethodId = x.PaymentMethod,
                RefId           = x.RefId,
                TotalAmount     = x.TotalAmount,
                CreationDate    = x.CreateionDate.ToFarsi()
            });

            query = query.Where(x => x.IsCanceled == searchModel.IsCanceled);

            if (searchModel.AccountId > 0)
            {
                query = query.Where(x => x.AccountId == searchModel.AccountId);
            }

            var orders = query.OrderByDescending(x => x.Id).ToList();

            foreach (var order in orders)
            {
                order.AccountFullName = accounts.FirstOrDefault(x => x.Id == order.AccountId)?.Fullname;
                order.PaymentMethod   = PaymentMethod.GetBy(order.PaymentMethodId).Name;
            }

            return(orders);
        }
        public void OrderController_Index_ShouldReturnTheSearchModelAsTheModel()
        {
            var orderSearchModel = new OrderSearchModel();
            var result           = _orderController.Index(orderSearchModel);

            result.Model.Should().Be(orderSearchModel);
        }
Exemplo n.º 3
0
        public IPagedList <Order> SearchOrders(OrderSearchModel model, int page = 1, int pageSize = 10)
        {
            var query = new OrderSearchQuery(model);

            return(_orderSearcher.Search(query.GetQuery(), page, pageSize, query.GetFilter(),
                                         new Sort(new SortField("id", SortField.INT, true))));
        }
Exemplo n.º 4
0
        public JsonResult getConfirmOrders([System.Web.Http.FromBody] OrderSearchModel data)
        {
            OrderBO bo    = new OrderBO();
            var     datas = bo.getConfirmedOrders(data);

            return(Json(datas));
        }
        public ActionResult List(OrderSearchModel model)
        {
            System.Web.HttpContext.Current.Session["ActiveOrder"] = null;
            int pageIndex = model.Page ?? 1;
            var orderList = _orderService.GetOrderDetailItems().Where(x =>
                                                                      (string.IsNullOrEmpty(model.OrderNo) ||
                                                                       x.OrderNoSeries.Trim().Contains(model.OrderNo.Trim()))
                                                                      &
                                                                      (model.StatusId == 0 || model.StatusId == null ||
                                                                       x.StatusId == model.StatusId)
                                                                      &
                                                                      (x.OrderDate >= Convert.ToDateTime(model.StartDateTime) & x.OrderDate <= Convert.ToDateTime(model.EndDateTime))
                                                                      );

            var data = _mapper.Map <List <OrderDetailItemModel> >(orderList);

            model.StatusList            = GetStatusList();
            model.Status2List           = GetStatusList();
            model.OrderDetailItemModels = data.ToPagedList(pageIndex, 10);
            if (Request.IsAjaxRequest())
            {
                return(PartialView("_OrderList", model));
            }
            return(View(model));
        }
Exemplo n.º 6
0
        public IPagedList <Order> Search(OrderSearchModel model)
        {
            var query = new OrderSearchQuery(model);

            return(_orderSearcher.Search(query.GetQuery(), model.Page, filter: query.GetFilter(),
                                         sort: new Sort(new SortField("id", SortField.INT, true))));
        }
Exemplo n.º 7
0
        public HttpResponseMessage GetUserStatics(int limit, int page)
        {
            ResultMsg resultMsg = new ResultMsg();

            try
            {
                if (limit < 1)
                {
                    limit = 10;
                }
                if (page < 1)
                {
                    page = 1;
                }
                OrderSearchModel search = new OrderSearchModel();
                search.limit = limit;
                search.page  = page;
                using (T_AdminRepository repository = new T_AdminRepository())
                {
                    var pagelist = repository.GetVSUserPageList(search.page, search.limit);
                    resultMsg.data  = pagelist.Data;
                    resultMsg.count = pagelist.TotalItemCount;
                }
            }
            catch (Exception ex)
            {
                resultMsg.code = (int)StatusCodeEnum.Error;
                resultMsg.msg  = ex.Message;
            }
            return(resultMsg.toJson());
        }
        public async Task <IEnumerable <BaseOrderInfo> > GetOrdersAsync(OrderSearchModel orderSearchModel, int skip, int take)
        {
            using (IUnitOfWork unitOfWork = _unitOfWorkFactory.Create())
            {
                var orders    = unitOfWork.Repository <Order>().Query();
                var autos     = unitOfWork.Repository <Auto>().Query();
                var customers = unitOfWork.Repository <Customer>().Query();

                var query = from o in orders
                            join a in autos on o.AutoId equals a.Id
                            join c in customers on o.CustomerId equals c.Id
                            where (orderSearchModel.TypeId > 0 ? a.TypeId == orderSearchModel.TypeId : true) &&
                            (orderSearchModel.MarkId > 0 ? a.MarkId == orderSearchModel.MarkId : true) &&
                            (orderSearchModel.ModelId > 0 ? a.ModelId == orderSearchModel.ModelId : true) &&
                            (!string.IsNullOrWhiteSpace(orderSearchModel.City) ? a.City == orderSearchModel.City : true) &&
                            (orderSearchModel.MinYear > 0 ? a.Year >= orderSearchModel.MinYear : true) &&
                            (orderSearchModel.MaxYear > 0 ? a.Year <= orderSearchModel.MaxYear : true)
                            select new BaseOrderInfo
                {
                    OrderId           = o.Id,
                    CustomerId        = c.Id,
                    CustomerFirstName = c.FirstName,
                    CustomerLastName  = c.LastName,
                    CustomerPhotoUrl  = c.Avatar,
                    AutoId            = a.Id,
                    MarkName          = a.MarkName,
                    ModelName         = a.ModelName,
                    CarPhotoUrl       = a.PhotoLink
                };

                return(await query.Skip(skip).Take(take).ToListAsync());
            }
        }
        public void OrderController_Index_ShouldCallOrderServiceGetAllPagedWithPassedArgument()
        {
            var orderSearchModel = new OrderSearchModel();
            var result           = _orderController.Index(orderSearchModel);

            A.CallTo(() => _orderAdminService.Search(orderSearchModel)).MustHaveHappened();
        }
Exemplo n.º 10
0
        public ActionResult ChargeOrders(OrderSearchModel searchModel)
        {
            OrderManagement orderMgt = new OrderManagement(User.Identity.GetUserId <int>());
            int             pageSize = 30;
            DateTime        sDate    = DateTime.MinValue;
            DateTime        eDate    = DateTime.MinValue;

            if (!string.IsNullOrEmpty(searchModel.StartTime))
            {
                DateTime.TryParse(searchModel.StartTime, out sDate);
            }
            if (!string.IsNullOrEmpty(searchModel.EndTime))
            {
                DateTime.TryParse(searchModel.EndTime, out eDate);
            }
            long sintDate = sDate != DateTime.MinValue ? DateTimeUtil.ConvertDateTimeToInt(sDate) : 0;
            long eintDate = eDate != DateTime.MinValue ? DateTimeUtil.ConvertDateTimeToInt(eDate) : 0;
            int  page     = 1;

            if (Request["page"] != null)
            {
                int.TryParse(Request["page"], out page);
            }
            searchModel.Page     = page;
            searchModel.AgencyId = User.Identity.GetUserId <int>();
            List <BOrder> orders = orderMgt.FindOrders(searchModel.OrderId != null ? (int)searchModel.OrderId : 0,
                                                       searchModel.AgencyId != null ? (int)searchModel.AgencyId : 0,
                                                       searchModel.ResourceId != null ? (int)searchModel.ResourceId : 0,
                                                       searchModel.ResourceTaocanId != null ? (int)searchModel.ResourceTaocanId : 0,
                                                       searchModel.RuoteId != null ? (int)searchModel.RuoteId : 0,
                                                       searchModel.SPName, searchModel.MobileNumber,
                                                       searchModel.Status,
                                                       sintDate,
                                                       eintDate,
                                                       out total,
                                                       pageSize,
                                                       searchModel.Page, true);
            PageItemsResult <BOrder> result = new PageItemsResult <BOrder>()
            {
                CurrentPage = searchModel.Page, Items = orders, PageSize = pageSize, TotalRecords = total, EnablePaging = true
            };

            KMBit.Grids.KMGrid <BOrder> grid  = new Grids.KMGrid <BOrder>(result);
            BigOrderSearchModel         model = new BigOrderSearchModel()
            {
                SearchModel = searchModel, OrderGrid = grid
            };
            List <BResourceTaocan> taocans = new List <BResourceTaocan>();

            agentMgt = new AgentManagement(orderMgt.CurrentLoginUser);
            List <BAgentRoute> routes = agentMgt.FindTaocans(0);

            taocans            = (from r in routes select r.Taocan).ToList <BResourceTaocan>();
            ViewBag.Taocans    = new SelectList((from t in taocans select new { Id = t.Taocan.Id, Name = t.Taocan2.Name }), "Id", "Name");
            ViewBag.StatusList = new SelectList((from s in StaticDictionary.GetChargeStatusList() select new { Id = s.Id, Name = s.Value }), "Id", "Name");
            return(View(model));
        }
        public ViewResult Index(OrderSearchModel model)
        {
            ViewData["shipping-status-options"] = _orderAdminService.GetShippingStatusOptions();
            ViewData["payment-status-options"]  = _orderAdminService.GetPaymentStatusOptions();

            ViewData["results"] = _orderAdminService.Search(model);

            return(View("Index", model));
        }
        public void Search()
        {
            OrderSearchModel model = new OrderSearchModel();

            ActionResult result = orderController.Search(model);

            Assert.IsTrue(result != null);
            Assert.Pass(result.ToString());
        }
        public void OrderController_Index_ShouldReturnTheResultOfTheCallToTheServiceAsViewData()
        {
            var orderSearchModel = new OrderSearchModel();
            var pagedList        = PagedList <Order> .Empty;

            A.CallTo(() => _orderAdminService.Search(orderSearchModel)).Returns(pagedList);
            var result = _orderController.Index(orderSearchModel);

            result.ViewData["results"].Should().Be(pagedList);
        }
        public virtual IActionResult OrderList(OrderSearchModel searchModel)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManageOrders))
            {
                return(AccessDeniedDataTablesJson());
            }

            //prepare model
            var model = _shipRocketService.PrepareOrderListModel(searchModel);

            return(Json(model));
        }
Exemplo n.º 15
0
 public ActionResult <IEnumerable <Order> > SearchOrders([FromQuery] OrderSearchModel searchModel)
 {
     try
     {
         return(this._orderRepository.SearchOrders(searchModel).ToList());
     }
     catch (Exception ex)
     {
         this._logger.LogError(exception: ex, message: "Error occurred.");
         return(BadRequest("Error occurred."));
     }
 }
Exemplo n.º 16
0
 public OrderSearchQuery(OrderSearchModel orderSearchModel)
 {
     SearchText     = orderSearchModel.SearchText;
     OrderId        = orderSearchModel.OrderId;
     DateFrom       = orderSearchModel.DateFrom;
     DateTo         = orderSearchModel.DateTo;
     PaymentStatus  = orderSearchModel.PaymentStatus;
     ShippingStatus = orderSearchModel.ShippingStatus;
     SalesChannel   = orderSearchModel.SalesChannel;
     OrderTotalFrom = orderSearchModel.OrderTotalFrom;
     OrderTotalTo   = orderSearchModel.OrderTotalTo;
 }
Exemplo n.º 17
0
        public IPagedList <Order> SearchOrders(OrderSearchModel model)
        {
            var queryOver = _session.QueryOver <Order>();

            if (!String.IsNullOrWhiteSpace(model.SearchText))
            {
                queryOver = queryOver.Where(o => o.OrderEmail.IsInsensitiveLike(model.SearchText, MatchMode.Anywhere) ||
                                            o.BillingAddress.LastName.IsInsensitiveLike(model.SearchText, MatchMode.Anywhere));
            }

            if (model.DateFrom.HasValue)
            {
                queryOver = queryOver.Where(o => (o.OrderDate != null && o.OrderDate > model.DateFrom) || (o.OrderDate == null && o.CreatedOn > model.DateFrom.Value));
            }

            if (model.DateTo.HasValue)
            {
                queryOver = queryOver.Where(o => (o.OrderDate != null && o.OrderDate < model.DateTo) || (o.OrderDate == null && o.CreatedOn < model.DateTo.Value));
            }

            if (!String.IsNullOrWhiteSpace(model.OrderId))
            {
                queryOver = queryOver.Where(o => o.Id == Convert.ToInt32(model.OrderId));
            }

            if (model.PaymentStatus.HasValue)
            {
                queryOver = queryOver.Where(o => o.PaymentStatus == model.PaymentStatus);
            }

            if (model.ShippingStatus.HasValue)
            {
                queryOver = queryOver.Where(o => o.ShippingStatus == model.ShippingStatus);
            }

            if (!String.IsNullOrWhiteSpace(model.SalesChannel))
            {
                queryOver = queryOver.Where(o => o.SalesChannel == model.SalesChannel);
            }

            if (model.OrderTotalFrom.HasValue)
            {
                queryOver = queryOver.Where(x => x.Total > model.OrderTotalFrom);
            }

            if (model.OrderTotalTo.HasValue)
            {
                queryOver = queryOver.Where(x => x.Total < model.OrderTotalTo);
            }

            return(queryOver.OrderBy(order => order.Id).Desc.Paged(model.Page));
        }
Exemplo n.º 18
0
 private void instances()
 {
     _taxesList                   = new List <QOBDCommon.Entities.Tax>();
     _currenciesList              = new List <CurrencyModel>();
     _order                       = new Entity.Order();
     OrderTask                    = new NotifyTaskCompletion <List <QOBDCommon.Entities.Order> >();
     OrderModelTask               = new NotifyTaskCompletion <List <OrderModel> >();
     TaxTask                      = new NotifyTaskCompletion <List <QOBDCommon.Entities.Tax> >();
     _title                       = "";
     _orderSearchModel            = new OrderSearchModel();
     _blockOrderVisibility        = "Visible";
     _blockSearchResultVisibility = "Hidden";
 }
Exemplo n.º 19
0
        public List <OrderDetailModel> GetList(OrderSearchModel searchModel)
        {
            var result = new List <OrderDetailModel>();

            for (var i = 0; i < 20; i++)
            {
                result.Add(new OrderDetailModel()
                {
                    OrderNo      = i.ToString().PadLeft(9),
                    CreateTime   = DateTime.Now,
                    CustomerName = $"顾客{i}",
                });
            }
            return(result);
        }
        public List <OrderViewModel> Search(OrderSearchModel searchModel)
        {
            var accounts = _accountContext.Accounts.Select(x => new { x.Id, x.FullName });
            var query    = _shopContext.Orders.Select(x => new OrderViewModel
            {
                Id              = x.Id,
                AccountId       = x.AccountId,
                DiscountAmount  = x.DiscountAmount,
                IsCanceled      = x.IsCanceled,
                IsPaid          = x.IsPaid,
                IssueTrackingNo = x.IssueTrackingNo,
                PayAmount       = x.PayAmount,
                RefId           = x.RefId,
                TotalAmount     = x.TotalAmount,
                CreationDate    = x.CreationDate.ToFarsi(),
            });

            query = query.Where(x => x.IsCanceled == searchModel.IsCanceled);

            if (searchModel.AccountId > 0)
            {
                query = query.Where(x => x.AccountId == searchModel.AccountId);
            }
            if (!string.IsNullOrWhiteSpace(searchModel.AccountName))
            {
                var ords = query.OrderByDescending(x => x.Id).ToList();

                foreach (var order in ords)
                {
                    order.AccountFullname = accounts.FirstOrDefault(x => x.Id == order.AccountId)?.FullName;
                }
                query = query.Where(x => x.AccountFullname.Contains(searchModel.AccountName));
            }
            if (!string.IsNullOrWhiteSpace(searchModel.IssueTrackingNo))
            {
                query = query.Where(x => x.IssueTrackingNo.Contains(searchModel.IssueTrackingNo));
            }

            var orders = query.OrderByDescending(x => x.Id).ToList();

            foreach (var order in orders)
            {
                order.AccountFullname = accounts.FirstOrDefault(x => x.Id == order.AccountId)?.FullName;
            }

            return(orders);
        }
Exemplo n.º 21
0
        public ActionResult Search(OrderSearchModel model)
        {
            var Msg = new Message();

            try
            {
                List <DVG.WIS.PublicModel.OrderOnListModel> listOrders = new List <DVG.WIS.PublicModel.OrderOnListModel>();
                int totalRow = 0;
                listOrders = _orderBo.GetList(model.KeyWord, model.Status, model.SourceType, model.DeliveryStatus, model.OrderType, model.FromCreatedDate, model.ToCreatedDate, model.RequestType, out totalRow, model.PageIndex, model.PageSize).ToList();
                List <District> listDistrict = _districtBoCached.GetAll().ToList();

                // nếu là màn hình bếp => lấy list Món ra
                var isDisplayListOrderDetails = (_userService.GetRole() == UserTypeEnum.Kitchen.GetHashCode() || _userService.GetRole() == UserTypeEnum.Checkfood.GetHashCode()) &&
                                                (model.Status == OrderStatusEnum.Pending.GetHashCode() || model.Status == OrderStatusEnum.PushToPOS.GetHashCode() || model.Status == OrderStatusEnum.KitchenAccept.GetHashCode() || model.Status == OrderStatusEnum.KitchenDone.GetHashCode());

                if (listOrders.Any())
                {
                    foreach (var item in listOrders)
                    {
                        var district = listDistrict.Find(x => x.district_id == item.DistrictId);
                        if (district != null)
                        {
                            item.DistrictStr = district.district_name;
                        }

                        if (isDisplayListOrderDetails)
                        {
                            item.lstOrderDetail = _orderBo.GetByOrderId(item.OrderId);
                        }
                    }
                }
                var pager = new Pager {
                    CurrentPage = model.PageIndex, PageSize = model.PageSize, TotalItem = totalRow
                };
                Msg.Obj = new { SearchModel = model, Data = listOrders, Pager = pager };
            }
            catch (Exception ex)
            {
                Msg.Obj   = null;
                Msg.Title = ex.Message;
                Msg.Error = true;
            }

            return(AuthorizeJson(Msg));
        }
Exemplo n.º 22
0
        public JsonResult getNotPayOrders([System.Web.Http.FromBody] OrderSearchModel data)
        {
            OrderBO bo      = new OrderBO();
            var     filUtil = new FileUploadProcess();
            var     res     = bo.getNotPayOrders(data);

            if (res.IsThereValues())
            {
                foreach (var d in res)
                {
                    if (d.payment.IsThereValues() && d.payment.file.IsThereValues())
                    {
                        d.payment.file.fileName = filUtil.GenerateHTTPFilePath(d.payment.file.fileName, JSettings.GoogleCloudStorage.Bucket.OrderPaymentSlip);
                    }
                }
            }

            return(Json(res));
        }
Exemplo n.º 23
0
        public HttpResponseMessage GetOrderList(int limit, int page, int?SearchShopID = null, string SearchDate = null)
        {
            ResultMsg resultMsg = new ResultMsg();

            try
            {
                if (limit < 1)
                {
                    limit = 10;
                }
                if (page < 1)
                {
                    page = 1;
                }
                OrderSearchModel search = new OrderSearchModel();
                search.ShopID = SearchShopID;

                if (!string.IsNullOrWhiteSpace(SearchDate))
                {
                    Regex reg   = new Regex(@"[0-9]{4}[/-][0-9]{1,2}[/-][0-9]{1,2}");
                    var   dates = reg.Matches(SearchDate);
                    if (dates.Count > 1)
                    {
                        search.BTimeStart = Convert.ToDateTime(dates[0].Value);
                        search.BTimeEnd   = Convert.ToDateTime(dates[1].Value).AddDays(1);
                    }
                }
                search.limit = limit;
                search.page  = page;
                using (IT_Order repository = new T_OrderRepository())
                {
                    var pagelist = repository.GetVOrderPageList(search);
                    resultMsg.data  = pagelist.Data;
                    resultMsg.count = pagelist.TotalItemCount;
                }
            }
            catch (Exception ex)
            {
                resultMsg.code = (int)StatusCodeEnum.Error;
                resultMsg.msg  = ex.Message;
            }
            return(resultMsg.toJson());
        }
Exemplo n.º 24
0
        public ActionResult Search(OrderSearchModel model)
        {
            ResponseData responseData = new ResponseData();

            try
            {
                List <DVG.WIS.PublicModel.OrderOnListModel> listOrders = new List <DVG.WIS.PublicModel.OrderOnListModel>();
                int totalRow = 0;
                listOrders = _orderBo.GetList(model.KeyWord, model.Status, model.SourceType, model.DeliveryStatus, model.OrderType, model.FromCreatedDate, model.ToCreatedDate, model.RequestType, out totalRow, model.PageIndex, model.PageSize).ToList();
                List <District> listDistrict = (List <District>)_districtBoCached.GetAll();

                // nếu là màn hình bếp => lấy list Món ra
                var isDisplayListOrderDetails = _userService.GetRole() == UserTypeEnum.Kitchen.GetHashCode() &&
                                                (model.Status == OrderStatusEnum.PushToPOS.GetHashCode() || model.Status == OrderStatusEnum.KitchenAccept.GetHashCode());

                if (listOrders.Any())
                {
                    foreach (var item in listOrders)
                    {
                        var district = listDistrict.Find(x => x.district_id == item.DistrictId);
                        if (district != null)
                        {
                            item.DistrictStr = district.district_name;
                        }

                        if (isDisplayListOrderDetails)
                        {
                            item.lstOrderDetail = _orderBo.GetByOrderId(item.OrderId);
                        }
                    }
                }
                responseData.Data     = listOrders;
                responseData.TotalRow = totalRow;
                responseData.Success  = true;
            }
            catch (Exception ex)
            {
                responseData.Data    = null;
                responseData.Success = false;
            }

            return(Json(responseData));
        }
Exemplo n.º 25
0
        public PagedList <VOrderModel> GetVOrderPageList(OrderSearchModel search)
        {
            var queryList = from o in context.T_Order
                            join s in context.T_Shop on o.ShopID.ToString() equals s.ID.ToString()
                            select new VOrderModel
            {
                ID           = o.ID,
                Mobile       = o.Mobile,
                ShopID       = o.ShopID,
                ShopName     = s.ShopName,
                ShopAddress  = s.ShopAddress,
                ShopPhoneNum = s.ShopPhoneNum,
                BTime        = o.BTime,
                ETime        = o.ETime,
                Duration     = o.Duration,
                Ver_Code     = o.Ver_Code,
                OrderNo      = o.OrderNo,
                ParentNo     = o.ParentNo,
                CardNo       = o.CardNo,
                CTime        = o.CTime,
                FeeCode      = o.FeeCode,
                ReMarks      = o.ReMarks,
                Flag         = o.Flag,
                PayStatus    = o.PayStatus
            };

            if (search.ShopID.HasValue)
            {
                queryList = queryList.Where(o => o.ShopID == search.ShopID);
            }
            if (search.BTimeStart.HasValue)
            {
                queryList = queryList.Where(o => o.BTime >= search.BTimeStart);
            }
            if (search.BTimeEnd.HasValue)
            {
                queryList = queryList.Where(o => o.BTime < search.BTimeEnd);
            }

            queryList = queryList.OrderByDescending(o => o.BTime);
            return(queryList.ToPagedList(search.page, search.limit));
        }
Exemplo n.º 26
0
        public IActionResult Order(int customerId, short?page = 1)
        {
            ViewData[GlobalViewBagKeys.ECommerceService] = eCommerce;
            OrderSearchModel searchModel = new OrderSearchModel
            {
                CustomerId = customerId
            };

            return(View(new OrdersListViewModel
            {
                Orders = eCommerce.GetOrdersByCustomerId(searchModel, (page - 1) * recordsPerPage, recordsPerPage),
                PagingInfo = new PagingInfo
                {
                    CurrentPage = (short)page,
                    RecordsPerPage = recordsPerPage,
                    TotalRecords = eCommerce.CountOrdersByCustomerId(searchModel)
                },
                SearchModel = searchModel
            }));
        }
Exemplo n.º 27
0
        public List <Order> getConfirmedOrders(OrderSearchModel data)
        {
            if (data.orderCode == null)
            {
                data.orderCode = "";
            }
            PaymentNotificationDAO pDao  = new PaymentNotificationDAO();
            List <Order>           datas = new List <Order>();
            var items = dao.getOrders(data.productId).Where(m => m.isPay == true && m.isActive == true && m.isFinish != true &&
                                                            (m.isCreateShipping != true || m.isShipping == true) &&
                                                            m.code.Contains(data.orderCode)).ToList();

            foreach (var i in items)
            {
                var d = ConvertToScreenModel.Transactions.order(i);
                datas.Add(d);
            }

            return(datas);
        }
Exemplo n.º 28
0
        public IActionResult OrdersList(int userId, OrderSearchModel orderSearchModel)
        {
            if (userId == 0)
            {
                return(R.Fail.WithError(ErrorCodes.ParentEntityMustBeNonZero).Result);
            }

            if (userId < 0 || _userService.Count(x => x.Id == userId) == 0)
            {
                return(NotFound());
            }

            var orders = _orderService.Get(out int totalResults, x => x.UserId == userId, x => x.CreatedOn,
                                           RowOrder.Descending, orderSearchModel.Current, orderSearchModel.RowCount).ToList();
            var ordersModel = orders.Select(_orderModelFactory.Create).ToList();

            return(R.Success.With("orders", ordersModel)
                   .With("userId", userId)
                   .WithGridResponse(totalResults, orderSearchModel.Current, orderSearchModel.RowCount).Result);
        }
Exemplo n.º 29
0
        public IActionResult Orders(OrderSearchModel searchModel)
        {
            var orderStatus = new List <OrderStatus>();

            switch (searchModel.OrderStatus)
            {
            case "closed":
                orderStatus.Add(OrderStatus.Closed);
                orderStatus.Add(OrderStatus.Complete);
                break;

            case "open":
                orderStatus.Add(OrderStatus.New);
                orderStatus.Add(OrderStatus.OnHold);
                orderStatus.Add(OrderStatus.Shipped);
                orderStatus.Add(OrderStatus.Processing);
                orderStatus.Add(OrderStatus.Delayed);
                orderStatus.Add(OrderStatus.PartiallyShipped);
                break;

            case "returned":
                orderStatus.Add(OrderStatus.Returned);
                break;

            case "cancelled":
                orderStatus.Add(OrderStatus.Cancelled);
                break;

            default:
                break;    //do nothing we'll show all orders by default
            }

            var orders = _orderService.GetOrders(out int totalResults, userId: CurrentUser.Id, startDate: searchModel.FromDate, endDate: searchModel.ToDate,
                                                 orderStatus: orderStatus, page: searchModel.Current, count: searchModel.RowCount);
            var orderModels = orders.Select(x => _orderModelFactory.Create(x)).ToList();

            return(R.Success.With("orders", orderModels).Result);
        }
Exemplo n.º 30
0
        public List <Order> getNotPayOrders(OrderSearchModel data)
        {
            if (data.orderCode == null)
            {
                data.orderCode = "";
            }
            PaymentNotificationDAO pDao    = new PaymentNotificationDAO();
            List <Order>           datas   = new List <Order>();
            List <Order>           results = new List <Order>();
            var items = dao.getOrders(data.productId)
                        .Where(m => m.isPay == false && m.isActive == true &&
                               m.code.Contains(data.orderCode))
                        .OrderByDescending(m => m.orderDate)
                        .ToList();

            foreach (var code in items.GroupBy(m => m.code).Select(m => m.Key))
            {
                var itms = items.Where(m => m.code == code).ToList();
                var itm  = ConvertToScreenModel.Transactions.order(itms.First());
                itm.totalPrice   = itms.Select(m => m.totalPrice).Sum();
                itm.product.name = string.Join(", ", itms.Select(m => m.M_Product.name));
                datas.Add(itm);
            }

            foreach (var d in datas)
            {
                d.payment = ConvertToScreenModel.Transactions.paymentNotification(
                    pDao.getPaymentNotifications().OrderByDescending(m => m.id).FirstOrDefault(m => m.orderCode == d.code));
                if (data.showOnlyPaymentSending == false || (data.showOnlyPaymentSending && d.payment != null))
                {
                    results.Add(d);
                }
            }

            return(results);
        }