using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace CAPI.Custom.Entities
{
    [Table("publ_InventoryItems")]
    public class InventoryItem : ISurfacePublishedEntity, ISurfaceChildEntity
    {
        // Sould always be uppercase
        protected string _partNumber = string.Empty;

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

        protected string _uniqueNumber = string.Empty;

        [Column("InventoryItemPartDetails_InventoryItemPartDetails_InventoryItemsUniqueNumber")]
        public string UniqueNumber
        {
            get { return _uniqueNumber.ToUpperNonEmpty(); }
            set { _uniqueNumber = value.ToUpperNonEmpty(); }
        }

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

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

        /// <summary>
        /// Links to PartsMaster
        /// </summary>
        [Column("ParentSurfaceItemId")]
        public int? ParentSurfaceItemId { get; set; } = 0;

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

        [Column("InventoryItemPartDetails_InventoryItemPartDetails_InventoryItemSafetyStock")]
        public decimal? SafetyStock { get; set; } = 0;

        [Column("InventoryItemPartDetails_InventoryItemPartDetails_InventoryItemAverageCost")]
        public decimal? AverageCost { get; set; } = 0;

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

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

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

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

        

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

        [Column("InventoryItemPartDetails_InventoryItemPartDetails_InventoryItemReviewCycledays")]
        public int? ReviewCycledays { get; set; } = 14;

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

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

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

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

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

        [Column("InventoryItemPartDetails_InventoryItemPartDetails_InventoryItemTotalValue")]
        public decimal? TotalValue { get; set; } = 0;

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

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

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

        #region Unused Columns

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemAverageCost")]
        //public decimal? InventoryDetails_AverageCost { get; set; } = 0;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemDescription")]
        //public string InventoryDetails_Description { get; set; } = string.Empty;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemPartNumber")]
        //public string InventoryDetails_PartNumber { get; set; } = string.Empty;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemReorderQuantity")]
        //public int? InventoryDetails_ReorderQuantity { get; set; } = 0;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemTotalAvailable")]
        //public int? InventoryDetails_TotalAvailable { get; set; } = 0;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemTotalCommitted")]
        //public int? InventoryDetails_TotalCommitted { get; set; } = 0;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemTotalOnHand")]
        //public int? InventoryDetails_TotalOnHand { get; set; } = 0;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemTotalOnOrder")]
        //public int? InventoryDetails_TotalOnOrder { get; set; } = 0;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemTotalValue")]
        //public decimal? InventoryDetails_TotalValue { get; set; } = 0;

        //[Column("InventoryItemInventoryDetails_InventoryItemInventoryDetails_InventoryItemUniqueNumber")]
        //public string InventoryDetails_UniqueNumber { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemItemDetails_InventoryItemsBarcode")]
        //public string ItemDetails_Barcode { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemItemDetails_InventoryItemsBrand")]
        //public string ItemDetails_Brand { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemItemDetails_InventoryItemsCondition")]
        //public string ItemDetails_Condition { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemItemDetails_SlowMoving")]
        //public bool? ItemDetails_SlowMoving { get; set; } = false;

        //[Column("InventoryItems_InventoryItemMasterPartDetails_InventoryItemsAdditionalDescription")]
        //public string MasterPartDetails_AdditionalDescription { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsAlternatePartNumber")]
        //public string MasterPartDetails_AlternatePartNumber { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsCategory")]
        //public string MasterPartDetails_Category { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsCategoryCustomerMargin")]
        //public decimal? MasterPartDetails_CategoryCustomerMargin { get; set; } = 0;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsCategoryMargin")]
        //public decimal? MasterPartDetails_CategoryMargin { get; set; } = 0;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsCEPNumber")]
        //public string MasterPartDetails_CEPNumber { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsDescription")]
        //public string MasterPartDetails_Description { get; set; } = string.Empty;

        //[Column("InventoryItems_InventoryItemMasterPartDetails_InventoryItemsDimensionalDescription")]
        //public string MasterPartDetails_DimensionalDescription { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsItemVetted")]
        //public string MasterPartDetails_ItemVetted { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsItemVettedBy")]
        //public string MasterPartDetails_ItemVettedBy { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsMachine")]
        //public string MasterPartDetails_Machine { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsMinorCode")]
        //public string MasterPartDetails_MinorCode { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_PartsMasterPartNumber")]
        //public string MasterPartDetails_PartsMasterPartNumber { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsPreferredSupplier")]
        //public string MasterPartDetails_PreferredSupplier { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsSalesMultiples")]
        //public string MasterPartDetails_SalesMultiples { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsSubcategory")]
        //public string MasterPartDetails_Subcategory { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsSubcategoryCustomerMargin")]
        //public decimal? MasterPartDetails_SubcategoryCustomerMargin { get; set; } = 0;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsSubcategoryMargin")]
        //public decimal? MasterPartDetails_SubcategoryMargin { get; set; } = 0;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsTopSpendSupplier")]
        //public string MasterPartDetails_TopSpendSupplier { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemType")]
        //public int? MasterPartDetails_Type { get; set; } = 0;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsUniqueNumber")]
        //public string MasterPartDetails_UniqueNumber { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsWeightKG")]
        //public string MasterPartDetails_WeightKG { get; set; } = string.Empty;

        //[Column("InventoryItemPartDetails_InventoryItemMasterPartDetails_InventoryItemsWeightLBS")]
        //public string MasterPartDetails_WeightLBS { get; set; } = string.Empty;

        //[Column("InventoryItemProductImages_InventoryItemProductImages_ProductImages")]
        //public string ProductImages_ProductImages { get; set; } = string.Empty;

        #endregion
    }
}