Ejemplo n.º 1
0
 public static string AddInventoryEvent(InventoryEventDto inventoryEvent)
 {
     return($"INSERT INTO INVENTORY_EVENT(" +
            $"ID," +
            $"INVENTORY_ID," +
            $"EVENT_DATE," +
            $"DESCRIPTION," +
            $"EVENT_TYPE_ID)" +
            $"VALUES(" +
            $"null," +
            $"{inventoryEvent.InventoryId}," +
            $"'{inventoryEvent.EventDate.ToString("yyyy-MM-dd hh:mm:ss")}'," +
            $"'{inventoryEvent.Description}'," +
            $"{inventoryEvent.EventType})");
 }
Ejemplo n.º 2
0
        public void UpdateInventory(UpdateInventoryDto updateInventoryDto)
        {
            InventoryEventDto eventDto = null;

            try
            {
                var inventoryDto = _inventoryDao.GetInventoryById(updateInventoryDto.InventoryId);

                inventoryDto.StatusId = updateInventoryDto.NewStatusId;

                eventDto = new InventoryEventDto
                {
                    Description = "Inventory action",
                    EventDate   = DateTime.Now,
                    EventType   = (int)InventoryEventTypeEnum.InventoryStarted,
                    InventoryId = updateInventoryDto.InventoryId
                };

                if (updateInventoryDto.NewStatusId == 3)
                {
                    eventDto.EventType = (int)InventoryEventTypeEnum.InventoryEnded;
                    CreateReport(updateInventoryDto.InventoryId);
                }
                else if (updateInventoryDto.NewStatusId == 4)
                {
                    eventDto.EventType = (int)InventoryEventTypeEnum.InventoryCancelled;
                }

                _inventoryDao.UpdateInventory(inventoryDto);
                _inventoryDao.RemoveAllUsersFromInventory(inventoryDto.Id);
            }
            catch (Exception e)
            {
                eventDto = new InventoryEventDto
                {
                    Description = e.Message,
                    EventDate   = DateTime.Now,
                    InventoryId = 0,
                    EventType   = (int)InventoryEventTypeEnum.UnknownError
                };
            }
            finally
            {
                _inventoryDao.AddInventoryEvent(eventDto);
            }
        }
Ejemplo n.º 3
0
        public void CreateNewInventory(NewInventoryRequestDto newInventoryRequestDto)
        {
            InventoryEventDto eventDto = null;

            try
            {
                _inventoryDao.InsertInventory(new InventoryDto
                {
                    Description = newInventoryRequestDto.Description,
                    StartDate   = DateTime.Now,
                    StatusId    = 1,
                    ZoneId      = newInventoryRequestDto.ZoneId
                });

                eventDto = new InventoryEventDto
                {
                    Description = "New inventory created",
                    EventDate   = DateTime.Now,
                    EventType   = (int)InventoryEventTypeEnum.InventoryCreated,
                    InventoryId = 0
                };
            }
            catch (Exception e)
            {
                eventDto = new InventoryEventDto
                {
                    Description = e.Message,
                    EventDate   = DateTime.Now,
                    InventoryId = 0,
                    EventType   = (int)InventoryEventTypeEnum.UnknownError
                };
            }
            finally
            {
                _inventoryDao.AddInventoryEvent(eventDto);
            }
        }
Ejemplo n.º 4
0
        public void AddInventoryProduct(InventoryProduct inventoryProduct)
        {
            InventoryEventDto eventDto = null;

            try
            {
                var productDto = _productDao.GetProductById(inventoryProduct.ProductId);

                if (productDto == null)
                {
                    eventDto = new InventoryEventDto
                    {
                        Description = $"Product {inventoryProduct.ProductId} does not exist in Product table",
                        EventDate   = DateTime.Now,
                        InventoryId = inventoryProduct.InventoryId,
                        EventType   = (int)InventoryEventTypeEnum.NotExisitingProductScanned
                    };

                    return;
                }

                var inventoryProductDto = _inventoryDao.GetInventoryProductByProductId(inventoryProduct.ProductId);

                if (inventoryProductDto != null)
                {
                    eventDto = new InventoryEventDto
                    {
                        Description = $"Product {inventoryProduct.ProductId} was already scanned",
                        EventDate   = DateTime.Now,
                        InventoryId = inventoryProduct.InventoryId,
                        EventType   = (int)InventoryEventTypeEnum.DuplicateScanned
                    };
                }
                else
                {
                    _inventoryDao.AddInventoryProduct(inventoryProduct.ToDto());

                    eventDto = new InventoryEventDto
                    {
                        Description = $"Product {inventoryProduct.ProductId} was added into inventory {inventoryProduct.InventoryId}",
                        EventDate   = DateTime.Now,
                        InventoryId = inventoryProduct.InventoryId,
                        EventType   = (int)InventoryEventTypeEnum.ProductAdded
                    };
                }
            }
            catch (Exception e)
            {
                eventDto = new InventoryEventDto
                {
                    Description = e.Message,
                    EventDate   = DateTime.Now,
                    InventoryId = inventoryProduct.InventoryId,
                    EventType   = (int)InventoryEventTypeEnum.UnknownError
                };
            }
            finally
            {
                _inventoryDao.AddInventoryEvent(eventDto);
            }
        }
Ejemplo n.º 5
0
 public void AddInventoryEvent(InventoryEventDto inventoryEvent)
 {
     NonResultQuerry(InventorySql.AddInventoryEvent(inventoryEvent));
 }