//
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("20240825112941_altrUserPosition")]
partial class altrUserPosition
{
///
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.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("CRNumber")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("CompanyName")
.IsRequired()
.HasColumnType("nvarchar(max)");
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("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.ToTable("Companies");
});
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.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.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.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