/// <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;
}
}
