//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();
}
