//Constructor public JordanCustomersController() { JordanDBEntities db = new JordanDBEntities(); customers = db.ShopCustomers .OrderBy(m => m.CustomerFirstName) .ToList(); }
//Constructor public JordanInventoryController() { JordanDBEntities db = new JordanDBEntities(); products = db.JordanInventories .OrderBy(m => m.ProductName) .ToList(); }
public List <PossibleState> GetAllJordanStates() { JordanDBEntities db = new JordanDBEntities(); List <PossibleState> states = db.PossibleStates .OrderBy(m => m.FullStateName) .ToList(); return(states); }
public List <ProductCategory> GetAllJordanCategories() { JordanDBEntities db = new JordanDBEntities(); List <ProductCategory> categories = db.ProductCategories .OrderBy(m => m.CategoryName) .ToList(); return(categories); }
public List <PossibleState> GetIndividualJordanState(string stateID) { JordanDBEntities db = new JordanDBEntities(); List <PossibleState> states = new List <PossibleState>(); states = db.PossibleStates .Where(m => m.StateAbbr == stateID) .ToList(); return(states); }
public List <ProductCategory> GetIndividualJordanCategory(string categoryID) { JordanDBEntities db = new JordanDBEntities(); List <ProductCategory> categories = new List <ProductCategory>(); categories = db.ProductCategories .Where(m => m.CategoryName == categoryID) .ToList(); return(categories); }
//GET: /JordanCustomers/Details/[email protected] public ActionResult Details(string id) { JordanDBEntities db = new JordanDBEntities(); List <ShopCustomer> customers = new List <ShopCustomer>(); customers = db.ShopCustomers.ToList(); var foundCustomer = customers.Where(m => m.CustomerFirstName == id) .First(); return(View(foundCustomer)); }
//GET: /JordanInventory/Details/546480-012 public ActionResult Details(string id) { JordanDBEntities db = new JordanDBEntities(); List <JordanInventory> inventory = new List <JordanInventory>(); inventory = db.JordanInventories.ToList(); var foundProduct = inventory.Where(m => m.ItemStyleNum == id) .First(); return(View(foundProduct)); }
// GET: /JordanCustomers/ByState/NC public ActionResult ByState(string id) { JordanDBEntities db = new JordanDBEntities(); List <ShopCustomer> customers = new List <ShopCustomer>(); customers = db.ShopCustomers.ToList(); var sortedList = customers.Where(m => m.CustomerState == id) .OrderBy(m => m.CustomerFirstName); ViewBag.ChosenState = id; return(View(sortedList)); }
// GET: /JordanInventory/ByCategory/Shoes public ActionResult ByCategory(string id) { JordanDBEntities db = new JordanDBEntities(); List <JordanInventory> inventory = new List <JordanInventory>(); inventory = db.JordanInventories.ToList(); var sortedList = inventory.Where(m => m.ProductCategoryCode == id) .OrderBy(m => m.ProductName); ViewBag.ChosenCategoryCode = id; return(View(sortedList)); }
//Class Constructor method public JordanCategoriesController() { JordanDBEntities db = new JordanDBEntities(); categories = db.ProductCategories.ToList(); }
//Class Constructor method public JordanStatesController() { JordanDBEntities db = new JordanDBEntities(); states = db.PossibleStates.ToList(); }