public IEnumerable <ProductsGet> GetProductByName(string ProductName)
{
List <ProductsGet> productsGET = new List <ProductsGet>();
String toSearch = String.Format("SELECT * FROM [ViewProducts] WHERE ProductName LIKE '%{0}%'", ProductName);
command = new SqlCommand(toSearch, connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductsGet productGET = new ProductsGet((int)Convert.ToInt64(reader["ProductID"]),
(long)reader["ProductSKU"],
(String)reader["ProductName"],
(String)reader["BrandName"],
(int)Convert.ToInt64(reader["ProductPrice"]),
(int)Convert.ToInt64(reader["ProductVariableCost"]),
(int)Convert.ToInt64(reader["ProductStartFactor"]),
(int)Convert.ToInt64(reader["ProductGrowthFactor"]),
(int)Convert.ToInt64(reader["ProductQuantity"]));
productsGET.Add(productGET);
}
}
connection.Close();
return(productsGET);
}
protected void Page_Load(object sender, EventArgs e)
{
this.DataBind();
Repeater1.DataSource = ProductsGet.Skip((CurrentPage - 1) * pageSize).Take(pageSize);
Repeater1.DataBind();
}
public IEnumerable <ProductsGet> GetProduct(int?ProductID)
{
List <ProductsGet> productsGet = new List <ProductsGet>();
if (ProductID == null)
{
command = new SqlCommand("SELECT * FROM [ViewProductsV3]", connection);
}
else
{
command = new SqlCommand("SELECT * FROM [ViewProductsV3] WHERE ProductID = '" + ProductID + "'", connection);
}
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductsGet productGet = new ProductsGet((int)Convert.ToInt64(reader["ProductID"]),
(long)reader["ProductSKU"],
(String)reader["ProductName"],
(String)reader["BrandName"],
(int)Convert.ToInt64(reader["ProductPrice"]),
(int)Convert.ToInt64(reader["ProductVariableCost"]),
(int)Convert.ToInt64(reader["ProductStartFactor"]),
(int)Convert.ToInt64(reader["ProductGrowthFactor"]),
(int)Convert.ToInt64(reader["ProductQuantity"]));
productsGet.Add(productGet);
}
}
connection.Close();
return(productsGet);
}