public void Remove(int id) { var removeCust = ctx.Customer.Find(id); ctx.Customer.Remove(removeCust); ctx.SaveChanges(); }
public IActionResult Create([Bind("ProductId,Title,Genre,Release,Price,Quantity")] Games games) { if (ModelState.IsValid) { _context.Add(games); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(games)); }
public IActionResult Create([Bind("CustomerId,FirstName,LastName,Phone,Email,Street,City,State,ZipCode,Password,UserName")] Customer customer) { if (ModelState.IsValid) { ctx.Add(customer); ctx.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(customer)); }
public IActionResult Create([Bind("StoreId,StoreName,Phone,Email,Street,City,State,ZipCode")] Locations locations) { if (ModelState.IsValid) { ctx.Add(locations); ctx.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(locations)); }
public IActionResult Create([Bind("InventoryId,StoreId,ProductId,Quantity,Title")] Inventory inventory) { if (ModelState.IsValid) { _context.Add(inventory); _context.SaveChanges(); return(RedirectToAction(nameof(Index))); } ViewData["ProductId"] = new SelectList(_context.Games, "ProductId", "Title", inventory.ProductId); ViewData["StoreId"] = new SelectList(_context.Locations, "StoreId", "StoreName", inventory.StoreId); return(View(inventory)); }
public void Remove(int id) { try { var toRemove = ctx.Orders.Find(id); ctx.Remove(toRemove); ctx.SaveChanges(); } catch (DbUpdateException) { return; } }
public IActionResult Create([Bind("ProductId,OrderId,Quantity")] Orderline orderline) { var lastOrderPlaced = ordsDAL.preOrder(); orderline.OrderId = lastOrderPlaced.OrderId; if (ModelState.IsValid) { _context.Orderline.Add(orderline); _context.SaveChanges(); return(RedirectToAction(nameof(Create))); } ViewData["Quantity"] = new SelectList(_context.Orders, "Quantity", "Quantity", orderline.OrderId); ViewData["ProductId"] = new SelectList(_context.Games, "ProductId", "Title", orderline.ProductId); return(View(orderline)); }
public IActionResult Create([Bind("LocationId,CustomerId,ProductID")] OrdersViewModel ordersV) { Game_RealmContext ctx = new Game_RealmContext(); if (ModelState.IsValid) { string orderlinesController = "Orderlines"; Orders newOrd = new Orders { CustomerId = ordersV.CustomerId, StoreId = ordersV.LocationId, Time = DateTime.Now, Checkout = 0 }; _context.Add(newOrd); _context.SaveChanges(); _context.Entry(newOrd).Reload(); Orderline ords = new Orderline { OrderId = newOrd.OrderId, ProductId = ordersV.ProductID, Quantity = 1, }; _context.Orderline.Add(ords); _context.SaveChanges(); _context.Entry(ords).Reload(); return(RedirectToAction(nameof(Create), orderlinesController)); } ViewData["CustomerId"] = new SelectList(_context.Customer, "CustomerId", "FirstName"); ViewData["StoreId"] = new SelectList(_context.Locations, "StoreId", "StoreName"); ViewData["ProductID"] = new SelectList(_context.Games, "ProductId", "Title"); ViewData["Price"] = new SelectList(_context.Games, "Price", "Price"); return(RedirectToAction(nameof(Index))); }
private static void TylerMain(string[] args) { Customer c = new Customer(); c.FirstName = Console.ReadLine(); c.LastName = Console.ReadLine(); c.Email = Console.ReadLine(); ctx.Customer.Add(c); ctx.SaveChanges(); }
public void Add(Library.Customer customer) { using Game_RealmContext ctx = new Game_RealmContext(); var C_Customer = new Model.Customer(); // add BusinessLogic Customer to DbCustomer C_Customer.FirstName = customer.firstName; C_Customer.LastName = customer.lastName; C_Customer.Password = customer.Password; C_Customer.UserName = customer.Username; ctx.Add(C_Customer); ctx.SaveChanges(); }
public void SaveStore(IDataStore store) { using Game_RealmContext context = new Game_RealmContext(); var S_Stores = new Locations(); // add BusinessLogic Store to DbStores S_Stores.StoreName = store.StoreName; S_Stores.Street = store.Street; S_Stores.City = store.City; S_Stores.State = store.State; S_Stores.ZipCode = store.Zipcode; context.Add(S_Stores); context.SaveChanges(); }
public void SaveOrder(Orders order, ICustomer customer, IDataStore store) { using Game_RealmContext context = new Game_RealmContext(); var O_Orders = new Orders(); // add BusinessLogic Order to DBOrders O_Orders.CustomerId = customer.CustomerId; O_Orders.StoreId = store.StoreId; O_Orders.Checkout = order.Checkout; O_Orders.Time = DateTime.Now; // local time context.Add(O_Orders); context.SaveChanges(); }
public static void addCustomer(Game_RealmContext ctx) { Customer newCust = new Customer(); Console.WriteLine("Please Enter your first name: "); newCust.FirstName = Console.ReadLine(); Console.WriteLine("Please enter your Last Name: "); newCust.LastName = Console.ReadLine(); Console.WriteLine("Please enter a new User Name: "); newCust.UserName = Console.ReadLine(); Console.WriteLine("Please enter a new password: "******"\nYou have been successfully added to the database! "); }
public static Customer buyGame(Game_RealmContext ctx, Customer cust, Locations loc) { var choice = ""; try { choice = Console.ReadLine(); } catch (Exception) { Console.WriteLine(""); } if (choice.ToUpper() == "Y") { cust = CustStorage.custLogin(ctx, cust); } else if (choice.ToUpper() == "N") { Console.WriteLine("You must be a user to place orders!\n"); Thread.Sleep(800); Console.WriteLine("Please Login or Create a new account!\n"); //Dont allow purchase until confirmation that they are registered with us. promptUser.promtUserMenu(ctx, cust); } else if (choice == "") { Console.WriteLine("You Must Enter something !\n"); Thread.Sleep(800); Console.WriteLine("Please Login or Create a new account!\n"); //Dont allow purchase until confirmation that they are registered with us. promptUser.promtUserMenu(ctx, cust); } else { Console.WriteLine("Invalid Entry!\n"); Thread.Sleep(800); Console.WriteLine("Please Login or Create a new account!\n"); //Dont allow purchase until confirmation that they are registered with us. promptUser.promtUserMenu(ctx, cust); } Console.WriteLine("Which store location would you like to purchase your game from?\n"); Thread.Sleep(800); Console.WriteLine("Choose by StoreID: "); List <Locations> locations_list = ctx.Locations.ToList(); foreach (var item in locations_list) { Console.WriteLine("StoreID: " + item.StoreId + " GameRealm Name: " + item.StoreName + "\nStreet: " + item.Street + "\nCity: " + item.City + "\nState: " + item.State + "\n\n"); } int uInput = 0; while (true) { try { uInput = int.Parse(Console.ReadLine()); if (ctx.Locations.Find(uInput) != null) { break; } else { Console.WriteLine("You Must Enter the correct GameRealm ID: "); } } catch (Exception) { Console.WriteLine("incorrect input, enter valid location ID!"); } } Orders newOrder = new Orders(); newOrder.Checkout = 0; newOrder.StoreId = uInput; newOrder.CustomerId = cust.CustomerId; newOrder.Time = DateTime.Now; ctx.Orders.Add(newOrder); ctx.SaveChanges(); ctx.Entry(newOrder).Reload(); int nID = newOrder.OrderId; /*var storeID = ctx.Locations.FirstOrDefault(sid => sid.StoreId == uInput);*/ loc = ctx.Locations.SingleOrDefault(c => c.StoreId == uInput); switch (uInput) { case 1: Console.WriteLine("\n"); Console.WriteLine("Your store: Long Beach, Ca\n"); Thread.Sleep(700); break; case 4: Console.WriteLine("\n"); Console.WriteLine("Your store: Miami, Fl\n"); Thread.Sleep(700); break; case 5: Console.WriteLine("\n"); Console.WriteLine("Your store: New York, Ny\n"); Thread.Sleep(700); break; case 6: Console.WriteLine("\n"); Console.WriteLine("Your store: Dallas, Tx\n"); Thread.Sleep(700); break; default: Console.WriteLine("\n"); Console.WriteLine("Incorrect input, you must choose a store location!\n\n"); Thread.Sleep(700); Console.WriteLine("Are you a registered customer? (y/n)"); buyGame(ctx, cust, loc); break; } List <Games> orderTotal = new List <Games>(); List <Orders> finalCost = new List <Orders>(); var showInventory = new placeOrders(); Console.WriteLine("Choose a game that you would you like to buy, based on GameID: \n\n"); Thread.Sleep(900); showInventory.gameInventory(); Thread.Sleep(800); Console.WriteLine("Choose GameID: "); int gameChoice = 0; Console.WriteLine("\n"); try { gameChoice = int.Parse(Console.ReadLine()); } catch (Exception) { Console.WriteLine("You Must Enter Some Data!"); } /*var orderHist = ctx.Orderline*/ var gameID = ctx.Games.FirstOrDefault(gChoice => gChoice.ProductId == gameChoice); if (gameID != null) { /*string uInput = "";*/ Console.WriteLine($"You have chosen:\nGame Title: {gameID.Title} \nPrice: ${gameID.Price}\n"); orderTotal.Add(gameID); Console.WriteLine("add another game to your cart? (y/n)"); string answer = ""; try { answer = Console.ReadLine(); } catch (Exception) { Console.WriteLine("You Must Enter Some Data!"); } Orderline tCost = new Orderline(); tCost.ProductId = gameID.ProductId; tCost.OrderId = nID; tCost.Quantity = 1; ctx.Orderline.Add(tCost); ctx.SaveChanges(); while (answer.ToUpper() == "Y") { Orderline totalCost = new Orderline(); int count = 0; Console.WriteLine("Choose GameID: "); int gameChoice2 = 0; try { gameChoice2 = int.Parse(Console.ReadLine()); } catch (Exception) { Console.WriteLine("You Must Enter Some Data!"); } Console.WriteLine("\n"); var gameID2 = ctx.Games.FirstOrDefault(gChoice => gChoice.ProductId == gameChoice2); orderTotal.Add(gameID2); foreach (var item in orderTotal) { count++; } Thread.Sleep(1000); Console.WriteLine($"You have chosen:\nGame Title: {gameID2.Title} \nPrice: ${gameID2.Price}\n"); Console.WriteLine(count + " Games in your cart!\n"); totalCost.ProductId = gameID2.ProductId; totalCost.OrderId = nID; totalCost.Quantity = 1; ctx.Orderline.Add(totalCost); ctx.SaveChanges(); Console.WriteLine("\nadd another game to your cart? (y/n)"); string answer2 = Console.ReadLine(); try { } catch (Exception) { Console.WriteLine("You must choose something!"); } if (answer2.ToUpper() == "N") { break; } } Console.WriteLine("Would you like to confirm your Purchase? (y/n)"); var uChoice = Console.ReadLine(); if (uChoice.ToUpper() == "Y") { /*DateTime orederTime = DateTime.Now; * Orders order = new Orders() * { * * * StoreId = loc.StoreId, * CustomerId = cust.CustomerId, * Checkout = gameID.Price, * Time = DateTime.Now * }; * ctx.Orders.Add(order); * ctx.SaveChanges();*/ Console.WriteLine("Thank you for your purchase!\n"); Thread.Sleep(1000); Console.WriteLine("Here is your order summary: \n"); foreach (var item in orderTotal) { Console.WriteLine($"Game: {item.Title}\nPrice: ${item.Price} \n"); } ctx.Entry(newOrder).Reload(); Console.Write("Your total comes out to: $" + newOrder.Checkout); } else if (uChoice.ToUpper() == "N") { Console.WriteLine("Ok, Well what would you like to do?"); Thread.Sleep(800); Console.WriteLine("1) Main Menu\t\t2) Compete Purchase\t\t"); int userChoice = int.Parse(Console.ReadLine()); switch (userChoice) { case 1: Console.WriteLine("\n"); promptUser.promtUserMenu(ctx, cust); Thread.Sleep(600); break; case 2: Console.WriteLine("\n"); Console.WriteLine("Thank you for your purchase!\n"); Thread.Sleep(1000); Console.WriteLine("Here is your order summary: \n"); foreach (var item in orderTotal) { Console.WriteLine($"Game: {item.Title}\nPrice: ${item.Price} \n"); } ctx.Entry(newOrder).Reload(); Console.Write("Your total comes out to: " + newOrder.Checkout); Thread.Sleep(600); Console.WriteLine("\n"); promptUser.promtUserMenu(ctx, cust); break; default: Console.WriteLine($"{cust.FirstName} {cust.LastName} You must choose an option."); Thread.Sleep(600); break; } } } else { Console.WriteLine("Invalid GameID! Please choose The proper GameID from the list of Games Shown."); Console.WriteLine("Are you a registered customer? (y/n)"); placeOrders.buyGame(ctx, cust, loc); } return(cust); }