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

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


        [Column("sku")]
        public string? Sku { get; set; }
        [Column("category")]
        public string? Category { get; set; }
        [Column("sub_category")]
        public string? Subcategory { get; set; }
        [Column("product_name")]
        public string? ProductName { get; set; }
        [Column("product_city")]
        public string? ProductCity { get; set; }
        [Column("product_country")]
        public string? ProductCountry { get; set; }
        [Column("product_type")]
        public string? ProductType { get; set; }
        [Column("product_desc")]


        public string? ProductDesc { get; set; }
        [Column("vendor_name")]
        public string? VendorName { get; set; }

        [Column("manufacturer")]
        public string? Manufacturer { get; set; }

        [Column("local_agent")]
        public string? LocalAgent { get; set; }

        [Column("approvalDate")]
        public DateTime? ApprovalDate { get; set; }

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

         [Column("firstapprovalDate")]
        public DateTime? FirstApprovalDate { get; set; }

        [Column("manufacturerEmail")]
        public string? ManufacturerEmail { get; set; }

        [Column("localAgentEmail")]
        public string? LocalAgentEmail { get; set; }



        [Column("vendor_id")]
        public long? VendorId { get; set; }
        
        [Column("status")]
        public RequestStatus? Status { get; set; }


        [Column("timestmp")]
        public DateTime Timestamp { get; set; } = DateTime.UtcNow;
        
        [Column("prequalification_request_id")]
        public long? PrequalificationRequestId { get; set; }
        
        [JsonIgnore] 
        public PrequalificationRequest PrequalificationRequest { get; set; }
        

    }
}