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