public String InsertCustomer(customer customer) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); db.customers.Add(customer); db.SaveChanges(); return(customer.customer_email + " was successfully added"); } catch (Exception e) { return("Error:" + e); } }
public String InsertProduct(product product) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); db.products.Add(product); db.SaveChanges(); return(product.product_name + " was successfully added"); } catch (Exception e) { return("Error:" + e); } }
public String DeleteCustomer(int id) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); customer p = db.customers.Find(id); db.customers.Attach(p); db.customers.Remove(p); db.SaveChanges(); return(p.customer_address + " was successfully deleted"); } catch (Exception e) { return("Error:" + e); } }
public String DeleteProduct(int id) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); product p = db.products.Find(id); db.products.Attach(p); db.products.Remove(p); db.SaveChanges(); return(p.product_name + " was successfully deleted"); } catch (Exception e) { return("Error:" + e); } }
public String UpdateCustomer(string id, customer customer) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); customer c = db.customers.Find(id); c.customer_address = customer.customer_address; c.first_name = customer.first_name; c.last_name = customer.last_name; db.SaveChanges(); return(c.customer_email + " was successfully updated"); } catch (Exception e) { return("Error:" + e); } }
public String UpdateProduct(int id, product product) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); product p = db.products.Find(id); p.product_description = product.product_description; p.product_name = product.product_name; p.product_type = product.product_type; p.image_url = product.image_url; p.stock = product.stock; p.price_per_unit = product.price_per_unit; p.categories_catogories_id = product.categories_catogories_id; p.product_type_idproduct_type = product.product_type_idproduct_type; db.SaveChanges(); return(product.product_name + " was successfully updated"); } catch (Exception e) { return("Error:" + e); } }