public tblProduct GetProduct(int id)
{
try
{
using (OnlineKitchenDBEntities db = new OnlineKitchenDBEntities())
{
tblProduct product = db.tblProducts.Find(id);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
public string InsertProduct(tblProduct product)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
db.tblProducts.Add(product);
db.SaveChanges();
return(product.Name + " was successfully inserted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string InsertProduct(tblCart cart)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
db.tblCarts.Add(cart);
db.SaveChanges();
return(cart.DatePurchased + " was successfully inserted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public List <tblProduct> GetAllProducts()
{
try
{
using (OnlineKitchenDBEntities db = new OnlineKitchenDBEntities())
{
List <tblProduct> products = (from x in db.tblProducts
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public List <tblProduct> GetProductsByType(int typeId)
{
try
{
using (OnlineKitchenDBEntities db = new OnlineKitchenDBEntities())
{
List <tblProduct> products = (from x in db.tblProducts
where x.TypeId == typeId
select x).ToList();
return(products);
}
}
catch (Exception)
{
return(null);
}
}
public string DeleteProduct(int id)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
tblProductType productType = db.tblProductTypes.Find(id);
db.tblProductTypes.Attach(productType);
db.tblProductTypes.Remove(productType);
db.SaveChanges();
return(productType.Name + " was successfully deleted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string DeleteProduct(int id)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
tblCart cart = db.tblCarts.Find(id);
db.tblCarts.Attach(cart);
db.tblCarts.Remove(cart);
db.SaveChanges();
return(cart.DatePurchased + " was successfully deleted");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string UpdateProduct(int id, tblProductType productType)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
//Fetch object from db
tblProductType p = db.tblProductTypes.Find(id);
p.Name = productType.Name;
db.SaveChanges();
return(productType.Name + " was successfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string UpdateProduct(int id, tblProduct product)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
//Fetch object from db
tblProduct p = db.tblProducts.Find(id);
p.Name = product.Name;
p.Price = product.Price;
p.TypeId = product.TypeId;
p.Description = product.Description;
p.Image = product.Image;
db.SaveChanges();
return(product.Name + " was successfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public string UpdateProduct(int id, tblCart cart)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
//Fetch object from db
tblCart p = db.tblCarts.Find(id);
p.DatePurchased = cart.DatePurchased;
p.ClientID = cart.ClientID;
p.Amount = cart.Amount;
p.IsInCart = cart.IsInCart;
p.ProductID = cart.ProductID;
db.SaveChanges();
return(cart.DatePurchased + " was successfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
