public void PlaceOrder(project0Context context) { List <Orderlist> orderlists = new List <Orderlist>(); int orderId = GetTheLastOrderId(context) + 1; Console.WriteLine("What is the customerId:"); string cs = Console.ReadLine(); int custId; if (!int.TryParse(cs, out custId)) { Console.WriteLine("We don't have you in our system"); } else { char stop = 'A'; do { orderlists.Add(AddProductToOrder(context, custId, orderId)); Console.WriteLine("Contnue shopping enter and letter or enter E to stop:"); string str = Console.ReadLine(); if (str != "") { stop = str[0]; } } while (stop != 'E'); } Orders order = new Orders() { UserId = custId, Total = sumTotal, OrderDate = DateTime.Now }; context.Add(order); context.SaveChanges(); context.Add(orderlists); context.SaveChanges(); /*foreach(Orderlist ol in orderlists) * { * context * }*/ }
public async Task <IActionResult> Create([Bind("CustomerId,FirstName,LastName,Date")] Customer customer) { if (ModelState.IsValid) { _context.Add(customer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(customer)); }
public async Task <IActionResult> Create([Bind("ProductId,ProductName,Price,Date")] Product product) { if (ModelState.IsValid) { _context.Add(product); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(product)); }
public async Task <IActionResult> Create([Bind("InventoryId,StoreId,ProductId,Stock")] Inventory inventory) { if (ModelState.IsValid) { _context.Add(inventory); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["ProductId"] = new SelectList(_context.Products, "ProductId", "ProductName", inventory.ProductId); ViewData["StoreId"] = new SelectList(_context.Stores, "StoreId", "StoreName", inventory.StoreId); return(View(inventory)); }
public void AddProduct(Library.Product product) { using var context = new project0Context(_dbContext); var dbProduct = new Product() { Name = product.Name, Price = product.Price }; context.Add(dbProduct); context.SaveChanges(); }
/// <summary> /// Adds order to a particular customer /// </summary> /// <param name="order">Order Added</param> public void AddOrderByCustomerId(int customerId, int productId, int locationId, int quantity) { using var context = new project0Context(_dbContext); var dbOrders = new DataModel.Order() { CustomerId = customerId, ProductId = productId, LocationId = locationId, OrderQuantity = quantity, }; context.Add(dbOrders); context.SaveChanges(); }
/// <summary> /// Adds a customer /// </summary> /// <param name="customer">Added customer</param> public void AddCustomer(Library.Customer customer) { using var context = new project0Context(_dbContext); var dbCustomer = new StoreApp.DataModel.Customer() { FirstName = customer.FirstName, LastName = customer.LastName, Email = customer.Email }; context.Add(dbCustomer); context.SaveChanges(); }
public void AddOrderItem(Library.OrderDetail orderItem) { using var context = new project0Context(_dbContext); var dbItem = new OrderDetail() { OrderId = orderItem.OrderId, ProductId = orderItem.ProductId, Quantity = orderItem.Quantity }; context.Add(dbItem); context.SaveChanges(); }
public void AddCustomer(string FirstName, string LastName) { /*using*/ var context = new project0Context(_dbContext); if (FirstName.Length > 0 && LastName.Length > 0) { Customer customer = new Customer() { FirstName = FirstName, LastName = LastName }; context.Add(customer); context.SaveChanges(); } }
public void AddLocation(string name) { // get the context of the db using var context = new project0Context(_dbContext); if (name.Length > 0) { // create the db model to add Location location = new Location() { Name = name }; //add location to context and save context.Add(location); context.SaveChanges(); } }
/// <summary> /// Adds order to a particular customer /// </summary> /// <param name="order">Order Added</param> public void AddOrderByCustomerId(int customerId, int locationId) { using var context = new project0Context(_dbContext); var appOrders = new Library.Order() { CustomerId = customerId, LocationId = locationId, }; var dbOrders = new DataModel.Order() { CustomerId = appOrders.CustomerId, LocationId = appOrders.LocationId, // OrderDetails.Quantity = quantity, }; context.Add(dbOrders); context.SaveChanges(); }
/// <summary> /// Adding new customer to the database /// input: customer object /// output: void /// </summary> /// <param name="ncustomer"></param> public void AddCustomer(project0Context context) { //using project0Context context = new project0Context(); Customers customer = new Customers(); //get the first name of the customer Console.WriteLine("Enter the customers first name:"); customer.FirstName = Console.ReadLine(); //get the customer last name Console.WriteLine("Enter the customers Last name:"); customer.LastName = Console.ReadLine(); //get the street address Console.WriteLine("Enter the customers Street address:"); customer.StreetAddress = Console.ReadLine(); //get the city address Console.WriteLine("Enter the customers City Address:"); customer.CityAddress = Console.ReadLine(); //get the state address Console.WriteLine("Enter the customers Sate Address:"); customer.StateAddress = Console.ReadLine(); //get the country address Console.WriteLine("Enter the customers Country Address:"); customer.CountryAddress = Console.ReadLine(); //get the username Console.WriteLine("Enter the customers username:"******"Enter the customers password:"); customer.PassWord = Console.ReadLine(); customer.RegDate = DateTime.Now; context.Add(customer); context.SaveChanges() ; }
public Order AddOrder(Library.Order order) { using var context = new project0Context(_dbContext); var dbOrder = new Order() { CustomerId = order.CustomerId, LocationId = order.LocationId, Date = order.Date }; //var appOrder = new Library.Order() //{ // CustomerId = dbOrder.CustomerId, // LocationId = dbOrder.LocationId, // Date = dbOrder.Date //}; context.Add(dbOrder); context.SaveChanges(); return(GetOrderById(dbOrder.OrderId)); }