HRDataContextModelSnapshot.cs 128 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493
  1. // <auto-generated />
  2. using System;
  3. using MTWorkHR.Infrastructure.DBContext;
  4. using Microsoft.EntityFrameworkCore;
  5. using Microsoft.EntityFrameworkCore.Infrastructure;
  6. using Microsoft.EntityFrameworkCore.Metadata;
  7. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  8. #nullable disable
  9. namespace MTWorkHR.Infrastructure.Migrations
  10. {
  11. [DbContext(typeof(HRDataContext))]
  12. partial class HRDataContextModelSnapshot : ModelSnapshot
  13. {
  14. protected override void BuildModel(ModelBuilder modelBuilder)
  15. {
  16. #pragma warning disable 612, 618
  17. modelBuilder
  18. .HasAnnotation("ProductVersion", "8.0.1")
  19. .HasAnnotation("Relational:MaxIdentifierLength", 128);
  20. SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
  21. modelBuilder.Entity("ApplicationRoleApplicationUser", b =>
  22. {
  23. b.Property<string>("UserRolesId")
  24. .HasColumnType("nvarchar(450)");
  25. b.Property<string>("UsersId")
  26. .HasColumnType("nvarchar(450)");
  27. b.HasKey("UserRolesId", "UsersId");
  28. b.HasIndex("UsersId");
  29. b.ToTable("ApplicationRoleApplicationUser", (string)null);
  30. });
  31. modelBuilder.Entity("MTWorkHR.Core.Entities.Attendance", b =>
  32. {
  33. b.Property<long>("Id")
  34. .ValueGeneratedOnAdd()
  35. .HasColumnType("bigint")
  36. .HasColumnOrder(0);
  37. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  38. b.Property<DateTime>("AttendanceDate")
  39. .HasColumnType("datetime2");
  40. b.Property<DateTime?>("CheckInTime")
  41. .HasColumnType("datetime2");
  42. b.Property<DateTime?>("CheckOutTime")
  43. .HasColumnType("datetime2");
  44. b.Property<long>("CompanyId")
  45. .HasColumnType("bigint");
  46. b.Property<DateTime>("CreateDate")
  47. .HasColumnType("datetime2")
  48. .HasColumnOrder(3);
  49. b.Property<string>("CreateUser")
  50. .HasMaxLength(450)
  51. .HasColumnType("nvarchar(450)")
  52. .HasColumnOrder(1);
  53. b.Property<string>("DeleteUserId")
  54. .HasMaxLength(450)
  55. .HasColumnType("nvarchar(450)")
  56. .HasColumnOrder(8);
  57. b.Property<bool>("IsDeleted")
  58. .HasColumnType("bit")
  59. .HasColumnOrder(7);
  60. b.Property<string>("LeaveReason")
  61. .HasMaxLength(250)
  62. .HasColumnType("nvarchar(250)");
  63. b.Property<int>("LeaveType")
  64. .HasColumnType("int");
  65. b.Property<DateTime?>("UpdateDate")
  66. .HasColumnType("datetime2")
  67. .HasColumnOrder(4);
  68. b.Property<string>("UpdateUser")
  69. .HasMaxLength(450)
  70. .HasColumnType("nvarchar(450)")
  71. .HasColumnOrder(2);
  72. b.Property<string>("UserId")
  73. .IsRequired()
  74. .HasColumnType("nvarchar(max)");
  75. b.Property<string>("UserName")
  76. .HasColumnType("nvarchar(max)");
  77. b.HasKey("Id");
  78. b.HasIndex("CompanyId");
  79. b.ToTable("Attendances", (string)null);
  80. });
  81. modelBuilder.Entity("MTWorkHR.Core.Entities.AttendanceLog", b =>
  82. {
  83. b.Property<long>("Id")
  84. .ValueGeneratedOnAdd()
  85. .HasColumnType("bigint")
  86. .HasColumnOrder(0);
  87. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  88. b.Property<string>("Channel")
  89. .HasColumnType("nvarchar(max)");
  90. b.Property<DateTime>("CreateDate")
  91. .HasColumnType("datetime2");
  92. b.Property<string>("CreateUser")
  93. .IsRequired()
  94. .HasColumnType("nvarchar(max)");
  95. b.Property<string>("ErrorCode")
  96. .IsRequired()
  97. .HasColumnType("nvarchar(max)");
  98. b.Property<string>("ErrorDescription")
  99. .IsRequired()
  100. .HasColumnType("nvarchar(max)");
  101. b.Property<string>("InnerException")
  102. .HasColumnType("nvarchar(max)");
  103. b.Property<string>("Input")
  104. .HasColumnType("nvarchar(max)");
  105. b.Property<string>("Method")
  106. .IsRequired()
  107. .HasColumnType("nvarchar(max)");
  108. b.Property<string>("QueryString")
  109. .HasColumnType("nvarchar(max)");
  110. b.Property<string>("ServerIP")
  111. .HasColumnType("nvarchar(max)");
  112. b.Property<string>("ServiceResponseTimeInSeconds")
  113. .IsRequired()
  114. .HasColumnType("nvarchar(max)");
  115. b.Property<string>("UserIP")
  116. .HasColumnType("nvarchar(max)");
  117. b.Property<string>("userAgent")
  118. .HasColumnType("nvarchar(max)");
  119. b.HasKey("Id");
  120. b.ToTable("AttendanceLogs", (string)null);
  121. });
  122. modelBuilder.Entity("MTWorkHR.Core.Entities.AuthLog", b =>
  123. {
  124. b.Property<long>("Id")
  125. .ValueGeneratedOnAdd()
  126. .HasColumnType("bigint")
  127. .HasColumnOrder(0);
  128. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  129. b.Property<string>("Channel")
  130. .HasColumnType("nvarchar(max)");
  131. b.Property<DateTime>("CreateDate")
  132. .HasColumnType("datetime2");
  133. b.Property<string>("CreateUser")
  134. .IsRequired()
  135. .HasColumnType("nvarchar(max)");
  136. b.Property<string>("ErrorCode")
  137. .IsRequired()
  138. .HasColumnType("nvarchar(max)");
  139. b.Property<string>("ErrorDescription")
  140. .IsRequired()
  141. .HasColumnType("nvarchar(max)");
  142. b.Property<string>("InnerException")
  143. .HasColumnType("nvarchar(max)");
  144. b.Property<string>("Input")
  145. .HasColumnType("nvarchar(max)");
  146. b.Property<string>("Method")
  147. .IsRequired()
  148. .HasColumnType("nvarchar(max)");
  149. b.Property<string>("QueryString")
  150. .HasColumnType("nvarchar(max)");
  151. b.Property<string>("ServerIP")
  152. .HasColumnType("nvarchar(max)");
  153. b.Property<string>("ServiceResponseTimeInSeconds")
  154. .IsRequired()
  155. .HasColumnType("nvarchar(max)");
  156. b.Property<string>("UserIP")
  157. .HasColumnType("nvarchar(max)");
  158. b.Property<string>("userAgent")
  159. .HasColumnType("nvarchar(max)");
  160. b.HasKey("Id");
  161. b.ToTable("AuthLogs", (string)null);
  162. });
  163. modelBuilder.Entity("MTWorkHR.Core.Entities.Base.AttachmentType", b =>
  164. {
  165. b.Property<long>("Id")
  166. .ValueGeneratedOnAdd()
  167. .HasColumnType("bigint")
  168. .HasColumnOrder(0);
  169. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  170. b.Property<bool>("IsRequired")
  171. .HasColumnType("bit");
  172. b.Property<string>("NameAr")
  173. .IsRequired()
  174. .HasMaxLength(250)
  175. .HasColumnType("nvarchar(250)");
  176. b.Property<string>("NameEn")
  177. .IsRequired()
  178. .HasMaxLength(250)
  179. .HasColumnType("nvarchar(250)");
  180. b.HasKey("Id");
  181. b.ToTable("AttachmentTypes", (string)null);
  182. b.HasData(
  183. new
  184. {
  185. Id = 1L,
  186. IsRequired = false,
  187. NameAr = "السيرة الذاتية",
  188. NameEn = "CV"
  189. },
  190. new
  191. {
  192. Id = 2L,
  193. IsRequired = false,
  194. NameAr = "جواز السفر",
  195. NameEn = "Passport"
  196. },
  197. new
  198. {
  199. Id = 3L,
  200. IsRequired = false,
  201. NameAr = "شهادة التعليم",
  202. NameEn = "Education Certification"
  203. },
  204. new
  205. {
  206. Id = 4L,
  207. IsRequired = false,
  208. NameAr = "شهادة الخبرة",
  209. NameEn = "Experience Certification"
  210. },
  211. new
  212. {
  213. Id = 5L,
  214. IsRequired = false,
  215. NameAr = "شهادة الاحتراف",
  216. NameEn = "Professional Certification"
  217. },
  218. new
  219. {
  220. Id = 6L,
  221. IsRequired = false,
  222. NameAr = "التسجيل التجارى",
  223. NameEn = "Commercial Regestration"
  224. },
  225. new
  226. {
  227. Id = 7L,
  228. IsRequired = false,
  229. NameAr = "البطاقة الضريبية",
  230. NameEn = "Tax Declaration"
  231. },
  232. new
  233. {
  234. Id = 8L,
  235. IsRequired = false,
  236. NameAr = "الهوية",
  237. NameEn = "Identification"
  238. },
  239. new
  240. {
  241. Id = 9L,
  242. IsRequired = false,
  243. NameAr = "الصورة",
  244. NameEn = "Image"
  245. });
  246. });
  247. modelBuilder.Entity("MTWorkHR.Core.Entities.City", b =>
  248. {
  249. b.Property<long>("Id")
  250. .ValueGeneratedOnAdd()
  251. .HasColumnType("bigint")
  252. .HasColumnOrder(0);
  253. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  254. b.Property<string>("Code")
  255. .IsRequired()
  256. .HasColumnType("nvarchar(max)");
  257. b.Property<long>("CountryId")
  258. .HasColumnType("bigint");
  259. b.Property<string>("NameAr")
  260. .IsRequired()
  261. .HasMaxLength(250)
  262. .HasColumnType("nvarchar(250)");
  263. b.Property<string>("NameEn")
  264. .IsRequired()
  265. .HasMaxLength(250)
  266. .HasColumnType("nvarchar(250)");
  267. b.Property<string>("NameFr")
  268. .IsRequired()
  269. .HasColumnType("nvarchar(max)");
  270. b.HasKey("Id");
  271. b.HasIndex("CountryId");
  272. b.ToTable("Cities", (string)null);
  273. });
  274. modelBuilder.Entity("MTWorkHR.Core.Entities.Company", b =>
  275. {
  276. b.Property<long>("Id")
  277. .ValueGeneratedOnAdd()
  278. .HasColumnType("bigint")
  279. .HasColumnOrder(0);
  280. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  281. b.Property<string>("CRNumber")
  282. .IsRequired()
  283. .HasColumnType("nvarchar(max)");
  284. b.Property<string>("CompanyName")
  285. .IsRequired()
  286. .HasColumnType("nvarchar(max)");
  287. b.Property<DateTime>("CreateDate")
  288. .HasColumnType("datetime2")
  289. .HasColumnOrder(3);
  290. b.Property<string>("CreateUser")
  291. .HasMaxLength(450)
  292. .HasColumnType("nvarchar(450)")
  293. .HasColumnOrder(1);
  294. b.Property<string>("DeleteUserId")
  295. .HasMaxLength(450)
  296. .HasColumnType("nvarchar(450)")
  297. .HasColumnOrder(8);
  298. b.Property<bool>("IsDeleted")
  299. .HasColumnType("bit")
  300. .HasColumnOrder(7);
  301. b.Property<int>("TaxNumber")
  302. .HasColumnType("int");
  303. b.Property<DateTime?>("UpdateDate")
  304. .HasColumnType("datetime2")
  305. .HasColumnOrder(4);
  306. b.Property<string>("UpdateUser")
  307. .HasMaxLength(450)
  308. .HasColumnType("nvarchar(450)")
  309. .HasColumnOrder(2);
  310. b.Property<string>("UserId")
  311. .IsRequired()
  312. .HasColumnType("nvarchar(max)");
  313. b.HasKey("Id");
  314. b.ToTable("Companies", (string)null);
  315. });
  316. modelBuilder.Entity("MTWorkHR.Core.Entities.CountryLookup", b =>
  317. {
  318. b.Property<long>("Id")
  319. .ValueGeneratedOnAdd()
  320. .HasColumnType("bigint")
  321. .HasColumnOrder(0);
  322. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  323. b.Property<string>("Code")
  324. .IsRequired()
  325. .HasColumnType("nvarchar(max)");
  326. b.Property<string>("NameAr")
  327. .IsRequired()
  328. .HasMaxLength(250)
  329. .HasColumnType("nvarchar(250)");
  330. b.Property<string>("NameEn")
  331. .IsRequired()
  332. .HasMaxLength(250)
  333. .HasColumnType("nvarchar(250)");
  334. b.Property<string>("NameFr")
  335. .IsRequired()
  336. .HasColumnType("nvarchar(max)");
  337. b.HasKey("Id");
  338. b.ToTable("CountryLookups", (string)null);
  339. });
  340. modelBuilder.Entity("MTWorkHR.Core.Entities.FileLog", b =>
  341. {
  342. b.Property<long>("Id")
  343. .ValueGeneratedOnAdd()
  344. .HasColumnType("bigint")
  345. .HasColumnOrder(0);
  346. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  347. b.Property<string>("Channel")
  348. .HasColumnType("nvarchar(max)");
  349. b.Property<DateTime>("CreateDate")
  350. .HasColumnType("datetime2");
  351. b.Property<string>("CreateUser")
  352. .IsRequired()
  353. .HasColumnType("nvarchar(max)");
  354. b.Property<string>("ErrorCode")
  355. .IsRequired()
  356. .HasColumnType("nvarchar(max)");
  357. b.Property<string>("ErrorDescription")
  358. .IsRequired()
  359. .HasColumnType("nvarchar(max)");
  360. b.Property<string>("InnerException")
  361. .HasColumnType("nvarchar(max)");
  362. b.Property<string>("Input")
  363. .HasColumnType("nvarchar(max)");
  364. b.Property<string>("Method")
  365. .IsRequired()
  366. .HasColumnType("nvarchar(max)");
  367. b.Property<string>("QueryString")
  368. .HasColumnType("nvarchar(max)");
  369. b.Property<string>("ServerIP")
  370. .HasColumnType("nvarchar(max)");
  371. b.Property<string>("ServiceResponseTimeInSeconds")
  372. .IsRequired()
  373. .HasColumnType("nvarchar(max)");
  374. b.Property<string>("UserIP")
  375. .HasColumnType("nvarchar(max)");
  376. b.Property<string>("userAgent")
  377. .HasColumnType("nvarchar(max)");
  378. b.HasKey("Id");
  379. b.ToTable("FileLogs", (string)null);
  380. });
  381. modelBuilder.Entity("MTWorkHR.Core.Entities.Industry", b =>
  382. {
  383. b.Property<long>("Id")
  384. .ValueGeneratedOnAdd()
  385. .HasColumnType("bigint")
  386. .HasColumnOrder(0);
  387. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  388. b.Property<string>("NameAr")
  389. .IsRequired()
  390. .HasMaxLength(250)
  391. .HasColumnType("nvarchar(250)");
  392. b.Property<string>("NameEn")
  393. .IsRequired()
  394. .HasMaxLength(250)
  395. .HasColumnType("nvarchar(250)");
  396. b.HasKey("Id");
  397. b.ToTable("Industries", (string)null);
  398. b.HasData(
  399. new
  400. {
  401. Id = 1L,
  402. NameAr = "صناعة الطيران والفضاء",
  403. NameEn = "Aerospace industry"
  404. },
  405. new
  406. {
  407. Id = 2L,
  408. NameAr = "صناعة الزراعة",
  409. NameEn = "Agricultural industry"
  410. },
  411. new
  412. {
  413. Id = 3L,
  414. NameAr = "صناعة السيارات",
  415. NameEn = "Automotive industry"
  416. },
  417. new
  418. {
  419. Id = 4L,
  420. NameAr = "صناعة المعادن الأساسية",
  421. NameEn = "Basic metal"
  422. },
  423. new
  424. {
  425. Id = 5L,
  426. NameAr = "صناعة الكيماويات",
  427. NameEn = "Chemical industry"
  428. },
  429. new
  430. {
  431. Id = 6L,
  432. NameAr = "صناعة الحواسيب",
  433. NameEn = "Computer industry"
  434. },
  435. new
  436. {
  437. Id = 7L,
  438. NameAr = "صناعة البناء",
  439. NameEn = "Construction industry"
  440. },
  441. new
  442. {
  443. Id = 8L,
  444. NameAr = "صناعة الإبداعية",
  445. NameEn = "Creative industry"
  446. },
  447. new
  448. {
  449. Id = 9L,
  450. NameAr = "صناعة الثقافة",
  451. NameEn = "Cultural industry"
  452. },
  453. new
  454. {
  455. Id = 10L,
  456. NameAr = "صناعة الدفاع",
  457. NameEn = "Defense industry"
  458. },
  459. new
  460. {
  461. Id = 11L,
  462. NameAr = "صناعة التعليم",
  463. NameEn = "Education industry"
  464. },
  465. new
  466. {
  467. Id = 12L,
  468. NameAr = "صناعة الطاقة الكهربائية",
  469. NameEn = "Electric power"
  470. },
  471. new
  472. {
  473. Id = 13L,
  474. NameAr = "صناعة الإلكترونيات",
  475. NameEn = "Electronics industry"
  476. },
  477. new
  478. {
  479. Id = 14L,
  480. NameAr = "صناعة الطاقة",
  481. NameEn = "Energy industry"
  482. },
  483. new
  484. {
  485. Id = 15L,
  486. NameAr = "صناعة الهندسة",
  487. NameEn = "Engineering industry"
  488. },
  489. new
  490. {
  491. Id = 16L,
  492. NameAr = "صناعة الترفيه",
  493. NameEn = "Entertainment industry"
  494. },
  495. new
  496. {
  497. Id = 17L,
  498. NameAr = "صناعة الزراعة",
  499. NameEn = "Farming industry"
  500. },
  501. new
  502. {
  503. Id = 18L,
  504. NameAr = "صناعة الموضة",
  505. NameEn = "Fashion industry"
  506. },
  507. new
  508. {
  509. Id = 19L,
  510. NameAr = "صناعة السينما",
  511. NameEn = "Film industry"
  512. },
  513. new
  514. {
  515. Id = 20L,
  516. NameAr = "صناعة الخدمات المالية",
  517. NameEn = "Financial services"
  518. },
  519. new
  520. {
  521. Id = 21L,
  522. NameAr = "صناعة الصيد",
  523. NameEn = "Fishing industry"
  524. },
  525. new
  526. {
  527. Id = 22L,
  528. NameAr = "صناعة الأغذية",
  529. NameEn = "Food industry"
  530. },
  531. new
  532. {
  533. Id = 23L,
  534. NameAr = "صناعة الغابات",
  535. NameEn = "Forestry industry"
  536. },
  537. new
  538. {
  539. Id = 24L,
  540. NameAr = "صناعة القمار",
  541. NameEn = "Gambling industry"
  542. },
  543. new
  544. {
  545. Id = 25L,
  546. NameAr = "صناعة الغاز",
  547. NameEn = "Gas industry"
  548. },
  549. new
  550. {
  551. Id = 26L,
  552. NameAr = "صناعة البيئة",
  553. NameEn = "Green industry"
  554. },
  555. new
  556. {
  557. Id = 27L,
  558. NameAr = "صناعة الخدمات الصحية",
  559. NameEn = "Health services industry"
  560. },
  561. new
  562. {
  563. Id = 28L,
  564. NameAr = "صناعة الضيافة",
  565. NameEn = "Hospitality industry"
  566. },
  567. new
  568. {
  569. Id = 29L,
  570. NameAr = "صناعة الفنادق",
  571. NameEn = "Hotels industry"
  572. },
  573. new
  574. {
  575. Id = 30L,
  576. NameAr = "صناعة الروبوتات الصناعية",
  577. NameEn = "Industrial robot"
  578. },
  579. new
  580. {
  581. Id = 31L,
  582. NameAr = "صناعة المعلومات",
  583. NameEn = "Information industry"
  584. },
  585. new
  586. {
  587. Id = 32L,
  588. NameAr = "صناعة تكنولوجيا المعلومات",
  589. NameEn = "Information technology"
  590. },
  591. new
  592. {
  593. Id = 33L,
  594. NameAr = "صناعة البنية التحتية",
  595. NameEn = "Infrastructure industry"
  596. },
  597. new
  598. {
  599. Id = 34L,
  600. NameAr = "صناعة التأمين",
  601. NameEn = "Insurance industry"
  602. },
  603. new
  604. {
  605. Id = 35L,
  606. NameAr = "صناعة الترفيه",
  607. NameEn = "Leisure industry"
  608. },
  609. new
  610. {
  611. Id = 36L,
  612. NameAr = "صناعة التكنولوجيا المنخفضة",
  613. NameEn = "Low technology"
  614. },
  615. new
  616. {
  617. Id = 37L,
  618. NameAr = "صناعة التصنيع",
  619. NameEn = "Manufacturing industry"
  620. },
  621. new
  622. {
  623. Id = 38L,
  624. NameAr = "صناعة اللحوم",
  625. NameEn = "Meat industry"
  626. },
  627. new
  628. {
  629. Id = 39L,
  630. NameAr = "صناعة الإعلام",
  631. NameEn = "Media industry"
  632. },
  633. new
  634. {
  635. Id = 40L,
  636. NameAr = "صناعة التجارة",
  637. NameEn = "Merchandising industry"
  638. },
  639. new
  640. {
  641. Id = 41L,
  642. NameAr = "صناعة التعدين",
  643. NameEn = "Mining industry"
  644. },
  645. new
  646. {
  647. Id = 42L,
  648. NameAr = "صناعة الموسيقى",
  649. NameEn = "Music industry"
  650. },
  651. new
  652. {
  653. Id = 43L,
  654. NameAr = "صناعة وسائل الإعلام",
  655. NameEn = "News media"
  656. },
  657. new
  658. {
  659. Id = 44L,
  660. NameAr = "صناعة النفط والغاز",
  661. NameEn = "Oil and gas industry"
  662. },
  663. new
  664. {
  665. Id = 45L,
  666. NameAr = "صناعة الأدوية",
  667. NameEn = "Pharmaceutical industry"
  668. },
  669. new
  670. {
  671. Id = 46L,
  672. NameAr = "صناعة المهنية",
  673. NameEn = "Professional industry"
  674. },
  675. new
  676. {
  677. Id = 47L,
  678. NameAr = "صناعة النشر",
  679. NameEn = "Publishing industry"
  680. },
  681. new
  682. {
  683. Id = 48L,
  684. NameAr = "صناعة الورق واللب",
  685. NameEn = "Pulp and paper industry"
  686. },
  687. new
  688. {
  689. Id = 49L,
  690. NameAr = "صناعة السكك الحديدية",
  691. NameEn = "Railway industry"
  692. },
  693. new
  694. {
  695. Id = 50L,
  696. NameAr = "الانشاءات",
  697. NameEn = "Real estate"
  698. });
  699. });
  700. modelBuilder.Entity("MTWorkHR.Core.Entities.JobTitle", b =>
  701. {
  702. b.Property<long>("Id")
  703. .ValueGeneratedOnAdd()
  704. .HasColumnType("bigint")
  705. .HasColumnOrder(0);
  706. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  707. b.Property<string>("NameAr")
  708. .IsRequired()
  709. .HasMaxLength(250)
  710. .HasColumnType("nvarchar(250)");
  711. b.Property<string>("NameEn")
  712. .IsRequired()
  713. .HasMaxLength(250)
  714. .HasColumnType("nvarchar(250)");
  715. b.HasKey("Id");
  716. b.ToTable("JobTitles", (string)null);
  717. b.HasData(
  718. new
  719. {
  720. Id = 1L,
  721. NameAr = "مساعد ادارى",
  722. NameEn = "Administrative Assistant"
  723. },
  724. new
  725. {
  726. Id = 2L,
  727. NameAr = "موظف استقبال",
  728. NameEn = "Receptionist"
  729. },
  730. new
  731. {
  732. Id = 3L,
  733. NameAr = "مدير مكتب",
  734. NameEn = "Office Manager"
  735. },
  736. new
  737. {
  738. Id = 4L,
  739. NameAr = "مدقق محتوى",
  740. NameEn = "Auditing Clerk"
  741. },
  742. new
  743. {
  744. Id = 5L,
  745. NameAr = "محاسب",
  746. NameEn = "Bookkeeper"
  747. },
  748. new
  749. {
  750. Id = 6L,
  751. NameAr = "مدير تنفيذى",
  752. NameEn = "Account Executive"
  753. },
  754. new
  755. {
  756. Id = 7L,
  757. NameAr = "مدير فرع",
  758. NameEn = "Branch Manager"
  759. },
  760. new
  761. {
  762. Id = 8L,
  763. NameAr = "مدير",
  764. NameEn = "Business Manager"
  765. },
  766. new
  767. {
  768. Id = 9L,
  769. NameAr = "مسؤول الجودة",
  770. NameEn = "Quality Control Coordinator"
  771. },
  772. new
  773. {
  774. Id = 10L,
  775. NameAr = "مدير ادارى",
  776. NameEn = "Administrative Manager"
  777. },
  778. new
  779. {
  780. Id = 11L,
  781. NameAr = "الرئيس التنفيذي",
  782. NameEn = "Chief Executive Officer"
  783. },
  784. new
  785. {
  786. Id = 12L,
  787. NameAr = "محلل",
  788. NameEn = "Business Analyst"
  789. },
  790. new
  791. {
  792. Id = 13L,
  793. NameAr = "مدير المخاطر",
  794. NameEn = "Risk Manager"
  795. },
  796. new
  797. {
  798. Id = 14L,
  799. NameAr = "موارد بشرية",
  800. NameEn = "Human Resources"
  801. },
  802. new
  803. {
  804. Id = 15L,
  805. NameAr = "مساعد مكتب",
  806. NameEn = "Office Assistant"
  807. },
  808. new
  809. {
  810. Id = 16L,
  811. NameAr = "السكرتارية",
  812. NameEn = "Secretary"
  813. },
  814. new
  815. {
  816. Id = 17L,
  817. NameAr = "موظف مكتب",
  818. NameEn = "Office Clerk"
  819. },
  820. new
  821. {
  822. Id = 18L,
  823. NameAr = "جامع الحسابات",
  824. NameEn = "Account Collector"
  825. },
  826. new
  827. {
  828. Id = 19L,
  829. NameAr = "أخصائي إداري",
  830. NameEn = "Administrative Specialist"
  831. },
  832. new
  833. {
  834. Id = 20L,
  835. NameAr = "مساعد تنفيذي",
  836. NameEn = "Executive Assistant"
  837. },
  838. new
  839. {
  840. Id = 21L,
  841. NameAr = "مسؤل البرنامج",
  842. NameEn = "Program Administrator"
  843. },
  844. new
  845. {
  846. Id = 22L,
  847. NameAr = "مدير البرنامج",
  848. NameEn = "Program Manager"
  849. },
  850. new
  851. {
  852. Id = 23L,
  853. NameAr = "محلل إداري",
  854. NameEn = "Administrative Analyst"
  855. },
  856. new
  857. {
  858. Id = 24L,
  859. NameAr = "مدخل بيانات",
  860. NameEn = "Data Entry"
  861. });
  862. });
  863. modelBuilder.Entity("MTWorkHR.Core.Entities.LeaveType", b =>
  864. {
  865. b.Property<long>("Id")
  866. .ValueGeneratedOnAdd()
  867. .HasColumnType("bigint")
  868. .HasColumnOrder(0);
  869. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  870. b.Property<int>("DefaultDays")
  871. .HasColumnType("int");
  872. b.Property<string>("NameAr")
  873. .IsRequired()
  874. .HasColumnType("nvarchar(max)");
  875. b.Property<string>("NameEn")
  876. .IsRequired()
  877. .HasColumnType("nvarchar(max)");
  878. b.HasKey("Id");
  879. b.ToTable("LeaveTypes", (string)null);
  880. b.HasData(
  881. new
  882. {
  883. Id = 1L,
  884. DefaultDays = 21,
  885. NameAr = "أجازة سنوية",
  886. NameEn = "Annual Leave"
  887. },
  888. new
  889. {
  890. Id = 2L,
  891. DefaultDays = 15,
  892. NameAr = "أجازة مرضية",
  893. NameEn = "Sick Leave"
  894. },
  895. new
  896. {
  897. Id = 3L,
  898. DefaultDays = 20,
  899. NameAr = "أجازة زواج",
  900. NameEn = "Marriage Leave"
  901. },
  902. new
  903. {
  904. Id = 4L,
  905. DefaultDays = 10,
  906. NameAr = "أجازة وضع",
  907. NameEn = "Paternity leave"
  908. },
  909. new
  910. {
  911. Id = 5L,
  912. DefaultDays = 10,
  913. NameAr = "أجازة طارئة",
  914. NameEn = "Emergency leave"
  915. });
  916. });
  917. modelBuilder.Entity("MTWorkHR.Core.Entities.LoginOTP", b =>
  918. {
  919. b.Property<long>("Id")
  920. .ValueGeneratedOnAdd()
  921. .HasColumnType("bigint")
  922. .HasColumnOrder(0);
  923. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  924. b.Property<DateTime>("CreateDate")
  925. .HasColumnType("datetime2");
  926. b.Property<DateTime>("ExpireDate")
  927. .HasColumnType("datetime2");
  928. b.Property<string>("OTP")
  929. .IsRequired()
  930. .HasColumnType("nvarchar(max)");
  931. b.Property<string>("UserId")
  932. .IsRequired()
  933. .HasColumnType("nvarchar(max)");
  934. b.HasKey("Id");
  935. b.ToTable("LoginOTPs", (string)null);
  936. });
  937. modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b =>
  938. {
  939. b.Property<long>("Id")
  940. .ValueGeneratedOnAdd()
  941. .HasColumnType("bigint")
  942. .HasColumnOrder(0);
  943. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  944. b.Property<long>("CompanyId")
  945. .HasColumnType("bigint");
  946. b.Property<DateTime>("CreateDate")
  947. .HasColumnType("datetime2")
  948. .HasColumnOrder(3);
  949. b.Property<string>("CreateUser")
  950. .HasMaxLength(450)
  951. .HasColumnType("nvarchar(450)")
  952. .HasColumnOrder(1);
  953. b.Property<string>("DeleteUserId")
  954. .HasMaxLength(450)
  955. .HasColumnType("nvarchar(450)")
  956. .HasColumnOrder(8);
  957. b.Property<string>("Description")
  958. .HasMaxLength(500)
  959. .HasColumnType("nvarchar(500)");
  960. b.Property<string>("EndTime")
  961. .IsRequired()
  962. .HasColumnType("nvarchar(max)");
  963. b.Property<bool>("IsDeleted")
  964. .HasColumnType("bit")
  965. .HasColumnOrder(7);
  966. b.Property<string>("Location")
  967. .HasMaxLength(250)
  968. .HasColumnType("nvarchar(250)");
  969. b.Property<DateTime>("MeetingDate")
  970. .HasColumnType("datetime2");
  971. b.Property<string>("MeetingLink")
  972. .HasMaxLength(250)
  973. .HasColumnType("nvarchar(250)");
  974. b.Property<int>("RepeatId")
  975. .HasColumnType("int");
  976. b.Property<string>("StartTime")
  977. .IsRequired()
  978. .HasColumnType("nvarchar(max)");
  979. b.Property<string>("Title")
  980. .IsRequired()
  981. .HasMaxLength(250)
  982. .HasColumnType("nvarchar(250)");
  983. b.Property<DateTime?>("UpdateDate")
  984. .HasColumnType("datetime2")
  985. .HasColumnOrder(4);
  986. b.Property<string>("UpdateUser")
  987. .HasMaxLength(450)
  988. .HasColumnType("nvarchar(450)")
  989. .HasColumnOrder(2);
  990. b.HasKey("Id");
  991. b.HasIndex("CompanyId");
  992. b.ToTable("Meetings", (string)null);
  993. });
  994. modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingLog", b =>
  995. {
  996. b.Property<long>("Id")
  997. .ValueGeneratedOnAdd()
  998. .HasColumnType("bigint")
  999. .HasColumnOrder(0);
  1000. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1001. b.Property<string>("Channel")
  1002. .HasColumnType("nvarchar(max)");
  1003. b.Property<DateTime>("CreateDate")
  1004. .HasColumnType("datetime2");
  1005. b.Property<string>("CreateUser")
  1006. .IsRequired()
  1007. .HasColumnType("nvarchar(max)");
  1008. b.Property<string>("ErrorCode")
  1009. .IsRequired()
  1010. .HasColumnType("nvarchar(max)");
  1011. b.Property<string>("ErrorDescription")
  1012. .IsRequired()
  1013. .HasColumnType("nvarchar(max)");
  1014. b.Property<string>("InnerException")
  1015. .HasColumnType("nvarchar(max)");
  1016. b.Property<string>("Input")
  1017. .HasColumnType("nvarchar(max)");
  1018. b.Property<string>("Method")
  1019. .IsRequired()
  1020. .HasColumnType("nvarchar(max)");
  1021. b.Property<string>("QueryString")
  1022. .HasColumnType("nvarchar(max)");
  1023. b.Property<string>("ServerIP")
  1024. .HasColumnType("nvarchar(max)");
  1025. b.Property<string>("ServiceResponseTimeInSeconds")
  1026. .IsRequired()
  1027. .HasColumnType("nvarchar(max)");
  1028. b.Property<string>("UserIP")
  1029. .HasColumnType("nvarchar(max)");
  1030. b.Property<string>("userAgent")
  1031. .HasColumnType("nvarchar(max)");
  1032. b.HasKey("Id");
  1033. b.ToTable("MeetingLogs", (string)null);
  1034. });
  1035. modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b =>
  1036. {
  1037. b.Property<long>("Id")
  1038. .ValueGeneratedOnAdd()
  1039. .HasColumnType("bigint")
  1040. .HasColumnOrder(0);
  1041. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1042. b.Property<string>("AssignedUserId")
  1043. .IsRequired()
  1044. .HasColumnType("nvarchar(max)");
  1045. b.Property<string>("AssignedUserName")
  1046. .IsRequired()
  1047. .HasColumnType("nvarchar(max)");
  1048. b.Property<DateTime>("CreateDate")
  1049. .HasColumnType("datetime2")
  1050. .HasColumnOrder(3);
  1051. b.Property<string>("CreateUser")
  1052. .HasMaxLength(450)
  1053. .HasColumnType("nvarchar(450)")
  1054. .HasColumnOrder(1);
  1055. b.Property<long>("MeetingId")
  1056. .HasColumnType("bigint");
  1057. b.Property<DateTime?>("UpdateDate")
  1058. .HasColumnType("datetime2")
  1059. .HasColumnOrder(4);
  1060. b.Property<string>("UpdateUser")
  1061. .HasMaxLength(450)
  1062. .HasColumnType("nvarchar(450)")
  1063. .HasColumnOrder(2);
  1064. b.HasKey("Id");
  1065. b.HasIndex("MeetingId");
  1066. b.ToTable("MeetingUser", (string)null);
  1067. });
  1068. modelBuilder.Entity("MTWorkHR.Core.Entities.OrderAllocation", b =>
  1069. {
  1070. b.Property<long>("Id")
  1071. .ValueGeneratedOnAdd()
  1072. .HasColumnType("bigint")
  1073. .HasColumnOrder(0);
  1074. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1075. b.Property<long>("CompanyId")
  1076. .HasColumnType("bigint");
  1077. b.Property<DateTime>("CreateDate")
  1078. .HasColumnType("datetime2")
  1079. .HasColumnOrder(3);
  1080. b.Property<string>("CreateUser")
  1081. .HasMaxLength(450)
  1082. .HasColumnType("nvarchar(450)")
  1083. .HasColumnOrder(1);
  1084. b.Property<string>("EmployeeId")
  1085. .IsRequired()
  1086. .HasColumnType("nvarchar(max)");
  1087. b.Property<long?>("LeaveTypeId")
  1088. .HasColumnType("bigint");
  1089. b.Property<int>("NumberOfDays")
  1090. .HasColumnType("int");
  1091. b.Property<long>("OrderTypeId")
  1092. .HasColumnType("bigint");
  1093. b.Property<int>("Period")
  1094. .HasColumnType("int");
  1095. b.Property<DateTime?>("UpdateDate")
  1096. .HasColumnType("datetime2")
  1097. .HasColumnOrder(4);
  1098. b.Property<string>("UpdateUser")
  1099. .HasMaxLength(450)
  1100. .HasColumnType("nvarchar(450)")
  1101. .HasColumnOrder(2);
  1102. b.HasKey("Id");
  1103. b.HasIndex("CompanyId");
  1104. b.HasIndex("LeaveTypeId");
  1105. b.HasIndex("OrderTypeId");
  1106. b.ToTable("OrderAllocations", (string)null);
  1107. });
  1108. modelBuilder.Entity("MTWorkHR.Core.Entities.OrderType", b =>
  1109. {
  1110. b.Property<long>("Id")
  1111. .ValueGeneratedOnAdd()
  1112. .HasColumnType("bigint")
  1113. .HasColumnOrder(0);
  1114. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1115. b.Property<int>("DefaultDays")
  1116. .HasColumnType("int");
  1117. b.Property<string>("NameAr")
  1118. .IsRequired()
  1119. .HasColumnType("nvarchar(max)");
  1120. b.Property<string>("NameEn")
  1121. .IsRequired()
  1122. .HasColumnType("nvarchar(max)");
  1123. b.HasKey("Id");
  1124. b.ToTable("OrderTypes", (string)null);
  1125. b.HasData(
  1126. new
  1127. {
  1128. Id = 1L,
  1129. DefaultDays = 2,
  1130. NameAr = "إذن",
  1131. NameEn = "Leave"
  1132. },
  1133. new
  1134. {
  1135. Id = 2L,
  1136. DefaultDays = 15,
  1137. NameAr = "طبية",
  1138. NameEn = "Medical"
  1139. },
  1140. new
  1141. {
  1142. Id = 3L,
  1143. DefaultDays = 20,
  1144. NameAr = "وقت إضافي",
  1145. NameEn = "Overtime"
  1146. },
  1147. new
  1148. {
  1149. Id = 4L,
  1150. DefaultDays = 0,
  1151. NameAr = "رحلة عمل",
  1152. NameEn = "Business trip"
  1153. },
  1154. new
  1155. {
  1156. Id = 5L,
  1157. DefaultDays = 0,
  1158. NameAr = "دورة تدريبية",
  1159. NameEn = "Course"
  1160. });
  1161. });
  1162. modelBuilder.Entity("MTWorkHR.Core.Entities.Permission", b =>
  1163. {
  1164. b.Property<long>("Id")
  1165. .ValueGeneratedOnAdd()
  1166. .HasColumnType("bigint")
  1167. .HasColumnOrder(0);
  1168. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1169. b.Property<string>("CategoryName")
  1170. .IsRequired()
  1171. .HasMaxLength(150)
  1172. .HasColumnType("nvarchar(150)");
  1173. b.Property<string>("Desc")
  1174. .IsRequired()
  1175. .HasMaxLength(250)
  1176. .HasColumnType("nvarchar(250)");
  1177. b.Property<string>("Name")
  1178. .IsRequired()
  1179. .HasMaxLength(250)
  1180. .HasColumnType("nvarchar(250)");
  1181. b.Property<bool>("Show")
  1182. .HasColumnType("bit");
  1183. b.HasKey("Id");
  1184. b.ToTable("Permissions", (string)null);
  1185. b.HasData(
  1186. new
  1187. {
  1188. Id = 1L,
  1189. CategoryName = "User",
  1190. Desc = "Project",
  1191. Name = "Project",
  1192. Show = true
  1193. },
  1194. new
  1195. {
  1196. Id = 2L,
  1197. CategoryName = "User",
  1198. Desc = "Project.Create",
  1199. Name = "Project.Create",
  1200. Show = false
  1201. },
  1202. new
  1203. {
  1204. Id = 3L,
  1205. CategoryName = "User",
  1206. Desc = "Project.Update",
  1207. Name = "Project.Update",
  1208. Show = false
  1209. },
  1210. new
  1211. {
  1212. Id = 4L,
  1213. CategoryName = "User",
  1214. Desc = "Project.Delete",
  1215. Name = "Project.Delete",
  1216. Show = false
  1217. },
  1218. new
  1219. {
  1220. Id = 5L,
  1221. CategoryName = "User",
  1222. Desc = "Meeting",
  1223. Name = "Meeting",
  1224. Show = true
  1225. },
  1226. new
  1227. {
  1228. Id = 6L,
  1229. CategoryName = "User",
  1230. Desc = "Meeting.Create",
  1231. Name = "Meeting.Create",
  1232. Show = false
  1233. },
  1234. new
  1235. {
  1236. Id = 7L,
  1237. CategoryName = "User",
  1238. Desc = "Meeting.Update",
  1239. Name = "Meeting.Update",
  1240. Show = false
  1241. },
  1242. new
  1243. {
  1244. Id = 8L,
  1245. CategoryName = "User",
  1246. Desc = "Meeting.Delete",
  1247. Name = "Meeting.Delete",
  1248. Show = false
  1249. },
  1250. new
  1251. {
  1252. Id = 9L,
  1253. CategoryName = "User",
  1254. Desc = "Team",
  1255. Name = "Team",
  1256. Show = true
  1257. },
  1258. new
  1259. {
  1260. Id = 10L,
  1261. CategoryName = "User",
  1262. Desc = "Team.Create",
  1263. Name = "Team.Create",
  1264. Show = false
  1265. },
  1266. new
  1267. {
  1268. Id = 11L,
  1269. CategoryName = "User",
  1270. Desc = "Team.Update",
  1271. Name = "Team.Update",
  1272. Show = false
  1273. },
  1274. new
  1275. {
  1276. Id = 12L,
  1277. CategoryName = "User",
  1278. Desc = "Team.Delete",
  1279. Name = "Team.Delete",
  1280. Show = false
  1281. },
  1282. new
  1283. {
  1284. Id = 13L,
  1285. CategoryName = "Sales",
  1286. Desc = "UserTask",
  1287. Name = "UserTask",
  1288. Show = true
  1289. },
  1290. new
  1291. {
  1292. Id = 14L,
  1293. CategoryName = "Sales",
  1294. Desc = "UserTask.Create",
  1295. Name = "UserTask.Create",
  1296. Show = false
  1297. },
  1298. new
  1299. {
  1300. Id = 15L,
  1301. CategoryName = "Sales",
  1302. Desc = "UserTask.Update",
  1303. Name = "UserTask.Update",
  1304. Show = false
  1305. },
  1306. new
  1307. {
  1308. Id = 16L,
  1309. CategoryName = "User",
  1310. Desc = "UserTask.Delete",
  1311. Name = "UserTask.Delete",
  1312. Show = false
  1313. },
  1314. new
  1315. {
  1316. Id = 17L,
  1317. CategoryName = "User",
  1318. Desc = "Company",
  1319. Name = "Company",
  1320. Show = true
  1321. },
  1322. new
  1323. {
  1324. Id = 18L,
  1325. CategoryName = "User",
  1326. Desc = "Company.Create",
  1327. Name = "Company.Create",
  1328. Show = false
  1329. },
  1330. new
  1331. {
  1332. Id = 19L,
  1333. CategoryName = "User",
  1334. Desc = "Company.Update",
  1335. Name = "Company.Update",
  1336. Show = false
  1337. },
  1338. new
  1339. {
  1340. Id = 20L,
  1341. CategoryName = "User",
  1342. Desc = "Company.Delete",
  1343. Name = "Company.Delete",
  1344. Show = false
  1345. },
  1346. new
  1347. {
  1348. Id = 21L,
  1349. CategoryName = "Adminstration",
  1350. Desc = "User",
  1351. Name = "User",
  1352. Show = true
  1353. },
  1354. new
  1355. {
  1356. Id = 22L,
  1357. CategoryName = "Adminstration",
  1358. Desc = "User.Create",
  1359. Name = "User.Create",
  1360. Show = false
  1361. },
  1362. new
  1363. {
  1364. Id = 23L,
  1365. CategoryName = "Adminstration",
  1366. Desc = "User.Update",
  1367. Name = "User.Update",
  1368. Show = false
  1369. },
  1370. new
  1371. {
  1372. Id = 24L,
  1373. CategoryName = "Adminstration",
  1374. Desc = "User.Delete",
  1375. Name = "User.Delete",
  1376. Show = false
  1377. },
  1378. new
  1379. {
  1380. Id = 25L,
  1381. CategoryName = "Adminstration",
  1382. Desc = "Role",
  1383. Name = "Role",
  1384. Show = true
  1385. },
  1386. new
  1387. {
  1388. Id = 26L,
  1389. CategoryName = "Adminstration",
  1390. Desc = "Role.Create",
  1391. Name = "Role.Create",
  1392. Show = false
  1393. },
  1394. new
  1395. {
  1396. Id = 27L,
  1397. CategoryName = "Adminstration",
  1398. Desc = "Role.Update",
  1399. Name = "Role.Update",
  1400. Show = false
  1401. },
  1402. new
  1403. {
  1404. Id = 28L,
  1405. CategoryName = "Adminstration",
  1406. Desc = "Role.Delete",
  1407. Name = "Role.Delete",
  1408. Show = false
  1409. });
  1410. });
  1411. modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b =>
  1412. {
  1413. b.Property<long>("Id")
  1414. .ValueGeneratedOnAdd()
  1415. .HasColumnType("bigint")
  1416. .HasColumnOrder(0);
  1417. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1418. b.Property<long>("CompanyId")
  1419. .HasColumnType("bigint");
  1420. b.Property<DateTime>("CreateDate")
  1421. .HasColumnType("datetime2")
  1422. .HasColumnOrder(3);
  1423. b.Property<string>("CreateUser")
  1424. .HasMaxLength(450)
  1425. .HasColumnType("nvarchar(450)")
  1426. .HasColumnOrder(1);
  1427. b.Property<string>("DeleteUserId")
  1428. .HasMaxLength(450)
  1429. .HasColumnType("nvarchar(450)")
  1430. .HasColumnOrder(8);
  1431. b.Property<string>("Desc")
  1432. .IsRequired()
  1433. .HasColumnType("nvarchar(max)");
  1434. b.Property<bool>("IsDeleted")
  1435. .HasColumnType("bit")
  1436. .HasColumnOrder(7);
  1437. b.Property<string>("NameAr")
  1438. .IsRequired()
  1439. .HasMaxLength(250)
  1440. .HasColumnType("nvarchar(250)");
  1441. b.Property<string>("NameEn")
  1442. .IsRequired()
  1443. .HasMaxLength(250)
  1444. .HasColumnType("nvarchar(250)");
  1445. b.Property<DateTime?>("UpdateDate")
  1446. .HasColumnType("datetime2")
  1447. .HasColumnOrder(4);
  1448. b.Property<string>("UpdateUser")
  1449. .HasMaxLength(450)
  1450. .HasColumnType("nvarchar(450)")
  1451. .HasColumnOrder(2);
  1452. b.HasKey("Id");
  1453. b.HasIndex("CompanyId");
  1454. b.ToTable("Projects", (string)null);
  1455. });
  1456. modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectTeam", b =>
  1457. {
  1458. b.Property<long>("Id")
  1459. .ValueGeneratedOnAdd()
  1460. .HasColumnType("bigint")
  1461. .HasColumnOrder(0);
  1462. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1463. b.Property<DateTime>("CreateDate")
  1464. .HasColumnType("datetime2")
  1465. .HasColumnOrder(3);
  1466. b.Property<string>("CreateUser")
  1467. .HasMaxLength(450)
  1468. .HasColumnType("nvarchar(450)")
  1469. .HasColumnOrder(1);
  1470. b.Property<long>("ProjectId")
  1471. .HasColumnType("bigint");
  1472. b.Property<long>("TeamId")
  1473. .HasColumnType("bigint");
  1474. b.Property<string>("TeamName")
  1475. .IsRequired()
  1476. .HasColumnType("nvarchar(max)");
  1477. b.Property<DateTime?>("UpdateDate")
  1478. .HasColumnType("datetime2")
  1479. .HasColumnOrder(4);
  1480. b.Property<string>("UpdateUser")
  1481. .HasMaxLength(450)
  1482. .HasColumnType("nvarchar(450)")
  1483. .HasColumnOrder(2);
  1484. b.HasKey("Id");
  1485. b.HasIndex("ProjectId");
  1486. b.ToTable("ProjectTeam", (string)null);
  1487. });
  1488. modelBuilder.Entity("MTWorkHR.Core.Entities.Qualification", b =>
  1489. {
  1490. b.Property<long>("Id")
  1491. .ValueGeneratedOnAdd()
  1492. .HasColumnType("bigint")
  1493. .HasColumnOrder(0);
  1494. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1495. b.Property<string>("NameAr")
  1496. .IsRequired()
  1497. .HasMaxLength(250)
  1498. .HasColumnType("nvarchar(250)");
  1499. b.Property<string>("NameEn")
  1500. .IsRequired()
  1501. .HasMaxLength(250)
  1502. .HasColumnType("nvarchar(250)");
  1503. b.HasKey("Id");
  1504. b.ToTable("Qualifications", (string)null);
  1505. b.HasData(
  1506. new
  1507. {
  1508. Id = 1L,
  1509. NameAr = "بكالوريوس",
  1510. NameEn = "BSC"
  1511. },
  1512. new
  1513. {
  1514. Id = 2L,
  1515. NameAr = "درجة الماجيستير",
  1516. NameEn = "Master"
  1517. },
  1518. new
  1519. {
  1520. Id = 3L,
  1521. NameAr = "درحة الدكتوراه",
  1522. NameEn = "Doctor"
  1523. });
  1524. });
  1525. modelBuilder.Entity("MTWorkHR.Core.Entities.RoleLog", b =>
  1526. {
  1527. b.Property<long>("Id")
  1528. .ValueGeneratedOnAdd()
  1529. .HasColumnType("bigint")
  1530. .HasColumnOrder(0);
  1531. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1532. b.Property<string>("Channel")
  1533. .HasColumnType("nvarchar(max)");
  1534. b.Property<DateTime>("CreateDate")
  1535. .HasColumnType("datetime2");
  1536. b.Property<string>("CreateUser")
  1537. .IsRequired()
  1538. .HasColumnType("nvarchar(max)");
  1539. b.Property<string>("ErrorCode")
  1540. .IsRequired()
  1541. .HasColumnType("nvarchar(max)");
  1542. b.Property<string>("ErrorDescription")
  1543. .IsRequired()
  1544. .HasColumnType("nvarchar(max)");
  1545. b.Property<string>("InnerException")
  1546. .HasColumnType("nvarchar(max)");
  1547. b.Property<string>("Input")
  1548. .HasColumnType("nvarchar(max)");
  1549. b.Property<string>("Method")
  1550. .IsRequired()
  1551. .HasColumnType("nvarchar(max)");
  1552. b.Property<string>("QueryString")
  1553. .HasColumnType("nvarchar(max)");
  1554. b.Property<string>("ServerIP")
  1555. .HasColumnType("nvarchar(max)");
  1556. b.Property<string>("ServiceResponseTimeInSeconds")
  1557. .IsRequired()
  1558. .HasColumnType("nvarchar(max)");
  1559. b.Property<string>("UserIP")
  1560. .HasColumnType("nvarchar(max)");
  1561. b.Property<string>("userAgent")
  1562. .HasColumnType("nvarchar(max)");
  1563. b.HasKey("Id");
  1564. b.ToTable("RoleLogs", (string)null);
  1565. });
  1566. modelBuilder.Entity("MTWorkHR.Core.Entities.SettingLog", b =>
  1567. {
  1568. b.Property<long>("Id")
  1569. .ValueGeneratedOnAdd()
  1570. .HasColumnType("bigint")
  1571. .HasColumnOrder(0);
  1572. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1573. b.Property<string>("Channel")
  1574. .HasColumnType("nvarchar(max)");
  1575. b.Property<DateTime>("CreateDate")
  1576. .HasColumnType("datetime2");
  1577. b.Property<string>("CreateUser")
  1578. .IsRequired()
  1579. .HasColumnType("nvarchar(max)");
  1580. b.Property<string>("ErrorCode")
  1581. .IsRequired()
  1582. .HasColumnType("nvarchar(max)");
  1583. b.Property<string>("ErrorDescription")
  1584. .IsRequired()
  1585. .HasColumnType("nvarchar(max)");
  1586. b.Property<string>("InnerException")
  1587. .HasColumnType("nvarchar(max)");
  1588. b.Property<string>("Input")
  1589. .HasColumnType("nvarchar(max)");
  1590. b.Property<string>("Method")
  1591. .IsRequired()
  1592. .HasColumnType("nvarchar(max)");
  1593. b.Property<string>("QueryString")
  1594. .HasColumnType("nvarchar(max)");
  1595. b.Property<string>("ServerIP")
  1596. .HasColumnType("nvarchar(max)");
  1597. b.Property<string>("ServiceResponseTimeInSeconds")
  1598. .IsRequired()
  1599. .HasColumnType("nvarchar(max)");
  1600. b.Property<string>("UserIP")
  1601. .HasColumnType("nvarchar(max)");
  1602. b.Property<string>("userAgent")
  1603. .HasColumnType("nvarchar(max)");
  1604. b.HasKey("Id");
  1605. b.ToTable("SettingLogs", (string)null);
  1606. });
  1607. modelBuilder.Entity("MTWorkHR.Core.Entities.TaskUser", b =>
  1608. {
  1609. b.Property<long>("Id")
  1610. .ValueGeneratedOnAdd()
  1611. .HasColumnType("bigint")
  1612. .HasColumnOrder(0);
  1613. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1614. b.Property<string>("AssignedUserId")
  1615. .IsRequired()
  1616. .HasColumnType("nvarchar(max)");
  1617. b.Property<string>("AssignedUserName")
  1618. .HasColumnType("nvarchar(max)");
  1619. b.Property<DateTime>("CreateDate")
  1620. .HasColumnType("datetime2")
  1621. .HasColumnOrder(3);
  1622. b.Property<string>("CreateUser")
  1623. .HasMaxLength(450)
  1624. .HasColumnType("nvarchar(450)")
  1625. .HasColumnOrder(1);
  1626. b.Property<long>("TaskId")
  1627. .HasColumnType("bigint");
  1628. b.Property<DateTime?>("UpdateDate")
  1629. .HasColumnType("datetime2")
  1630. .HasColumnOrder(4);
  1631. b.Property<string>("UpdateUser")
  1632. .HasMaxLength(450)
  1633. .HasColumnType("nvarchar(450)")
  1634. .HasColumnOrder(2);
  1635. b.HasKey("Id");
  1636. b.HasIndex("TaskId");
  1637. b.ToTable("TaskUser", (string)null);
  1638. });
  1639. modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b =>
  1640. {
  1641. b.Property<long>("Id")
  1642. .ValueGeneratedOnAdd()
  1643. .HasColumnType("bigint")
  1644. .HasColumnOrder(0);
  1645. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1646. b.Property<long>("CompanyId")
  1647. .HasColumnType("bigint");
  1648. b.Property<DateTime>("CreateDate")
  1649. .HasColumnType("datetime2")
  1650. .HasColumnOrder(3);
  1651. b.Property<string>("CreateUser")
  1652. .HasMaxLength(450)
  1653. .HasColumnType("nvarchar(450)")
  1654. .HasColumnOrder(1);
  1655. b.Property<string>("DeleteUserId")
  1656. .HasMaxLength(450)
  1657. .HasColumnType("nvarchar(450)")
  1658. .HasColumnOrder(8);
  1659. b.Property<bool>("IsDeleted")
  1660. .HasColumnType("bit")
  1661. .HasColumnOrder(7);
  1662. b.Property<string>("NameAr")
  1663. .IsRequired()
  1664. .HasMaxLength(250)
  1665. .HasColumnType("nvarchar(250)");
  1666. b.Property<string>("NameEn")
  1667. .IsRequired()
  1668. .HasMaxLength(250)
  1669. .HasColumnType("nvarchar(250)");
  1670. b.Property<DateTime?>("UpdateDate")
  1671. .HasColumnType("datetime2")
  1672. .HasColumnOrder(4);
  1673. b.Property<string>("UpdateUser")
  1674. .HasMaxLength(450)
  1675. .HasColumnType("nvarchar(450)")
  1676. .HasColumnOrder(2);
  1677. b.HasKey("Id");
  1678. b.HasIndex("CompanyId");
  1679. b.ToTable("Teams", (string)null);
  1680. });
  1681. modelBuilder.Entity("MTWorkHR.Core.Entities.TeamLog", b =>
  1682. {
  1683. b.Property<long>("Id")
  1684. .ValueGeneratedOnAdd()
  1685. .HasColumnType("bigint")
  1686. .HasColumnOrder(0);
  1687. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1688. b.Property<string>("Channel")
  1689. .HasColumnType("nvarchar(max)");
  1690. b.Property<DateTime>("CreateDate")
  1691. .HasColumnType("datetime2");
  1692. b.Property<string>("CreateUser")
  1693. .IsRequired()
  1694. .HasColumnType("nvarchar(max)");
  1695. b.Property<string>("ErrorCode")
  1696. .IsRequired()
  1697. .HasColumnType("nvarchar(max)");
  1698. b.Property<string>("ErrorDescription")
  1699. .IsRequired()
  1700. .HasColumnType("nvarchar(max)");
  1701. b.Property<string>("InnerException")
  1702. .HasColumnType("nvarchar(max)");
  1703. b.Property<string>("Input")
  1704. .HasColumnType("nvarchar(max)");
  1705. b.Property<string>("Method")
  1706. .IsRequired()
  1707. .HasColumnType("nvarchar(max)");
  1708. b.Property<string>("QueryString")
  1709. .HasColumnType("nvarchar(max)");
  1710. b.Property<string>("ServerIP")
  1711. .HasColumnType("nvarchar(max)");
  1712. b.Property<string>("ServiceResponseTimeInSeconds")
  1713. .IsRequired()
  1714. .HasColumnType("nvarchar(max)");
  1715. b.Property<string>("UserIP")
  1716. .HasColumnType("nvarchar(max)");
  1717. b.Property<string>("userAgent")
  1718. .HasColumnType("nvarchar(max)");
  1719. b.HasKey("Id");
  1720. b.ToTable("TeamLogs", (string)null);
  1721. });
  1722. modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b =>
  1723. {
  1724. b.Property<long>("Id")
  1725. .ValueGeneratedOnAdd()
  1726. .HasColumnType("bigint")
  1727. .HasColumnOrder(0);
  1728. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1729. b.Property<string>("AssignedUserId")
  1730. .IsRequired()
  1731. .HasColumnType("nvarchar(max)");
  1732. b.Property<string>("AssignedUserName")
  1733. .IsRequired()
  1734. .HasColumnType("nvarchar(max)");
  1735. b.Property<DateTime>("CreateDate")
  1736. .HasColumnType("datetime2")
  1737. .HasColumnOrder(3);
  1738. b.Property<string>("CreateUser")
  1739. .HasMaxLength(450)
  1740. .HasColumnType("nvarchar(450)")
  1741. .HasColumnOrder(1);
  1742. b.Property<bool>("IsAdmin")
  1743. .HasColumnType("bit");
  1744. b.Property<long>("TeamId")
  1745. .HasColumnType("bigint");
  1746. b.Property<DateTime?>("UpdateDate")
  1747. .HasColumnType("datetime2")
  1748. .HasColumnOrder(4);
  1749. b.Property<string>("UpdateUser")
  1750. .HasMaxLength(450)
  1751. .HasColumnType("nvarchar(450)")
  1752. .HasColumnOrder(2);
  1753. b.HasKey("Id");
  1754. b.HasIndex("TeamId");
  1755. b.ToTable("TeamUser", (string)null);
  1756. });
  1757. modelBuilder.Entity("MTWorkHR.Core.Entities.University", b =>
  1758. {
  1759. b.Property<long>("Id")
  1760. .ValueGeneratedOnAdd()
  1761. .HasColumnType("bigint")
  1762. .HasColumnOrder(0);
  1763. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1764. b.Property<string>("NameAr")
  1765. .IsRequired()
  1766. .HasMaxLength(250)
  1767. .HasColumnType("nvarchar(250)");
  1768. b.Property<string>("NameEn")
  1769. .IsRequired()
  1770. .HasMaxLength(250)
  1771. .HasColumnType("nvarchar(250)");
  1772. b.HasKey("Id");
  1773. b.ToTable("Universities", (string)null);
  1774. b.HasData(
  1775. new
  1776. {
  1777. Id = 1L,
  1778. NameAr = "جامعة الملك فهد",
  1779. NameEn = "Fahd Univ"
  1780. },
  1781. new
  1782. {
  1783. Id = 2L,
  1784. NameAr = "جامعة الرياض",
  1785. NameEn = "Riydh Univ"
  1786. },
  1787. new
  1788. {
  1789. Id = 3L,
  1790. NameAr = "جامعة جدة",
  1791. NameEn = "Geda Univ"
  1792. });
  1793. });
  1794. modelBuilder.Entity("MTWorkHR.Core.Entities.User.OrderRequest", b =>
  1795. {
  1796. b.Property<long>("Id")
  1797. .ValueGeneratedOnAdd()
  1798. .HasColumnType("bigint")
  1799. .HasColumnOrder(0);
  1800. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1801. b.Property<int?>("CityId")
  1802. .HasColumnType("int");
  1803. b.Property<long>("CompanyId")
  1804. .HasColumnType("bigint");
  1805. b.Property<int?>("CountryId")
  1806. .HasColumnType("int");
  1807. b.Property<DateTime>("CreateDate")
  1808. .HasColumnType("datetime2")
  1809. .HasColumnOrder(3);
  1810. b.Property<string>("CreateUser")
  1811. .HasMaxLength(450)
  1812. .HasColumnType("nvarchar(450)")
  1813. .HasColumnOrder(1);
  1814. b.Property<string>("DeleteUserId")
  1815. .HasMaxLength(450)
  1816. .HasColumnType("nvarchar(450)")
  1817. .HasColumnOrder(8);
  1818. b.Property<DateTime?>("EndDate")
  1819. .HasColumnType("datetime2");
  1820. b.Property<string>("EndTime")
  1821. .HasColumnType("nvarchar(max)");
  1822. b.Property<bool>("IsDeleted")
  1823. .HasColumnType("bit")
  1824. .HasColumnOrder(7);
  1825. b.Property<long?>("LeaveTypeId")
  1826. .HasColumnType("bigint");
  1827. b.Property<int?>("OrderStatus")
  1828. .HasColumnType("int");
  1829. b.Property<long>("OrderTypeId")
  1830. .HasColumnType("bigint");
  1831. b.Property<string>("RequestComments")
  1832. .HasColumnType("nvarchar(max)");
  1833. b.Property<string>("RequestingEmployeeId")
  1834. .IsRequired()
  1835. .HasColumnType("nvarchar(max)");
  1836. b.Property<DateTime>("StartDate")
  1837. .HasColumnType("datetime2");
  1838. b.Property<string>("StartTime")
  1839. .HasColumnType("nvarchar(max)");
  1840. b.Property<DateTime?>("UpdateDate")
  1841. .HasColumnType("datetime2")
  1842. .HasColumnOrder(4);
  1843. b.Property<string>("UpdateUser")
  1844. .HasMaxLength(450)
  1845. .HasColumnType("nvarchar(450)")
  1846. .HasColumnOrder(2);
  1847. b.HasKey("Id");
  1848. b.HasIndex("CompanyId");
  1849. b.HasIndex("LeaveTypeId");
  1850. b.HasIndex("OrderTypeId");
  1851. b.ToTable("OrderRequests", (string)null);
  1852. });
  1853. modelBuilder.Entity("MTWorkHR.Core.Entities.UserLog", b =>
  1854. {
  1855. b.Property<long>("Id")
  1856. .ValueGeneratedOnAdd()
  1857. .HasColumnType("bigint")
  1858. .HasColumnOrder(0);
  1859. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1860. b.Property<string>("Channel")
  1861. .HasColumnType("nvarchar(max)");
  1862. b.Property<DateTime>("CreateDate")
  1863. .HasColumnType("datetime2");
  1864. b.Property<string>("CreateUser")
  1865. .IsRequired()
  1866. .HasColumnType("nvarchar(max)");
  1867. b.Property<string>("ErrorCode")
  1868. .IsRequired()
  1869. .HasColumnType("nvarchar(max)");
  1870. b.Property<string>("ErrorDescription")
  1871. .IsRequired()
  1872. .HasColumnType("nvarchar(max)");
  1873. b.Property<string>("InnerException")
  1874. .HasColumnType("nvarchar(max)");
  1875. b.Property<string>("Input")
  1876. .HasColumnType("nvarchar(max)");
  1877. b.Property<string>("Method")
  1878. .IsRequired()
  1879. .HasColumnType("nvarchar(max)");
  1880. b.Property<string>("QueryString")
  1881. .HasColumnType("nvarchar(max)");
  1882. b.Property<string>("ServerIP")
  1883. .HasColumnType("nvarchar(max)");
  1884. b.Property<string>("ServiceResponseTimeInSeconds")
  1885. .IsRequired()
  1886. .HasColumnType("nvarchar(max)");
  1887. b.Property<string>("UserIP")
  1888. .HasColumnType("nvarchar(max)");
  1889. b.Property<string>("userAgent")
  1890. .HasColumnType("nvarchar(max)");
  1891. b.HasKey("Id");
  1892. b.ToTable("UserLogs", (string)null);
  1893. });
  1894. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
  1895. {
  1896. b.Property<long>("Id")
  1897. .ValueGeneratedOnAdd()
  1898. .HasColumnType("bigint")
  1899. .HasColumnOrder(0);
  1900. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1901. b.Property<string>("AssignedUserId")
  1902. .IsRequired()
  1903. .HasColumnType("nvarchar(max)");
  1904. b.Property<long>("CompanyId")
  1905. .HasColumnType("bigint");
  1906. b.Property<DateTime>("CreateDate")
  1907. .HasColumnType("datetime2")
  1908. .HasColumnOrder(3);
  1909. b.Property<string>("CreateUser")
  1910. .HasMaxLength(450)
  1911. .HasColumnType("nvarchar(450)")
  1912. .HasColumnOrder(1);
  1913. b.Property<string>("DeleteUserId")
  1914. .HasMaxLength(450)
  1915. .HasColumnType("nvarchar(450)")
  1916. .HasColumnOrder(8);
  1917. b.Property<string>("Description")
  1918. .IsRequired()
  1919. .HasColumnType("nvarchar(max)");
  1920. b.Property<DateTime>("DueDate")
  1921. .HasColumnType("datetime2");
  1922. b.Property<bool>("IsDeleted")
  1923. .HasColumnType("bit")
  1924. .HasColumnOrder(7);
  1925. b.Property<int>("Priority")
  1926. .HasColumnType("int");
  1927. b.Property<long>("ProjectId")
  1928. .HasColumnType("bigint");
  1929. b.Property<long>("StatusId")
  1930. .HasColumnType("bigint");
  1931. b.Property<string>("Title")
  1932. .IsRequired()
  1933. .HasColumnType("nvarchar(max)");
  1934. b.Property<DateTime?>("UpdateDate")
  1935. .HasColumnType("datetime2")
  1936. .HasColumnOrder(4);
  1937. b.Property<string>("UpdateUser")
  1938. .HasMaxLength(450)
  1939. .HasColumnType("nvarchar(450)")
  1940. .HasColumnOrder(2);
  1941. b.HasKey("Id");
  1942. b.HasIndex("CompanyId");
  1943. b.HasIndex("ProjectId");
  1944. b.HasIndex("StatusId");
  1945. b.ToTable("UserTasks", (string)null);
  1946. });
  1947. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b =>
  1948. {
  1949. b.Property<long>("Id")
  1950. .ValueGeneratedOnAdd()
  1951. .HasColumnType("bigint")
  1952. .HasColumnOrder(0);
  1953. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1954. b.Property<long?>("AttachmentTypeId")
  1955. .HasColumnType("bigint");
  1956. b.Property<byte[]>("Content")
  1957. .IsRequired()
  1958. .HasColumnType("varbinary(max)");
  1959. b.Property<string>("ContentType")
  1960. .HasColumnType("nvarchar(max)");
  1961. b.Property<DateTime>("CreateDate")
  1962. .HasColumnType("datetime2")
  1963. .HasColumnOrder(3);
  1964. b.Property<string>("CreateUser")
  1965. .HasMaxLength(450)
  1966. .HasColumnType("nvarchar(450)")
  1967. .HasColumnOrder(1);
  1968. b.Property<string>("FileName")
  1969. .HasMaxLength(250)
  1970. .HasColumnType("nvarchar(250)");
  1971. b.Property<string>("FilePath")
  1972. .HasColumnType("nvarchar(max)");
  1973. b.Property<string>("OriginalName")
  1974. .HasMaxLength(250)
  1975. .HasColumnType("nvarchar(250)");
  1976. b.Property<long>("TaskId")
  1977. .HasColumnType("bigint");
  1978. b.Property<DateTime?>("UpdateDate")
  1979. .HasColumnType("datetime2")
  1980. .HasColumnOrder(4);
  1981. b.Property<string>("UpdateUser")
  1982. .HasMaxLength(450)
  1983. .HasColumnType("nvarchar(450)")
  1984. .HasColumnOrder(2);
  1985. b.HasKey("Id");
  1986. b.HasIndex("AttachmentTypeId");
  1987. b.HasIndex("TaskId");
  1988. b.ToTable("UserTaskAttachments", (string)null);
  1989. });
  1990. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b =>
  1991. {
  1992. b.Property<long>("Id")
  1993. .ValueGeneratedOnAdd()
  1994. .HasColumnType("bigint")
  1995. .HasColumnOrder(0);
  1996. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1997. b.Property<string>("AssignedToUserId")
  1998. .HasColumnType("nvarchar(max)");
  1999. b.Property<string>("Comment")
  2000. .HasMaxLength(500)
  2001. .HasColumnType("nvarchar(500)");
  2002. b.Property<DateTime>("CreateDate")
  2003. .HasColumnType("datetime2")
  2004. .HasColumnOrder(3);
  2005. b.Property<string>("CreateUser")
  2006. .HasMaxLength(450)
  2007. .HasColumnType("nvarchar(450)")
  2008. .HasColumnOrder(1);
  2009. b.Property<long>("CurrentStatusId")
  2010. .HasColumnType("bigint");
  2011. b.Property<bool>("IsDeleted")
  2012. .HasColumnType("bit");
  2013. b.Property<long>("TaskId")
  2014. .HasColumnType("bigint");
  2015. b.Property<DateTime?>("UpdateDate")
  2016. .HasColumnType("datetime2")
  2017. .HasColumnOrder(4);
  2018. b.Property<string>("UpdateUser")
  2019. .HasMaxLength(450)
  2020. .HasColumnType("nvarchar(450)")
  2021. .HasColumnOrder(2);
  2022. b.HasKey("Id");
  2023. b.HasIndex("CurrentStatusId");
  2024. b.HasIndex("TaskId");
  2025. b.ToTable("UserTaskHistories", (string)null);
  2026. });
  2027. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskLog", b =>
  2028. {
  2029. b.Property<long>("Id")
  2030. .ValueGeneratedOnAdd()
  2031. .HasColumnType("bigint")
  2032. .HasColumnOrder(0);
  2033. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  2034. b.Property<string>("Channel")
  2035. .HasColumnType("nvarchar(max)");
  2036. b.Property<DateTime>("CreateDate")
  2037. .HasColumnType("datetime2");
  2038. b.Property<string>("CreateUser")
  2039. .IsRequired()
  2040. .HasColumnType("nvarchar(max)");
  2041. b.Property<string>("ErrorCode")
  2042. .IsRequired()
  2043. .HasColumnType("nvarchar(max)");
  2044. b.Property<string>("ErrorDescription")
  2045. .IsRequired()
  2046. .HasColumnType("nvarchar(max)");
  2047. b.Property<string>("InnerException")
  2048. .HasColumnType("nvarchar(max)");
  2049. b.Property<string>("Input")
  2050. .HasColumnType("nvarchar(max)");
  2051. b.Property<string>("Method")
  2052. .IsRequired()
  2053. .HasColumnType("nvarchar(max)");
  2054. b.Property<string>("QueryString")
  2055. .HasColumnType("nvarchar(max)");
  2056. b.Property<string>("ServerIP")
  2057. .HasColumnType("nvarchar(max)");
  2058. b.Property<string>("ServiceResponseTimeInSeconds")
  2059. .IsRequired()
  2060. .HasColumnType("nvarchar(max)");
  2061. b.Property<string>("UserIP")
  2062. .HasColumnType("nvarchar(max)");
  2063. b.Property<string>("userAgent")
  2064. .HasColumnType("nvarchar(max)");
  2065. b.HasKey("Id");
  2066. b.ToTable("UserTaskLogs", (string)null);
  2067. });
  2068. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskStatus", b =>
  2069. {
  2070. b.Property<long>("Id")
  2071. .ValueGeneratedOnAdd()
  2072. .HasColumnType("bigint")
  2073. .HasColumnOrder(0);
  2074. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  2075. b.Property<string>("NameAr")
  2076. .IsRequired()
  2077. .HasMaxLength(250)
  2078. .HasColumnType("nvarchar(250)");
  2079. b.Property<string>("NameEn")
  2080. .IsRequired()
  2081. .HasMaxLength(250)
  2082. .HasColumnType("nvarchar(250)");
  2083. b.HasKey("Id");
  2084. b.ToTable("UserTaskStatuses", (string)null);
  2085. b.HasData(
  2086. new
  2087. {
  2088. Id = 1L,
  2089. NameAr = "جديدة",
  2090. NameEn = "To Do"
  2091. },
  2092. new
  2093. {
  2094. Id = 2L,
  2095. NameAr = "قيد العمل",
  2096. NameEn = "In progress"
  2097. },
  2098. new
  2099. {
  2100. Id = 3L,
  2101. NameAr = "تحتاج مراجعة",
  2102. NameEn = "Need Review"
  2103. },
  2104. new
  2105. {
  2106. Id = 4L,
  2107. NameAr = "تمت",
  2108. NameEn = "Done"
  2109. });
  2110. });
  2111. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b =>
  2112. {
  2113. b.Property<string>("Id")
  2114. .HasColumnType("nvarchar(450)");
  2115. b.Property<string>("ConcurrencyStamp")
  2116. .IsConcurrencyToken()
  2117. .HasColumnType("nvarchar(max)");
  2118. b.Property<DateTime>("CreateDate")
  2119. .HasColumnType("datetime2");
  2120. b.Property<string>("CreateUser")
  2121. .HasColumnType("nvarchar(max)");
  2122. b.Property<string>("DeleteUserId")
  2123. .HasColumnType("nvarchar(max)");
  2124. b.Property<bool?>("IsAdmin")
  2125. .HasColumnType("bit");
  2126. b.Property<bool>("IsDeleted")
  2127. .HasColumnType("bit");
  2128. b.Property<string>("Name")
  2129. .HasMaxLength(256)
  2130. .HasColumnType("nvarchar(256)");
  2131. b.Property<string>("NormalizedName")
  2132. .HasMaxLength(256)
  2133. .HasColumnType("nvarchar(256)");
  2134. b.Property<DateTime?>("UpdateDate")
  2135. .HasColumnType("datetime2");
  2136. b.Property<string>("UpdateUser")
  2137. .HasColumnType("nvarchar(max)");
  2138. b.HasKey("Id");
  2139. b.HasIndex("NormalizedName")
  2140. .IsUnique()
  2141. .HasDatabaseName("RoleNameIndex")
  2142. .HasFilter("[NormalizedName] IS NOT NULL");
  2143. b.ToTable("AspNetRoles", (string)null);
  2144. b.HasData(
  2145. new
  2146. {
  2147. Id = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A",
  2148. CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2149. IsAdmin = true,
  2150. IsDeleted = false,
  2151. Name = "Admin",
  2152. NormalizedName = "ADMIN"
  2153. },
  2154. new
  2155. {
  2156. Id = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E",
  2157. CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2158. IsAdmin = false,
  2159. IsDeleted = false,
  2160. Name = "Employee",
  2161. NormalizedName = "EMPLOYEE"
  2162. },
  2163. new
  2164. {
  2165. Id = "CO5B3B92-2311-48F8-9DEC-F9FAEF1F211R",
  2166. CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2167. IsAdmin = false,
  2168. IsDeleted = false,
  2169. Name = "Contractor",
  2170. NormalizedName = "CONTRACTOR"
  2171. });
  2172. });
  2173. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
  2174. {
  2175. b.Property<string>("Id")
  2176. .HasColumnType("nvarchar(450)");
  2177. b.Property<int>("AccessFailedCount")
  2178. .HasColumnType("int");
  2179. b.Property<long?>("CompanyId")
  2180. .HasColumnType("bigint");
  2181. b.Property<string>("ConcurrencyStamp")
  2182. .IsConcurrencyToken()
  2183. .HasColumnType("nvarchar(max)");
  2184. b.Property<long?>("CountryId")
  2185. .HasColumnType("bigint");
  2186. b.Property<string>("CreateUser")
  2187. .HasColumnType("nvarchar(max)");
  2188. b.Property<DateTime>("DateOfBirth")
  2189. .HasColumnType("datetime2");
  2190. b.Property<string>("DeleteUserId")
  2191. .HasColumnType("nvarchar(max)");
  2192. b.Property<string>("Email")
  2193. .HasMaxLength(256)
  2194. .HasColumnType("nvarchar(256)");
  2195. b.Property<bool>("EmailConfirmed")
  2196. .HasColumnType("bit");
  2197. b.Property<string>("FavoriteName")
  2198. .HasColumnType("nvarchar(max)");
  2199. b.Property<string>("FirstName")
  2200. .IsRequired()
  2201. .HasColumnType("nvarchar(max)");
  2202. b.Property<string>("IdNumber")
  2203. .IsRequired()
  2204. .HasColumnType("nvarchar(max)");
  2205. b.Property<decimal?>("IncomeTaxValue")
  2206. .HasColumnType("decimal(18,2)");
  2207. b.Property<long?>("IndustryId")
  2208. .HasColumnType("bigint");
  2209. b.Property<bool>("IsDeleted")
  2210. .HasColumnType("bit");
  2211. b.Property<bool>("IsStopped")
  2212. .HasColumnType("bit");
  2213. b.Property<long?>("JobTitleId")
  2214. .HasColumnType("bigint");
  2215. b.Property<string>("LastName")
  2216. .IsRequired()
  2217. .HasColumnType("nvarchar(max)");
  2218. b.Property<string>("LinkedInLink")
  2219. .HasColumnType("nvarchar(max)");
  2220. b.Property<bool>("LockoutEnabled")
  2221. .HasColumnType("bit");
  2222. b.Property<DateTimeOffset?>("LockoutEnd")
  2223. .HasColumnType("datetimeoffset");
  2224. b.Property<string>("ManagerId")
  2225. .HasColumnType("nvarchar(450)");
  2226. b.Property<string>("NormalizedEmail")
  2227. .HasMaxLength(256)
  2228. .HasColumnType("nvarchar(256)");
  2229. b.Property<string>("NormalizedUserName")
  2230. .HasMaxLength(256)
  2231. .HasColumnType("nvarchar(256)");
  2232. b.Property<string>("PassportNumber")
  2233. .IsRequired()
  2234. .HasColumnType("nvarchar(max)");
  2235. b.Property<string>("PasswordHash")
  2236. .HasColumnType("nvarchar(max)");
  2237. b.Property<string>("PhoneNumber")
  2238. .HasColumnType("nvarchar(max)");
  2239. b.Property<bool>("PhoneNumberConfirmed")
  2240. .HasColumnType("bit");
  2241. b.Property<string>("Position")
  2242. .HasColumnType("nvarchar(max)");
  2243. b.Property<long?>("QualificationId")
  2244. .HasColumnType("bigint");
  2245. b.Property<string>("SecurityStamp")
  2246. .HasColumnType("nvarchar(max)");
  2247. b.Property<decimal?>("TaxNumber")
  2248. .HasColumnType("decimal(18,2)");
  2249. b.Property<bool>("TwoFactorEnabled")
  2250. .HasColumnType("bit");
  2251. b.Property<long?>("UniversityId")
  2252. .HasColumnType("bigint");
  2253. b.Property<string>("UpdateUser")
  2254. .HasColumnType("nvarchar(max)");
  2255. b.Property<string>("UserName")
  2256. .HasMaxLength(256)
  2257. .HasColumnType("nvarchar(256)");
  2258. b.Property<int>("UserType")
  2259. .HasColumnType("int");
  2260. b.HasKey("Id");
  2261. b.HasIndex("CountryId");
  2262. b.HasIndex("IndustryId");
  2263. b.HasIndex("JobTitleId");
  2264. b.HasIndex("ManagerId");
  2265. b.HasIndex("NormalizedEmail")
  2266. .HasDatabaseName("EmailIndex");
  2267. b.HasIndex("NormalizedUserName")
  2268. .IsUnique()
  2269. .HasDatabaseName("UserNameIndex")
  2270. .HasFilter("[NormalizedUserName] IS NOT NULL");
  2271. b.HasIndex("QualificationId");
  2272. b.HasIndex("UniversityId");
  2273. b.ToTable("AspNetUsers", (string)null);
  2274. b.HasData(
  2275. new
  2276. {
  2277. Id = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA",
  2278. AccessFailedCount = 0,
  2279. CompanyId = 1L,
  2280. ConcurrencyStamp = "7cc87689-9eab-4280-b8e3-1834080783a5",
  2281. DateOfBirth = new DateTime(2000, 2, 10, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2282. Email = "a@b.com",
  2283. EmailConfirmed = true,
  2284. FirstName = "Zinab",
  2285. IdNumber = "123",
  2286. IncomeTaxValue = 1m,
  2287. IsDeleted = false,
  2288. IsStopped = false,
  2289. LastName = "Elgendy",
  2290. LockoutEnabled = false,
  2291. NormalizedEmail = "A@B.COM",
  2292. NormalizedUserName = "A@B.COM",
  2293. PassportNumber = "1234567",
  2294. PasswordHash = "AQAAAAIAAYagAAAAEPg+ASbciPFxtyxQq8Wx5ilBUQ0RbAoITXXkOQm1PzC5BzySX0sn/wUmOjBKPDGV9w==",
  2295. PhoneNumber = "1234567890",
  2296. PhoneNumberConfirmed = true,
  2297. SecurityStamp = "49bb16c3-4704-4c60-908d-dc8506950acc",
  2298. TaxNumber = 111m,
  2299. TwoFactorEnabled = false,
  2300. UserName = "A@b.com",
  2301. UserType = 1
  2302. },
  2303. new
  2304. {
  2305. Id = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
  2306. AccessFailedCount = 0,
  2307. CompanyId = 1L,
  2308. ConcurrencyStamp = "4af7b4cf-802a-455b-b598-997e167745b3",
  2309. DateOfBirth = new DateTime(2001, 5, 13, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2310. Email = "ali@b.com",
  2311. EmailConfirmed = true,
  2312. FirstName = "Ali",
  2313. IdNumber = "343434",
  2314. IncomeTaxValue = 100m,
  2315. IsDeleted = false,
  2316. IsStopped = false,
  2317. LastName = "Farok",
  2318. LockoutEnabled = false,
  2319. NormalizedEmail = "ALI@B.COM",
  2320. NormalizedUserName = "ALI@B.COM",
  2321. PassportNumber = "7654321001010",
  2322. PasswordHash = "AQAAAAIAAYagAAAAEI3QJkcZjCH4Y8Db4rEgL8Mmll5oCvYcWiXZjQSN9bGW4SMcjHe3ZPMnkN/l9DmJeQ==",
  2323. PhoneNumber = "1234567888",
  2324. PhoneNumberConfirmed = true,
  2325. SecurityStamp = "62549056-1b9d-46d4-84f8-adea3e4d8b68",
  2326. TaxNumber = 222m,
  2327. TwoFactorEnabled = false,
  2328. UserName = "Ali@b.com",
  2329. UserType = 1
  2330. });
  2331. });
  2332. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b =>
  2333. {
  2334. b.Property<long>("Id")
  2335. .ValueGeneratedOnAdd()
  2336. .HasColumnType("bigint")
  2337. .HasColumnOrder(0);
  2338. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  2339. b.Property<long>("PermissionId")
  2340. .HasColumnType("bigint");
  2341. b.Property<string>("PermissionName")
  2342. .IsRequired()
  2343. .HasColumnType("nvarchar(max)");
  2344. b.Property<string>("RoleId")
  2345. .IsRequired()
  2346. .HasColumnType("nvarchar(450)");
  2347. b.HasKey("Id");
  2348. b.HasIndex("PermissionId");
  2349. b.HasIndex("RoleId");
  2350. b.ToTable("RolePermissions", (string)null);
  2351. });
  2352. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAddress", b =>
  2353. {
  2354. b.Property<long>("Id")
  2355. .ValueGeneratedOnAdd()
  2356. .HasColumnType("bigint")
  2357. .HasColumnOrder(0);
  2358. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  2359. b.Property<string>("AddressDesc")
  2360. .HasColumnType("nvarchar(max)");
  2361. b.Property<long?>("CityId")
  2362. .HasColumnType("bigint");
  2363. b.Property<long?>("CountryId")
  2364. .HasColumnType("bigint");
  2365. b.Property<DateTime>("CreateDate")
  2366. .HasColumnType("datetime2")
  2367. .HasColumnOrder(3);
  2368. b.Property<string>("CreateUser")
  2369. .HasMaxLength(450)
  2370. .HasColumnType("nvarchar(450)")
  2371. .HasColumnOrder(1);
  2372. b.Property<string>("PostalCode")
  2373. .HasColumnType("nvarchar(max)");
  2374. b.Property<DateTime?>("UpdateDate")
  2375. .HasColumnType("datetime2")
  2376. .HasColumnOrder(4);
  2377. b.Property<string>("UpdateUser")
  2378. .HasMaxLength(450)
  2379. .HasColumnType("nvarchar(450)")
  2380. .HasColumnOrder(2);
  2381. b.Property<string>("UserId")
  2382. .IsRequired()
  2383. .HasColumnType("nvarchar(450)");
  2384. b.HasKey("Id");
  2385. b.HasIndex("CityId");
  2386. b.HasIndex("CountryId");
  2387. b.HasIndex("UserId")
  2388. .IsUnique();
  2389. b.ToTable("UserAddress", (string)null);
  2390. });
  2391. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b =>
  2392. {
  2393. b.Property<long>("Id")
  2394. .ValueGeneratedOnAdd()
  2395. .HasColumnType("bigint")
  2396. .HasColumnOrder(0);
  2397. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  2398. b.Property<long>("AttachmentTypeId")
  2399. .HasColumnType("bigint");
  2400. b.Property<byte[]>("Content")
  2401. .IsRequired()
  2402. .HasColumnType("varbinary(max)");
  2403. b.Property<string>("ContentType")
  2404. .HasColumnType("nvarchar(max)");
  2405. b.Property<DateTime>("CreateDate")
  2406. .HasColumnType("datetime2")
  2407. .HasColumnOrder(3);
  2408. b.Property<string>("CreateUser")
  2409. .HasMaxLength(450)
  2410. .HasColumnType("nvarchar(450)")
  2411. .HasColumnOrder(1);
  2412. b.Property<string>("FileName")
  2413. .IsRequired()
  2414. .HasMaxLength(250)
  2415. .HasColumnType("nvarchar(250)");
  2416. b.Property<string>("FilePath")
  2417. .HasColumnType("nvarchar(max)");
  2418. b.Property<string>("OriginalName")
  2419. .IsRequired()
  2420. .HasMaxLength(250)
  2421. .HasColumnType("nvarchar(250)");
  2422. b.Property<DateTime?>("UpdateDate")
  2423. .HasColumnType("datetime2")
  2424. .HasColumnOrder(4);
  2425. b.Property<string>("UpdateUser")
  2426. .HasMaxLength(450)
  2427. .HasColumnType("nvarchar(450)")
  2428. .HasColumnOrder(2);
  2429. b.Property<string>("UserId")
  2430. .IsRequired()
  2431. .HasColumnType("nvarchar(450)");
  2432. b.HasKey("Id");
  2433. b.HasIndex("AttachmentTypeId");
  2434. b.HasIndex("UserId");
  2435. b.ToTable("UserAttachments", (string)null);
  2436. });
  2437. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
  2438. {
  2439. b.Property<int>("Id")
  2440. .ValueGeneratedOnAdd()
  2441. .HasColumnType("int");
  2442. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  2443. b.Property<string>("ClaimType")
  2444. .HasColumnType("nvarchar(max)");
  2445. b.Property<string>("ClaimValue")
  2446. .HasColumnType("nvarchar(max)");
  2447. b.Property<string>("RoleId")
  2448. .IsRequired()
  2449. .HasColumnType("nvarchar(450)");
  2450. b.HasKey("Id");
  2451. b.HasIndex("RoleId");
  2452. b.ToTable("AspNetRoleClaims", (string)null);
  2453. });
  2454. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
  2455. {
  2456. b.Property<int>("Id")
  2457. .ValueGeneratedOnAdd()
  2458. .HasColumnType("int");
  2459. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  2460. b.Property<string>("ClaimType")
  2461. .HasColumnType("nvarchar(max)");
  2462. b.Property<string>("ClaimValue")
  2463. .HasColumnType("nvarchar(max)");
  2464. b.Property<string>("UserId")
  2465. .IsRequired()
  2466. .HasColumnType("nvarchar(450)");
  2467. b.HasKey("Id");
  2468. b.HasIndex("UserId");
  2469. b.ToTable("AspNetUserClaims", (string)null);
  2470. });
  2471. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
  2472. {
  2473. b.Property<string>("LoginProvider")
  2474. .HasColumnType("nvarchar(450)");
  2475. b.Property<string>("ProviderKey")
  2476. .HasColumnType("nvarchar(450)");
  2477. b.Property<string>("ProviderDisplayName")
  2478. .HasColumnType("nvarchar(max)");
  2479. b.Property<string>("UserId")
  2480. .IsRequired()
  2481. .HasColumnType("nvarchar(450)");
  2482. b.HasKey("LoginProvider", "ProviderKey");
  2483. b.HasIndex("UserId");
  2484. b.ToTable("AspNetUserLogins", (string)null);
  2485. });
  2486. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
  2487. {
  2488. b.Property<string>("UserId")
  2489. .HasColumnType("nvarchar(450)");
  2490. b.Property<string>("RoleId")
  2491. .HasColumnType("nvarchar(450)");
  2492. b.HasKey("UserId", "RoleId");
  2493. b.HasIndex("RoleId");
  2494. b.ToTable("AspNetUserRoles", (string)null);
  2495. b.HasData(
  2496. new
  2497. {
  2498. UserId = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA",
  2499. RoleId = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A"
  2500. },
  2501. new
  2502. {
  2503. UserId = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
  2504. RoleId = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E"
  2505. });
  2506. });
  2507. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
  2508. {
  2509. b.Property<string>("UserId")
  2510. .HasColumnType("nvarchar(450)");
  2511. b.Property<string>("LoginProvider")
  2512. .HasColumnType("nvarchar(450)");
  2513. b.Property<string>("Name")
  2514. .HasColumnType("nvarchar(450)");
  2515. b.Property<string>("Value")
  2516. .HasColumnType("nvarchar(max)");
  2517. b.HasKey("UserId", "LoginProvider", "Name");
  2518. b.ToTable("AspNetUserTokens", (string)null);
  2519. });
  2520. modelBuilder.Entity("ApplicationRoleApplicationUser", b =>
  2521. {
  2522. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
  2523. .WithMany()
  2524. .HasForeignKey("UserRolesId")
  2525. .OnDelete(DeleteBehavior.Cascade)
  2526. .IsRequired();
  2527. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2528. .WithMany()
  2529. .HasForeignKey("UsersId")
  2530. .OnDelete(DeleteBehavior.Cascade)
  2531. .IsRequired();
  2532. });
  2533. modelBuilder.Entity("MTWorkHR.Core.Entities.City", b =>
  2534. {
  2535. b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
  2536. .WithMany()
  2537. .HasForeignKey("CountryId")
  2538. .OnDelete(DeleteBehavior.Cascade)
  2539. .IsRequired();
  2540. b.Navigation("Country");
  2541. });
  2542. modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b =>
  2543. {
  2544. b.HasOne("MTWorkHR.Core.Entities.Meeting", "Meeting")
  2545. .WithMany("MeetingUsers")
  2546. .HasForeignKey("MeetingId")
  2547. .OnDelete(DeleteBehavior.Cascade)
  2548. .IsRequired();
  2549. b.Navigation("Meeting");
  2550. });
  2551. modelBuilder.Entity("MTWorkHR.Core.Entities.OrderAllocation", b =>
  2552. {
  2553. b.HasOne("MTWorkHR.Core.Entities.LeaveType", "LeaveType")
  2554. .WithMany()
  2555. .HasForeignKey("LeaveTypeId");
  2556. b.HasOne("MTWorkHR.Core.Entities.OrderType", "OrderType")
  2557. .WithMany()
  2558. .HasForeignKey("OrderTypeId")
  2559. .OnDelete(DeleteBehavior.Cascade)
  2560. .IsRequired();
  2561. b.Navigation("LeaveType");
  2562. b.Navigation("OrderType");
  2563. });
  2564. modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectTeam", b =>
  2565. {
  2566. b.HasOne("MTWorkHR.Core.Entities.Project", "Project")
  2567. .WithMany("ProjectTeams")
  2568. .HasForeignKey("ProjectId")
  2569. .OnDelete(DeleteBehavior.Cascade)
  2570. .IsRequired();
  2571. b.Navigation("Project");
  2572. });
  2573. modelBuilder.Entity("MTWorkHR.Core.Entities.TaskUser", b =>
  2574. {
  2575. b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask")
  2576. .WithMany("TaskUsers")
  2577. .HasForeignKey("TaskId")
  2578. .OnDelete(DeleteBehavior.Cascade)
  2579. .IsRequired();
  2580. b.Navigation("UserTask");
  2581. });
  2582. modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b =>
  2583. {
  2584. b.HasOne("MTWorkHR.Core.Entities.Team", "Team")
  2585. .WithMany("TeamUsers")
  2586. .HasForeignKey("TeamId")
  2587. .OnDelete(DeleteBehavior.Cascade)
  2588. .IsRequired();
  2589. b.Navigation("Team");
  2590. });
  2591. modelBuilder.Entity("MTWorkHR.Core.Entities.User.OrderRequest", b =>
  2592. {
  2593. b.HasOne("MTWorkHR.Core.Entities.LeaveType", "LeaveType")
  2594. .WithMany()
  2595. .HasForeignKey("LeaveTypeId");
  2596. b.HasOne("MTWorkHR.Core.Entities.OrderType", "OrderType")
  2597. .WithMany()
  2598. .HasForeignKey("OrderTypeId")
  2599. .OnDelete(DeleteBehavior.Cascade)
  2600. .IsRequired();
  2601. b.Navigation("LeaveType");
  2602. b.Navigation("OrderType");
  2603. });
  2604. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
  2605. {
  2606. b.HasOne("MTWorkHR.Core.Entities.Project", "Project")
  2607. .WithMany()
  2608. .HasForeignKey("ProjectId")
  2609. .OnDelete(DeleteBehavior.Cascade)
  2610. .IsRequired();
  2611. b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus")
  2612. .WithMany()
  2613. .HasForeignKey("StatusId")
  2614. .OnDelete(DeleteBehavior.Cascade)
  2615. .IsRequired();
  2616. b.Navigation("Project");
  2617. b.Navigation("TaskStatus");
  2618. });
  2619. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b =>
  2620. {
  2621. b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType")
  2622. .WithMany()
  2623. .HasForeignKey("AttachmentTypeId");
  2624. b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask")
  2625. .WithMany("TaskAttachments")
  2626. .HasForeignKey("TaskId")
  2627. .OnDelete(DeleteBehavior.Cascade)
  2628. .IsRequired();
  2629. b.Navigation("AttachmentType");
  2630. b.Navigation("UserTask");
  2631. });
  2632. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b =>
  2633. {
  2634. b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus")
  2635. .WithMany()
  2636. .HasForeignKey("CurrentStatusId")
  2637. .OnDelete(DeleteBehavior.Cascade)
  2638. .IsRequired();
  2639. b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask")
  2640. .WithMany("TaskHistories")
  2641. .HasForeignKey("TaskId")
  2642. .OnDelete(DeleteBehavior.Cascade)
  2643. .IsRequired();
  2644. b.Navigation("TaskStatus");
  2645. b.Navigation("UserTask");
  2646. });
  2647. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
  2648. {
  2649. b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
  2650. .WithMany()
  2651. .HasForeignKey("CountryId");
  2652. b.HasOne("MTWorkHR.Core.Entities.Industry", "Industry")
  2653. .WithMany()
  2654. .HasForeignKey("IndustryId");
  2655. b.HasOne("MTWorkHR.Core.Entities.JobTitle", "JobTitle")
  2656. .WithMany()
  2657. .HasForeignKey("JobTitleId");
  2658. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "Manager")
  2659. .WithMany()
  2660. .HasForeignKey("ManagerId");
  2661. b.HasOne("MTWorkHR.Core.Entities.Qualification", "Qualification")
  2662. .WithMany()
  2663. .HasForeignKey("QualificationId");
  2664. b.HasOne("MTWorkHR.Core.Entities.University", "University")
  2665. .WithMany()
  2666. .HasForeignKey("UniversityId");
  2667. b.Navigation("Country");
  2668. b.Navigation("Industry");
  2669. b.Navigation("JobTitle");
  2670. b.Navigation("Manager");
  2671. b.Navigation("Qualification");
  2672. b.Navigation("University");
  2673. });
  2674. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b =>
  2675. {
  2676. b.HasOne("MTWorkHR.Core.Entities.Permission", "Permission")
  2677. .WithMany()
  2678. .HasForeignKey("PermissionId")
  2679. .OnDelete(DeleteBehavior.Cascade)
  2680. .IsRequired();
  2681. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", "Role")
  2682. .WithMany("RolePermissions")
  2683. .HasForeignKey("RoleId")
  2684. .OnDelete(DeleteBehavior.Cascade)
  2685. .IsRequired();
  2686. b.Navigation("Permission");
  2687. b.Navigation("Role");
  2688. });
  2689. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAddress", b =>
  2690. {
  2691. b.HasOne("MTWorkHR.Core.Entities.City", "City")
  2692. .WithMany()
  2693. .HasForeignKey("CityId");
  2694. b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
  2695. .WithMany()
  2696. .HasForeignKey("CountryId");
  2697. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "User")
  2698. .WithOne("UserAddress")
  2699. .HasForeignKey("MTWorkHR.Infrastructure.Entities.UserAddress", "UserId")
  2700. .OnDelete(DeleteBehavior.Cascade)
  2701. .IsRequired();
  2702. b.Navigation("City");
  2703. b.Navigation("Country");
  2704. b.Navigation("User");
  2705. });
  2706. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b =>
  2707. {
  2708. b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType")
  2709. .WithMany()
  2710. .HasForeignKey("AttachmentTypeId")
  2711. .OnDelete(DeleteBehavior.Cascade)
  2712. .IsRequired();
  2713. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "User")
  2714. .WithMany("UserAttachments")
  2715. .HasForeignKey("UserId")
  2716. .OnDelete(DeleteBehavior.Cascade)
  2717. .IsRequired();
  2718. b.Navigation("AttachmentType");
  2719. b.Navigation("User");
  2720. });
  2721. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
  2722. {
  2723. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
  2724. .WithMany()
  2725. .HasForeignKey("RoleId")
  2726. .OnDelete(DeleteBehavior.Cascade)
  2727. .IsRequired();
  2728. });
  2729. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
  2730. {
  2731. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2732. .WithMany()
  2733. .HasForeignKey("UserId")
  2734. .OnDelete(DeleteBehavior.Cascade)
  2735. .IsRequired();
  2736. });
  2737. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
  2738. {
  2739. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2740. .WithMany()
  2741. .HasForeignKey("UserId")
  2742. .OnDelete(DeleteBehavior.Cascade)
  2743. .IsRequired();
  2744. });
  2745. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
  2746. {
  2747. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
  2748. .WithMany()
  2749. .HasForeignKey("RoleId")
  2750. .OnDelete(DeleteBehavior.Cascade)
  2751. .IsRequired();
  2752. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2753. .WithMany()
  2754. .HasForeignKey("UserId")
  2755. .OnDelete(DeleteBehavior.Cascade)
  2756. .IsRequired();
  2757. });
  2758. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
  2759. {
  2760. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2761. .WithMany()
  2762. .HasForeignKey("UserId")
  2763. .OnDelete(DeleteBehavior.Cascade)
  2764. .IsRequired();
  2765. });
  2766. modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b =>
  2767. {
  2768. b.Navigation("MeetingUsers");
  2769. });
  2770. modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b =>
  2771. {
  2772. b.Navigation("ProjectTeams");
  2773. });
  2774. modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b =>
  2775. {
  2776. b.Navigation("TeamUsers");
  2777. });
  2778. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
  2779. {
  2780. b.Navigation("TaskAttachments");
  2781. b.Navigation("TaskHistories");
  2782. b.Navigation("TaskUsers");
  2783. });
  2784. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b =>
  2785. {
  2786. b.Navigation("RolePermissions");
  2787. });
  2788. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
  2789. {
  2790. b.Navigation("UserAddress")
  2791. .IsRequired();
  2792. b.Navigation("UserAttachments");
  2793. });
  2794. #pragma warning restore 612, 618
  2795. }
  2796. }
  2797. }