Untitled

using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace AIS.Data.Models
{
    public partial class OvertimeRequest
    {
        [Column("Overtime_Request_ID"), Key]
        public int OvertimeRequestID { get; set; }

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

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

        [Column("Reason", TypeName = "varchar"), StringLength(100)]
        public string Reason { get; set; }

        [Column("Pre_Shift_Datetime_From")]
        public DateTime? PreShiftDatetimeFrom { get; set; }

        [Column("Pre_Shift_Datetime_To")]
        public DateTime? PreShiftDatetimeTo { get; set; }

        [Column("Post_Shift_Datetime_From")]
        public DateTime? PostShiftDatetimeFrom { get; set; }

        [Column("Post_Shift_Datetime_To")]
        public DateTime? PostShiftDatetimeTo { get; set; }

        [Column("No_Of_Hours")]
        public float? NoOfHours { get; set; }

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

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

        [Column("Created_By")]
        public int? CreatedBy { get; set; }

        [Column("Date_Created")]
        public DateTime DateCreated { get; set; }

        [Column("Modified_By")]
        public int? ModifiedBy { get; set; }

        [Column("Date_Modified")]
        public DateTime? DateModified { get; set; }

        [ForeignKey("EmployeeID")]
        [JsonIgnore]
        public virtual Employee201 Employee { get; set; }

        [ForeignKey("OvertimeStatusID")]
        [JsonIgnore]
        public virtual Status OvertimeStatus { get; set; }

        [ForeignKey("CreatedBy")]
        [JsonIgnore]
        public virtual Employee201 CreatedByEmployee { get; set; }

        [ForeignKey("ModifiedBy")]
        [JsonIgnore]
        public virtual Employee201 ModifiedByEmployee { get; set; }

        [ForeignKey("CompanyID")]
        [JsonIgnore]
        public virtual Company Company { get; set; }

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

        [Column("Log_Shift_DateTime")]
        public DateTime? LogShiftDateTime { get; set; }

        public virtual ICollection<OvertimeRequestApprovers> OvertimeRequestApprovers { get; set; }

        public virtual string EmployeeName
        {
            get
            {
                return (Employee != null) ? string.Format(Constants.Common.NameFormat, Employee.LastName, Employee.FirstName, Employee.MiddleName.Substring(0, 1).ToUpper()) : string.Empty;
            }
        }

        public virtual string OvertimeStatusName
        {
            get
            {
                return (OvertimeStatus != null) ? OvertimeStatus.StatusName : string.Empty;
            }
        }
    }
}