public GetProductFilterOut GetProductFilter(GetProductFilterIn input)
{
GetProductFilterOut response = new GetProductFilterOut()
{
ResponseCode = Entities.Client.General.ResponseCode.Error
};
using (IDbConnection connection = new SqlConnection(connectionString))
{
connection.Open();
DynamicParameters param = new DynamicParameters();
var data = connection.Query <Product>("SELECT [ProductId] ,[Name] ,[Quantity] ,[Price] ,[CreationDate] FROM [tbl_Product] WHERE Name LIKE '%" + input.Name + "%' ORDER BY CreationDate DESC");
var productList = new List <Product>();
foreach (var i in data)
{
var product = new Product()
{
ProductId = i.ProductId,
Name = i.Name,
Quantity = i.Quantity,
Price = i.Price,
CreationDate = i.CreationDate
};
productList.Add(product);
}
response.product = productList;
if (response.product.Count > 0)
{
response.ResponseCode = Entities.Client.General.ResponseCode.Success;
}
}
return(response);
}
public IHttpActionResult GetProductFilterName(GetProductFilterIn input)
{
var response = Product.GetProductFilter(input);
return(Ok(response));
}
public GetProductFilterOut GetProductFilter(GetProductFilterIn input)
{
return(productDA.GetProductFilter(input));
}
