public Products ProductsSelectRow(int productId) { var select = new DAL.Product.Products(); DbDataReader dr = select.ProductsSelectRow(productId); var product = new Products(); if (dr.Read()) { product.productId = (int)dr["ProductId"]; product.productName = (string)dr["ProductName"]; product.lastModified = (DateTime)dr["LastModified"]; product.categoryName = (string)dr["CategoryName"]; } return(product); }
public List <Products> ProductsSelectAll() { DAL.Product.Products select = new DAL.Product.Products(); List <Products> productsList = new List <Products>(); DbDataReader dr = select.ProductsSelectAll(); while (dr.Read()) { var myProducts = new Products { productId = (int)dr["ProductId"], productName = (string)dr["ProductName"], lastModified = (DateTime)dr["LastModified"], categoryName = (string)dr["CategoryName"] }; productsList.Add(myProducts); } return(productsList); }
public int ProductsPatchRow(int productId, string productName, int categoryId) { DAL.Product.Products patch = new DAL.Product.Products(); return(patch.ProductsPatchRow(productId, productName, categoryId)); }
public int ProductsDeleteRow(int productId) { DAL.Product.Products delete = new DAL.Product.Products(); return(delete.ProductsDeleteRow(productId)); }
public int ProductsUpdateRow(int productId, string productName, int categoryId) { DAL.Product.Products update = new DAL.Product.Products(); return(update.ProductsUpdateRow(productId, productName, categoryId)); }
public int ProductsInsertRow(string productName, int categoryId) { DAL.Product.Products insert = new DAL.Product.Products(); return(insert.ProductsInsertRow(productName, categoryId)); }