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