//FUNCTIONS

        private int MarkerId(Finalmarker marker)
        {
            var repo  = new ProductionRespository(Properties.Settings.Default.ManufacturingConStr);
            var sizes = marker.Sizes.Select(s =>
            {
                return(new MarkerDetail
                {
                    SizeId = s.SizeId,
                    AmountPerLayer = s.AmountPerLayer
                });
            });
            var existingMarker = repo.GetMarker(marker.MarkerCatId, sizes.ToList());

            if (existingMarker != null)
            {
                return(existingMarker.Id);
            }
            else
            {
                var newMarker = new Marker {
                    MarkerCatId = marker.MarkerCatId
                };
                repo.AddMarker(newMarker);
                sizes = sizes.Select(s => { s.MarkerId = newMarker.Id; return(s); });
                repo.AddMarkerDetails(sizes);
                return(newMarker.Id);
            }
        }
        private void GetMarkerText(Finalmarker marker)
        {
            var markerSize = new StringBuilder();

            markerSize.Append(marker.Name);
            if (!marker.AllSizes)
            {
                if (marker.Sizes.Count() == 1)
                {
                    markerSize.Append($"-{marker.Sizes.ToList()[0].Name}");
                }
                else if (marker.Sizes.Count() > 1)
                {
                    markerSize.Append("-NEWMARKER");
                    foreach (var size in marker.Sizes)
                    {
                        markerSize.Append($"-{size.Name}_{size.AmountPerLayer}");
                    }
                }
            }
            marker.MarkerSizeText = markerSize.ToString();
            //return markerSize.ToString();
        }