private void FillPage()
{
//Get selected product's data
if (!String.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
int id = Convert.ToInt32(Request.QueryString["id"]);
ProductModel productModel = new ProductModel();
Product product = productModel.GetProduct(id);
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fill Page with data
lblColor.Text = " " + product.Color;
lblPrice.Text = " $" + product.Price;
lblTitle.Text = product.Name;
lblDescription.Text = product.Description;
lblProductNum.Text = "Product Number: " + id.ToString();
imgProdcut.ImageUrl = "~/Image/Products/" + product.Image;
//Retrieve supplier
int supplierId = product.SupplierID;
Supplier supplier = db.Suppliers.Find(supplierId);
lblSupplier.Text = "By " + supplier.Name;
//Fille amount dropdown list with numbers 1-30;
int[] quantity = Enumerable.Range(1, 30).ToArray();
ddlQuantity.DataSource = quantity;
ddlQuantity.AppendDataBoundItems = true;
ddlQuantity.DataBind();
}
}
private void FillPage()
{
//Get selected product's data
if (!String.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
int id = Convert.ToInt32(Request.QueryString["id"]);
ProductModel productModel = new ProductModel();
Product product = productModel.GetProduct(id);
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fill Page with data
lblColor.Text = " " + product.Color;
lblPrice.Text = " $" + product.Price;
lblTitle.Text = product.Name;
lblDescription.Text = product.Description;
lblProductNum.Text = "Product Number: "+ id.ToString();
imgProdcut.ImageUrl = "~/Image/Products/" + product.Image;
//Retrieve supplier
int supplierId = product.SupplierID;
Supplier supplier = db.Suppliers.Find(supplierId);
lblSupplier.Text = "By " + supplier.Name;
//Fille amount dropdown list with numbers 1-30;
int[] quantity = Enumerable.Range(1, 30).ToArray();
ddlQuantity.DataSource = quantity;
ddlQuantity.AppendDataBoundItems = true;
ddlQuantity.DataBind();
}
}
//Update qty from shopping cart page
public void UpdateQuantity(int id, int quantity)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Cart cart = db.Carts.Find(id);
cart.Quantity = quantity;
//Save changes to database
db.SaveChanges();
}
//Retrieve current objects in the shopping cart
public List<Cart> GetOrdersFromeCart(int clientId)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
List<Cart> orders = (from x in db.Carts
where x.ClientID == clientId
&& x.IsInCart
orderby x.DataPurchased
select x).ToList();
return orders;
}
//Retrieve current objects in the shopping cart
public List <Cart> GetOrdersFromeCart(int clientId)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
List <Cart> orders = (from x in db.Carts
where x.ClientID == clientId &&
x.IsInCart
orderby x.DataPurchased
select x).ToList();
return(orders);
}
public Client GetClient(int id)
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
Client client = db.Clients.Find(id);
return(client);
}
}
catch (Exception)
{
return(null);
}
}
public Product GetProduct(int id)
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
Product product = db.Products.Find(id);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
public string InsertOrder(Order order)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Orders.Add(order);
db.SaveChanges();
return order.ID.ToString();
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string InsertCategory(Category category)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Categories.Add(category);
db.SaveChanges();
return category.Name + " was successfully inserted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string InsertCart(Cart cart)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Carts.Add(cart);
db.SaveChanges();
return cart.DataPurchased + " was successfully inserted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string InsertSupplier(Supplier supplier)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Suppliers.Add(supplier);
db.SaveChanges();
return(supplier.Name + " was successfully inserted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertCart(Cart cart)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Carts.Add(cart);
db.SaveChanges();
return(cart.DataPurchased + " was successfully inserted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertClient(Client client)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Clients.Add(client);
db.SaveChanges();
return(client.Name + " was successfully inserted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public Product GetProduct(int id)
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
Product product = db.Products.Find(id);
return product;
}
}
catch (Exception)
{
return null;
}
}
public string InsertSupplier(Supplier supplier)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Suppliers.Add(supplier);
db.SaveChanges();
return supplier.Name + " was successfully inserted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string InsertOrder(Order order)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Orders.Add(order);
db.SaveChanges();
return(order.ID.ToString());
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertProduct(Product product)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Products.Add(product);
db.SaveChanges();
return product.Name + " was successfully inserted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string InsertProduct(Product product)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Products.Add(product);
db.SaveChanges();
return(product.Name + " was successfully inserted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string InsertCategory(Category category)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Categories.Add(category);
db.SaveChanges();
return(category.Name + " was successfully inserted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public Client GetClient(int id)
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
Client client = db.Clients.Find(id);
return client;
}
}
catch (Exception)
{
return null;
}
}
public string InsertClient(Client client)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
db.Clients.Add(client);
db.SaveChanges();
return client.Name + " was successfully inserted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public List <Client> GetAllClients()
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
List <Client> clients = (from x in db.Clients
select x).ToList();
return(clients);
}
}
catch (Exception)
{
return(null);
}
}
//Return total number of the added products
public int GetAmountOfOrders(int clientId)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
int amount = (from x in db.Carts
where x.ClientID == clientId &&
x.IsInCart
select x.Quantity).Sum();
return(amount);
}
catch
{
return(0);
}
}
public List <Product> GetAllProducts()
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
List <Product> products = (from x in db.Products
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
//Mark all the added products as paid, after checkout
public void MarkOrderAsPaid(List <Cart> carts)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
if (carts != null)
{
foreach (Cart cart in carts)
{
Cart oldCart = db.Carts.Find(cart.ID);
oldCart.DataPurchased = DateTime.Now;
oldCart.IsInCart = false;
}
}
db.SaveChanges();
}
//Update qty of same product from singleProduct page
public string UpdateQty(int productId, int quantity, int clientId)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
var cart = (from x in db.Carts
where x.ProductID == productId &&
x.IsInCart &&
x.ClientID == clientId
select x).FirstOrDefault();
int oldQuantity = cart.Quantity;
int newQuantity = oldQuantity + quantity;
cart.Quantity = newQuantity;
db.SaveChanges();
return("Update Successfully!");
}
public List <Product> GetProductByCategory(int categoryId)
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
List <Product> products = (from x in db.Products
where x.CategoryID == categoryId
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public string DeleteCategory(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Category category = db.Categories.Find(id);
db.Categories.Attach(category);
db.Categories.Remove(category);
db.SaveChanges();
return category.Name + " was successfully deleted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string DeleteProduct(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Product product = db.Products.Find(id);
db.Products.Attach(product);
db.Products.Remove(product);
db.SaveChanges();
return product.Name + " was successfully deleted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string DeleteCart(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Cart cart = db.Carts.Find(id);
db.Carts.Attach(cart);
db.Carts.Remove(cart);
db.SaveChanges();
return(cart.DataPurchased + " was successfully deleted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteOrder(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Order order = db.Orders.Find(id);
db.Orders.Attach(order);
db.Orders.Remove(order);
db.SaveChanges();
return order.ID + " was successfully delected!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string DeleteClient(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Client client = db.Clients.Find(id);
db.Clients.Attach(client);
db.Clients.Remove(client);
db.SaveChanges();
return(client.Name + " was successfully deleted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteProduct(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Product product = db.Products.Find(id);
db.Products.Attach(product);
db.Products.Remove(product);
db.SaveChanges();
return(product.Name + " was successfully deleted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteSupplier(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Supplier supplier = db.Suppliers.Find(id);
db.Suppliers.Attach(supplier);
db.Suppliers.Remove(supplier);
db.SaveChanges();
return(supplier.Name + " was successfully delected!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string DeleteSupplier(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Supplier supplier = db.Suppliers.Find(id);
db.Suppliers.Attach(supplier);
db.Suppliers.Remove(supplier);
db.SaveChanges();
return supplier.Name + " was successfully delected!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string DeleteClient(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Client client = db.Clients.Find(id);
db.Clients.Attach(client);
db.Clients.Remove(client);
db.SaveChanges();
return client.Name + " was successfully deleted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string DeleteCart(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Cart cart = db.Carts.Find(id);
db.Carts.Attach(cart);
db.Carts.Remove(cart);
db.SaveChanges();
return cart.DataPurchased + " was successfully deleted!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string DeleteCategory(int id)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Category category = db.Categories.Find(id);
db.Categories.Attach(category);
db.Categories.Remove(category);
db.SaveChanges();
return(category.Name + " was successfully deleted!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
protected void btnsubmit_click(object sender, EventArgs e)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
ClientModel clientModel = new ClientModel();
List<Client> clients = clientModel.GetAllClients();
String clientId = "";
if (clients != null)
{
//Check if product in DB
foreach (Client client in clients)
{
if (client.Name == txtName.Text.Trim() && client.Password == txtPassword.Text.Trim() && client.ActiveUser == true)
{
int Id = client.ID;
Application["clientId"] = Id;
Application["clientName"] = client.Name;
//Redirect page to WebShop after lable showing
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
lblResult.Text = Application["clientName"].ToString() + ", your login is successful!";
meta.Content = "3; url = /ZHUW15/asp_practical/Pages/WebShop.aspx";
this.Page.Controls.Add(meta);
}
else if (client.Name == txtName.Text.Trim() && client.Password == txtPassword.Text.Trim() && client.ActiveUser == false)
{
lblResult.Text = ("Sorry, this account is disable, please contact us for further help.");
}
else
{
lblResult.Text = ("Invalid username or password!");
}
}
}
}
public string UpdateCategory(int id, Category category)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Category p = db.Categories.Find(id);
p.Name = category.Name;
p.Description = category.Description;
db.SaveChanges();
return category.Name + " was successfully updated!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string UpdateCategory(int id, Category category)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Category p = db.Categories.Find(id);
p.Name = category.Name;
p.Description = category.Description;
db.SaveChanges();
return(category.Name + " was successfully updated!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateSupplier(int id, Supplier supplier)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Supplier p = db.Suppliers.Find(id);
p.Name = supplier.Name;
p.PhoneNumber = supplier.PhoneNumber;
p.EmailAddress = supplier.EmailAddress;
db.SaveChanges();
return(supplier.Name + " was successfully updated!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateSupplier(int id, Supplier supplier)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Supplier p = db.Suppliers.Find(id);
p.Name = supplier.Name;
p.PhoneNumber = supplier.PhoneNumber;
p.EmailAddress = supplier.EmailAddress;
db.SaveChanges();
return supplier.Name + " was successfully updated!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string UpdateOrder(int id, Order order)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Order p = db.Orders.Find(id);
p.ClientID = order.ClientID;
p.Status = order.Status;
p.TotalAmount = order.TotalAmount;
p.OrderDate = order.OrderDate;
db.SaveChanges();
return(order.ID + " was successfully updated!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateOrder(int id, Order order)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Order p = db.Orders.Find(id);
p.ClientID = order.ClientID;
p.Status = order.Status;
p.TotalAmount = order.TotalAmount;
p.OrderDate = order.OrderDate;
db.SaveChanges();
return order.ID + " was successfully updated!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
protected void btnsubmit_click(object sender, EventArgs e)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
ClientModel clientModel = new ClientModel();
List <Client> clients = clientModel.GetAllClients();
String clientId = "";
if (clients != null)
{
//Check if product in DB
foreach (Client client in clients)
{
if (client.Name == txtName.Text.Trim() && client.Password == txtPassword.Text.Trim() && client.ActiveUser == true)
{
int Id = client.ID;
Application["clientId"] = Id;
Application["clientName"] = client.Name;
//Redirect page to WebShop after lable showing
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
lblResult.Text = Application["clientName"].ToString() + ", your login is successful!";
meta.Content = "3; url = /ZHUW15/asp_practical/Pages/WebShop.aspx";
this.Page.Controls.Add(meta);
}
else if (client.Name == txtName.Text.Trim() && client.Password == txtPassword.Text.Trim() && client.ActiveUser == false)
{
lblResult.Text = ("Sorry, this account is disable, please contact us for further help.");
}
else
{
lblResult.Text = ("Invalid username or password!");
}
}
}
}
public string UpdateClient(int id, Client client)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Client p = db.Clients.Find(id);
p.Name = client.Name;
p.Password = client.Password;
p.PhoneNumber = client.PhoneNumber;
p.EmailAddress = client.EmailAddress;
p.HomeAddress = client.HomeAddress;
db.SaveChanges();
return client.Name + " was successfully updated!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string UpdateClient(int id, Client client)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Client p = db.Clients.Find(id);
p.Name = client.Name;
p.Password = client.Password;
p.PhoneNumber = client.PhoneNumber;
p.EmailAddress = client.EmailAddress;
p.HomeAddress = client.HomeAddress;
db.SaveChanges();
return(client.Name + " was successfully updated!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProduct(int id, Product product)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Product p = db.Products.Find(id);
p.Name = product.Name;
p.Price = product.Price;
p.CategoryID = product.CategoryID;
p.Description = product.Description;
p.SupplierID = product.SupplierID;
p.Image = product.Image;
p.Color = product.Color;
db.SaveChanges();
return product.Name + " was successfully updated!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string UpdateCart(int id, Cart cart)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Cart p = db.Carts.Find(id);
p.ClientID = cart.ClientID;
p.ProductID = cart.ProductID;
p.Status = cart.Status;
p.TotalCost = cart.TotalCost;
p.IsInCart = cart.IsInCart;
p.DataPurchased = cart.DataPurchased;
db.SaveChanges();
return cart.DataPurchased + " was successfully updated!";
}
catch (Exception e)
{
return "Error:" + e;
}
}
public string UpdateCart(int id, Cart cart)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Cart p = db.Carts.Find(id);
p.ClientID = cart.ClientID;
p.ProductID = cart.ProductID;
p.Status = cart.Status;
p.TotalCost = cart.TotalCost;
p.IsInCart = cart.IsInCart;
p.DataPurchased = cart.DataPurchased;
db.SaveChanges();
return(cart.DataPurchased + " was successfully updated!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateProduct(int id, Product product)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
//Fetch object from db
Product p = db.Products.Find(id);
p.Name = product.Name;
p.Price = product.Price;
p.CategoryID = product.CategoryID;
p.Description = product.Description;
p.SupplierID = product.SupplierID;
p.Image = product.Image;
p.Color = product.Color;
db.SaveChanges();
return(product.Name + " was successfully updated!");
}
catch (Exception e)
{
return("Error:" + e);
}
}
//Return total number of the added products
public int GetAmountOfOrders(int clientId)
{
try
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
int amount = (from x in db.Carts
where x.ClientID == clientId
&& x.IsInCart
select x.Quantity).Sum();
return amount;
}
catch
{
return 0;
}
}
public List<Client> GetAllClients()
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
List<Client> clients = (from x in db.Clients
select x).ToList();
return clients;
}
}
catch (Exception)
{
return null;
}
}
//Update qty from shopping cart page
public void UpdateQuantity (int id, int quantity)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
Cart cart = db.Carts.Find(id);
cart.Quantity = quantity;
//Save changes to database
db.SaveChanges();
}
//Update qty of same product from singleProduct page
public string UpdateQty (int productId, int quantity, int clientId)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
var cart = (from x in db.Carts
where x.ProductID == productId
&& x.IsInCart
&& x.ClientID == clientId
select x).FirstOrDefault();
int oldQuantity = cart.Quantity;
int newQuantity = oldQuantity + quantity;
cart.Quantity = newQuantity;
db.SaveChanges();
return "Update Successfully!";
}
//Mark all the added products as paid, after checkout
public void MarkOrderAsPaid(List<Cart> carts)
{
ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities();
if(carts != null)
{
foreach(Cart cart in carts)
{
Cart oldCart = db.Carts.Find(cart.ID);
oldCart.DataPurchased = DateTime.Now;
oldCart.IsInCart = false;
}
}
db.SaveChanges();
}
public List<Product> GetAllProducts()
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
List<Product> products = (from x in db.Products
select x).ToList();
return products;
}
}
catch (Exception)
{
return null;
}
}
public List<Product> GetProductByCategory(int categoryId)
{
try
{
using (ZHUW15sqlserver1Entities db = new ZHUW15sqlserver1Entities())
{
List<Product> products = (from x in db.Products
where x.CategoryID == categoryId
select x).ToList();
return products;
}
}
catch (Exception)
{
return null;
}
}
