///// <summary> ///// Implementation of method. ///// </summary> ///// <returns>value.</returns> // public List<ProductsListModel> GetProducts() // { // var parameter = new List<SqlParameter>(); // List<ProductsListModel> list = new List<ProductsListModel>(); // ProductsListModel product = null; // var productList = this.basedal.GetData("SP_GetProducts", CommandType.StoredProcedure); // foreach (DataRow data in productList.Tables[0].Rows) // { // product = new ProductsListModel(); // product.ProductId = data[0].ToString(); // product.CategoryId = data[1].ToString(); // list.Add(product); // } // return list; // } /// <summary> /// Implementation of Method. /// </summary> /// <param name="productList">list.</param> /// <returns>value.</returns> public int InsertProducts(ProductsListModel productList) { var parameter = new List <SqlParameter>(); parameter.Add(this.basedal.CreateParameter("@ProductName", 50, productList.ProductName, DbType.String)); parameter.Add(this.basedal.CreateParameter("@CategoryId", 50, productList.CategoryId, DbType.Int16)); parameter.Add(this.basedal.CreateParameter("@Description", 50, productList.Description, DbType.String)); parameter.Add(this.basedal.CreateParameter("@Price", 50, productList.Price, DbType.VarNumeric)); parameter.Add(this.basedal.CreateParameter("@Quantity", 50, productList.Quantity, DbType.Int16)); parameter.Add(this.basedal.CreateParameter("@Image", 50, productList.Image, DbType.String)); this.basedal.Insert("SP_InsertProduct", CommandType.StoredProcedure, parameter.ToArray(), out int lastId); return(lastId); }
/// <summary> /// Implementation of method. /// </summary> /// <param name="keyword">list.</param> /// <returns>value.</returns> public List <ProductsListModel> SearchProduct(string keyword) { var parameter = new List <SqlParameter>(); List <ProductsListModel> list = new List <ProductsListModel>(); ProductsListModel product = null; parameter.Add(this.basedal.CreateParameter("@keyword", 50, keyword, DbType.String)); var productList = this.basedal.GetData("SP_SearchProductByKeyword", CommandType.StoredProcedure); foreach (DataRow data in productList.Tables[0].Rows) { product = new ProductsListModel(); product.ProductId = data[0].ToString(); product.CategoryId = data[1].ToString(); list.Add(product); } return(list); }