public void SaveUserToInventory(int userId, int inventoryId)
{
NonResultQuerry(InventorySql.SaveUserToInventory(userId, inventoryId));
}
public void UpdateInventory(InventoryDto inventoryDto)
{
NonResultQuerry(InventorySql.UpdateInventory(inventoryDto));
}
public void InsertReport(InventoryReportDto raport)
{
NonResultQuerry(InventorySql.InsertInventoryReport(raport));
}
public void RemoveAllUsersFromInventory(int inventoryId)
{
NonResultQuerry(InventorySql.RemoveAllUsersFormInventory(inventoryId));
}
public InventoryReportDto GetReportForInventory(int inventoryId)
{
return(QueryForObject <InventoryReportDto>(InventorySql.GetReportForInventory(inventoryId)));
}
public void InsertInventory(InventoryDto inventoryDto)
{
NonResultQuerry(InventorySql.InsertInventory(inventoryDto));
}
public IEnumerable <InventoryEventDto> GetInventoryEventsByInventoryId(int invenoryId)
{
return(QuerryForList <InventoryEventDto>(InventorySql.GetInventoryEventsByInventoryId(invenoryId)));
}
public InventoryProductDto GetInventoryProductByProductId(int productId)
{
return(QueryForObject <InventoryProductDto>(InventorySql.GetInventoryProductByProductId(productId)));
}
public int GetInventoryAssignedToUser(int userId)
{
return(QueryForObject <int>(InventorySql.GetInventoryAssignedToUser(userId)));
}
public InventoryDto GetInventoryById(int inventoryId)
{
return(QueryForObject <InventoryDto>(InventorySql.GetInventoryById(inventoryId)));
}
public IEnumerable <InventoryProductDto> GetAllInventoryProductsByInventoryId(int inventoryId)
{
return(QuerryForList <InventoryProductDto>(InventorySql.GetInventoryProductsByInventoryId(inventoryId)));
}
public IEnumerable <InventoryDto> GetAllInventoriesByStatus(int?statusId)
{
return(QuerryForList <InventoryDto>(InventorySql.GetAllInventoriesByStatus(statusId)));
}
public IEnumerable <InventorySearchDto> GetAllActiveInventorySearch()
{
return(QuerryForList <InventorySearchDto>(InventorySql.GetAllActiveInventorySearches()));
}
public void AddInventoryProduct(InventoryProductDto inventoryProduct)
{
NonResultQuerry(InventorySql.AddInventoryProduct(inventoryProduct));
}
public void AddInventoryEvent(InventoryEventDto inventoryEvent)
{
NonResultQuerry(InventorySql.AddInventoryEvent(inventoryEvent));
}
