public void UploadUsers() { using (var reader = new StreamReader(@"C:\Users\Curtis Weide - IT\source\repos\ANWInventoryManagement\ANWInventoryManagement\Files\ID Card LIST - Sheet3.csv")) { while (!reader.EndOfStream) { var lines = reader.ReadLine(); var values = lines.Split(','); var duplicateEntry = _context.Users.Where(i => i.UserID == int.Parse(values[3])).FirstOrDefault(); if (duplicateEntry == null) { User newUser = new User() { UserID = int.Parse(values[3]), Name = values[0] + " " + values[1] }; _context.Users.Add(newUser); } } _context.SaveChanges(); } }
public IActionResult AddItem(InventoryViewModel addItemViewModel) { if (ModelState.IsValid) { Category category = _context.Categories.Where(i => i.ID == addItemViewModel.CategoryID).FirstOrDefault(); var categoryName = category.Name; var categoryID = category.ID; DateTime purchaseDate = addItemViewModel.PurchaseDate; if (purchaseDate == DateTime.MinValue) { purchaseDate = DateTime.Today; } var dupItem = _context.Items.Where(i => i.ItemID == addItemViewModel.ItemID).FirstOrDefault(); if (dupItem == null) { Item newItem = new Item { Name = addItemViewModel.DeviceName, ItemID = addItemViewModel.BarcodeID, PurchaseDate = purchaseDate, Category = categoryName, CategoryID = categoryID, CheckedOut = false }; _context.Items.Add(newItem); _context.SaveChanges(); return(Redirect("/Inventory")); } else { ViewBag.message = "Duplicate Barcode"; return(View(addItemViewModel)); } } IList <Category> categories = _context.Categories.ToList(); InventoryViewModel inventoryViewModel = new InventoryViewModel { Categories = categories }; return(View(inventoryViewModel)); }