public List <Product> GetALLProduct()
{
DataTable dt = DBManger.ExecuteDataTable("select * from products ",
System.Data.CommandType.Text);
List <Product> products = Helper.DataTableToList <Product>(dt);
return(products);
}
public Product GetProductbyID(int id)
{
var list = Helper.DataTableToList <Product>(
DBManger.ExecuteDataTable("select top(1) * from products where ProductID = @ID", CommandType.Text,
new System.Data.SqlClient.SqlParameter("@ID", id))
);
return(list[0]);
}
