public async Task <ActionResult> deleteUser(int id)
{
CoffeeShopEntities shop = new CoffeeShopEntities();
UserInfo dedPerson = shop.UserInfoes.Find(id);
var userEmail = dedPerson.Email;
if (userEmail == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (userEmail != User.Identity.Name)
{
TempData["msg"] = "Not Autherized";
return(RedirectToAction("displayUser", "Home"));
}
var user = await UserManager.FindByNameAsync(dedPerson.Email);
if (User.Identity.Name == userEmail)
{
var AM = HttpContext.GetOwinContext().Authentication;
AM.SignOut();
}
await UserManager.DeleteAsync(user);
//////////////////////////////////////////////////////
shop.UserInfoes.Remove(dedPerson);
shop.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public ActionResult Add(int id)
{
CoffeeShopEntities db = new CoffeeShopEntities();
if (Session["Cart"] == null)
{
List <Item> cart = new List <Item>();
cart.Add((from i in db.Items
where i.ID == id
select i).Single());
Session.Add("Cart", cart);
}
else
{
List <Item> cart = (List <Item>)(Session["Cart"]);
cart.Add((from i in db.Items
where i.ID == id
select i).Single());
}
return(View());
}
public ActionResult Index()
{
CoffeeShopEntities s = new CoffeeShopEntities();
ViewBag.Temp = s.UserInfoes.Count();
return(View(ViewBag.Temp));
}
public ActionResult Add(string ItemName)
{
CoffeeShopEntities db = new CoffeeShopEntities();
//check if the Cart object already exists
if (Session["Cart"] == null)
{
//if it doesn't, make a new list of books
List <Item> cart = new List <Item>();
//add this book to it
cart.Add((from i in db.Items
where i.ItemName == ItemName
select i).Single());
//add the list to the session
Session.Add("Cart", cart);
}
else
{
//if it does exist, get the list
List <Item> cart = (List <Item>)(Session["Cart"]);
//add this book to it
cart.Add((from i in db.Items
where i.ItemName == ItemName
select i).Single());
}
return(View());
}
public ActionResult Add(int id)
{
CoffeeShopEntities ORM = new CoffeeShopEntities();
//check if cart object already exists
if (Session["Cart"] == null)
{
//if it doesn't, make new list of books
List <Item> cart = new List <Item>();
//add this book to it
cart.Add((from x in ORM.Items where x.ID == id select x).Single());
//add the list to the session
Session.Add("Cart", cart);
}
else
{
//if it does exist, get the list
List <Item> cart = (List <Item>)(Session["Cart"]);
//add this book to it
cart.Add((from x in ORM.Items where x.ID == id select x).Single());
//add it back to the session
//Session["Cart"] = cart;
}
return(View());
}
public ActionResult MenuSorted(string column)
{
CoffeeShopEntities db = new CoffeeShopEntities();
if (column == "Name")
{
ViewBag.Items = (from i in db.Items
orderby i.Name
select i).ToList();
}
else if (column == "Description")
{
ViewBag.Items = (from i in db.Items
orderby i.Description
select i).ToList();
}
else if (column == "Stock")
{
ViewBag.Items = (from i in db.Items
orderby i.Stock
select i).ToList();
}
else if (column == "Price")
{
ViewBag.Items = (from i in db.Items
orderby i.Price
select i).ToList();
}
return(View("Menu"));
}
public async Task <ActionResult> Register(Person u)
{
//var identityResult = await UserManager.CreateAsync(new Person(u.UserName),u.Password);
if (ModelState.IsValid)
{
LoginModel user = new LoginModel();
user.UserName = u.UserName;
var userManager = HttpContext.GetOwinContext().Get <UserManager <Person> >();
var identityResult = await userManager.CreateAsync(new Person(u.UserName), u.Password);
if (identityResult.Succeeded)
{
UserInfo ui = new UserInfo();
ui.Birthday = u.Birthday;
ui.Email = u.UserName;
ui.FirstName = u.FirstName;
ui.LastName = u.LastName;
ui.MothersName = u.MotherName;
ui.Phone = u.Phone;
CoffeeShopEntities shop = new CoffeeShopEntities();
shop.UserInfoes.Add(ui);
shop.SaveChanges();
return(RedirectToAction("registerComplete", u));
}
ModelState.AddModelError("", identityResult.Errors.FirstOrDefault());
return(View());
}
return(View());
}
public ActionResult BrowseProducts()
{
CoffeeShopEntities Items = new CoffeeShopEntities();
ViewBag.ItemData = Items.Items.ToList();
return(View("BrowseProducts"));
}
public ActionResult Add(int id)
{
CoffeeShopEntities db = new CoffeeShopEntities();
//check if the Cart object already exists
if (Session["Cart"] == null)
{
List <Item> cart = new List <Item>();
cart.Add((from i in db.Items
where i.ID == id
select i).Single());
Session.Add("Cart", cart);
}
else
{
//if it does exist, get the list
List <Item> cart = (List <Item>)(Session["Cart"]);
//add this book to it
cart.Add((from i in db.Items
where i.ID == id
select i).Single());
//(add it back to the session)
Session["Cart"] = cart;
}
return(View());
}
public ActionResult EditItemByID(string Name, string Description, int Quantity, decimal Price, bool Visibility)
{
CoffeeShopEntities Coffee = new CoffeeShopEntities();
int ItemID = (int)TempData["ItemID"];
var MyItem = Coffee.Items.Single(t => t.ItemID == ItemID);
try
{
MyItem.Name = Name;
MyItem.Description = Description;
MyItem.Quantity = Quantity;
MyItem.Price = Price;
MyItem.Visibility = Visibility;
Coffee.SaveChanges();
ModalUsage = true;
TempData["ModalUsage"] = ModalUsage;
ViewBag.ModalUsage = TempData["ModalUsage"];
}
catch
{
Exception e = new Exception("Had some issues with the database");
TempData["ModalUsage"] = false;
TempData["ModalUsage"] = ModalUsage;
ViewBag.ModalUsage = TempData["ModalUsage"];
}
TempData["ItemID"] = ItemID;
ViewBag.StockItems = Coffee.Items.ToList();
return(View("AdminTool"));
}
public ActionResult Menu()
{
CoffeeShopEntities db = new CoffeeShopEntities();
List <Item> items = db.Items.ToList();
ViewBag.Items = items;
return(View());
}
public ActionResult editUser(int id)
{
CoffeeShopEntities shop = new CoffeeShopEntities();
UserInfo u = new UserInfo();
u = shop.UserInfoes.Find(id);
return(View(u));
}
public ActionResult DeleteItem(int ItemID)
{
CoffeeShopEntities Coffee = new CoffeeShopEntities();
Item MyItem = Coffee.Items.Find(ItemID);
ViewBag.MyItem = MyItem;
return(View("DeleteItem", MyItem));
}
public ActionResult EditItem(int ItemID)
{
CoffeeShopEntities Coffee = new CoffeeShopEntities();
ViewBag.ItemInfo = Coffee.Items.Find(ItemID);
TempData["ItemID"] = ItemID;
return(View("EditItem", ViewBag.ItemInfo));
}
public ActionResult Menu(Item data)
{
CoffeeShopEntities ORM = new CoffeeShopEntities();
List <Item> items = ORM.Items.ToList();
ViewBag.Items = items;
ViewBag.Items = ORM.Items;
return(View());
}
//public=Access modifier**
//returnType=ActionResult
//BookListByAuthor=Method name
public ActionResult ItemListByItemName(string ItemName)
{
CoffeeShopEntities db = new CoffeeShopEntities();
//LINQ Query
ViewBag.Items = db.Items.Where(i => i.ItemName == ItemName).ToList();
return(View("ItemList"));
}
public ActionResult ConfirmDelete(int ItemID)
{
CoffeeShopEntities Coffee = new CoffeeShopEntities();
Item MyItem = Coffee.Items.Find(ItemID);
Coffee.Items.Remove(Coffee.Items.Find(ItemID));
Coffee.SaveChanges();
ViewBag.StockItems = Coffee.Items.ToList();
return(View("AdminTool", MyItem));
}
public ActionResult ItemList()
{
CoffeeShopEntities db = new CoffeeShopEntities();
List <Item> Items = db.Items.ToList();
ViewBag.Items = Items;
//ViewBag.Statuses = db.Statuses.ToList();
return(View());
}
public ActionResult ItemListByDescription(string description)
{
CoffeeShopEntities db = new CoffeeShopEntities();
List <Item> items = (from i in db.Items
where i.Description.Contains(description)
select i).ToList();
ViewBag.Items = items;
return(View("ItemList"));
}
public ActionResult MenuByDescription(string description)
{
CoffeeShopEntities db = new CoffeeShopEntities();
//LINQ Query
List <Item> items = (from i in db.Items
where i.Description.Contains(description)
select i).ToList();
ViewBag.Items = items;
ViewBag.Names = db.Items.ToList();
return(View("Menu"));
}
//filter by Name
public ActionResult MenuByName(string name)
{
CoffeeShopEntities db = new CoffeeShopEntities();
//LINQ Query
List <Item> items = (from i in db.Items
where i.Name == name
select i).ToList();
ViewBag.Name = items;
ViewBag.Name = db.Items.ToList();
return(View("Menu"));
}
public ActionResult Add(int id = 0)/*, int quantity = 0)*/
{
//dao.UpdateQuantity(id, quantity);
CoffeeShopEntities db = new CoffeeShopEntities();
//int Quantity = 0;
if (id == 0 && Session["Cart"] != null)
{
//List<Item> cart = (List<Item>)(Session["Cart"]);
//Item item = ()
return(View("Add", Session["Cart"]));
}
else if (id == 0)
{
//List<Item> cart = (List<Item>)(Session["Cart"]);
//Item item = ()
return(View("Add", Session["Cart"] = null));
}
else
{
//Check if the Cart already exists
if (Session["Cart"] == null)
{
//if it doesn't make a new list of books
List <Item> cart = new List <Item>();
//add this book to it
cart.Add((from i in db.Items
where i.ItemId == id
select i).Single());
//cart[id] = cart[id] + Quantity++;
//add the list to the session
Session.Add("Cart", cart);
}
else
{
//if it does exist need to get the list
List <Item> cart = (List <Item>)(Session["Cart"]);
//add this book to the list
cart.Add((from b in db.Items
where b.ItemId == id
select b).Single());
//add the list to the session
//Session["Cart"] = cart;
}
return(View());
}
}
//filter by status
public ActionResult ItemListByQuantity(int Quantity)
{
CoffeeShopEntities db = new CoffeeShopEntities();
//LINQ Query
List <Item> Items = (from b in db.Items
where b.Quantity == Quantity
select b).ToList();
ViewBag.Items = Items;
ViewBag.Quantity = db.Quantity.ToString();
return(View("ItemList"));
}
public ActionResult AddNewItem(string Name, string Description, int Quantity, decimal Price, bool Visibility)
{
CoffeeShopEntities Coffee = new CoffeeShopEntities();
Item NewItem = new Item
{
Name = Name,
Description = Description,
Quantity = Quantity,
Price = Price,
Visibility = Visibility
};
Coffee.Items.Add(NewItem);
Coffee.SaveChanges();
ViewBag.StockItems = Coffee.Items.ToList();
return(View("AdminTool"));
}
public ActionResult Browse()
{
CoffeeShopEntities Coffee = new CoffeeShopEntities();
List <Item> Stock = new List <Item>();
Stock = Coffee.Items.ToList();
ViewBag.Item1 = Stock[0].Name + "$ " + Stock[0].Price + " Qty: " + Stock[0].Quantity;
ViewBag.Item2 = Stock[1].Name + "$ " + Stock[1].Price + " Qty: " + Stock[1].Quantity;
ViewBag.Item3 = Stock[2].Name + "$ " + Stock[2].Price + " Qty: " + Stock[2].Quantity;
ViewBag.Item4 = Stock[3].Name + "$ " + Stock[3].Price + " Qty: " + Stock[3].Quantity;
ViewBag.Item1Description = Stock[0].Description.ToString();
ViewBag.Item2Description = Stock[1].Description.ToString();
ViewBag.Item3Description = Stock[2].Description.ToString();
ViewBag.Item4Description = Stock[3].Description.ToString();
return(View());
}
public ActionResult UserChanges(UserInfo u)
{
CoffeeShopEntities shop = new CoffeeShopEntities();
UserInfo old = shop.UserInfoes.Find(u.UserID);
old.FirstName = u.FirstName;
old.LastName = u.LastName;
old.Phone = u.Phone;
old.Email = u.Email;
old.Password = u.Password;
old.MothersName = u.MothersName;
old.Birthday = u.Birthday;
shop.Entry(old).State = System.Data.Entity.EntityState.Modified;
shop.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AdminTool()
{
CoffeeShopEntities Coffee = new CoffeeShopEntities();
ViewBag.ModalUsage = ModalUsage;
ViewBag.StockItems = Coffee.Items.ToList();
if (TempData["ModalUsage"] == null)
{
TempData["ModalUsage"] = false;
ModalUsage = (bool)TempData["ModalUsage"];
}
else
{
ModalUsage = (bool)TempData["ModalUsage"];
}
return(View());
}
public ActionResult ItemListSorted(string column)
{
CoffeeShopEntities db = new CoffeeShopEntities();
//LINQ Query
if (column == "ItemID")
{
ViewBag.Books = (from b in db.Items
orderby b.ItemID
select b).ToList();
}
else if (column == "ItemName")
{
ViewBag.Books = (from i in db.Items
orderby i.ItemName
select i).ToList();
}
else if (column == "Description")
{
ViewBag.Books = (from i in db.Items
orderby i.Description
select i).ToList();
}
else if (column == "Quantity")
{
ViewBag.Books = (from i in db.Items
orderby i.Quantity
select i).ToList();
}
else if (column == "Price")
{
ViewBag.Books = (from i in db.Items
orderby i.Price
select i).ToList();
}
ViewBag.ItemID = db.Items.ToList();
return(View("ItemList"));
}
public ActionResult MenuSorted(string column)
{
CoffeeShopEntities db = new CoffeeShopEntities();
//LINQ Query
if (column == "ID")
{
ViewBag.Items = (from i in db.Items
orderby i.ID
select i).ToList();
}
else if (column == "Name")
{
ViewBag.Items = (from i in db.Items
orderby i.Name
select i).ToList();
}
else if (column == "Description")
{
ViewBag.Items = (from i in db.Items
orderby i.Description
select i).ToList();
}
else if (column == "Quantity")
{
ViewBag.Items = (from i in db.Items
orderby i.Quantity
select i).ToList();
}
else if (column == "Price")
{
ViewBag.Items = (from i in db.Items
orderby i.Price
select i).ToList();
}
ViewBag.Statuses = db.Items.ToList();
return(View("Menu"));
}
public ActionResult AddUser(string FirstName, string LastName, string Email)
{
CoffeeShopEntities Coffee = new CoffeeShopEntities();
User NewUser = new User
{
FirstName = FirstName,
LastName = LastName,
Email = Email
};
if (!ModelState.IsValid)
{
foreach (ModelState s in ModelState.Values)
{
foreach (ModelError r in s.Errors)
{
//individual errors for each field
//r.ErrorMessage
}
}
}
try
{
Coffee.Users.Add(NewUser);
Coffee.SaveChanges();
ViewBag.CustomerFirstName = NewUser.FirstName;
return(View("About"));
}
catch (Exception e)
{
ModelState.Values.Add(new ModelState());
return(View("../Shared/Error"));//error page
}
}
