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