namespace CAPI.Custom.Entities
{
	using System;
	using System.ComponentModel.DataAnnotations;
	using System.ComponentModel.DataAnnotations.Schema;

    [Table("publ_SupplierPricelistParts")]
    public class SupplierPricelistPart : ISupplierPricelistPart
    {
        protected string _alternateNumbers = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsAlternateNumbers")]
        public string AlternateNumbers
        {
            get { return _alternateNumbers.ToUpperNonEmpty(); }
            set { _alternateNumbers = value.ToUpperNonEmpty(); }
        }

        protected string _partNumber = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsPartNumber")]
        public string PartNumber
        {
            get { return _partNumber.ToUpperNonEmpty(); }
            set { _partNumber = value.ToUpperNonEmpty(); }
        }

        [Column("isActive")]
        public bool? isActive { get; set; }

        [Column("itemID")]
        public int itemID { get; set; }

        [Column("ParentSurfaceItemId")]
        public int? ParentSurfaceItemId { get; set; }

        [Key]
        [Column("recId")]
        public int recId { get; set; }

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsAdditionalDescription")]
        public string AdditionalDescription { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsAvailability")]
        public int? Availability { get; set; } = 0;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsBrand")]
        public string Brand { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsCondition")]
        public string Condition { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsCurrency")]
        public string Currency { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsDescription")]
        public string Description { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsExpiryDate")]
        public string ExpiryDate { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsLastUpdatedBy")]
        public string LastUpdatedBy { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsLastUpdatedOn")]
        public string LastUpdatedOn { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsLeadTime")]
        public string LeadTime { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsNote")]
        public string Note { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsPricelistStatus")]
        public string PricelistStatus { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsSalesPrice")]
        public decimal? SalesPrice { get; set; } = 0m;

        [Column("SupplierPricelistParts_SupplierPricelistParts_SupplierPricelistPartsSupplierName")]
        public string SupplierName { get; set; } = string.Empty;

        [Column("SupplierPricelistParts_SupplierPricelistParts_WeightKG")]
        public decimal? WeightKG { get; set; } = 0m;

        [Column("SupplierPricelistParts_SupplierPricelistParts_WeightLBS")]
        public decimal? WeightLBS { get; set; } = 0m;

        [Column("surfaceId")]
        public int surfaceId { get; set; }
    }
}