public InventoryItemViewModel(InventoryItem inventory) { this.Guid = inventory.Guid; this.ProductGuid = inventory.ProductGuid; this.Status = inventory.Status; this.DateCreated = inventory.DateCreated; this.DatesUnavailable = inventory.DatesUnavailable; }
private InventoryItem ConvertToInventory(dynamic inventory) { IList<DateTime> datesUnavailable = this._serializer.Deserialize<List<DateTime>>(inventory.DatesUnavailable); InventoryItem inventoryItem = new InventoryItem() { Id = inventory.Id, Guid = inventory.Guid, ProductGuid = inventory.ProductGuid, Status = (InventoryStatus)Enum.Parse(typeof(InventoryStatus), inventory.Status), DatesUnavailable = datesUnavailable, DateCreated = inventory.DateCreated }; return inventoryItem; }
public InventoryItem SaveInventory(InventoryItem inventory) { if (this.GetInventoryByGuid(inventory.Guid) == null) { // insert string sql = "Insert Into VintageRabbit.Inventory (Guid, ProductGuid, Status, DatesUnavailable, DateCreated, DateLastModified) Values (@Guid, @ProductGuid, @Status, @DatesUnavailable, @DateCreated, @DateLastModified)"; using (SqlConnection connection = new SqlConnection(this._connectionString)) { connection.Execute(sql, new { Guid = inventory.Guid, ProductGuid = inventory.ProductGuid, Status = inventory.Status.ToString(), DatesUnavailable = this._serializer.Serialize(inventory.DatesUnavailable), DateCreated = DateTime.Now, DateLastModified = DateTime.Now }); } } else { //update string sql = @"Update VintageRabbit.Inventory Set ProductGuid = @ProductGuid, Status = @Status, OrderItemGuid = @OrderItemGuid, DateSold = @DateSold, DatesUnavailable = @DatesUnavailable, DateLastModified = @DateLastModified Where Guid = @Guid"; using (SqlConnection connection = new SqlConnection(this._connectionString)) { connection.Execute(sql, new { Guid = inventory.Guid, ProductGuid = inventory.ProductGuid, Status = inventory.Status.ToString(), DatesUnavailable = this._serializer.Serialize(inventory.DatesUnavailable), DateCreated = DateTime.Now, DateLastModified = DateTime.Now, OrderItemGuid = inventory.OrderItemGuid, DateSold = inventory.DateSold }); } } return inventory; }