Production Requests

_Production Requests

handling requests for labels, brochures, etc to be made (internally)

LabelSize.cs

using System;
using System.Collections.Generic;

namespace ProductionServices.Models
{
    public partial class LabelSize
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }
}

LabelSizeO.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using ProductionServices.Models;

/**protected access to database, accepts logic from ViewLogic and commits to db**/

namespace ProductionServices.DataLogic
{
    public class LabelSize
    {
        private ServicesContext lblDB;

        public LabelSize()
        {
            lblDB = new ServicesContext();
        } 
        public IEnumerable<LabelSize> GetAll()
        {
            return lblDB.LabelSize.ToList();
        }
    }
}

ServicesContext.cs

using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;

namespace ProductionServices.Models
{
    public partial class ServicesContext : DbContext
    {
        public virtual DbSet<Board> Board { get; set; }
        public virtual DbSet<BoardDescription> BoardDescription { get; set; }
        public virtual DbSet<BoardSize> BoardSize { get; set; }
        public virtual DbSet<BoardType> BoardType { get; set; }
        public virtual DbSet<Brand> Brand { get; set; }
        public virtual DbSet<Brochure> Brochure { get; set; }
        public virtual DbSet<BusinessCard> BusinessCard { get; set; }
        public virtual DbSet<Flyer> Flyer { get; set; }
        public virtual DbSet<InstallInstructions> InstallInstructions { get; set; }
        public virtual DbSet<Label> Label { get; set; }
        public virtual DbSet<LabelDescription> LabelDescription { get; set; }
        public virtual DbSet<LabelSize> LabelSize { get; set; }
        public virtual DbSet<LabelType> LabelType { get; set; }
        public virtual DbSet<Media> Media { get; set; }
        public virtual DbSet<MediaType> MediaType { get; set; }
        public virtual DbSet<NewLaunch> NewLaunch { get; set; }
        public virtual DbSet<Photography> Photography { get; set; }
        public virtual DbSet<PhotographyType> PhotographyType { get; set; }
        public virtual DbSet<Region> Region { get; set; }
        public virtual DbSet<Request> Request { get; set; }
        public virtual DbSet<Sds> Sds { get; set; }
        public virtual DbSet<SpecSheet> SpecSheet { get; set; }
        public virtual DbSet<StrapSet> StrapSet { get; set; }
        public virtual DbSet<StrapSetDescription> StrapSetDescription { get; set; }
        public virtual DbSet<StrapsetLabel> StrapsetLabel { get; set; }
        public virtual DbSet<Website> Website { get; set; }

       /** protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
        #warning To protect potentially sensitive information in your connection string, you should move it out of source code. See http://go.microsoft.com/fwlink/?LinkId=723263 for guidance on storing connection strings.

        }**/

