public IHttpActionResult GetProductByCategory(string idcate, [FromUri] string searchValue = null, [FromUri] int pageIndex = 1, [FromUri] int pageSize = 10) { try { var paginationImp = new PaginationImp(); var query = _context.ProductCategories.Where(x => x.id_cate == idcate).Select(x => x.Product) .Where(x => searchValue == null || x.name.Contains(searchValue)) .Select(x => new { id_product = x.id_product, name = x.name, groupImages = x.GroupImage.Images.Select(_ => _.url), price = x.price, qualify = x.qualify, description = x.description, market = x.ProductInMarkets.Select(xx => xx.SMarket.name), type = x.type, brandName = x.Brands.Select(_ => _.name), productCategory = x.ProductCategories.Select(_ => _.Category.name) }); return(Ok(paginationImp.ToPagedList(pageIndex, pageSize, query))); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IHttpActionResult GetByShipperId(string id_shipper) { var Shipper = _context.Accounts.FirstOrDefault(x => x.id_account == id_shipper); var paginationImp = new PaginationImp(); try { if (Shipper == null) { return(NotFound()); } var orders = _context.Orders.Where(x => x.id_shipper == Shipper.id_account).ToList(); if (orders == null) { return(NotFound()); } var model = orders.Select(xx => new { id_order = xx.id_order, shipper_id = xx.id_shipper, customer_id = xx.id_customer, order_state = xx.state, point = xx.point, shipping_cost = xx.shipping_cost, time_to_ship = xx.time_to_ship, customer_address_id = xx.customer_address_id, dis_cus_to_market = xx.dis_cus_to_market, //shipper_name = shipper.Select(x => x.username), //customer_name = customer.Select(x => x.username), created_date = xx.created_date, id_address = xx.id_address, phone = xx.phone, name = xx.name, taking_time = xx.taking_time, done_time = xx.done_time, order_code = xx.order_code, customer_comment = xx.customer_comment, system_cost = xx.system_cost, total_amount = xx.total_amount, token = xx.token, orderDetails = xx.OrderDetails.Select(__ => new { __.Product.name, Price = __.Product.price * __.quanlity, __.Product.qualify, market_name = __.SMarket.name, }).ToList() }).ToList().OrderByDescending(x => x.done_time); return(Ok(model)); } catch (Exception ex) { return(InternalServerError(ex)); } }
/// <summary> /// Constructor. /// </summary> /// <param name="view">The view</param> public RequestPresenter(IRequestView view) : base(view) { Pagination = new PaginationImp <RequestModel>(_GetRequestList, _GetRequestListCount); }
public IHttpActionResult GetById(string id_customer, [FromUri] int pageIndex = 1, [FromUri] int pageSize = 100) { var customer = _context.Accounts.FirstOrDefault(x => x.id_account == id_customer); var paginationImp = new PaginationImp(); try { if (customer == null) { return(NotFound()); } var orders = _context.Orders.Where(x => x.id_customer == customer.id_account).ToList(); if (orders == null) { return(NotFound()); } var model = orders.Select(xx => new { id_order = xx.id_order, created_date = xx.created_date, id_customer = xx.id_customer, id_shipper = xx.id_shipper, state = xx.state, id_group_image = xx.id_group_image, id_address = xx.id_address, point = xx.point, shipping_cost = xx.shipping_cost, time_to_ship = xx.time_to_ship, customer_address_id = xx.customer_address_id, dis_cus_to_market = xx.dis_cus_to_market, phone = xx.phone, name = xx.name, taking_time = xx.taking_time, done_time = xx.done_time, order_code = xx.order_code, customer_comment = xx.customer_comment, system_cost = xx.system_cost, total_amount = xx.total_amount, token = xx.token, markert_id = xx.OrderDetails.Select(x => x.id_market), OrderDetails = xx.OrderDetails.Select(__ => new { id_orderdetail = __.id_orderdetail, id_order = __.id_order, product = new { id_product = __.Product.id_product, name = __.Product.name, groupImages = __.Product.GroupImage.Images.Select(_ => _.url), price = __.Product.price, qualify = __.Product.qualify, description = __.Product.description, type = __.Product.type, brandName = __.Product.Brands.Select(_ => _.name), productCategory = __.Product.ProductCategories.Select(_ => _.Category.name) }, id_market = __.id_market, price = __.price, quanlity = __.quanlity, priority = __.priority, }).ToList() }).ToList().OrderByDescending(x => x.created_date); return(Ok(paginationImp.ToPagedList(pageIndex, pageSize, model))); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IHttpActionResult GetByOrderID(string id_order) { var order = _context.Orders.Find(id_order); var paginationImp = new PaginationImp(); try { if (order == null) { return(NotFound()); } return(Ok(new { id_order = order.id_order, created_date = order.created_date, id_customer = order.id_customer, id_shipper = order.id_shipper, state = order.state, id_group_image = order.id_group_image, id_address = order.id_address, point = order.point, shipping_cost = order.shipping_cost, time_to_ship = order.time_to_ship, customer_address_id = order.customer_address_id, dis_cus_to_market = order.dis_cus_to_market, phone = order.phone, name = order.name, taking_time = order.taking_time, done_time = order.done_time, order_code = order.order_code, customer_comment = order.customer_comment, system_cost = order.system_cost, total_amount = order.total_amount, token = order.token, markert_id = order.OrderDetails.Select(x => x.id_market), OrderDetails = order.OrderDetails.Select(__ => new { id_orderdetail = __.id_orderdetail, id_order = __.id_order, product = new { id_product = __.Product.id_product, name = __.Product.name, groupImages = __.Product.GroupImage.Images.Select(_ => _.url), price = __.Product.price, qualify = __.Product.qualify, description = __.Product.description, type = __.Product.type, brandName = __.Product.Brands.Select(_ => _.name), productCategory = __.Product.ProductCategories.Select(_ => _.Category.name) }, id_market = __.id_market, price = __.price, quanlity = __.quanlity, priority = __.priority, }).ToList() })); } catch (Exception ex) { return(InternalServerError(ex)); } }
/// <summary> /// Constructor. /// </summary> /// <param name="view">The view</param> public WorkerPresenter(IUserView view) : base(view) { Pagination = new PaginationImp <UserModel>(_GetWorkerList, _GetWorkerListCount); }