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));
}
