public ADOProduct GetById(int id)
{
ADOProduct prod = null;
using (SqlCommand com = new SqlCommand(
"SELECT * FROM Products WHERE ProductId = @PId",
db.Connection))
{
com.Parameters.AddWithValue("PId", id);
using (SqlDataReader reader = com.ExecuteReader())
{
if (reader.Read())
{
prod = new ADOProduct()
{
ProductId = (int)reader[0],
Name = (string)reader[1],
Price = (int)reader[2],
CategoryId = (int)reader[3]
}
}
;
}
}
return(prod);
}
public void Delete(ADOProduct prod)
{
if (prod != null)
{
using (SqlCommand com = new SqlCommand(
"DELETE Products WHERE ProductId = @ProdId",
db.Connection))
{
com.Parameters.AddWithValue("ProdId", prod.ProductId);
com.ExecuteNonQuery();
}
}
}
public void Update(ADOProduct prod)
{
if (prod != null)
{
using (SqlCommand com = new SqlCommand(
"UPDATE Products SET Name = @PName, CategoryId = @CatId WHERE ProductId = @ProdId",
db.Connection))
{
com.Parameters.AddWithValue("PName", prod.Name);
com.Parameters.AddWithValue("CatId", prod.CategoryId);
com.Parameters.AddWithValue("ProdId", prod.ProductId);
com.ExecuteNonQuery();
}
}
}
public void Create(ADOProduct prod)
{
if (prod != null)
{
using (SqlCommand com = new SqlCommand(
"INSERT INTO Products (Name, Price, CategoryID) VALUES (@PName, @PPrice, @CatId)",
db.Connection))
{
com.Parameters.AddWithValue("PName", prod.Name);
com.Parameters.AddWithValue("PPrice", prod.Price);
com.Parameters.AddWithValue("CatId", prod.CategoryId);
com.ExecuteNonQuery();
}
}
}
public EntProduct getProductById(List <EntProduct> l, string id)
{
ADOProduct adop = new ADOProduct();
return(adop.getProductById(l, id));
}
public List <EntProduct> addProduct(List <EntProduct> l, EntProduct p)
{
ADOProduct adop = new ADOProduct();
return(adop.addProduct(l, p));
}
public List <EntProduct> getCatalog(List <EntProduct> l)
{
ADOProduct adop = new ADOProduct();
return(adop.getCatalog(l));
}
