using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.Spatial;

namespace OSS.Models
{
    public class ProjectProfile
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public long ProjectID { get; set; }
        public string ProjectCode { get; set; }
        [Required]
        public string ProjectName { get; set; }
        [Required]
        public string CompanyTIN { get; set; }
        [Required]
        public string RegionName { get; set; }

        public string WardName { get; set; }

        public string AreaType { get; set; }
        public string Unsurveyedaddress { get; set; }
        public string HouseNo { get; set; }
        public string Road { get; set; }
        public string LoanConditions { get; set; }
        [Required]
        public string Location { get; set; }
        public string CompanyName { get; set; }
        public string ZonalName { get; set; }
        [Required]
        public string DistrictName { get; set; }

        public string ExpansionNo { get; set; }
        public string OriginalCOI { get; set; }

        public string SerialNumber { get; set; }
        public double? TotalCapital { get; set; }
        public long Jobs { get; set; }
        [Required]
        public long MenLocal { get; set; }
        [Required]
        public long TotalEmploymentLocal { get; set; }
        [Required]
        public long TotalEmploymentForeign { get; set; }
        [Required]
        public long WomenLocal { get; set; }
        [Required]
        public long MenForeign { get; set; }
        [Required]
        public long WomenForeign { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime ApprovedDate { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime LastExpansionDate { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime PaymentDate { get; set; }
        [Column(TypeName = "datetime2")]
        [Required]
        public DateTime LodgedDate { get; set; }
        [StringLength(255)]
        [Required]
        public string TypeofApplication { get; set; }
        [Required]
        public string Email { get; set; }
        public float? latitude { get; set; }
        public float? longitude { get; set; }
        [Required]
        public string ProcessingStatus { get; set; }
        public string CurrentlyWith { get; set; }
        public string ApprovedStatus { get; set; }
        public string ApprovedBy { get; set; }
        [DataType(DataType.PhoneNumber)]
        [Required]
        public string Telephone { get; set; }
        public string Address { get; set; }
        [DataType(DataType.PhoneNumber)]
        [Required]
        public string Mobile { get; set; }
        public string SectorIcon { get; set; }
        [StringLength(255)]

        public string BlockNumber { get; set; }
        [StringLength(255)]

        public string PlotNumber { get; set; }
        [StringLength(255)]
        [Required]
        public string PhysicalAddress { get; set; }
        [StringLength(255)]
        [Required]
        public string SubSector { get; set; }
        [StringLength(255)]
        [Required]
        public string Street { get; set; }
        [StringLength(255)]
        [Required]
        public string ProductionCapacity { get; set; }
        [Required]
        [StringLength(255)]
        public string Sector { get; set; }
        [StringLength(255)]
        [Required]
        public string ContactPerson { get; set; }
        [StringLength(255)]
        [Required]
        public string Position { get; set; }

        public string AmendmentSection { get; set; }

        [Required]
        public string MajorityShare { get; set; }
        public string StrategicInvestor { get; set; }
        public string CleaningStatus { get; set; }

        public string PrintingStatus { get; set; }
        public string PrintingStatusAmendment { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime PrintedDate { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime PrintedDateAmendment { get; set; }
        public string AmendmentStatus { get; set; }
        public string Conditions { get; set; }
        public string PrintedBy { get; set; }
        public string PrintedByAmendment { get; set; }
        public string ReportingStatus { get; set; }
        public string PostalAddress { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime UpdatedDate { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime OperativeDate { get; set; }
        public string UpdatedBy { get; set; }
        public string VerifiedBy { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime VerifiedDate { get; set; }
        public string CleaningComment { get; set; }
        public string ReportingComent { get; set; }
        public string LandMarkType { get; set; }
        public string Area { get; set; }
        public string LandMarkDescription { get; set; }
        public string ReportingApprovedBy { get; set; }
        [Required]
        public string Activity { get; set; }
        [StringLength(255)]
        [Required]
        public string LodgedBy { get; set; }
        [Column(TypeName = "datetime2")]
        [Required]
        public DateTime ImplementationStartDate { get; set; }
        [Column(TypeName = "datetime2")]
        public DateTime ImplementationEndDate { get; set; }
        [StringLength(255)]

        public string CertificateOfIncentiveNo { get; set; }
        public string FileNo { get; set; }
        

    }
}