public admin GetAdmin(string id) { try { using (etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities()) { admin ifadmin = db.admins.Find(id); return(ifadmin); } } catch (Exception ex) { return(null); } }
public string AddAdmin(admin admin) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); db.admins.Add(admin); db.SaveChanges(); return(admin.email + " was successfully added"); } catch (Exception e) { return("Error:" + e); } }
public String CreateShipment(shipment ship) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); db.shipments.Add(ship); db.SaveChanges(); return("Order successful by: " + ship.customer_customer_email); } catch (Exception e) { return("Error:" + e); } }
public List <shipment> MyOrders(String email) { try { using (etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities()) { List <shipment> shipments = (from x in db.shipments where x.customer_customer_email == email select x).ToList(); return(shipments); } } catch (Exception e) { return(null); } }
public List <shipment> GetAllShipments() { try { using (etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities()) { List <shipment> shipments = (from x in db.shipments select x).ToList(); return(shipments); } } catch (Exception e) { return(null); } }
public shipment GetShipment(int id) { try { using (etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities()) { shipment ship = db.shipments.Find(id); return(ship); } } catch (Exception ex) { return(null); } }
public string RemoveAdmin(string email) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); admin p = db.admins.Find(email); db.admins.Attach(p); db.admins.Remove(p); db.SaveChanges(); return(p.email + " was successfully deleted"); } catch (Exception e) { return("Error:" + e); } }
public String DeleteShipment(int id) { try { etvffqgz_megastoreEntities db = new etvffqgz_megastoreEntities(); shipment p = db.shipments.Find(id); db.shipments.Attach(p); db.shipments.Remove(p); db.SaveChanges(); return(p.shipment_id + " was successfully deleted"); } catch (Exception e) { return("Error:" + e); } }