        public ServicesContext(DbContextOptions<ServicesContext> options)
            : base(options)
        { }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Board>(entity =>
            {
                entity.Property(e => e.Description).HasColumnType("nchar(10)");

                entity.Property(e => e.Quantity).HasColumnType("nchar(10)");

                entity.Property(e => e.Size).HasColumnType("varchar(50)");

                entity.Property(e => e.Type).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<BoardDescription>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<BoardSize>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<BoardType>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<Brand>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<Brochure>(entity =>
            {
                entity.Property(e => e.Description).HasColumnType("varchar(50)");

                entity.Property(e => e.Quantity).HasColumnType("nchar(10)");
            });

            modelBuilder.Entity<BusinessCard>(entity =>
            {
                entity.Property(e => e.Id).ValueGeneratedNever();

                entity.Property(e => e.Astm)
                    .HasColumnName("ASTM")
                    .HasColumnType("varchar(max)");

                entity.Property(e => e.FloorScore).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<Flyer>(entity =>
            {
                entity.Property(e => e.Description).HasColumnType("varchar(max)");

                entity.Property(e => e.Quantity).HasColumnType("nchar(10)");
            });

            modelBuilder.Entity<InstallInstructions>(entity =>
            {
                entity.Property(e => e.Description).HasColumnType("varchar(max)");

                entity.Property(e => e.Quantity).HasColumnType("nchar(10)");
            });

            modelBuilder.Entity<Label>(entity =>
            {
                entity.Property(e => e.Description).HasColumnType("nchar(10)");

                entity.Property(e => e.Quantity).HasColumnType("nchar(10)");

                entity.Property(e => e.Size).HasColumnType("varchar(50)");

                entity.Property(e => e.Type).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<LabelDescription>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<LabelSize>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<LabelType>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<Media>(entity =>
            {
                entity.Property(e => e.Name)
                    .IsRequired()
                    .HasColumnType("varchar(50)");

                entity.Property(e => e.Path).IsRequired();

                entity.Property(e => e.Type)
                    .IsRequired()
                    .HasMaxLength(50);
            });

            modelBuilder.Entity<MediaType>(entity =>
            {
                entity.Property(e => e.Name)
                    .IsRequired()
                    .HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<NewLaunch>(entity =>
            {
                entity.Property(e => e.Astm).HasColumnName("ASTM");

                entity.Property(e => e.Name).HasColumnType("varchar(max)");
            });

            modelBuilder.Entity<Photography>(entity =>
            {
                entity.Property(e => e.Link).HasColumnType("varchar(max)");

                entity.Property(e => e.Type).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<PhotographyType>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<Region>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<Request>(entity =>
            {
                entity.Property(e => e.CurrDate).HasColumnType("datetime");

                entity.Property(e => e.CusNo).HasColumnType("varchar(50)");

                entity.Property(e => e.NeedByDate).HasColumnType("nchar(10)");

                entity.Property(e => e.Region).HasColumnType("varchar(50)");

                entity.Property(e => e.RequestedBy).HasColumnType("varchar(50)");

                entity.Property(e => e.ShippingPackingInfo).HasColumnType("varchar(max)");

                entity.Property(e => e.Type).HasColumnType("nchar(10)");
            });

            modelBuilder.Entity<Sds>(entity =>
            {
                entity.ToTable("SDS");

                entity.Property(e => e.Description).HasColumnType("varchar(max)");

                entity.Property(e => e.Quantity).HasColumnType("nchar(10)");
            });

            modelBuilder.Entity<SpecSheet>(entity =>
            {
                entity.Property(e => e.As400color)
                    .HasColumnName("AS400Color")
                    .HasMaxLength(50);

                entity.Property(e => e.Beveling).HasColumnType("varchar(50)");

                entity.Property(e => e.CartonBarcodes).HasColumnType("varchar(max)");

                entity.Property(e => e.Coating).HasColumnType("varchar(50)");

                entity.Property(e => e.CountryofOrigin).HasColumnType("varchar(50)");

                entity.Property(e => e.Edge).HasColumnType("varchar(50)");

                entity.Property(e => e.EmbossingType).HasColumnType("varchar(50)");

                entity.Property(e => e.FactorFilmNo).HasColumnType("varchar(50)");

                entity.Property(e => e.Finish).HasColumnType("varchar(50)");

                entity.Property(e => e.FinishStyle).HasColumnType("varchar(50)");

                entity.Property(e => e.GlossLevel).HasColumnType("varchar(50)");

                entity.Property(e => e.Grade).HasColumnType("varchar(50)");

                entity.Property(e => e.Material).HasColumnType("varchar(50)");

                entity.Property(e => e.MillColor).HasColumnType("varchar(50)");

                entity.Property(e => e.MillName).HasColumnType("varchar(50)");

                entity.Property(e => e.MillPatternNo).HasColumnType("varchar(50)");

                entity.Property(e => e.PalletDimensions).HasColumnType("varchar(50)");

                entity.Property(e => e.ProductNo)
                    .HasColumnName("ProductNo:")
                    .HasMaxLength(50);

                entity.Property(e => e.Qrcode)
                    .HasColumnName("QRCode")
                    .HasColumnType("varchar(50)");

                entity.Property(e => e.SizeIn).HasColumnName("SizeIN");

                entity.Property(e => e.SizeMm).HasColumnName("SizeMM");

                entity.Property(e => e.SkuNumbers).HasColumnType("varchar(max)");

                entity.Property(e => e.Species).HasColumnType("varchar(50)");

                entity.Property(e => e.SqMcarton).HasColumnName("SqMCarton");

                entity.Property(e => e.Warranty).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<StrapSet>(entity =>
            {
                entity.Property(e => e.Description).HasColumnType("nchar(10)");

                entity.Property(e => e.Label).HasColumnType("varchar(50)");

                entity.Property(e => e.LabelSize).HasColumnType("varchar(50)");

                entity.Property(e => e.Quantity).HasColumnType("nchar(10)");

                entity.Property(e => e.Size).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<StrapSetDescription>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<StrapsetLabel>(entity =>
            {
                entity.Property(e => e.Name).HasColumnType("varchar(50)");
            });

            modelBuilder.Entity<Website>(entity =>
            {
                entity.Property(e => e.Description).HasColumnType("nchar(10)");

                entity.Property(e => e.Type).HasColumnType("varchar(max)");
            });
        }
    }
}