/// <summary> /// Lấy tất cả sản phẩm theo điều kiện tìm kiếm là giá tiền /// </summary> /// <returns></returns> public GetItemResponse GetItemByPrice(GetItemByPriceRequest req) { try { var ListItems = itemDAO.GetItemByPrice <List <Item> >(req); if (ListItems != null && ListItems.Count > 0) { var res = ListItems.Select(s => new ItemResponse() { Item = s, ListDetail = itemDAO.GetItemDetailByItemID <List <ItemDetail> >(s.ID), ListMeta = itemDAO.GetItemMetaByItemID <List <ItemMeta> >(s.ID) }).ToList(); return(new GetItemResponse() { Code = ResStatusCode.Success, ListItemResponse = res }); } return(new GetItemResponse() { Code = ResStatusCode.NotFoundItem, ListItemResponse = null }); } catch (Exception ex) { throw ex; } }
public HttpResponseMessage GetItemByPrice(decimal MinPrice, decimal MaxPrice) { try { if (MinPrice == 0 && MaxPrice == 0) { return(Request.CreateResponse(HttpStatusCode.OK, ResponseDataFactory.getInstace(ResStatusCode.BadRequest))); } if (MinPrice > MaxPrice) { return(Request.CreateResponse(HttpStatusCode.OK, ResponseDataFactory.getInstace(ResStatusCode.BadRequest))); } GetItemByPriceRequest req = new GetItemByPriceRequest() { MaxPrice = MaxPrice, MinPrice = MinPrice }; var result = itemService.GetItemByPrice(req); return(Request.CreateResponse(HttpStatusCode.OK, ResponseDataFactory.getInstace(result.Code, result.ListItemResponse))); } catch { return(Request.CreateResponse(HttpStatusCode.OK, ResponseDataFactory.getInstace(ResStatusCode.InternalServerError))); } }
/// <summary> /// Tìm kiếm sản phẩm theo gía tiền /// </summary> /// <param name="query"></param> /// <returns></returns> public T GetItemByPrice <T>(GetItemByPriceRequest req) { SqlDataReader reader = null; List <Item> list = new List <Item>(); object result = null; string query = "select* from dbo.Item where Price >= @min AND Price <= @max"; try { connect.Open(); using (SqlCommand cmd = new SqlCommand(query, connect)) { cmd.Parameters.Add("@min", SqlDbType.Decimal).Value = req.MinPrice; cmd.Parameters.Add("@max", SqlDbType.Decimal).Value = req.MaxPrice; reader = cmd.ExecuteReader(); while (reader.Read()) { //list.Add(new Item() //{ // Brand = reader["Brand"].ToString().Trim(), // Category = reader["Category"].ToString().Trim(), // Color = reader["Color"].ToString().Trim(), // CreatedDate = (DateTime)reader["CreatedDate"], // ID = (int)reader["ID"], // ProductName = reader["ProductName"].ToString().Trim(), // Status = reader["Status"].ToString().Trim(), // Type = reader["Type"].ToString().Trim(), // Gender = (Sex)Int16.Parse(reader["Gender"].ToString()), // Price = (decimal)reader["Price"], //}); list.Add(GetItemFromReader(reader)); } } result = list.ToList(); return((T)result); } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } if (connect != null) { connect.Close(); } } }
/// <summary> /// Tìm kiếm sản phẩm theo giá tiền /// </summary> /// <typeparam name="T"></typeparam> /// <param name="type"></param> /// <returns></returns> public T GetItemByPrice <T>(GetItemByPriceRequest req) { try { object result = null; result = Database.GetInstance().GetItemByPrice <T>(req); return((T)result); } catch { throw; } }