using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.ModelConfiguration;

namespace IntegrationTests.Models.Mapping
{
    public class SC_TotalSeatsAcrossExpCatsMap : EntityTypeConfiguration<SC_TotalSeatsAcrossExpCats>
    {
        public SC_TotalSeatsAcrossExpCatsMap()
        {
            // Primary Key
            this.HasKey(t => new { t.ScenarioType, t.ScenarioName, t.ShowObjectID, t.ShowName, t.ShowTypeObjectID, t.ShowStatusObjectID, t.Probability, t.ExpenditureCatObjectID });

            // Properties
            this.Property(t => t.CGEFX)
                .IsFixedLength()
                .HasMaxLength(10);

            this.Property(t => t.ScenarioType)
                .HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);

            this.Property(t => t.ScenarioName)
                .IsRequired()
                .HasMaxLength(200);

            this.Property(t => t.ShowName)
                .IsRequired()
                .HasMaxLength(200);

            this.Property(t => t.ShowStatusName)
                .HasMaxLength(200);

            this.Property(t => t.Probability)
                .HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);

            this.Property(t => t.ShowColor)
                .HasMaxLength(16);

            this.Property(t => t.ScenarioColor)
                .HasMaxLength(16);

            // Table & Column Mappings
            this.ToTable("SC_TotalSeatsAcrossExpCats");
            this.Property(t => t.ScenarioObjectID).HasColumnName("ScenarioObjectID");
            this.Property(t => t.WeekEndingDate).HasColumnName("WeekEndingDate");
            this.Property(t => t.Quantity).HasColumnName("Quantity");
            this.Property(t => t.Cost).HasColumnName("Cost");
            this.Property(t => t.CGEFX).HasColumnName("CGEFX");
            this.Property(t => t.ScenarioType).HasColumnName("ScenarioType");
            this.Property(t => t.ScenarioName).HasColumnName("ScenarioName");
            this.Property(t => t.ShowObjectID).HasColumnName("ShowObjectID");
            this.Property(t => t.ShowName).HasColumnName("ShowName");
            this.Property(t => t.ShowTypeObjectID).HasColumnName("ShowTypeObjectID");
            this.Property(t => t.ShowStatusObjectID).HasColumnName("ShowStatusObjectID");
            this.Property(t => t.ShowStatusName).HasColumnName("ShowStatusName");
            this.Property(t => t.Probability).HasColumnName("Probability");
            this.Property(t => t.ShowColor).HasColumnName("ShowColor");
            this.Property(t => t.ScenarioColor).HasColumnName("ScenarioColor");
            this.Property(t => t.ExpenditureCatObjectID).HasColumnName("ExpenditureCatObjectID");
            this.Property(t => t.Status).HasColumnName("Status");
            this.Property(t => t.SystemAttributeObjectID).HasColumnName("SystemAttributeObjectID");
            this.Property(t => t.GroupId).HasColumnName("GroupId");
            this.Property(t => t.SystemAttributeOne).HasColumnName("SystemAttributeOne");
            this.Property(t => t.SystemAttributeTwo).HasColumnName("SystemAttributeTwo");
        }
    }
}