public string Insertcart(Cart cart)
{
try
{
firstdbEntities2 db = new firstdbEntities2();
db.Carts.Add(cart);
db.SaveChanges();
return(cart.datepurchased + "was sucessfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string Insertproduct(product product)
{
try
{
firstdbEntities2 db = new firstdbEntities2();
db.products.Add(product);
db.SaveChanges();
return(product.Name + "was sucessfully inserted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string Deleteproduct(int id)
{
try
{
firstdbEntities2 db = new firstdbEntities2();
product product = db.products.Find(id);
db.products.Attach(product);
db.products.Remove(product);
db.SaveChanges();
return(product.Name + "was sucessfully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string Deletecart(int id)
{
try
{
firstdbEntities2 db = new firstdbEntities2();
Cart cart = db.Carts.Find(id);
db.Carts.Attach(cart);
db.Carts.Remove(cart);
db.SaveChanges();
return(cart.datepurchased + "was succefully deleted");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string UpdateproductType(int id, productType productType)
{
try
{
firstdbEntities2 db = new firstdbEntities2();
//Fetch object from db
productType p = db.productTypes.Find(id);
p.Name = productType.Name;
db.SaveChanges();
return(productType.Name + "was sucessfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string Updateproduct(int id, product product)
{
try
{
firstdbEntities2 db = new firstdbEntities2();
// Fetch object from db
product p = db.products.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 sucessfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public string Updatecart(int id, Cart cart)
{
try
{
firstdbEntities2 db = new firstdbEntities2();
// Fetch object from db
Cart p = db.Carts.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 sucessfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
