/// <summary> /// Adds a new product to the database /// </summary> /// <param name="product"></param> /// <returns></returns> public ServiceResponse <Product> CreateProduct(Product product) { try { _solarDb.Add(product); var newInvertory = new ProductInventory { Product = product, QuantityOnHand = 0, IdealQuantity = 10 }; _solarDb.Add(newInvertory); _solarDb.SaveChanges(); return(new ServiceResponse <Product> { Data = product, Time = DateTime.UtcNow, IsSuccess = true, Message = "Saved new product" }); } catch (Exception ex) { return(new ServiceResponse <Product> { Data = product, Time = DateTime.UtcNow, IsSuccess = false, Message = ex.StackTrace }); } }
/// <summary> /// Add Customer record /// </summary> /// <param name="customer"></param> /// <returns>ServiceResponse<Customer></returns> public ServiceResponse <Customer> CreateCustomer(Customer customer) { try { db.Add(customer); var response = db.SaveChanges(); if (response >= 1) { return(new ServiceResponse <Customer> { IsSuccess = true, Message = "New Customer Added", Time = DateTime.UtcNow, Data = customer }); } return(new ServiceResponse <Customer> { IsSuccess = false, Message = "Customer not Added", Time = DateTime.UtcNow, Data = customer }); } catch (Exception ex) { return(new ServiceResponse <Customer> { IsSuccess = false, Message = ex.StackTrace, Time = DateTime.UtcNow, Data = null }); } }
/// <summary> /// Creates a Snapshot record using the provided ProductInventory instance /// </summary> /// <param name="inventory"></param> //private void CreateSnapshot(ProductInventory inventory) // OLD VERSION private void CreateSnapshot() { var now = DateTime.UtcNow; /* OLD VERSION * var snapshot = new ProductInventorySnapshot * { * Product = inventory.Product, * QuantityOnHand = inventory.QuantityOnHand, * SnapshotTime = now * }; * * // Entity framework will infer type of 'snapshot' & its respective table * _db.Add(snapshot); */ // NEW VERSION var inventories = _db.ProductInventories .Include(inv => inv.Product) .ToList(); foreach (var inventory in inventories) { var snapshot = new ProductInventorySnapshot { SnapshotTime = now, Product = inventory.Product, QuantityOnHand = inventory.QuantityOnHand }; _db.Add(snapshot); } }
//Creates an open SalesOrder public ServiceResponse <bool> GenerateOpenOrder(SalesOrder order) { var now = DateTime.UtcNow; _logger.LogInformation("Generating new order"); foreach (var item in order.SalesOrderItems) { item.Product = _productService.GetProductById(item.Product.Id); var inventoryId = _inventoryService.GetByProductId(item.Product.Id).Id; _inventoryService.UpdateUnitsAvailable(inventoryId, -item.Quantity); } try{ _db.Add(order); _db.SaveChanges(); return(new ServiceResponse <bool> { IsSuccess = true, Data = true, Time = now, Message = "Open Order Created" }); } catch (Exception e) { return(new ServiceResponse <bool> { IsSuccess = false, Data = false, Time = now, Message = e.StackTrace }); } }
private void CreateSnpashot(data.models.ProductInventory inventory) { data.models.ProductInventorySnapshot snapshot = new data.models.ProductInventorySnapshot { SnapshotTime = DateTime.UtcNow, Product = inventory.Product, quantityOnHand = inventory.quantityOnHand }; _db.Add(snapshot); }
private void CreateSnapShot(ProductInventory inventory) { var snapshot = new ProductInventorySnapshot { SnapshotTime = DateTime.UtcNow, Product = inventory.Product, QuantityOnHand = inventory.QuantityOnHand }; _db.Add(snapshot); //_db.SaveChanges(); }
private void CreateSnapshot(ProductInventory inventory) { var snapshot = new ProductInventorySnapshot { SnapshotTime = DateTime.UtcNow, Product = inventory.Product, QuantityOnHand = inventory.QuantityOnHand }; _solarDbContext.Add(snapshot); }
private void CreateSnapshot(ProductInventory inventory) { var snapshot = new ProductInventorySnapshot { SnapshotTime = now, Product = inventory.Product, QuantityOnHand = inventory.QuantityOnHand }; db.Add(snapshot); }
private void CreateSnapshot(ProductInventory inventory) { var snapshot = new ProductInventorySnapshot { SnapshotTime = DateTime.UtcNow, QuantityOnHand = inventory.QuantityOnHand, Product = inventory.Product }; _db.Add(snapshot); }
public void CreateSnapshot(ProductInventory inventory) { var snapshot = new ProductInventorySnapshot { SnapshotTime = DateTime.UtcNow, Product = inventory.Product, QuantityOnHand = inventory.QuantityOnHand }; // z automatu doda do dobrej tabeli poniewaz zna typ _db.Add(snapshot); _db.SaveChanges(); // komentarz }
/// <summary> /// Create Snapshot record using the provided ProductInventory instance /// </summary> /// <param name="inventory"></param> public void CreateSnapshot(ProductsInventory inventory) { var now = DateTime.UtcNow; var snapshot = new ProductsInventorySnapshot { SnapshootTime = now, Products = inventory.Products, QuantityOnHand = inventory.QuantityOnHand }; _db.Add(snapshot); }
private void CreateSnapshot(ProductInventory inventory) { var now = DateTime.UtcNow; var snapshot = new ProductInventorySnapshot { SnapshotTime = now, Product = inventory.Product, QuantityOnHand = inventory.QuantityOnHand, }; context.Add(snapshot); context.SaveChanges(); }
//Create a snapshot record using the provided ProductIventory instance private void CreateSnapshot() { var now = DateTime.UtcNow; var inventories = _db.ProductInventorys .Include(inv => inv.Product).ToList(); foreach (var inventory in inventories) { var snapshot = new ProductInventorySnapshot { SnapshotTime = now, Product = inventory.Product, QuantityOnHand = inventory.QuantityOnHand }; _db.Add(snapshot); } }
//Add a new customer public ServiceResponse <Data.Models.Customer> CreateCustomer(Data.Models.Customer customer) { try{ _db.Add(customer); _db.SaveChanges(); return(new ServiceResponse <Data.Models.Customer> { IsSuccess = true, Message = "New Customer Add", Time = DateTime.UtcNow, Data = customer }); }catch (Exception e) { return(new ServiceResponse <Data.Models.Customer> { IsSuccess = false, Message = e.StackTrace, Time = DateTime.UtcNow, Data = customer }); } }
/// <summary> /// Creates a Snapshot record using the provided ProductInventory instance /// </summary> /// <param name="inventory"></param> private void CreateSnapshot() { var now = DateTime.UtcNow; var inventories = _db.ProductInventories .Include(inv => inv.Product).ToList(); foreach (var inventory in inventories) { var snapshot = new ProductInventorySnapshot { SnapshotTime = now, Product = inventory.Product, QuantityOnHand = inventory.QuantityOnHand }; _db.Add(snapshot); } // don't need to save changes because CreateSnapshot is follewed by _db.SaveChanges }