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