public ActionResult SearchByItem(string ItemName)
{
//1. Create an object from the ORM class in the .context file (this is what converts from database to object)
Lab22CoffeeShopDB MyORM = new Lab22CoffeeShopDB();
ViewBag.DisplayItems = MyORM.Items.Where(x => x.ItemName.Contains(ItemName)).toList();
return(View(SearchByItem));
}
public ActionResult AddNewUser(User newUser)
{
//1: create object
Lab22CoffeeShopDB MyORM = new Lab22CoffeeShopDB();
{
MyORM.Customers.Add(newUser); /* this addds the new customer. because we connected the tables, we will add data to the form in the correct place. Don't need to create individual objects; can add, remove, insert customers now */
MyORM.SaveChanges(); /*MUST save changes. this moves the change to the database. otherwise you just added it to a list that didn't go beyond this file*/
}
return(View("AddNewUser"));
}
