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

namespace vendorApproverBackend.Entities;

public class User
{

    [Column("user_id")]
    public long Id { get; set; }

    [JsonIgnore]
    [Column("user_name")]
    public string Username { get; set; }

    [Column("email")]
    public string Email { get; set; }

    [JsonIgnore]
    [Column("password")]
    public string Password { get; set; }

    [Column("name")]
    public string Name { get; set; } = "";

    [Column("gender")]
    public Gendre? Gendre { get; set; }

    [Column("phone_number")]
    public string? PhoneNumber { get; set; }

    [Column("city")]
    public string? City { get; set; }

    [Column("country")]
    public string? Country { get; set; }

    [Column("code")]
    public string? Code { get; set; }

    [Column("departement")]
    public string? Departement { get; set; }

    [Column("job_title")]
    public string? JobTitle { get; set; }

    [Column("position")]
    public string? Position { get; set; }

    [Column("active")]
    public bool Active { get; set; } = false;

    [Column("Status")]
    public bool Status { get; set; } = false;

    [Column("deleted")]
    public bool Deleted { get; set; } = false;

    [Column("start_date")]
    public DateTime StartDate { get; set; }

    [Column("role")]
    public RoleEnum Role { get; set; }

    [Column("type")]
    public EmployeeTypeEnum? Type { get; set; }

    /* [Column("Category")]
    public EmployeeCategory Category { get; set; } */


    [JsonIgnore]
    public UserDevice? Device { get; set; }

    [JsonIgnore]
    public ICollection<EmployeeApplication> EmployeeApplications { get; set; } = new List<EmployeeApplication>();

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


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

    [JsonIgnore]
    [Column("otp")]
    public string? LastOtp { get; set; }

    [JsonIgnore]
    [Column("pass_otp")]
    public string? PassOtp { get; set; }

    [Column("otp_created_at")]
    public DateTime? OtpCreatedAt { get; set; }


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

    /*  [Column("evaluation_pq_id")]
     public long? EvaluationPqId { get; set; } */

    [Column("requests_evaluation_ids")]
    public List<long>? RequestsEvaluationIds { get; set; } = new List<long>();


    [Column("inspection_pq_id")]
    public long? InspectionPqId { get; set; }


    public FileModel? Image { get; set; }

    public Vendor? Vendor { get; set; }
    [JsonIgnore]
    public virtual ICollection<AssessmentReport> CreatedAssessmentReports { get; set; } = new List<AssessmentReport>();

    public ICollection<ApplicationCategory> Categories { get; set; } = new List<ApplicationCategory>();

    public ICollection<Degree> Degrees { get; set; } = new List<Degree>();
    public ICollection<WorkExperience> WorkExperiences { get; set; } = new List<WorkExperience>();
    public ICollection<EmployeeCertification> Certifications { get; set; } = new List<EmployeeCertification>();


    [Column("device_ids")]
    public List<string> DeviceIds { get; set; } = new List<string>();

}