public async Task <IActionResult> Edit(int id, [Bind("ID,Date,Quantity")] AddInventoryModel addInventoryModel)
{
if (id != addInventoryModel.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(addInventoryModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AddInventoryModelExists(addInventoryModel.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(addInventoryModel));
}
private void ClearBtnClick(object sender, RoutedEventArgs e)
{
AddInventoryModel context = this.DataContext as AddInventoryModel;
context.Number = 0;
context.ObjectName = context.Repack = string.Empty;
context.InDate = DateTime.Now;
context.Price = 0;
}
private void ClearContext()
{
AddInventoryModel context = this.DataContext as AddInventoryModel;
context.Number = 0;
context.ObjectName = string.Empty;
context.InDate = DateTime.Now;
context.Price = 0;
context.Repack = string.Empty;
}
public AddInventory()
{
InitializeComponent();
AddInventoryModel context = new AddInventoryModel();
this.DataContext = context;
context.InDate = DateTime.Now;
AddedList.ItemsSource = context.ObjectNumbers;
}
private Inventory GetInventoryFromContext()
{
AddInventoryModel context = this.DataContext as AddInventoryModel;
return(new Inventory
{
Number = context.Number,
Object = context.ObjectName,
InDate = context.InDate,
Price = context.Price,
Repack = context.Repack
});
}
private async void AddInventoryBtn_Executed(object sender, ExecutedRoutedEventArgs e)
{
AddInventoryModel context = this.DataContext as AddInventoryModel;
if (context.IsNull())
{
CustomMessageBox.ShowOK("Not enough information for inventory. Please try again.", "Error", "OK", MessageBoxImage.Error);
return;
}
Inventory inventory = GetInventoryFromContext();
using (SQLiteConnection connection = new SQLiteConnection(SqlHelpers.ConnectionString))
{
connection.Open();
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT Number FROM Inventory WHERE Number = @Number";
cmd.Parameters.AddWithValue("Number", inventory.Number);
using (var reader = await cmd.ExecuteReaderAsync())
{
if (reader.HasRows)
{
CustomMessageBox.ShowOK("The Inventory has already existed", "Error", "OK", MessageBoxImage.Error);
return;
}
}
cmd.CommandText = "INSERT INTO Inventory ([Number], [Object], [Incoming Date], [Repack], [Price]) VALUES (@Number, @Object, @InDate, @Repack, @Price)";
cmd.Parameters.AddWithValue("Number", inventory.Number);
cmd.Parameters.AddWithValue("Object", inventory.Object);
cmd.Parameters.AddWithValue("InDate", inventory.InDate);
cmd.Parameters.AddWithValue("Repack", inventory.Repack);
cmd.Parameters.AddWithValue("Price", inventory.Price);
var res = await cmd.ExecuteNonQueryAsync();
if (res != -1)
{
CustomMessageBox.ShowOK("Inventory added successfully.", "Information", "OK", MessageBoxImage.Information);
context.ObjectNumbers.Insert(0, inventory.Number);
ClearContext();
return;
}
CustomMessageBox.ShowOK("Something wrong while adding inventory. Please try again later.", "Error", "OK", MessageBoxImage.Error);
}
}
}
public async Task <ActionResult> Create(IFormCollection formCollection)
{
if (ModelState.IsValid)
{
//Save new AddInventoryModel
AddInventoryModel addInventoryModel = new AddInventoryModel();
addInventoryModel.UserName = User.Identity.Name;
addInventoryModel.Date = DateTime.Now;
_context.Add(addInventoryModel);
await _context.SaveChangesAsync();
//Save new AddedItems to AddInventoryModel and update DB with new quantities
var inventory = _context.InventoryItem;
foreach (var _key in formCollection.Keys)
{
if (_key != "__RequestVerificationToken")
{
var item = inventory.Find(Convert.ToInt32(_key));
int addQty = Convert.ToInt32(formCollection[_key]);
//Add addedItem to _context and populate AddedItems
AddedItem addedItem = new AddedItem();
addedItem.AddInventoryModelId = addInventoryModel.ID;
addedItem.InventoryItemId = item.ID;
addedItem.Quantity = addQty;
_context.Add(addedItem);
//Update InventoryItem new StockQty
item.StockQty += addQty;
}
}
await _context.SaveChangesAsync();
return(Redirect("../InventoryItems"));
}
return(RedirectToAction("AddInventory/Create"));
}
public static async Task <ErrorModel> AddInventory(long vintageId, long shelfId, int amount)
{
var url = Links.baseLink + Links.inventories;
var payload = new AddInventoryModel
{
VintageId = vintageId,
ShelfId = shelfId,
Amount = amount
};
var token = await GetToken();
var responseBody = await RestVerbs.Post(url, payload, token);
if (string.IsNullOrEmpty(responseBody))
{
return new ErrorModel {
ErrorCode = false, Message = "Inventeringen har inte lagts till", Object = new InventoryResponse {
InventoryId = 0, ShelfId = 0, Amount = 0
}
}
}
;
try
{
var responseBodyJson = JsonConvert.DeserializeObject <InventoryResponse>(responseBody);
return(new ErrorModel {
ErrorCode = true, Message = null, Object = responseBodyJson
});
}
catch (Exception error)
{
return(new ErrorModel {
ErrorCode = false, Message = error.Message, Object = null
});
}
}
private async Task LoadObjectNumbers()
{
AddInventoryModel context = this.DataContext as AddInventoryModel;
using (var connection = new SQLiteConnection(SqlHelpers.ConnectionString))
{
connection.Open();
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT Id,Number FROM Inventory ORDER BY Id DESC";
var reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
if (int.TryParse(Convert.ToString(reader["Number"]), out int objectNumber))
{
context.ObjectNumbers.Add(objectNumber);
}
await Task.Delay(1);
}
}
}
}
private void AddInventoryBtn_CanExecute(object sender, CanExecuteRoutedEventArgs e)
{
AddInventoryModel context = this.DataContext as AddInventoryModel;
e.CanExecute = context.IsNull() == false;
}
