// using System; using MTWorkHR.Infrastructure.DBContext; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace MTWorkHR.Infrastructure.Migrations { [DbContext(typeof(HRDataContext))] [Migration("20241210094124_alteContractfixedPay")] partial class alteContractfixedPay { /// protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "8.0.1") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("ApplicationRoleApplicationUser", b => { b.Property("UserRolesId") .HasColumnType("nvarchar(450)"); b.Property("UsersId") .HasColumnType("nvarchar(450)"); b.HasKey("UserRolesId", "UsersId"); b.HasIndex("UsersId"); b.ToTable("ApplicationRoleApplicationUser"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Attendance", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AttendanceDate") .HasColumnType("datetime2"); b.Property("CheckInTime") .HasColumnType("datetime2"); b.Property("CheckOutTime") .HasColumnType("datetime2"); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("LeaveReason") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("LeaveType") .HasColumnType("int"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserName") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.HasIndex("CompanyId"); b.ToTable("Attendances"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.AttendanceLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("AttendanceLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.AuthLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("AuthLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Base.AttachmentType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("IsRequired") .HasColumnType("bit"); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("AttachmentTypes"); b.HasData( new { Id = 1L, IsRequired = false, NameAr = "السيرة الذاتية", NameEn = "CV" }, new { Id = 2L, IsRequired = false, NameAr = "جواز السفر", NameEn = "Passport" }, new { Id = 3L, IsRequired = false, NameAr = "شهادة التعليم", NameEn = "Education Certification" }, new { Id = 4L, IsRequired = false, NameAr = "شهادة الخبرة", NameEn = "Experience Certification" }, new { Id = 5L, IsRequired = false, NameAr = "شهادة الاحتراف", NameEn = "Professional Certification" }, new { Id = 6L, IsRequired = false, NameAr = "التسجيل التجارى", NameEn = "Commercial Regestration" }, new { Id = 7L, IsRequired = false, NameAr = "البطاقة الضريبية", NameEn = "Tax Declaration" }, new { Id = 8L, IsRequired = false, NameAr = "الهوية", NameEn = "Identification" }, new { Id = 9L, IsRequired = false, NameAr = "الصورة", NameEn = "Image" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ChatAttachment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("ChatMessageId") .HasColumnType("bigint"); b.Property("ContentType") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("FileName") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("FilePath") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("FileType") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("ChatMessageId"); b.ToTable("ChatAttachment"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ChatMessage", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Content") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("IsSeen") .HasColumnType("bit"); b.Property("ReceiverId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ReceiverName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("SenderId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("SenderName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.ToTable("ChatMessages"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.City", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Code") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CountryId") .HasColumnType("bigint"); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameFr") .IsRequired() .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.HasIndex("CountryId"); b.ToTable("Cities"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Company", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Address") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CRNumber") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CityId") .HasColumnType("bigint"); b.Property("CompanyName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CountryId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("Email") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("PhoneNumber") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("TaxNumber") .HasColumnType("int"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.HasIndex("CityId"); b.HasIndex("CountryId"); b.ToTable("Companies"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Contract", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AcademicQualificationId") .HasColumnType("int"); b.Property("BillingCycle") .HasColumnType("int"); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CompanyRepresentativeId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ContractDurationId") .HasColumnType("int"); b.Property("ContractStatusId") .HasColumnType("int"); b.Property("ContractTypeId") .HasColumnType("int"); b.Property("ContractorTaxResidencyId") .HasColumnType("int"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("Currency") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("EndDailyWorkingHours") .HasColumnType("datetime2"); b.Property("EndDate") .HasColumnType("datetime2"); b.Property("FirstPatchAmount") .HasColumnType("decimal(18,2)"); b.Property("FirstPatchDateFrom") .HasColumnType("datetime2"); b.Property("FirstPatchDateTo") .HasColumnType("datetime2"); b.Property("IncludesAllAllowances") .HasColumnType("bit"); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("JobDescription") .HasColumnType("nvarchar(max)"); b.Property("JobId") .HasColumnType("int"); b.Property("JobNumber") .HasMaxLength(150) .HasColumnType("nvarchar(150)"); b.Property("JobTitleName") .HasColumnType("nvarchar(max)"); b.Property("LastPatchAmount") .HasColumnType("decimal(18,2)"); b.Property("LastPatchDateFrom") .HasColumnType("datetime2"); b.Property("LastPatchDateTo") .HasColumnType("datetime2"); b.Property("NoticePeriodBeforeTermination") .HasColumnType("int"); b.Property("Salary") .HasColumnType("decimal(18,2)"); b.Property("SpecializationId") .HasColumnType("int"); b.Property("StartDailyWorkingHours") .HasColumnType("datetime2"); b.Property("StartDate") .HasColumnType("datetime2"); b.Property("TrialPeriod") .HasColumnType("int"); b.Property("TypeOfWork") .HasColumnType("int"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("VacationDays") .HasColumnType("int"); b.Property("WhoCanTerminateContract") .HasColumnType("int"); b.Property("WhoCanTerminateContractInTrial") .HasColumnType("int"); b.Property("WorkCountryId") .HasColumnType("int"); b.Property("WorkStateId") .HasColumnType("int"); b.Property("WorkingDays") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("WorkingHours") .HasColumnType("int"); b.Property("WorkingHoursNum") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("CompanyId"); b.ToTable("Contracts"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ContractAllowance", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AllowanceDesc") .HasColumnType("nvarchar(max)"); b.Property("AllowanceType") .HasColumnType("bigint"); b.Property("ContractId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("EntitlementAmount") .HasColumnType("decimal(18,2)"); b.Property("EntitlementPercent") .HasColumnType("decimal(18,2)"); b.Property("PaymentType") .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("ContractId"); b.ToTable("ContractAllowance"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTask", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Amount") .HasColumnType("decimal(18,2)"); b.Property("ContractId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("ScopeOfWork") .HasColumnType("nvarchar(max)"); b.Property("StartDate") .HasColumnType("datetime2"); b.Property("Title") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("ContractId"); b.ToTable("ContractTask"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTaskAttachment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AttachmentTypeId") .HasColumnType("bigint"); b.Property("Content") .IsRequired() .HasColumnType("varbinary(max)"); b.Property("ContentType") .HasColumnType("nvarchar(max)"); b.Property("ContractTaskId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("FileName") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("FilePath") .HasColumnType("nvarchar(max)"); b.Property("OriginalName") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("AttachmentTypeId"); b.HasIndex("ContractTaskId"); b.ToTable("ContractTaskAttachment"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.CountryLookup", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Code") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameFr") .IsRequired() .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("CountryLookups"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.FileLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("FileLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.HubConnection", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("SignalrId") .HasColumnType("nvarchar(max)"); b.Property("TimeStamp") .HasColumnType("datetime2"); b.Property("UserId") .HasColumnType("nvarchar(max)"); b.Property("UserName") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("HubConnections"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Industry", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("Industries"); b.HasData( new { Id = 1L, NameAr = "صناعة الطيران والفضاء", NameEn = "Aerospace industry" }, new { Id = 2L, NameAr = "صناعة الزراعة", NameEn = "Agricultural industry" }, new { Id = 3L, NameAr = "صناعة السيارات", NameEn = "Automotive industry" }, new { Id = 4L, NameAr = "صناعة المعادن الأساسية", NameEn = "Basic metal" }, new { Id = 5L, NameAr = "صناعة الكيماويات", NameEn = "Chemical industry" }, new { Id = 6L, NameAr = "صناعة الحواسيب", NameEn = "Computer industry" }, new { Id = 7L, NameAr = "صناعة البناء", NameEn = "Construction industry" }, new { Id = 8L, NameAr = "صناعة الإبداعية", NameEn = "Creative industry" }, new { Id = 9L, NameAr = "صناعة الثقافة", NameEn = "Cultural industry" }, new { Id = 10L, NameAr = "صناعة الدفاع", NameEn = "Defense industry" }, new { Id = 11L, NameAr = "صناعة التعليم", NameEn = "Education industry" }, new { Id = 12L, NameAr = "صناعة الطاقة الكهربائية", NameEn = "Electric power" }, new { Id = 13L, NameAr = "صناعة الإلكترونيات", NameEn = "Electronics industry" }, new { Id = 14L, NameAr = "صناعة الطاقة", NameEn = "Energy industry" }, new { Id = 15L, NameAr = "صناعة الهندسة", NameEn = "Engineering industry" }, new { Id = 16L, NameAr = "صناعة الترفيه", NameEn = "Entertainment industry" }, new { Id = 17L, NameAr = "صناعة الزراعة", NameEn = "Farming industry" }, new { Id = 18L, NameAr = "صناعة الموضة", NameEn = "Fashion industry" }, new { Id = 19L, NameAr = "صناعة السينما", NameEn = "Film industry" }, new { Id = 20L, NameAr = "صناعة الخدمات المالية", NameEn = "Financial services" }, new { Id = 21L, NameAr = "صناعة الصيد", NameEn = "Fishing industry" }, new { Id = 22L, NameAr = "صناعة الأغذية", NameEn = "Food industry" }, new { Id = 23L, NameAr = "صناعة الغابات", NameEn = "Forestry industry" }, new { Id = 24L, NameAr = "صناعة القمار", NameEn = "Gambling industry" }, new { Id = 25L, NameAr = "صناعة الغاز", NameEn = "Gas industry" }, new { Id = 26L, NameAr = "صناعة البيئة", NameEn = "Green industry" }, new { Id = 27L, NameAr = "صناعة الخدمات الصحية", NameEn = "Health services industry" }, new { Id = 28L, NameAr = "صناعة الضيافة", NameEn = "Hospitality industry" }, new { Id = 29L, NameAr = "صناعة الفنادق", NameEn = "Hotels industry" }, new { Id = 30L, NameAr = "صناعة الروبوتات الصناعية", NameEn = "Industrial robot" }, new { Id = 31L, NameAr = "صناعة المعلومات", NameEn = "Information industry" }, new { Id = 32L, NameAr = "صناعة تكنولوجيا المعلومات", NameEn = "Information technology" }, new { Id = 33L, NameAr = "صناعة البنية التحتية", NameEn = "Infrastructure industry" }, new { Id = 34L, NameAr = "صناعة التأمين", NameEn = "Insurance industry" }, new { Id = 35L, NameAr = "صناعة الترفيه", NameEn = "Leisure industry" }, new { Id = 36L, NameAr = "صناعة التكنولوجيا المنخفضة", NameEn = "Low technology" }, new { Id = 37L, NameAr = "صناعة التصنيع", NameEn = "Manufacturing industry" }, new { Id = 38L, NameAr = "صناعة اللحوم", NameEn = "Meat industry" }, new { Id = 39L, NameAr = "صناعة الإعلام", NameEn = "Media industry" }, new { Id = 40L, NameAr = "صناعة التجارة", NameEn = "Merchandising industry" }, new { Id = 41L, NameAr = "صناعة التعدين", NameEn = "Mining industry" }, new { Id = 42L, NameAr = "صناعة الموسيقى", NameEn = "Music industry" }, new { Id = 43L, NameAr = "صناعة وسائل الإعلام", NameEn = "News media" }, new { Id = 44L, NameAr = "صناعة النفط والغاز", NameEn = "Oil and gas industry" }, new { Id = 45L, NameAr = "صناعة الأدوية", NameEn = "Pharmaceutical industry" }, new { Id = 46L, NameAr = "صناعة المهنية", NameEn = "Professional industry" }, new { Id = 47L, NameAr = "صناعة النشر", NameEn = "Publishing industry" }, new { Id = 48L, NameAr = "صناعة الورق واللب", NameEn = "Pulp and paper industry" }, new { Id = 49L, NameAr = "صناعة السكك الحديدية", NameEn = "Railway industry" }, new { Id = 50L, NameAr = "الانشاءات", NameEn = "Real estate" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.JobTitle", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("JobTitles"); b.HasData( new { Id = 1L, NameAr = "مساعد ادارى", NameEn = "Administrative Assistant" }, new { Id = 2L, NameAr = "موظف استقبال", NameEn = "Receptionist" }, new { Id = 3L, NameAr = "مدير مكتب", NameEn = "Office Manager" }, new { Id = 4L, NameAr = "مدقق محتوى", NameEn = "Auditing Clerk" }, new { Id = 5L, NameAr = "محاسب", NameEn = "Bookkeeper" }, new { Id = 6L, NameAr = "مدير تنفيذى", NameEn = "Account Executive" }, new { Id = 7L, NameAr = "مدير فرع", NameEn = "Branch Manager" }, new { Id = 8L, NameAr = "مدير", NameEn = "Business Manager" }, new { Id = 9L, NameAr = "مسؤول الجودة", NameEn = "Quality Control Coordinator" }, new { Id = 10L, NameAr = "مدير ادارى", NameEn = "Administrative Manager" }, new { Id = 11L, NameAr = "الرئيس التنفيذي", NameEn = "Chief Executive Officer" }, new { Id = 12L, NameAr = "محلل", NameEn = "Business Analyst" }, new { Id = 13L, NameAr = "مدير المخاطر", NameEn = "Risk Manager" }, new { Id = 14L, NameAr = "موارد بشرية", NameEn = "Human Resources" }, new { Id = 15L, NameAr = "مساعد مكتب", NameEn = "Office Assistant" }, new { Id = 16L, NameAr = "السكرتارية", NameEn = "Secretary" }, new { Id = 17L, NameAr = "موظف مكتب", NameEn = "Office Clerk" }, new { Id = 18L, NameAr = "جامع الحسابات", NameEn = "Account Collector" }, new { Id = 19L, NameAr = "أخصائي إداري", NameEn = "Administrative Specialist" }, new { Id = 20L, NameAr = "مساعد تنفيذي", NameEn = "Executive Assistant" }, new { Id = 21L, NameAr = "مسؤل البرنامج", NameEn = "Program Administrator" }, new { Id = 22L, NameAr = "مدير البرنامج", NameEn = "Program Manager" }, new { Id = 23L, NameAr = "محلل إداري", NameEn = "Administrative Analyst" }, new { Id = 24L, NameAr = "مدخل بيانات", NameEn = "Data Entry" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.LeaveType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("DefaultDays") .HasColumnType("int"); b.Property("NameAr") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("NameEn") .IsRequired() .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("LeaveTypes"); b.HasData( new { Id = 1L, DefaultDays = 21, NameAr = "أجازة سنوية", NameEn = "Annual Leave" }, new { Id = 2L, DefaultDays = 15, NameAr = "أجازة مرضية", NameEn = "Sick Leave" }, new { Id = 3L, DefaultDays = 20, NameAr = "أجازة زواج", NameEn = "Marriage Leave" }, new { Id = 4L, DefaultDays = 10, NameAr = "أجازة وضع", NameEn = "Paternity leave" }, new { Id = 5L, DefaultDays = 10, NameAr = "أجازة طارئة", NameEn = "Emergency leave" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.LoginOTP", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("ExpireDate") .HasColumnType("datetime2"); b.Property("OTP") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("LoginOTPs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("Description") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("EndTime") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("Location") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("MeetingDate") .HasColumnType("datetime2"); b.Property("MeetingLink") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("RepeatId") .HasColumnType("int"); b.Property("StartTime") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("Title") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("CompanyId"); b.ToTable("Meetings"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("MeetingLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedUserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("AssignedUserName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("MeetingId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("MeetingId"); b.ToTable("MeetingUser"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Nationality", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CountryCode") .HasColumnType("nvarchar(max)"); b.Property("CountryId") .HasColumnType("nvarchar(max)"); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("Nationalities"); b.HasData( new { Id = 1L, CountryCode = "AF", NameAr = "أفغاني", NameEn = "Afghan" }, new { Id = 2L, CountryCode = "AL", NameAr = "ألباني", NameEn = "Albanian" }, new { Id = 3L, CountryCode = "DZ", NameAr = "جزائري", NameEn = "Algerian" }, new { Id = 4L, CountryCode = "AS", NameAr = "أمريكي ساموي", NameEn = "American Samoan" }, new { Id = 5L, CountryCode = "US", NameAr = "أمريكي", NameEn = "American" }, new { Id = 6L, CountryCode = "AD", NameAr = "أندوري", NameEn = "Andorran" }, new { Id = 7L, CountryCode = "AO", NameAr = "أنغولي", NameEn = "Angolan" }, new { Id = 8L, CountryCode = "AI", NameAr = "أنغويلي", NameEn = "Anguillian" }, new { Id = 9L, CountryCode = "AG", NameAr = "أنتيغي", NameEn = "Antiguan" }, new { Id = 10L, CountryCode = "AR", NameAr = "أرجنتيني", NameEn = "Argentinian" }, new { Id = 11L, CountryCode = "AM", NameAr = "أرميني", NameEn = "Armenian" }, new { Id = 12L, CountryCode = "AW", NameAr = "أروبي", NameEn = "Aruban" }, new { Id = 13L, CountryCode = "AU", NameAr = "أسترالي", NameEn = "Australian" }, new { Id = 14L, CountryCode = "AT", NameAr = "نمساوي", NameEn = "Austrian" }, new { Id = 15L, CountryCode = "AZ", NameAr = "أذربيجاني", NameEn = "Azerbaijani" }, new { Id = 16L, CountryCode = "BS", NameAr = "باهامي", NameEn = "Bahamian" }, new { Id = 17L, CountryCode = "BH", NameAr = "بحريني", NameEn = "Bahraini" }, new { Id = 18L, CountryCode = "BD", NameAr = "بنغلاديشي", NameEn = "Bangladeshi" }, new { Id = 19L, CountryCode = "BB", NameAr = "باربادوسي", NameEn = "Barbadian" }, new { Id = 20L, CountryCode = "BY", NameAr = "بيلاروسي", NameEn = "Belarusian" }, new { Id = 21L, CountryCode = "BE", NameAr = "بلجيكي", NameEn = "Belgian" }, new { Id = 22L, CountryCode = "BZ", NameAr = "بليزي", NameEn = "Belizean" }, new { Id = 23L, CountryCode = "BJ", NameAr = "بنيني", NameEn = "Beninese" }, new { Id = 24L, CountryCode = "BT", NameAr = "بوتاني", NameEn = "Bhutanese" }, new { Id = 25L, CountryCode = "BO", NameAr = "بوليفي", NameEn = "Bolivian" }, new { Id = 26L, CountryCode = "BA", NameAr = "بوسني", NameEn = "Bosnian" }, new { Id = 27L, CountryCode = "BR", NameAr = "برازيلي", NameEn = "Brazilian" }, new { Id = 28L, CountryCode = "GB", NameAr = "بريطاني", NameEn = "British" }, new { Id = 29L, CountryCode = "BN", NameAr = "بروني", NameEn = "Bruneian" }, new { Id = 30L, CountryCode = "BG", NameAr = "بلغاري", NameEn = "Bulgarian" }, new { Id = 31L, CountryCode = "BF", NameAr = "بوركيني", NameEn = "Burkinabe" }, new { Id = 32L, CountryCode = "MM", NameAr = "بورمي", NameEn = "Burmese" }, new { Id = 33L, CountryCode = "BI", NameAr = "بوروندي", NameEn = "Burundian" }, new { Id = 34L, CountryCode = "KH", NameAr = "كمبودي", NameEn = "Cambodian" }, new { Id = 35L, CountryCode = "CM", NameAr = "كاميروني", NameEn = "Cameroonian" }, new { Id = 36L, CountryCode = "CA", NameAr = "كندي", NameEn = "Canadian" }, new { Id = 37L, CountryCode = "CV", NameAr = "الرأس الأخضر", NameEn = "Cape Verdean" }, new { Id = 38L, CountryCode = "CF", NameAr = "أفريقي أوسط", NameEn = "Central African" }, new { Id = 39L, CountryCode = "TD", NameAr = "تشادي", NameEn = "Chadian" }, new { Id = 40L, CountryCode = "CL", NameAr = "تشيلي", NameEn = "Chilean" }, new { Id = 41L, CountryCode = "CN", NameAr = "صيني", NameEn = "Chinese" }, new { Id = 42L, CountryCode = "CO", NameAr = "كولومبي", NameEn = "Colombian" }, new { Id = 43L, CountryCode = "KM", NameAr = "قُمُري", NameEn = "Comorian" }, new { Id = 44L, CountryCode = "CG", NameAr = "كونغولي", NameEn = "Congolese" }, new { Id = 45L, CountryCode = "CR", NameAr = "كوستاريكي", NameEn = "Costa Rican" }, new { Id = 46L, CountryCode = "HR", NameAr = "كرواتي", NameEn = "Croatian" }, new { Id = 47L, CountryCode = "CU", NameAr = "كوبي", NameEn = "Cuban" }, new { Id = 48L, CountryCode = "CY", NameAr = "قبرصي", NameEn = "Cypriot" }, new { Id = 49L, CountryCode = "CZ", NameAr = "تشيكي", NameEn = "Czech" }, new { Id = 50L, CountryCode = "DK", NameAr = "دنماركي", NameEn = "Danish" }, new { Id = 51L, CountryCode = "DJ", NameAr = "جيبوتي", NameEn = "Djiboutian" }, new { Id = 52L, CountryCode = "DO", NameAr = "دومينيكاني", NameEn = "Dominican" }, new { Id = 53L, CountryCode = "NL", NameAr = "هولندي", NameEn = "Dutch" }, new { Id = 54L, CountryCode = "EC", NameAr = "إكوادوري", NameEn = "Ecuadorean" }, new { Id = 55L, CountryCode = "EG", NameAr = "مصري", NameEn = "Egyptian" }, new { Id = 56L, CountryCode = "AE", NameAr = "إماراتي", NameEn = "Emirati" }, new { Id = 57L, CountryCode = "GQ", NameAr = "غيني استوائي", NameEn = "Equatorial Guinean" }, new { Id = 58L, CountryCode = "ER", NameAr = "إريتيري", NameEn = "Eritrean" }, new { Id = 59L, CountryCode = "EE", NameAr = "إستوني", NameEn = "Estonian" }, new { Id = 60L, CountryCode = "ET", NameAr = "أثيوبي", NameEn = "Ethiopian" }, new { Id = 61L, CountryCode = "FJ", NameAr = "فيجي", NameEn = "Fijian" }, new { Id = 62L, CountryCode = "FI", NameAr = "فنلندي", NameEn = "Finnish" }, new { Id = 63L, CountryCode = "FR", NameAr = "فرنسي", NameEn = "French" }, new { Id = 64L, CountryCode = "GA", NameAr = "غابوني", NameEn = "Gabonese" }, new { Id = 65L, CountryCode = "GM", NameAr = "غامبي", NameEn = "Gambian" }, new { Id = 66L, CountryCode = "GE", NameAr = "جورجي", NameEn = "Georgian" }, new { Id = 67L, CountryCode = "DE", NameAr = "ألماني", NameEn = "German" }, new { Id = 68L, CountryCode = "GH", NameAr = "غاني", NameEn = "Ghanaian" }, new { Id = 69L, CountryCode = "GI", NameAr = "جبل طارق", NameEn = "Gibraltarian" }, new { Id = 70L, CountryCode = "GR", NameAr = "يوناني", NameEn = "Greek" }, new { Id = 71L, CountryCode = "GL", NameAr = "جرينلندي", NameEn = "Greenlandic" }, new { Id = 72L, CountryCode = "GD", NameAr = "غرينادي", NameEn = "Grenadian" }, new { Id = 73L, CountryCode = "GU", NameAr = "غوامي", NameEn = "Guamanian" }, new { Id = 74L, CountryCode = "GT", NameAr = "غواتيمالي", NameEn = "Guatemalan" }, new { Id = 75L, CountryCode = "GN", NameAr = "غيني", NameEn = "Guinean" }, new { Id = 76L, CountryCode = "GW", NameAr = "غيني", NameEn = "Guinean" }, new { Id = 77L, CountryCode = "GY", NameAr = "غياني", NameEn = "Guyanese" }, new { Id = 78L, CountryCode = "HT", NameAr = "هايتي", NameEn = "Haitian" }, new { Id = 79L, CountryCode = "HN", NameAr = "هندوراسي", NameEn = "Honduran" }, new { Id = 80L, CountryCode = "HK", NameAr = "هونغ كونغي", NameEn = "Hong Konger" }, new { Id = 81L, CountryCode = "HU", NameAr = "مجري", NameEn = "Hungarian" }, new { Id = 82L, CountryCode = "IS", NameAr = "آيسلندي", NameEn = "Icelander" }, new { Id = 83L, CountryCode = "IN", NameAr = "هندي", NameEn = "Indian" }, new { Id = 84L, CountryCode = "ID", NameAr = "إندونيسي", NameEn = "Indonesian" }, new { Id = 85L, CountryCode = "IR", NameAr = "إيراني", NameEn = "Iranian" }, new { Id = 86L, CountryCode = "IQ", NameAr = "عراقي", NameEn = "Iraqi" }, new { Id = 87L, CountryCode = "IE", NameAr = "إيرلندي", NameEn = "Irish" }, new { Id = 89L, CountryCode = "IT", NameAr = "إيطالي", NameEn = "Italian" }, new { Id = 90L, CountryCode = "JM", NameAr = "جامايكي", NameEn = "Jamaican" }, new { Id = 91L, CountryCode = "JP", NameAr = "ياباني", NameEn = "Japanese" }, new { Id = 92L, CountryCode = "JE", NameAr = "جيرسي", NameEn = "Jersey" }, new { Id = 93L, CountryCode = "JO", NameAr = "أردني", NameEn = "Jordanian" }, new { Id = 94L, CountryCode = "KZ", NameAr = "كازاخي", NameEn = "Kazakh" }, new { Id = 95L, CountryCode = "KE", NameAr = "كيني", NameEn = "Kenyan" }, new { Id = 96L, CountryCode = "KI", NameAr = "كيريباتي", NameEn = "Kiribati" }, new { Id = 97L, CountryCode = "KP", NameAr = "كوري شمالي", NameEn = "North Korean" }, new { Id = 98L, CountryCode = "KR", NameAr = "كوري جنوبي", NameEn = "South Korean" }, new { Id = 99L, CountryCode = "KW", NameAr = "كويتي", NameEn = "Kuwaiti" }, new { Id = 100L, CountryCode = "KG", NameAr = "قرغيزستاني", NameEn = "Kyrgyzstani" }, new { Id = 101L, CountryCode = "LA", NameAr = "لاوي", NameEn = "Lao" }, new { Id = 102L, CountryCode = "LV", NameAr = "لاتفي", NameEn = "Latvian" }, new { Id = 103L, CountryCode = "LB", NameAr = "لبناني", NameEn = "Lebanese" }, new { Id = 104L, CountryCode = "LS", NameAr = "ليسوتو", NameEn = "Lesotho" }, new { Id = 105L, CountryCode = "LR", NameAr = "ليبيريي", NameEn = "Liberian" }, new { Id = 106L, CountryCode = "LY", NameAr = "ليبي", NameEn = "Libyan" }, new { Id = 107L, CountryCode = "LI", NameAr = "ليختنشتايني", NameEn = "Liechtensteiner" }, new { Id = 108L, CountryCode = "LT", NameAr = "ليتواني", NameEn = "Lithuanian" }, new { Id = 109L, CountryCode = "LU", NameAr = "لوكسمبورغي", NameEn = "Luxembourgish" }, new { Id = 110L, CountryCode = "MG", NameAr = "ملغاشي", NameEn = "Malagasy" }, new { Id = 111L, CountryCode = "MW", NameAr = "ملووي", NameEn = "Malawian" }, new { Id = 112L, CountryCode = "MY", NameAr = "ماليزيا", NameEn = "Malaysian" }, new { Id = 113L, CountryCode = "MV", NameAr = "مالديفي", NameEn = "Maldivian" }, new { Id = 114L, CountryCode = "ML", NameAr = "مالي", NameEn = "Malian" }, new { Id = 115L, CountryCode = "MT", NameAr = "مالطي", NameEn = "Maltese" }, new { Id = 116L, CountryCode = "MH", NameAr = "مارشالي", NameEn = "Marshallese" }, new { Id = 117L, CountryCode = "MR", NameAr = "موريتاني", NameEn = "Mauritanian" }, new { Id = 118L, CountryCode = "MU", NameAr = "موريشيوسي", NameEn = "Mauritian" }, new { Id = 119L, CountryCode = "MX", NameAr = "مكسيكي", NameEn = "Mexican" }, new { Id = 120L, CountryCode = "FM", NameAr = "ماكروني", NameEn = "Micronesian" }, new { Id = 121L, CountryCode = "MD", NameAr = "مولدوفي", NameEn = "Moldovan" }, new { Id = 122L, CountryCode = "MC", NameAr = "موناكي", NameEn = "Monacan" }, new { Id = 123L, CountryCode = "MN", NameAr = "منغولي", NameEn = "Mongolian" }, new { Id = 124L, CountryCode = "ME", NameAr = "مونتينيغري", NameEn = "Montenegrin" }, new { Id = 125L, CountryCode = "MA", NameAr = "مغربي", NameEn = "Moroccan" }, new { Id = 126L, CountryCode = "MZ", NameAr = "موزمبيقي", NameEn = "Mozambican" }, new { Id = 127L, CountryCode = "NA", NameAr = "ناميبي", NameEn = "Namibian" }, new { Id = 128L, CountryCode = "NR", NameAr = "نيواروي", NameEn = "Nauruan" }, new { Id = 129L, CountryCode = "NP", NameAr = "نيبالي", NameEn = "Nepali" }, new { Id = 130L, CountryCode = "NL", NameAr = "هولندي", NameEn = "Dutch" }, new { Id = 131L, CountryCode = "NZ", NameAr = "نيوزيلندي", NameEn = "New Zealander" }, new { Id = 132L, CountryCode = "NI", NameAr = "نيكاراغوي", NameEn = "Nicaraguan" }, new { Id = 133L, CountryCode = "NE", NameAr = "نيجيري", NameEn = "Nigerien" }, new { Id = 134L, CountryCode = "NG", NameAr = "نيجيري", NameEn = "Nigerian" }, new { Id = 135L, CountryCode = "MK", NameAr = "مقدوني شمالي", NameEn = "North Macedonian" }, new { Id = 136L, CountryCode = "NO", NameAr = "نرويجي", NameEn = "Norwegian" }, new { Id = 137L, CountryCode = "OM", NameAr = "عماني", NameEn = "Omani" }, new { Id = 138L, CountryCode = "PK", NameAr = "باكستاني", NameEn = "Pakistani" }, new { Id = 139L, CountryCode = "PW", NameAr = "بالاوي", NameEn = "Palauan" }, new { Id = 140L, CountryCode = "PA", NameAr = "بنمي", NameEn = "Panamanian" }, new { Id = 141L, CountryCode = "PG", NameAr = "بابوا غينيا الجديدة", NameEn = "Papua New Guinean" }, new { Id = 142L, CountryCode = "PY", NameAr = "باراغواني", NameEn = "Paraguayan" }, new { Id = 143L, CountryCode = "PE", NameAr = "بيروفي", NameEn = "Peruvian" }, new { Id = 144L, CountryCode = "PH", NameAr = "فلبيني", NameEn = "Filipino" }, new { Id = 145L, CountryCode = "PL", NameAr = "بولندي", NameEn = "Polish" }, new { Id = 146L, CountryCode = "PT", NameAr = "برتغالي", NameEn = "Portuguese" }, new { Id = 147L, CountryCode = "QA", NameAr = "قطري", NameEn = "Qatari" }, new { Id = 148L, CountryCode = "RE", NameAr = "لا ريونيون", NameEn = "Réunionese" }, new { Id = 149L, CountryCode = "RO", NameAr = "روماني", NameEn = "Romanian" }, new { Id = 150L, CountryCode = "RU", NameAr = "روسي", NameEn = "Russian" }, new { Id = 151L, CountryCode = "RW", NameAr = "رواندي", NameEn = "Rwandan" }, new { Id = 152L, CountryCode = "BL", NameAr = "سانت بارتيليمي", NameEn = "Saint Barthélemy" }, new { Id = 153L, CountryCode = "SH", NameAr = "سانت هيلاني", NameEn = "Saint Helenian" }, new { Id = 154L, CountryCode = "KN", NameAr = "سانت كيتس ونيفيس", NameEn = "Saint Kitts and Nevis" }, new { Id = 155L, CountryCode = "LC", NameAr = "سانت لوسيان", NameEn = "Saint Lucian" }, new { Id = 156L, CountryCode = "MF", NameAr = "سانت مارتن", NameEn = "Saint Martin" }, new { Id = 157L, CountryCode = "SX", NameAr = "سانت مارتن", NameEn = "Sint Maarten" }, new { Id = 158L, CountryCode = "WS", NameAr = "سماوي", NameEn = "Samoan" }, new { Id = 159L, CountryCode = "SM", NameAr = "سانماريني", NameEn = "Sammarinese" }, new { Id = 160L, CountryCode = "ST", NameAr = "ساو توماني", NameEn = "Sao Tomean" }, new { Id = 161L, CountryCode = "SA", NameAr = "سعودي", NameEn = "Saudi" }, new { Id = 162L, CountryCode = "SN", NameAr = "سنغالي", NameEn = "Senegalese" }, new { Id = 163L, CountryCode = "RS", NameAr = "صربي", NameEn = "Serbian" }, new { Id = 164L, CountryCode = "SC", NameAr = "سيشلي", NameEn = "Seychellois" }, new { Id = 165L, CountryCode = "SL", NameAr = "سيراليوني", NameEn = "Sierra Leonean" }, new { Id = 166L, CountryCode = "SG", NameAr = "سنغافوري", NameEn = "Singaporean" }, new { Id = 167L, CountryCode = "SK", NameAr = "سلوفاكي", NameEn = "Slovak" }, new { Id = 168L, CountryCode = "SI", NameAr = "سلوفيني", NameEn = "Slovenian" }, new { Id = 169L, CountryCode = "SB", NameAr = "سولوموني", NameEn = "Solomon Islander" }, new { Id = 170L, CountryCode = "SO", NameAr = "صومالي", NameEn = "Somali" }, new { Id = 171L, CountryCode = "ZA", NameAr = "جنوب أفريقي", NameEn = "South African" }, new { Id = 172L, CountryCode = "SS", NameAr = "جنوب سوداني", NameEn = "South Sudanese" }, new { Id = 173L, CountryCode = "ES", NameAr = "إسباني", NameEn = "Spanish" }, new { Id = 174L, CountryCode = "LK", NameAr = "سريلانكي", NameEn = "Sri Lankan" }, new { Id = 175L, CountryCode = "SD", NameAr = "سوداني", NameEn = "Sudanese" }, new { Id = 176L, CountryCode = "SR", NameAr = "سورينامي", NameEn = "Surinamese" }, new { Id = 177L, CountryCode = "SZ", NameAr = "سواتي", NameEn = "Swazi" }, new { Id = 178L, CountryCode = "SE", NameAr = "سويدي", NameEn = "Swedish" }, new { Id = 179L, CountryCode = "CH", NameAr = "سويسري", NameEn = "Swiss" }, new { Id = 180L, CountryCode = "SY", NameAr = "سوري", NameEn = "Syrian" }, new { Id = 181L, CountryCode = "TW", NameAr = "تايواني", NameEn = "Taiwanese" }, new { Id = 182L, CountryCode = "TJ", NameAr = "طاجيكي", NameEn = "Tajik" }, new { Id = 183L, CountryCode = "TZ", NameAr = "تنزاني", NameEn = "Tanzanian" }, new { Id = 184L, CountryCode = "TH", NameAr = "تايلندي", NameEn = "Thai" }, new { Id = 185L, CountryCode = "TL", NameAr = "تيموري", NameEn = "Timorese" }, new { Id = 186L, CountryCode = "TG", NameAr = "توغولي", NameEn = "Togolese" }, new { Id = 187L, CountryCode = "TK", NameAr = "توكلاوي", NameEn = "Tokelauan" }, new { Id = 188L, CountryCode = "TO", NameAr = "تونغي", NameEn = "Tongan" }, new { Id = 189L, CountryCode = "TT", NameAr = "ترينيدادي", NameEn = "Trinidadian" }, new { Id = 190L, CountryCode = "TN", NameAr = "تونسي", NameEn = "Tunisian" }, new { Id = 191L, CountryCode = "TR", NameAr = "تركي", NameEn = "Turkish" }, new { Id = 192L, CountryCode = "TM", NameAr = "تركماني", NameEn = "Turkmen" }, new { Id = 193L, CountryCode = "TC", NameAr = "تركي وكايكوسي", NameEn = "Turks and Caicos Islander" }, new { Id = 194L, CountryCode = "TV", NameAr = "توفالي", NameEn = "Tuvaluan" }, new { Id = 195L, CountryCode = "UG", NameAr = "أوغندي", NameEn = "Ugandan" }, new { Id = 196L, CountryCode = "UA", NameAr = "أوكراني", NameEn = "Ukrainian" }, new { Id = 197L, CountryCode = "AE", NameAr = "إماراتي", NameEn = "Emirati" }, new { Id = 198L, CountryCode = "GB", NameAr = "بريطاني", NameEn = "British" }, new { Id = 199L, CountryCode = "US", NameAr = "أمريكي", NameEn = "American" }, new { Id = 200L, CountryCode = "UY", NameAr = "أوروغواي", NameEn = "Uruguayan" }, new { Id = 201L, CountryCode = "UZ", NameAr = "أوزبكي", NameEn = "Uzbek" }, new { Id = 202L, CountryCode = "VU", NameAr = "فانواتي", NameEn = "Vanuatuan" }, new { Id = 203L, CountryCode = "VE", NameAr = "فنزويلي", NameEn = "Venezuelan" }, new { Id = 204L, CountryCode = "VN", NameAr = "فيتنامي", NameEn = "Vietnamese" }, new { Id = 205L, CountryCode = "WF", NameAr = "واليس وفوتونا", NameEn = "Wallis and Futuna" }, new { Id = 206L, CountryCode = "YE", NameAr = "يمني", NameEn = "Yemeni" }, new { Id = 207L, CountryCode = "ZM", NameAr = "زامبي", NameEn = "Zambian" }, new { Id = 208L, CountryCode = "ZW", NameAr = "زيمبابوي", NameEn = "Zimbabwean" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.OrderAllocation", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("EmployeeId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("LeaveTypeId") .HasColumnType("bigint"); b.Property("NumberOfDays") .HasColumnType("int"); b.Property("OrderTypeId") .HasColumnType("bigint"); b.Property("Period") .HasColumnType("int"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("CompanyId"); b.HasIndex("LeaveTypeId"); b.HasIndex("OrderTypeId"); b.ToTable("OrderAllocations"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.OrderType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("DefaultDays") .HasColumnType("int"); b.Property("NameAr") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("NameEn") .IsRequired() .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("OrderTypes"); b.HasData( new { Id = 1L, DefaultDays = 2, NameAr = "إذن", NameEn = "Leave" }, new { Id = 2L, DefaultDays = 15, NameAr = "طبية", NameEn = "Medical" }, new { Id = 3L, DefaultDays = 20, NameAr = "وقت إضافي", NameEn = "Overtime" }, new { Id = 4L, DefaultDays = 0, NameAr = "رحلة عمل", NameEn = "Business trip" }, new { Id = 5L, DefaultDays = 0, NameAr = "دورة تدريبية", NameEn = "Course" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Permission", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CategoryName") .IsRequired() .HasMaxLength(150) .HasColumnType("nvarchar(150)"); b.Property("Desc") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("Name") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("Show") .HasColumnType("bit"); b.HasKey("Id"); b.ToTable("Permissions"); b.HasData( new { Id = 1L, CategoryName = "User", Desc = "Project", Name = "Project", Show = true }, new { Id = 2L, CategoryName = "User", Desc = "Project.Create", Name = "Project.Create", Show = false }, new { Id = 3L, CategoryName = "User", Desc = "Project.Update", Name = "Project.Update", Show = false }, new { Id = 4L, CategoryName = "User", Desc = "Project.Delete", Name = "Project.Delete", Show = false }, new { Id = 5L, CategoryName = "User", Desc = "Meeting", Name = "Meeting", Show = true }, new { Id = 6L, CategoryName = "User", Desc = "Meeting.Create", Name = "Meeting.Create", Show = false }, new { Id = 7L, CategoryName = "User", Desc = "Meeting.Update", Name = "Meeting.Update", Show = false }, new { Id = 8L, CategoryName = "User", Desc = "Meeting.Delete", Name = "Meeting.Delete", Show = false }, new { Id = 9L, CategoryName = "User", Desc = "Team", Name = "Team", Show = true }, new { Id = 10L, CategoryName = "User", Desc = "Team.Create", Name = "Team.Create", Show = false }, new { Id = 11L, CategoryName = "User", Desc = "Team.Update", Name = "Team.Update", Show = false }, new { Id = 12L, CategoryName = "User", Desc = "Team.Delete", Name = "Team.Delete", Show = false }, new { Id = 13L, CategoryName = "Sales", Desc = "UserTask", Name = "UserTask", Show = true }, new { Id = 14L, CategoryName = "Sales", Desc = "UserTask.Create", Name = "UserTask.Create", Show = false }, new { Id = 15L, CategoryName = "Sales", Desc = "UserTask.Update", Name = "UserTask.Update", Show = false }, new { Id = 16L, CategoryName = "User", Desc = "UserTask.Delete", Name = "UserTask.Delete", Show = false }, new { Id = 17L, CategoryName = "User", Desc = "Company", Name = "Company", Show = true }, new { Id = 18L, CategoryName = "User", Desc = "Company.Create", Name = "Company.Create", Show = false }, new { Id = 19L, CategoryName = "User", Desc = "Company.Update", Name = "Company.Update", Show = false }, new { Id = 20L, CategoryName = "User", Desc = "Company.Delete", Name = "Company.Delete", Show = false }, new { Id = 21L, CategoryName = "Adminstration", Desc = "User", Name = "User", Show = true }, new { Id = 22L, CategoryName = "Adminstration", Desc = "User.Create", Name = "User.Create", Show = false }, new { Id = 23L, CategoryName = "Adminstration", Desc = "User.Update", Name = "User.Update", Show = false }, new { Id = 24L, CategoryName = "Adminstration", Desc = "User.Delete", Name = "User.Delete", Show = false }, new { Id = 25L, CategoryName = "Adminstration", Desc = "Role", Name = "Role", Show = true }, new { Id = 26L, CategoryName = "Adminstration", Desc = "Role.Create", Name = "Role.Create", Show = false }, new { Id = 27L, CategoryName = "Adminstration", Desc = "Role.Update", Name = "Role.Update", Show = false }, new { Id = 28L, CategoryName = "Adminstration", Desc = "Role.Delete", Name = "Role.Delete", Show = false }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("Desc") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("CompanyId"); b.ToTable("Projects"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStage", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AmountPercent") .HasColumnType("decimal(18,2)"); b.Property("ContractId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("ExpectedEndDate") .HasColumnType("datetime2"); b.Property("ScopeOfWork") .HasColumnType("nvarchar(max)"); b.Property("StartDate") .HasColumnType("datetime2"); b.Property("Title") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("ContractId"); b.ToTable("ProjectStage"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStageAttachment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AttachmentTypeId") .HasColumnType("bigint"); b.Property("Content") .IsRequired() .HasColumnType("varbinary(max)"); b.Property("ContentType") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("FileName") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("FilePath") .HasColumnType("nvarchar(max)"); b.Property("OriginalName") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("ProjectStageId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("AttachmentTypeId"); b.HasIndex("ProjectStageId"); b.ToTable("ProjectStageAttachment"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectTeam", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("ProjectId") .HasColumnType("bigint"); b.Property("TeamId") .HasColumnType("bigint"); b.Property("TeamName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("ProjectId"); b.ToTable("ProjectTeam"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Qualification", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("Qualifications"); b.HasData( new { Id = 1L, NameAr = "بكالوريوس", NameEn = "BSC" }, new { Id = 2L, NameAr = "درجة الماجيستير", NameEn = "Master" }, new { Id = 3L, NameAr = "درحة الدكتوراه", NameEn = "Doctor" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.RoleLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("RoleLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.SettingLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("SettingLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.TaskUser", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedUserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("AssignedUserName") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("TaskId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("TaskId"); b.ToTable("TaskUser"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("CompanyId"); b.ToTable("Teams"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.TeamLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("TeamLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedUserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("AssignedUserName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("IsAdmin") .HasColumnType("bit"); b.Property("TeamId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("TeamId"); b.ToTable("TeamUser"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.University", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("Universities"); b.HasData( new { Id = 1L, NameAr = "جامعة الملك فهد", NameEn = "Fahd Univ" }, new { Id = 2L, NameAr = "جامعة الرياض", NameEn = "Riydh Univ" }, new { Id = 3L, NameAr = "جامعة جدة", NameEn = "Geda Univ" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.User.OrderRequest", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CityId") .HasColumnType("int"); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CountryId") .HasColumnType("int"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("EndDate") .HasColumnType("datetime2"); b.Property("EndTime") .HasColumnType("nvarchar(max)"); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("LeaveTypeId") .HasColumnType("bigint"); b.Property("OrderStatus") .HasColumnType("int"); b.Property("OrderTypeId") .HasColumnType("bigint"); b.Property("RequestComments") .HasColumnType("nvarchar(max)"); b.Property("RequestingEmployeeId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("StartDate") .HasColumnType("datetime2"); b.Property("StartTime") .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("CompanyId"); b.HasIndex("LeaveTypeId"); b.HasIndex("OrderTypeId"); b.ToTable("OrderRequests"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("UserLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedUserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("Description") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("DueDate") .HasColumnType("datetime2"); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("Priority") .HasColumnType("int"); b.Property("ProjectId") .HasColumnType("bigint"); b.Property("StatusId") .HasColumnType("bigint"); b.Property("Title") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("CompanyId"); b.HasIndex("ProjectId"); b.HasIndex("StatusId"); b.ToTable("UserTasks"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AttachmentTypeId") .HasColumnType("bigint"); b.Property("Content") .IsRequired() .HasColumnType("varbinary(max)"); b.Property("ContentType") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("FileName") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("FilePath") .HasColumnType("nvarchar(max)"); b.Property("OriginalName") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("TaskId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("AttachmentTypeId"); b.HasIndex("TaskId"); b.ToTable("UserTaskAttachments"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedToUserId") .HasColumnType("nvarchar(max)"); b.Property("Comment") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("CurrentStatusId") .HasColumnType("bigint"); b.Property("IsDeleted") .HasColumnType("bit"); b.Property("TaskId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("CurrentStatusId"); b.HasIndex("TaskId"); b.ToTable("UserTaskHistories"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("UserTaskLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskStatus", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("UserTaskStatuses"); b.HasData( new { Id = 1L, NameAr = "جديدة", NameEn = "To Do" }, new { Id = 2L, NameAr = "قيد العمل", NameEn = "In progress" }, new { Id = 3L, NameAr = "تحتاج مراجعة", NameEn = "Need Review" }, new { Id = 4L, NameAr = "تمت", NameEn = "Done" }); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b => { b.Property("Id") .HasColumnType("nvarchar(450)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .HasColumnType("nvarchar(max)"); b.Property("DeleteUserId") .HasColumnType("nvarchar(max)"); b.Property("IsAdmin") .HasColumnType("bit"); b.Property("IsDeleted") .HasColumnType("bit"); b.Property("Name") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("NormalizedName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("UpdateDate") .HasColumnType("datetime2"); b.Property("UpdateUser") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.HasIndex("NormalizedName") .IsUnique() .HasDatabaseName("RoleNameIndex") .HasFilter("[NormalizedName] IS NOT NULL"); b.ToTable("AspNetRoles", (string)null); b.HasData( new { Id = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A", CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), IsAdmin = true, IsDeleted = false, Name = "Admin", NormalizedName = "ADMIN" }, new { Id = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E", CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), IsAdmin = false, IsDeleted = false, Name = "Employee", NormalizedName = "EMPLOYEE" }, new { Id = "CO5B3B92-2311-48F8-9DEC-F9FAEF1F211R", CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), IsAdmin = false, IsDeleted = false, Name = "Contractor", NormalizedName = "CONTRACTOR" }, new { Id = "BS5B3B92-2311-48F8-9DEC-F9FAEF1F2110", CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), IsAdmin = false, IsDeleted = false, Name = "Business", NormalizedName = "BUSINESS" }); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b => { b.Property("Id") .HasColumnType("nvarchar(450)"); b.Property("AccessFailedCount") .HasColumnType("int"); b.Property("CompanyId") .HasColumnType("bigint"); b.Property("CompanyRepresentativeTitle") .HasColumnType("nvarchar(max)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasColumnType("nvarchar(max)"); b.Property("CountryId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .HasColumnType("nvarchar(max)"); b.Property("DateOfBirth") .HasColumnType("datetime2"); b.Property("DeleteUserId") .HasColumnType("nvarchar(max)"); b.Property("Email") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("EmailConfirmed") .HasColumnType("bit"); b.Property("FavoriteName") .HasColumnType("nvarchar(max)"); b.Property("FirstName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("IdNumber") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("IncomeTaxValue") .HasColumnType("decimal(18,2)"); b.Property("IndustryId") .HasColumnType("bigint"); b.Property("IsDeleted") .HasColumnType("bit"); b.Property("IsStopped") .HasColumnType("bit"); b.Property("JobTitleId") .HasColumnType("bigint"); b.Property("LastName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("LinkedInLink") .HasColumnType("nvarchar(max)"); b.Property("LockoutEnabled") .HasColumnType("bit"); b.Property("LockoutEnd") .HasColumnType("datetimeoffset"); b.Property("ManagerId") .HasColumnType("nvarchar(450)"); b.Property("NationalityId") .HasColumnType("bigint"); b.Property("NormalizedEmail") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("NormalizedUserName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("PassportExpiryDate") .HasColumnType("datetime2"); b.Property("PassportNumber") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("PasswordHash") .HasColumnType("nvarchar(max)"); b.Property("PhoneNumber") .HasColumnType("nvarchar(max)"); b.Property("PhoneNumberConfirmed") .HasColumnType("bit"); b.Property("Position") .HasColumnType("nvarchar(max)"); b.Property("QualificationId") .HasColumnType("bigint"); b.Property("SecurityStamp") .HasColumnType("nvarchar(max)"); b.Property("TaxNumber") .HasColumnType("decimal(18,2)"); b.Property("TwoFactorEnabled") .HasColumnType("bit"); b.Property("UniversityId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2"); b.Property("UpdateUser") .HasColumnType("nvarchar(max)"); b.Property("UserName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("UserType") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("CountryId"); b.HasIndex("IndustryId"); b.HasIndex("JobTitleId"); b.HasIndex("ManagerId"); b.HasIndex("NationalityId"); b.HasIndex("NormalizedEmail") .HasDatabaseName("EmailIndex"); b.HasIndex("NormalizedUserName") .IsUnique() .HasDatabaseName("UserNameIndex") .HasFilter("[NormalizedUserName] IS NOT NULL"); b.HasIndex("QualificationId"); b.HasIndex("UniversityId"); b.ToTable("AspNetUsers", (string)null); b.HasData( new { Id = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA", AccessFailedCount = 0, CompanyId = 1L, ConcurrencyStamp = "7cc87689-9eab-4280-b8e3-1834080783a5", DateOfBirth = new DateTime(2000, 2, 10, 0, 0, 0, 0, DateTimeKind.Unspecified), Email = "a@b.com", EmailConfirmed = true, FirstName = "Zinab", IdNumber = "123", IncomeTaxValue = 1m, IsDeleted = false, IsStopped = false, LastName = "Elgendy", LockoutEnabled = false, NormalizedEmail = "A@B.COM", NormalizedUserName = "A@B.COM", PassportNumber = "1234567", PasswordHash = "AQAAAAIAAYagAAAAEPg+ASbciPFxtyxQq8Wx5ilBUQ0RbAoITXXkOQm1PzC5BzySX0sn/wUmOjBKPDGV9w==", PhoneNumber = "1234567890", PhoneNumberConfirmed = true, SecurityStamp = "49bb16c3-4704-4c60-908d-dc8506950acc", TaxNumber = 111m, TwoFactorEnabled = false, UserName = "A@b.com", UserType = 1 }, new { Id = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB", AccessFailedCount = 0, CompanyId = 1L, ConcurrencyStamp = "4af7b4cf-802a-455b-b598-997e167745b3", DateOfBirth = new DateTime(2001, 5, 13, 0, 0, 0, 0, DateTimeKind.Unspecified), Email = "ali@b.com", EmailConfirmed = true, FirstName = "Ali", IdNumber = "343434", IncomeTaxValue = 100m, IsDeleted = false, IsStopped = false, LastName = "Farok", LockoutEnabled = false, NormalizedEmail = "ALI@B.COM", NormalizedUserName = "ALI@B.COM", PassportNumber = "7654321001010", PasswordHash = "AQAAAAIAAYagAAAAEI3QJkcZjCH4Y8Db4rEgL8Mmll5oCvYcWiXZjQSN9bGW4SMcjHe3ZPMnkN/l9DmJeQ==", PhoneNumber = "1234567888", PhoneNumberConfirmed = true, SecurityStamp = "62549056-1b9d-46d4-84f8-adea3e4d8b68", TaxNumber = 222m, TwoFactorEnabled = false, UserName = "Ali@b.com", UserType = 1 }); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("PermissionId") .HasColumnType("bigint"); b.Property("PermissionName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("RoleId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("PermissionId"); b.HasIndex("RoleId"); b.ToTable("RolePermissions"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAddress", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AddressDesc") .HasColumnType("nvarchar(max)"); b.Property("CityId") .HasColumnType("bigint"); b.Property("CountryId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("PostalCode") .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("CityId"); b.HasIndex("CountryId"); b.HasIndex("UserId") .IsUnique(); b.ToTable("UserAddress"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AttachmentTypeId") .HasColumnType("bigint"); b.Property("Content") .IsRequired() .HasColumnType("varbinary(max)"); b.Property("ContentType") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("FileName") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("FilePath") .HasColumnType("nvarchar(max)"); b.Property("OriginalName") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("AttachmentTypeId"); b.HasIndex("UserId"); b.ToTable("UserAttachments"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("ClaimType") .HasColumnType("nvarchar(max)"); b.Property("ClaimValue") .HasColumnType("nvarchar(max)"); b.Property("RoleId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("RoleId"); b.ToTable("AspNetRoleClaims", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("ClaimType") .HasColumnType("nvarchar(max)"); b.Property("ClaimValue") .HasColumnType("nvarchar(max)"); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("UserId"); b.ToTable("AspNetUserClaims", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b => { b.Property("LoginProvider") .HasColumnType("nvarchar(450)"); b.Property("ProviderKey") .HasColumnType("nvarchar(450)"); b.Property("ProviderDisplayName") .HasColumnType("nvarchar(max)"); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("LoginProvider", "ProviderKey"); b.HasIndex("UserId"); b.ToTable("AspNetUserLogins", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b => { b.Property("UserId") .HasColumnType("nvarchar(450)"); b.Property("RoleId") .HasColumnType("nvarchar(450)"); b.HasKey("UserId", "RoleId"); b.HasIndex("RoleId"); b.ToTable("AspNetUserRoles", (string)null); b.HasData( new { UserId = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA", RoleId = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A" }, new { UserId = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB", RoleId = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E" }); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b => { b.Property("UserId") .HasColumnType("nvarchar(450)"); b.Property("LoginProvider") .HasColumnType("nvarchar(450)"); b.Property("Name") .HasColumnType("nvarchar(450)"); b.Property("Value") .HasColumnType("nvarchar(max)"); b.HasKey("UserId", "LoginProvider", "Name"); b.ToTable("AspNetUserTokens", (string)null); }); modelBuilder.Entity("ApplicationRoleApplicationUser", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null) .WithMany() .HasForeignKey("UserRolesId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null) .WithMany() .HasForeignKey("UsersId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ChatAttachment", b => { b.HasOne("MTWorkHR.Core.Entities.ChatMessage", "ChatMessage") .WithMany("ChatAttachments") .HasForeignKey("ChatMessageId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("ChatMessage"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.City", b => { b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country") .WithMany() .HasForeignKey("CountryId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Country"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Company", b => { b.HasOne("MTWorkHR.Core.Entities.City", "City") .WithMany() .HasForeignKey("CityId"); b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country") .WithMany() .HasForeignKey("CountryId"); b.Navigation("City"); b.Navigation("Country"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ContractAllowance", b => { b.HasOne("MTWorkHR.Core.Entities.Contract", "Contract") .WithMany("FixedAllowances") .HasForeignKey("ContractId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Contract"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTask", b => { b.HasOne("MTWorkHR.Core.Entities.Contract", "Contract") .WithMany("ContractTasks") .HasForeignKey("ContractId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Contract"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTaskAttachment", b => { b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType") .WithMany() .HasForeignKey("AttachmentTypeId"); b.HasOne("MTWorkHR.Core.Entities.ContractTask", "ContractTask") .WithMany("TaskAttachments") .HasForeignKey("ContractTaskId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("AttachmentType"); b.Navigation("ContractTask"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b => { b.HasOne("MTWorkHR.Core.Entities.Meeting", "Meeting") .WithMany("MeetingUsers") .HasForeignKey("MeetingId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Meeting"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.OrderAllocation", b => { b.HasOne("MTWorkHR.Core.Entities.LeaveType", "LeaveType") .WithMany() .HasForeignKey("LeaveTypeId"); b.HasOne("MTWorkHR.Core.Entities.OrderType", "OrderType") .WithMany() .HasForeignKey("OrderTypeId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("LeaveType"); b.Navigation("OrderType"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStage", b => { b.HasOne("MTWorkHR.Core.Entities.Contract", "Contract") .WithMany("ProjectStages") .HasForeignKey("ContractId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Contract"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStageAttachment", b => { b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType") .WithMany() .HasForeignKey("AttachmentTypeId"); b.HasOne("MTWorkHR.Core.Entities.ProjectStage", "ProjectStage") .WithMany("StageAttachments") .HasForeignKey("ProjectStageId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("AttachmentType"); b.Navigation("ProjectStage"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectTeam", b => { b.HasOne("MTWorkHR.Core.Entities.Project", "Project") .WithMany("ProjectTeams") .HasForeignKey("ProjectId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Project"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.TaskUser", b => { b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask") .WithMany("TaskUsers") .HasForeignKey("TaskId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("UserTask"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b => { b.HasOne("MTWorkHR.Core.Entities.Team", "Team") .WithMany("TeamUsers") .HasForeignKey("TeamId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Team"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.User.OrderRequest", b => { b.HasOne("MTWorkHR.Core.Entities.LeaveType", "LeaveType") .WithMany() .HasForeignKey("LeaveTypeId"); b.HasOne("MTWorkHR.Core.Entities.OrderType", "OrderType") .WithMany() .HasForeignKey("OrderTypeId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("LeaveType"); b.Navigation("OrderType"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b => { b.HasOne("MTWorkHR.Core.Entities.Project", "Project") .WithMany() .HasForeignKey("ProjectId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus") .WithMany() .HasForeignKey("StatusId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Project"); b.Navigation("TaskStatus"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b => { b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType") .WithMany() .HasForeignKey("AttachmentTypeId"); b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask") .WithMany("TaskAttachments") .HasForeignKey("TaskId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("AttachmentType"); b.Navigation("UserTask"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b => { b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus") .WithMany() .HasForeignKey("CurrentStatusId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask") .WithMany("TaskHistories") .HasForeignKey("TaskId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("TaskStatus"); b.Navigation("UserTask"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b => { b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country") .WithMany() .HasForeignKey("CountryId"); b.HasOne("MTWorkHR.Core.Entities.Industry", "Industry") .WithMany() .HasForeignKey("IndustryId"); b.HasOne("MTWorkHR.Core.Entities.JobTitle", "JobTitle") .WithMany() .HasForeignKey("JobTitleId"); b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "Manager") .WithMany() .HasForeignKey("ManagerId"); b.HasOne("MTWorkHR.Core.Entities.Nationality", "Nationality") .WithMany() .HasForeignKey("NationalityId"); b.HasOne("MTWorkHR.Core.Entities.Qualification", "Qualification") .WithMany() .HasForeignKey("QualificationId"); b.HasOne("MTWorkHR.Core.Entities.University", "University") .WithMany() .HasForeignKey("UniversityId"); b.Navigation("Country"); b.Navigation("Industry"); b.Navigation("JobTitle"); b.Navigation("Manager"); b.Navigation("Nationality"); b.Navigation("Qualification"); b.Navigation("University"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b => { b.HasOne("MTWorkHR.Core.Entities.Permission", "Permission") .WithMany() .HasForeignKey("PermissionId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", "Role") .WithMany("RolePermissions") .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Permission"); b.Navigation("Role"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAddress", b => { b.HasOne("MTWorkHR.Core.Entities.City", "City") .WithMany() .HasForeignKey("CityId"); b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country") .WithMany() .HasForeignKey("CountryId"); b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "User") .WithOne("UserAddress") .HasForeignKey("MTWorkHR.Infrastructure.Entities.UserAddress", "UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("City"); b.Navigation("Country"); b.Navigation("User"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b => { b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType") .WithMany() .HasForeignKey("AttachmentTypeId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "User") .WithMany("UserAttachments") .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("AttachmentType"); b.Navigation("User"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null) .WithMany() .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null) .WithMany() .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ChatMessage", b => { b.Navigation("ChatAttachments"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Contract", b => { b.Navigation("ContractTasks"); b.Navigation("FixedAllowances"); b.Navigation("ProjectStages"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTask", b => { b.Navigation("TaskAttachments"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b => { b.Navigation("MeetingUsers"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b => { b.Navigation("ProjectTeams"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStage", b => { b.Navigation("StageAttachments"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b => { b.Navigation("TeamUsers"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b => { b.Navigation("TaskAttachments"); b.Navigation("TaskHistories"); b.Navigation("TaskUsers"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b => { b.Navigation("RolePermissions"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b => { b.Navigation("UserAddress") .IsRequired(); b.Navigation("UserAttachments"); }); #pragma warning restore 612, 618 } } }