123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297 |
- // <auto-generated />
- using System;
- using MTWorkHR.Infrastructure.DBContext;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Metadata;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- #nullable disable
- namespace MTWorkHR.Infrastructure.Migrations
- {
- [DbContext(typeof(HRDataContext))]
- partial class HRDataContextModelSnapshot : ModelSnapshot
- {
- protected override void BuildModel(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<string>("UserRolesId")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("UsersId")
- .HasColumnType("nvarchar(450)");
- b.HasKey("UserRolesId", "UsersId");
- b.HasIndex("UsersId");
- b.ToTable("ApplicationRoleApplicationUser");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Attendance", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<DateTime>("AttendanceDate")
- .HasColumnType("datetime2");
- b.Property<DateTime?>("CheckInTime")
- .HasColumnType("datetime2");
- b.Property<DateTime?>("CheckOutTime")
- .HasColumnType("datetime2");
- b.Property<long>("CompanyId")
- .HasColumnType("bigint");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("DeleteUserId")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(8);
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit")
- .HasColumnOrder(7);
- b.Property<string>("LeaveReason")
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<int>("LeaveType")
- .HasColumnType("int");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("UpdateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(2);
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserName")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.HasIndex("CompanyId");
- b.ToTable("Attendances");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.AttendanceLog", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("AttendanceLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.AuthLog", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("AuthLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Base.AttachmentType", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<bool>("IsRequired")
- .HasColumnType("bit");
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("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"
- });
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.City", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Code")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<long>("CountryId")
- .HasColumnType("bigint");
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("NameEn")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("NameFr")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.HasIndex("CountryId");
- b.ToTable("Cities");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Company", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("CRNumber")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("CompanyName")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("DeleteUserId")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(8);
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit")
- .HasColumnOrder(7);
- b.Property<int>("TaxNumber")
- .HasColumnType("int");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("UpdateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(2);
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("Companies");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.CountryLookup", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Code")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("NameEn")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("NameFr")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("CountryLookups");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.FileLog", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("FileLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Industry", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<int>("DefaultDays")
- .HasColumnType("int");
- b.Property<string>("NameAr")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<DateTime>("ExpireDate")
- .HasColumnType("datetime2");
- b.Property<string>("OTP")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("LoginOTPs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("CompanyId")
- .HasColumnType("bigint");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("DeleteUserId")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(8);
- b.Property<string>("Description")
- .HasMaxLength(500)
- .HasColumnType("nvarchar(500)");
- b.Property<DateTime>("EndDate")
- .HasColumnType("datetime2");
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit")
- .HasColumnOrder(7);
- b.Property<string>("Location")
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("MeetingLink")
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<DateTime>("StartDate")
- .HasColumnType("datetime2");
- b.Property<string>("Title")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("MeetingLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("AssignedUserId")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<long>("MeetingId")
- .HasColumnType("bigint");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("CompanyId")
- .HasColumnType("bigint");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("EmployeeId")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<long?>("LeaveTypeId")
- .HasColumnType("bigint");
- b.Property<int>("NumberOfDays")
- .HasColumnType("int");
- b.Property<long>("OrderTypeId")
- .HasColumnType("bigint");
- b.Property<int>("Period")
- .HasColumnType("int");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<int>("DefaultDays")
- .HasColumnType("int");
- b.Property<string>("NameAr")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("CategoryName")
- .IsRequired()
- .HasMaxLength(150)
- .HasColumnType("nvarchar(150)");
- b.Property<string>("Desc")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("Name")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<bool>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("CompanyId")
- .HasColumnType("bigint");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("DeleteUserId")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(8);
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit")
- .HasColumnOrder(7);
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("NameEn")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("UpdateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(2);
- b.HasKey("Id");
- b.HasIndex("CompanyId");
- b.ToTable("Projects");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Qualification", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("RoleLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.SettingLog", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("SettingLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("CompanyId")
- .HasColumnType("bigint");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("DeleteUserId")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(8);
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit")
- .HasColumnOrder(7);
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("NameEn")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("TeamLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("AssignedUserId")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<bool>("IsAdmin")
- .HasColumnType("bit");
- b.Property<long>("TeamId")
- .HasColumnType("bigint");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<int?>("CityId")
- .HasColumnType("int");
- b.Property<long>("CompanyId")
- .HasColumnType("bigint");
- b.Property<int?>("CountryId")
- .HasColumnType("int");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("DeleteUserId")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(8);
- b.Property<DateTime?>("EndDate")
- .HasColumnType("datetime2");
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit")
- .HasColumnOrder(7);
- b.Property<long?>("LeaveTypeId")
- .HasColumnType("bigint");
- b.Property<int?>("OrderStatus")
- .HasColumnType("int");
- b.Property<long>("OrderTypeId")
- .HasColumnType("bigint");
- b.Property<string>("RequestComments")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("RequestingEmployeeId")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("StartDate")
- .HasColumnType("datetime2");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("UserLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("AssignedUserId")
- .HasColumnType("bigint");
- b.Property<long>("CompanyId")
- .HasColumnType("bigint");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("DeleteUserId")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(8);
- b.Property<string>("Description")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("DueDate")
- .HasColumnType("datetime2");
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit")
- .HasColumnOrder(7);
- b.Property<int>("Priority")
- .HasColumnType("int");
- b.Property<long>("ProjectId")
- .HasColumnType("bigint");
- b.Property<long>("StatusId")
- .HasColumnType("bigint");
- b.Property<string>("Title")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long?>("AttachmentTypeId")
- .HasColumnType("bigint");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("FileName")
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("OriginalName")
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<long>("TaskId")
- .HasColumnType("bigint");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("AssignedToUserId")
- .HasColumnType("bigint");
- b.Property<string>("Comment")
- .HasMaxLength(500)
- .HasColumnType("nvarchar(500)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<long>("CurrentStatusId")
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit");
- b.Property<long>("TaskId")
- .HasColumnType("bigint");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("UpdateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(2);
- b.Property<long?>("UserTaskId")
- .HasColumnType("bigint");
- b.HasKey("Id");
- b.HasIndex("CurrentStatusId");
- b.HasIndex("UserTaskId");
- b.ToTable("UserTaskHistories");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskLog", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("Channel")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorCode")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ErrorDescription")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("InnerException")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Input")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Method")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("QueryString")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServerIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ServiceResponseTimeInSeconds")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserIP")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("userAgent")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.ToTable("UserTaskLogs");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskStatus", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("NameAr")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("NameEn")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.HasKey("Id");
- b.ToTable("UserTaskStatuses");
- b.HasData(
- new
- {
- Id = 1L,
- NameAr = "جديدة",
- NameEn = "New"
- },
- new
- {
- Id = 2L,
- NameAr = "قيد العمل",
- NameEn = "Under progress"
- },
- new
- {
- Id = 3L,
- NameAr = "أغلقت",
- NameEn = "Closed"
- },
- new
- {
- Id = 4L,
- NameAr = "تمت",
- NameEn = "Completed"
- },
- new
- {
- Id = 5L,
- NameAr = "مؤجلة",
- NameEn = "Delayed"
- });
- });
- modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("DeleteUserId")
- .HasColumnType("nvarchar(max)");
- b.Property<bool?>("IsAdmin")
- .HasColumnType("bit");
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit");
- b.Property<string>("Name")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<string>("NormalizedName")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2");
- b.Property<string>("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"
- });
- });
- modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("nvarchar(450)");
- b.Property<int>("AccessFailedCount")
- .HasColumnType("int");
- b.Property<long?>("CompanyId")
- .HasColumnType("bigint");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasColumnType("nvarchar(max)");
- b.Property<long?>("CountryId")
- .HasColumnType("bigint");
- b.Property<string>("CreateUser")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("DateOfBirth")
- .HasColumnType("datetime2");
- b.Property<string>("DeleteUserId")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Email")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<bool>("EmailConfirmed")
- .HasColumnType("bit");
- b.Property<string>("FavoriteName")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("FirstName")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("IdNumber")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<decimal?>("IncomeTaxValue")
- .HasColumnType("decimal(18,2)");
- b.Property<long?>("IndustryId")
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit");
- b.Property<bool>("IsStopped")
- .HasColumnType("bit");
- b.Property<long?>("JobTitleId")
- .HasColumnType("bigint");
- b.Property<string>("LastName")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("LinkedInLink")
- .HasColumnType("nvarchar(max)");
- b.Property<bool>("LockoutEnabled")
- .HasColumnType("bit");
- b.Property<DateTimeOffset?>("LockoutEnd")
- .HasColumnType("datetimeoffset");
- b.Property<string>("ManagerId")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("NormalizedEmail")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<string>("NormalizedUserName")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<string>("PassportNumber")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("PasswordHash")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("PhoneNumber")
- .HasColumnType("nvarchar(max)");
- b.Property<bool>("PhoneNumberConfirmed")
- .HasColumnType("bit");
- b.Property<long?>("QualificationId")
- .HasColumnType("bigint");
- b.Property<string>("SecurityStamp")
- .HasColumnType("nvarchar(max)");
- b.Property<decimal?>("TaxNumber")
- .HasColumnType("decimal(18,2)");
- b.Property<bool>("TwoFactorEnabled")
- .HasColumnType("bit");
- b.Property<long?>("UniversityId")
- .HasColumnType("bigint");
- b.Property<string>("UpdateUser")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserName")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<int>("UserType")
- .HasColumnType("int");
- b.HasKey("Id");
- b.HasIndex("CountryId");
- b.HasIndex("IndustryId");
- b.HasIndex("JobTitleId");
- b.HasIndex("ManagerId");
- 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,
- 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 = "ADMIN",
- PassportNumber = "1234567",
- PasswordHash = "AQAAAAIAAYagAAAAEPg+ASbciPFxtyxQq8Wx5ilBUQ0RbAoITXXkOQm1PzC5BzySX0sn/wUmOjBKPDGV9w==",
- PhoneNumber = "1234567890",
- PhoneNumberConfirmed = true,
- SecurityStamp = "49bb16c3-4704-4c60-908d-dc8506950acc",
- TaxNumber = 111m,
- TwoFactorEnabled = false,
- UserName = "Admin",
- UserType = 1
- },
- new
- {
- Id = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
- AccessFailedCount = 0,
- 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",
- PassportNumber = "7654321001010",
- PasswordHash = "AQAAAAIAAYagAAAAEI3QJkcZjCH4Y8Db4rEgL8Mmll5oCvYcWiXZjQSN9bGW4SMcjHe3ZPMnkN/l9DmJeQ==",
- PhoneNumber = "1234567888",
- PhoneNumberConfirmed = true,
- SecurityStamp = "62549056-1b9d-46d4-84f8-adea3e4d8b68",
- TaxNumber = 222m,
- TwoFactorEnabled = false,
- UserName = "ali",
- UserType = 1
- });
- });
- modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("PermissionId")
- .HasColumnType("bigint");
- b.Property<string>("PermissionName")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("AddressDesc")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("City")
- .HasColumnType("nvarchar(max)");
- b.Property<int?>("CountryId")
- .HasColumnType("int");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("PostalCode")
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("UpdateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(2);
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- b.HasKey("Id");
- b.HasIndex("UserId")
- .IsUnique();
- b.ToTable("UserAddress");
- });
- modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("AttachmentTypeId")
- .HasColumnType("bigint");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(3);
- b.Property<string>("CreateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(1);
- b.Property<string>("FileName")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("OriginalName")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("UpdateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(2);
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- b.HasKey("Id");
- b.HasIndex("AttachmentTypeId");
- b.HasIndex("UserId");
- b.ToTable("UserAttachments");
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("int");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
- b.Property<string>("ClaimType")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ClaimValue")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("RoleId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- b.HasKey("Id");
- b.HasIndex("RoleId");
- b.ToTable("AspNetRoleClaims", (string)null);
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("int");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
- b.Property<string>("ClaimType")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ClaimValue")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- b.HasKey("Id");
- b.HasIndex("UserId");
- b.ToTable("AspNetUserClaims", (string)null);
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
- {
- b.Property<string>("LoginProvider")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("ProviderKey")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("ProviderDisplayName")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- b.HasKey("LoginProvider", "ProviderKey");
- b.HasIndex("UserId");
- b.ToTable("AspNetUserLogins", (string)null);
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
- {
- b.Property<string>("UserId")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("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<string>", b =>
- {
- b.Property<string>("UserId")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("LoginProvider")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("Name")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("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.City", b =>
- {
- b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
- .WithMany()
- .HasForeignKey("CountryId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("Country");
- });
- 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.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", null)
- .WithMany("UserTaskHistories")
- .HasForeignKey("UserTaskId");
- b.Navigation("TaskStatus");
- });
- 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.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("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.Infrastructure.Entities.ApplicationUser", "User")
- .WithOne("UserAddress")
- .HasForeignKey("MTWorkHR.Infrastructure.Entities.UserAddress", "UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- 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<string>", b =>
- {
- b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
- .WithMany()
- .HasForeignKey("RoleId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
- {
- b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
- {
- b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", 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<string>", b =>
- {
- b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b =>
- {
- b.Navigation("MeetingUsers");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b =>
- {
- b.Navigation("TeamUsers");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
- {
- b.Navigation("TaskAttachments");
- b.Navigation("UserTaskHistories");
- });
- 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
- }
- }
- }
|