using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Text.Json.Serialization;
using vendorApproverBackend.Enums;
using System.Text.Json.Serialization;

namespace vendorApproverBackend.Entities
{
    [Table("certifications")]
    public class Certification
    {
        [Column("id")]
        public long Id { get; set; }

        [Column("certification_number")]
        public string CertificationNumber { get; set; }

        [Column("supplier_name")]
        public string SupplierName { get; set; }

        [Column("supplier_id")]
        public long SupplierId { get; set; }

        [Column("certification_type")]
        public string CertificationType { get; set; }

        [Column("issue_date")]
        public DateTime IssueDate { get; set; }

        [Column("expiry_date")]
        public DateTime ExpiryDate { get; set; }

        [Column("status")]
        public CertificationStatus Status { get; set; }

        [Column("verified_by_user_id")]
        public long VerifiedById { get; set; }
        public virtual User VerifiedBy { get; set; }

        [Column("prequalification_request_id")]
        public long PrequalificationRequestId { get; set; }
        
        public PrequalificationRequest PrequalificationRequest { get; set; }

        [Column("timestmp")]
        public DateTime Timestamp { get; set; } = DateTime.UtcNow;

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

         [JsonIgnore]
        public virtual ICollection<RequestRenew> RequestRenews { get; set; } = new List<RequestRenew>();
    }
}