20250226121257_altrLeaveConfig.cs 2.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. using Microsoft.EntityFrameworkCore.Migrations;
  2. #nullable disable
  3. namespace MTWorkHR.Infrastructure.Migrations
  4. {
  5. /// <inheritdoc />
  6. public partial class altrLeaveConfig : Migration
  7. {
  8. /// <inheritdoc />
  9. protected override void Up(MigrationBuilder migrationBuilder)
  10. {
  11. migrationBuilder.UpdateData(
  12. table: "LeaveTypes",
  13. keyColumn: "Id",
  14. keyValue: 1L,
  15. column: "DefaultDays",
  16. value: 30);
  17. migrationBuilder.UpdateData(
  18. table: "LeaveTypes",
  19. keyColumn: "Id",
  20. keyValue: 2L,
  21. column: "DefaultDays",
  22. value: 90);
  23. migrationBuilder.UpdateData(
  24. table: "LeaveTypes",
  25. keyColumn: "Id",
  26. keyValue: 3L,
  27. column: "DefaultDays",
  28. value: 5);
  29. migrationBuilder.UpdateData(
  30. table: "LeaveTypes",
  31. keyColumn: "Id",
  32. keyValue: 4L,
  33. columns: new[] { "DefaultDays", "NameEn" },
  34. values: new object[] { 20, "Maternity leave" });
  35. migrationBuilder.InsertData(
  36. table: "LeaveTypes",
  37. columns: new[] { "Id", "DefaultDays", "NameAr", "NameEn" },
  38. values: new object[] { 6L, 3, "وفاة", "Death of a relative" });
  39. }
  40. /// <inheritdoc />
  41. protected override void Down(MigrationBuilder migrationBuilder)
  42. {
  43. migrationBuilder.DeleteData(
  44. table: "LeaveTypes",
  45. keyColumn: "Id",
  46. keyValue: 6L);
  47. migrationBuilder.UpdateData(
  48. table: "LeaveTypes",
  49. keyColumn: "Id",
  50. keyValue: 1L,
  51. column: "DefaultDays",
  52. value: 21);
  53. migrationBuilder.UpdateData(
  54. table: "LeaveTypes",
  55. keyColumn: "Id",
  56. keyValue: 2L,
  57. column: "DefaultDays",
  58. value: 15);
  59. migrationBuilder.UpdateData(
  60. table: "LeaveTypes",
  61. keyColumn: "Id",
  62. keyValue: 3L,
  63. column: "DefaultDays",
  64. value: 20);
  65. migrationBuilder.UpdateData(
  66. table: "LeaveTypes",
  67. keyColumn: "Id",
  68. keyValue: 4L,
  69. columns: new[] { "DefaultDays", "NameEn" },
  70. values: new object[] { 10, "Paternity leave" });
  71. }
  72. }
  73. }