New_REP_SYSTEM/ERP_Distribution
8
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
dev
ERP_Distribution/Distribution/Migrations/20261019092950_AddPaymentServiceModule.Designer.cs
T
Kalana B. Thilakarathna 87c807c16c
CI/CD - ERP Distribution / Build & Deploy Backend (pull_request) Failing after 11m8s
Details
CI/CD - ERP Distribution / Build & Deploy Frontend (pull_request) Failing after 14m49s
Details
feat: add cheque books and received cheques management 
- Implemented ChequeBooksPage for viewing and filtering cheque books.
- Added NewReceivedChequePage for recording received cheques.
- Created ReceivedChequesPage for listing and managing received cheques.
- Introduced API endpoints for bank accounts, cheque books, and received cheques.
- Defined types for payments including bank accounts, cheque books, and received cheques.
2026-10-19 16:09:05 +05:30

5547 lines
235 KiB
C#
Raw Permalink Blame History

// <auto-generated />
using System;
using Distribution.Data;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
#nullable disable
namespace Distribution.Migrations
{
[DbContext(typeof(AppDBContext))]
[Migration("20261019092950_AddPaymentServiceModule")]
partial class AddPaymentServiceModule
{
/// <inheritdoc />
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "9.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 64);
MySqlModelBuilderExtensions.AutoIncrementColumns(modelBuilder);
modelBuilder.Entity("Distribution.Models.BankAccount", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("AccountName")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("varchar(200)");
b.Property<string>("AccountNumber")
.HasMaxLength(100)
.HasColumnType("varchar(100)");
b.Property<int>("AccountType")
.HasColumnType("int");
b.Property<string>("BankName")
.HasMaxLength(200)
.HasColumnType("varchar(200)");
b.Property<string>("CashAccountTypeName")
.HasMaxLength(100)
.HasColumnType("varchar(100)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("CurrencyCode")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("varchar(10)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsDefault")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.HasIndex("AccountType", "AccountName")
.IsUnique();
b.ToTable("BankAccounts");
});
modelBuilder.Entity("Distribution.Models.Brand", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int?>("ExternalErpId")
.HasColumnType("int");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.ToTable("Brands");
b.HasData(
new
{
Id = new Guid("21000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Coca-Cola"
},
new
{
Id = new Guid("21000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Lays"
});
});
modelBuilder.Entity("Distribution.Models.Category", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<bool>("AllowCustomerReturn")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int?>("ExternalErpId")
.HasColumnType("int");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.ToTable("Categories");
b.HasData(
new
{
Id = new Guid("20000000-0000-0000-0000-000000000001"),
AllowCustomerReturn = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Beverages"
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000002"),
AllowCustomerReturn = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Snacks"
});
});
modelBuilder.Entity("Distribution.Models.ChequeBook", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<int>("BranchId")
.HasColumnType("int");
b.Property<string>("ChequeBookNo")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("varchar(100)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("CreatedBy")
.HasColumnType("longtext");
b.Property<string>("Description")
.HasColumnType("longtext");
b.Property<string>("EndChequeNo")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("varchar(50)");
b.Property<Guid>("FK_BankAccountId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("ReceivedDate")
.HasColumnType("datetime(6)");
b.Property<string>("StartChequeNo")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("varchar(50)");
b.Property<int>("Status")
.HasColumnType("int");
b.Property<int>("TotalLeaves")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("ChequeBookNo")
.IsUnique();
b.HasIndex("FK_BankAccountId");
b.ToTable("ChequeBooks");
});
modelBuilder.Entity("Distribution.Models.ChequePage", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal?>("Amount")
.HasColumnType("decimal(65,30)");
b.Property<string>("CancelReason")
.HasColumnType("longtext");
b.Property<string>("ChequeNo")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("varchar(50)");
b.Property<bool?>("ClearedByBank")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("ClearedDate")
.HasColumnType("datetime(6)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("CurrencyCode")
.HasMaxLength(10)
.HasColumnType("varchar(10)");
b.Property<Guid>("FK_ChequeBookId")
.HasColumnType("char(36)");
b.Property<bool?>("IsAccountPayee")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<bool?>("IsCrossCheque")
.HasColumnType("tinyint(1)");
b.Property<bool?>("IsPostDated")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("IssueDate")
.HasColumnType("datetime(6)");
b.Property<int>("IssueStatus")
.HasColumnType("int");
b.Property<string>("Notes")
.HasColumnType("longtext");
b.Property<int?>("PayeeId")
.HasColumnType("int");
b.Property<string>("PayeeName")
.HasColumnType("longtext");
b.Property<int?>("PayeeType")
.HasColumnType("int");
b.Property<DateTime?>("PrintedAt")
.HasColumnType("datetime(6)");
b.Property<string>("PrintedBy")
.HasColumnType("longtext");
b.Property<string>("Purpose")
.HasColumnType("longtext");
b.Property<string>("ReferenceNo")
.HasColumnType("longtext");
b.Property<int?>("VoucherId")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("ChequeNo")
.IsUnique();
b.HasIndex("FK_ChequeBookId");
b.ToTable("ChequePages");
});
modelBuilder.Entity("Distribution.Models.Claim", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Details")
.IsRequired()
.HasColumnType("longtext");
b.Property<Guid>("FK_AgencyUserId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("SettledAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("SettledByUserId")
.HasColumnType("char(36)");
b.Property<decimal?>("SettlementAmount")
.HasColumnType("decimal(65,30)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_AgencyUserId");
b.HasIndex("SettledByUserId");
b.ToTable("Claims");
b.HasData(
new
{
Id = new Guid("53000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 27, 0, 0, 0, 0, DateTimeKind.Unspecified),
Details = "Distributor margin claim for Q3 promotional shortfall",
FK_AgencyUserId = new Guid("70000000-0000-0000-0000-000000000001"),
IsActive = true,
SettledAt = new DateTime(2026, 8, 28, 0, 0, 0, 0, DateTimeKind.Unspecified),
SettledByUserId = new Guid("29000000-0000-0000-0000-000000000006"),
SettlementAmount = 15000m,
Status = 1
});
});
modelBuilder.Entity("Distribution.Models.CreditNote", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal>("Amount")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_SaleReturnId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("IssuedAt")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_SaleReturnId");
b.ToTable("CreditNotes");
b.HasData(
new
{
Id = new Guid("54000000-0000-0000-0000-000000000001"),
Amount = 300m,
CreatedAt = new DateTime(2026, 8, 26, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_SaleReturnId = new Guid("51000000-0000-0000-0000-000000000001"),
IsActive = true,
IssuedAt = new DateTime(2026, 8, 26, 0, 0, 0, 0, DateTimeKind.Unspecified)
});
});
modelBuilder.Entity("Distribution.Models.DeliveryRun", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("CancelReason")
.HasColumnType("longtext");
b.Property<int?>("CancelTypeCode")
.HasColumnType("int");
b.Property<DateTime?>("ClosedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_DriverProfileId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_VehicleId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Meterend")
.HasColumnType("int");
b.Property<int>("Meterstart")
.HasColumnType("int");
b.Property<DateTime?>("StartedAt")
.HasColumnType("datetime(6)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_DriverProfileId");
b.HasIndex("FK_VehicleId");
b.ToTable("DeliveryRuns");
b.HasData(
new
{
Id = new Guid("31000000-0000-0000-0000-000000000001"),
ClosedAt = new DateTime(2026, 8, 25, 14, 0, 0, 0, DateTimeKind.Unspecified),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
FK_DriverProfileId = new Guid("30000000-0000-0000-0000-000000000001"),
FK_VehicleId = new Guid("28000000-0000-0000-0000-000000000001"),
IsActive = true,
Meterend = 10550,
Meterstart = 10500,
StartedAt = new DateTime(2026, 8, 25, 8, 0, 0, 0, DateTimeKind.Unspecified),
Status = 2
},
new
{
Id = new Guid("31000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 30, 8, 45, 0, 0, DateTimeKind.Unspecified),
FK_DriverProfileId = new Guid("30000000-0000-0000-0000-000000000002"),
FK_VehicleId = new Guid("28000000-0000-0000-0000-000000000002"),
IsActive = true,
Meterend = 0,
Meterstart = 20300,
StartedAt = new DateTime(2026, 8, 30, 9, 0, 0, 0, DateTimeKind.Unspecified),
Status = 0
});
});
modelBuilder.Entity("Distribution.Models.DeliveryTask", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime?>("ConfirmedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("CustomerConfirmed")
.HasColumnType("tinyint(1)");
b.Property<Guid>("FK_RideId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Note")
.HasColumnType("longtext");
b.Property<int>("Sequence")
.HasColumnType("int");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_RideId");
b.HasIndex("FK_ShopPOId");
b.ToTable("DeliveryTasks");
b.HasData(
new
{
Id = new Guid("37000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 30, 10, 5, 0, 0, DateTimeKind.Unspecified),
CustomerConfirmed = false,
FK_RideId = new Guid("31000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000002"),
IsActive = true,
Sequence = 1,
Status = 0
});
});
modelBuilder.Entity("Distribution.Models.DriverComplianceConfig", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<bool>("EnforceLicenseExpiry")
.HasColumnType("tinyint(1)");
b.Property<bool>("EnforceMedicalClearance")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("UpdatedBy")
.HasColumnType("char(36)");
b.HasKey("Id");
b.ToTable("DriverComplianceConfigs");
b.HasData(
new
{
Id = new Guid("64000000-0000-0000-0000-000000000001"),
EnforceLicenseExpiry = true,
EnforceMedicalClearance = true,
UpdatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
UpdatedBy = new Guid("29000000-0000-0000-0000-000000000001")
});
});
modelBuilder.Entity("Distribution.Models.DriverProfile", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("LicenseExpiry")
.HasColumnType("datetime(6)");
b.Property<string>("LicenseNumber")
.IsRequired()
.HasColumnType("longtext");
b.Property<DateTime>("MedicalClearanceExpiry")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_UserId")
.IsUnique();
b.ToTable("DriverProfiles");
b.HasData(
new
{
Id = new Guid("30000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_UserId = new Guid("29000000-0000-0000-0000-000000000004"),
IsActive = true,
LicenseExpiry = new DateTime(2027, 6, 30, 0, 0, 0, 0, DateTimeKind.Unspecified),
LicenseNumber = "B1234567",
MedicalClearanceExpiry = new DateTime(2027, 1, 31, 0, 0, 0, 0, DateTimeKind.Unspecified)
},
new
{
Id = new Guid("30000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_UserId = new Guid("29000000-0000-0000-0000-000000000005"),
IsActive = true,
LicenseExpiry = new DateTime(2027, 9, 30, 0, 0, 0, 0, DateTimeKind.Unspecified),
LicenseNumber = "B7654321",
MedicalClearanceExpiry = new DateTime(2027, 3, 31, 0, 0, 0, 0, DateTimeKind.Unspecified)
});
});
modelBuilder.Entity("Distribution.Models.GoodsReceipt", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("DiscountPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.Property<Guid?>("FK_PurchaseOrderId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ReceivedByUserId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_SupplierId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_WarehouseId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("NbtPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.Property<DateTime>("ReceivedAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("VatPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.HasKey("Id");
b.HasIndex("FK_PurchaseOrderId");
b.HasIndex("FK_SupplierId");
b.HasIndex("FK_WarehouseId");
b.ToTable("GoodsReceipts");
b.HasData(
new
{
Id = new Guid("43000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
DiscountPercent = 0m,
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000001"),
FK_ReceivedByUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_WarehouseId = new Guid("27000000-0000-0000-0000-000000000001"),
IsActive = true,
NbtPercent = 0m,
ReceivedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
VatPercent = 0m
});
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<int>("AcceptedQuantity")
.HasColumnType("int");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("DiscountPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.Property<Guid>("FK_GoodsReceiptId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_PurchaseOrderItemId")
.HasColumnType("char(36)");
b.Property<int>("FreeQuantity")
.HasColumnType("int");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("NbtPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.Property<int>("RejectedQuantity")
.HasColumnType("int");
b.Property<decimal>("UnitCost")
.HasPrecision(18, 2)
.HasColumnType("decimal(18,2)");
b.Property<decimal>("VatPercent")
.HasPrecision(5, 2)
.HasColumnType("decimal(5,2)");
b.HasKey("Id");
b.HasIndex("FK_GoodsReceiptId");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_PurchaseOrderItemId");
b.ToTable("GoodsReceiptItems");
b.HasData(
new
{
Id = new Guid("44000000-0000-0000-0000-000000000001"),
AcceptedQuantity = 200,
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
DiscountPercent = 0m,
FK_GoodsReceiptId = new Guid("43000000-0000-0000-0000-000000000001"),
FK_PurchaseOrderItemId = new Guid("42000000-0000-0000-0000-000000000001"),
FreeQuantity = 0,
IsActive = true,
NbtPercent = 0m,
RejectedQuantity = 0,
UnitCost = 0m,
VatPercent = 0m
},
new
{
Id = new Guid("44000000-0000-0000-0000-000000000002"),
AcceptedQuantity = 98,
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
DiscountPercent = 0m,
FK_GoodsReceiptId = new Guid("43000000-0000-0000-0000-000000000001"),
FK_PurchaseOrderItemId = new Guid("42000000-0000-0000-0000-000000000002"),
FreeQuantity = 0,
IsActive = true,
NbtPercent = 0m,
RejectedQuantity = 2,
UnitCost = 0m,
VatPercent = 0m
});
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItemBatch", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_GoodsReceiptItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemBatchId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Quantity")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_GoodsReceiptItemId");
b.HasIndex("FK_ItemBatchId");
b.ToTable("GoodsReceiptItemBatches");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItemSerial", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_GoodsReceiptItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemSerialNumberId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.HasIndex("FK_GoodsReceiptItemId");
b.HasIndex("FK_ItemSerialNumberId");
b.ToTable("GoodsReceiptItemSerials");
});
modelBuilder.Entity("Distribution.Models.Invoice", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("CreatedBy")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<DateTime?>("FinalizedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("FinalizedBy")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("PaymentStatus")
.HasColumnType("int");
b.Property<DateTime?>("PrintedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("PrintedBy")
.HasColumnType("char(36)");
b.Property<int>("Status")
.HasColumnType("int");
b.Property<decimal>("TotalAmount")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ShopPOId");
b.ToTable("Invoices");
b.HasData(
new
{
Id = new Guid("34500000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 8, 30, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
FinalizedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FinalizedBy = new Guid("29000000-0000-0000-0000-000000000001"),
IsActive = true,
PaymentStatus = 2,
PrintedAt = new DateTime(2026, 8, 25, 8, 45, 0, 0, DateTimeKind.Unspecified),
PrintedBy = new Guid("29000000-0000-0000-0000-000000000002"),
Status = 2,
TotalAmount = 3000m
},
new
{
Id = new Guid("34500000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 31, 9, 0, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000003"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000003"),
IsActive = true,
PaymentStatus = 1,
PrintedAt = new DateTime(2026, 8, 31, 9, 15, 0, 0, DateTimeKind.Unspecified),
PrintedBy = new Guid("29000000-0000-0000-0000-000000000003"),
Status = 1,
TotalAmount = 2400m
});
});
modelBuilder.Entity("Distribution.Models.Item", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<bool>("AllowCustomWarrantyPeriod")
.HasColumnType("tinyint(1)");
b.Property<decimal?>("CostPrice")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Description")
.HasColumnType("longtext");
b.Property<int?>("ExternalErpItemId")
.HasColumnType("int");
b.Property<Guid>("FK_BaseUomId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_BrandId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_CategoryId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_SubCategoryId")
.HasColumnType("char(36)");
b.Property<bool>("HasWarranty")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("LastSyncedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<decimal?>("ReorderLevel")
.HasColumnType("decimal(65,30)");
b.Property<decimal?>("SalePrice")
.HasColumnType("decimal(65,30)");
b.Property<string>("Sku")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("SyncSource")
.HasColumnType("int");
b.Property<bool>("TracksBatches")
.HasColumnType("tinyint(1)");
b.Property<bool>("TracksExpiryDate")
.HasColumnType("tinyint(1)");
b.Property<bool>("TracksSerialNumbers")
.HasColumnType("tinyint(1)");
b.Property<int?>("WarrantyPeriodDays")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_BaseUomId");
b.HasIndex("FK_BrandId");
b.HasIndex("FK_CategoryId");
b.HasIndex("FK_SubCategoryId");
b.ToTable("Items");
b.HasData(
new
{
Id = new Guid("23000000-0000-0000-0000-000000000001"),
AllowCustomWarrantyPeriod = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Coca-Cola 500ml bottle",
FK_BaseUomId = new Guid("22000000-0000-0000-0000-000000000001"),
FK_BrandId = new Guid("21000000-0000-0000-0000-000000000001"),
FK_CategoryId = new Guid("20000000-0000-0000-0000-000000000001"),
HasWarranty = false,
IsActive = true,
Name = "Coca-Cola 500ml",
SalePrice = 60m,
Sku = "BEV-COKE-500",
SyncSource = 0,
TracksBatches = false,
TracksExpiryDate = false,
TracksSerialNumbers = false
},
new
{
Id = new Guid("23000000-0000-0000-0000-000000000002"),
AllowCustomWarrantyPeriod = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Coca-Cola 1.5L bottle",
FK_BaseUomId = new Guid("22000000-0000-0000-0000-000000000001"),
FK_BrandId = new Guid("21000000-0000-0000-0000-000000000001"),
FK_CategoryId = new Guid("20000000-0000-0000-0000-000000000001"),
HasWarranty = false,
IsActive = true,
Name = "Coca-Cola 1.5L",
SalePrice = 120m,
Sku = "BEV-COKE-1500",
SyncSource = 0,
TracksBatches = false,
TracksExpiryDate = false,
TracksSerialNumbers = false
},
new
{
Id = new Guid("23000000-0000-0000-0000-000000000003"),
AllowCustomWarrantyPeriod = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Lays Classic Salted 52g pack",
FK_BaseUomId = new Guid("22000000-0000-0000-0000-000000000001"),
FK_BrandId = new Guid("21000000-0000-0000-0000-000000000002"),
FK_CategoryId = new Guid("20000000-0000-0000-0000-000000000002"),
HasWarranty = false,
IsActive = true,
Name = "Lays Classic 52g",
SalePrice = 50m,
Sku = "SNK-LAYS-52",
SyncSource = 0,
TracksBatches = false,
TracksExpiryDate = false,
TracksSerialNumbers = false
},
new
{
Id = new Guid("23000000-0000-0000-0000-000000000004"),
AllowCustomWarrantyPeriod = false,
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Lays Family Pack 150g",
FK_BaseUomId = new Guid("22000000-0000-0000-0000-000000000001"),
FK_BrandId = new Guid("21000000-0000-0000-0000-000000000002"),
FK_CategoryId = new Guid("20000000-0000-0000-0000-000000000002"),
HasWarranty = false,
IsActive = true,
Name = "Lays Family Pack 150g",
SalePrice = 150m,
Sku = "SNK-LAYS-FAM",
SyncSource = 0,
TracksBatches = false,
TracksExpiryDate = false,
TracksSerialNumbers = false
});
});
modelBuilder.Entity("Distribution.Models.ItemBatch", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("BatchNumber")
.HasColumnType("varchar(255)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime?>("ExpiryDate")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("ManufactureDate")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_ItemId", "BatchNumber");
b.ToTable("ItemBatches");
});
modelBuilder.Entity("Distribution.Models.ItemSerialNumber", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("CurrentLocationId")
.HasColumnType("char(36)");
b.Property<int?>("CurrentLocationType")
.HasColumnType("int");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("ReceivedAt")
.HasColumnType("datetime(6)");
b.Property<string>("SerialNumber")
.IsRequired()
.HasColumnType("varchar(255)");
b.Property<int>("Status")
.HasColumnType("int");
b.Property<DateTime?>("WarrantyExpiresAt")
.HasColumnType("datetime(6)");
b.Property<int?>("WarrantyPeriodDaysOverride")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_ItemId", "SerialNumber")
.IsUnique();
b.ToTable("ItemSerialNumbers");
});
modelBuilder.Entity("Distribution.Models.LoadingSheet", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime?>("ConfirmedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("ConfirmedBy")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RideId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime>("PopulatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("PopulatedBy")
.HasColumnType("char(36)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_RideId");
b.ToTable("LoadingSheets");
b.HasData(
new
{
Id = new Guid("35000000-0000-0000-0000-000000000001"),
ConfirmedAt = new DateTime(2026, 8, 25, 7, 45, 0, 0, DateTimeKind.Unspecified),
ConfirmedBy = new Guid("29000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
FK_RideId = new Guid("31000000-0000-0000-0000-000000000001"),
IsActive = true,
PopulatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
PopulatedBy = new Guid("29000000-0000-0000-0000-000000000001"),
Status = 1
});
});
modelBuilder.Entity("Distribution.Models.LoadingSheetItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_LoadingSheetId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ShopPOItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_WarehouseId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("QuantityDispatched")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_LoadingSheetId");
b.HasIndex("FK_ShopPOItemId");
b.HasIndex("FK_WarehouseId");
b.ToTable("LoadingSheetItems");
b.HasData(
new
{
Id = new Guid("36000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_LoadingSheetId = new Guid("35000000-0000-0000-0000-000000000001"),
FK_WarehouseId = new Guid("27000000-0000-0000-0000-000000000001"),
IsActive = true,
QuantityDispatched = 50m
},
new
{
Id = new Guid("36000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_LoadingSheetId = new Guid("35000000-0000-0000-0000-000000000001"),
FK_WarehouseId = new Guid("27000000-0000-0000-0000-000000000001"),
IsActive = true,
QuantityDispatched = 30m
});
});
modelBuilder.Entity("Distribution.Models.LoadingSheetOrder", b =>
{
b.Property<Guid>("FK_LoadingSheetId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.HasKey("FK_LoadingSheetId", "FK_ShopPOId");
b.HasIndex("FK_ShopPOId");
b.ToTable("LoadingSheetOrders");
});
modelBuilder.Entity("Distribution.Models.Payment", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal>("Amount")
.HasColumnType("decimal(65,30)");
b.Property<DateTime?>("ChequeDate")
.HasColumnType("datetime(6)");
b.Property<string>("ChequeNumber")
.HasColumnType("longtext");
b.Property<DateTime>("CollectedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("CollectedBy")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int>("EntryMode")
.HasColumnType("int");
b.Property<Guid>("FK_InvoiceId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Method")
.HasColumnType("int");
b.Property<Guid?>("RecordedBy")
.HasColumnType("char(36)");
b.HasKey("Id");
b.HasIndex("FK_InvoiceId");
b.ToTable("Payments");
b.HasData(
new
{
Id = new Guid("47000000-0000-0000-0000-000000000001"),
Amount = 3000m,
CollectedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified),
CollectedBy = new Guid("29000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified),
EntryMode = 0,
FK_InvoiceId = new Guid("34500000-0000-0000-0000-000000000001"),
IsActive = true,
Method = 0
},
new
{
Id = new Guid("47000000-0000-0000-0000-000000000002"),
Amount = 1000m,
CollectedAt = new DateTime(2026, 8, 31, 9, 20, 0, 0, DateTimeKind.Unspecified),
CollectedBy = new Guid("29000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 31, 9, 20, 0, 0, DateTimeKind.Unspecified),
EntryMode = 0,
FK_InvoiceId = new Guid("34500000-0000-0000-0000-000000000002"),
IsActive = true,
Method = 0
},
new
{
Id = new Guid("47000000-0000-0000-0000-000000000003"),
Amount = 800m,
ChequeDate = new DateTime(2026, 8, 31, 0, 0, 0, 0, DateTimeKind.Unspecified),
ChequeNumber = "000456",
CollectedAt = new DateTime(2026, 8, 31, 11, 0, 0, 0, DateTimeKind.Unspecified),
CollectedBy = new Guid("29000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 31, 18, 0, 0, 0, DateTimeKind.Unspecified),
EntryMode = 1,
FK_InvoiceId = new Guid("34500000-0000-0000-0000-000000000002"),
IsActive = true,
Method = 1,
RecordedBy = new Guid("29000000-0000-0000-0000-000000000001")
},
new
{
Id = new Guid("47000000-0000-0000-0000-000000000004"),
Amount = 300m,
CollectedAt = new DateTime(2026, 8, 31, 11, 5, 0, 0, DateTimeKind.Unspecified),
CollectedBy = new Guid("29000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 31, 11, 5, 0, 0, DateTimeKind.Unspecified),
EntryMode = 0,
FK_InvoiceId = new Guid("34500000-0000-0000-0000-000000000002"),
IsActive = true,
Method = 2
});
});
modelBuilder.Entity("Distribution.Models.Permission", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("Code")
.IsRequired()
.HasColumnType("longtext");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.ToTable("Permissions");
b.HasData(
new
{
Id = new Guid("20000000-0000-0000-0000-000000000001"),
Code = "orders.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View shop POs, invoices, payments and returns",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000002"),
Code = "rides.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage delivery rides and delivery tasks",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000003"),
Code = "loading.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage loading sheets",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000004"),
Code = "stores.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View store accounts, credit limits and balances",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000005"),
Code = "sales_visits.checkin",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Check in and out of scheduled store visits",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000006"),
Code = "items.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage catalogue products",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000007"),
Code = "categories.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage product categories and brands",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000008"),
Code = "warehouses.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View stock balances, movements, warehouses and reports",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000009"),
Code = "purchase_orders.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage purchase orders, GRNs and supplier claims",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000010"),
Code = "pricelists.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage regional price lists",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000011"),
Code = "schemes.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage pricing schemes and promotions",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000012"),
Code = "suppliers.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage supplier accounts",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000013"),
Code = "driver_profiles.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage driver profiles and licensing",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000014"),
Code = "compliance.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Manage driver compliance rules",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000015"),
Code = "users.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage staff user accounts",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000016"),
Code = "roles.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage roles and their permission sets",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000017"),
Code = "regions.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage regions and region configuration",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000018"),
Code = "routes.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage delivery routes",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000019"),
Code = "vehicles.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View and manage fleet vehicles",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000020"),
Code = "claim.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View agency claims and settlement status",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000021"),
Code = "claim.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and settle agency claims",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000022"),
Code = "delivery-task.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View delivery tasks within a ride",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000023"),
Code = "delivery-task.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Confirm and fail delivery tasks",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000024"),
Code = "driver.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View driver profiles and license details",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000025"),
Code = "driver.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and update driver profiles",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000026"),
Code = "grn.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View goods receipt notes",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000027"),
Code = "grn.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and confirm goods receipts",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000028"),
Code = "loading-sheet.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View loading sheets and their items",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000029"),
Code = "loading-sheet.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create, edit, and confirm loading sheets",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000030"),
Code = "price-list.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View regional price lists",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000031"),
Code = "price-list.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and manage item price lists",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000032"),
Code = "purchase-order.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View purchase orders and line items",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000033"),
Code = "purchase-order.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create, confirm, and close purchase orders",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000034"),
Code = "purchase-return.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and manage purchase returns to suppliers",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000035"),
Code = "region.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View regions and their configuration",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000036"),
Code = "region.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and update regions, targets, and budgets",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000037"),
Code = "return.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View order returns",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000038"),
Code = "return.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and manage order returns",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000039"),
Code = "route.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View delivery routes",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000040"),
Code = "route.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and manage delivery routes",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000041"),
Code = "scheme.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View pricing schemes and promotions",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000042"),
Code = "scheme.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and configure pricing schemes",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000043"),
Code = "stock.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View stock balances and movements",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000044"),
Code = "stock.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Transfer stock and record damage or adjustments",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000045"),
Code = "store.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View store accounts and balances",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000046"),
Code = "store.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and update store accounts",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000047"),
Code = "supplier-claim.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View supplier claims",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000048"),
Code = "supplier-claim.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Create and resolve supplier claims",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000049"),
Code = "sys-config.view",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "View system configuration settings",
IsActive = true
},
new
{
Id = new Guid("20000000-0000-0000-0000-000000000050"),
Code = "sys-config.manage",
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Description = "Update system configuration settings",
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.PriceList", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("EffectiveFrom")
.HasColumnType("datetime(6)");
b.Property<DateTime>("EffectiveTo")
.HasColumnType("datetime(6)");
b.Property<Guid?>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_RegionId");
b.ToTable("PriceLists");
b.HasData(
new
{
Id = new Guid("39000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
EffectiveFrom = new DateTime(2026, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
EffectiveTo = new DateTime(2026, 12, 31, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Name = "Western Province Price List"
});
});
modelBuilder.Entity("Distribution.Models.PriceListItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal?>("AgencyMarginPercent")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PriceListId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal?>("MinPrice")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("Price")
.HasColumnType("decimal(65,30)");
b.Property<decimal?>("RetailPrice")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_PriceListId", "FK_ItemId")
.IsUnique();
b.ToTable("PriceListItems");
b.HasData(
new
{
Id = new Guid("40000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_PriceListId = new Guid("39000000-0000-0000-0000-000000000001"),
IsActive = true,
MinPrice = 55m,
Price = 60m
},
new
{
Id = new Guid("40000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_PriceListId = new Guid("39000000-0000-0000-0000-000000000001"),
IsActive = true,
MinPrice = 45m,
Price = 50m
});
});
modelBuilder.Entity("Distribution.Models.PurchaseOrder", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("CancelReason")
.HasColumnType("longtext");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_CreatedByUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SupplierId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_SupplierId");
b.ToTable("PurchaseOrders");
b.HasData(
new
{
Id = new Guid("41000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_CreatedByUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_SupplierId = new Guid("38000000-0000-0000-0000-000000000001"),
IsActive = true,
Status = 2
},
new
{
Id = new Guid("41000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_CreatedByUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_SupplierId = new Guid("38000000-0000-0000-0000-000000000002"),
IsActive = true,
Status = 2
});
});
modelBuilder.Entity("Distribution.Models.PurchaseOrderItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<int>("CancelledQuantity")
.HasColumnType("int");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PurchaseOrderId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsCancelled")
.HasColumnType("tinyint(1)");
b.Property<int>("Quantity")
.HasColumnType("int");
b.Property<int>("ReceivedQuantity")
.HasColumnType("int");
b.Property<decimal>("UnitCost")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_PurchaseOrderId");
b.ToTable("PurchaseOrderItems");
b.HasData(
new
{
Id = new Guid("42000000-0000-0000-0000-000000000001"),
CancelledQuantity = 0,
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000001"),
IsActive = true,
IsCancelled = false,
Quantity = 200,
ReceivedQuantity = 200,
UnitCost = 40m
},
new
{
Id = new Guid("42000000-0000-0000-0000-000000000002"),
CancelledQuantity = 0,
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000002"),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000001"),
IsActive = true,
IsCancelled = false,
Quantity = 100,
ReceivedQuantity = 98,
UnitCost = 80m
},
new
{
Id = new Guid("42000000-0000-0000-0000-000000000003"),
CancelledQuantity = 0,
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000002"),
IsActive = true,
IsCancelled = false,
Quantity = 150,
ReceivedQuantity = 150,
UnitCost = 35m
});
});
modelBuilder.Entity("Distribution.Models.PurchaseReturn", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_PurchaseOrderId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Reason")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_PurchaseOrderId");
b.ToTable("PurchaseReturns");
b.HasData(
new
{
Id = new Guid("45000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 16, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000002"),
IsActive = true,
Reason = "Damaged in transit"
});
});
modelBuilder.Entity("Distribution.Models.PurchaseReturnItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PurchaseReturnId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Quantity")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_PurchaseReturnId");
b.ToTable("PurchaseReturnItems");
b.HasData(
new
{
Id = new Guid("46000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 16, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_PurchaseReturnId = new Guid("45000000-0000-0000-0000-000000000001"),
IsActive = true,
Quantity = 10
});
});
modelBuilder.Entity("Distribution.Models.ReceivedCheque", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("AccountHolderName")
.HasColumnType("longtext");
b.Property<decimal>("Amount")
.HasColumnType("decimal(65,30)");
b.Property<int?>("BranchId")
.HasColumnType("int");
b.Property<DateTime>("ChequeDate")
.HasColumnType("datetime(6)");
b.Property<string>("ChequeNo")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("varchar(50)");
b.Property<int>("CompanyId")
.HasColumnType("int");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("CreatedBy")
.HasColumnType("longtext");
b.Property<DateTime?>("DepositDate")
.HasColumnType("datetime(6)");
b.Property<string>("DrawerBankBranch")
.HasColumnType("longtext");
b.Property<string>("DrawerBankName")
.HasColumnType("longtext");
b.Property<Guid?>("FK_DepositBankAccountId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Notes")
.HasColumnType("longtext");
b.Property<DateTime>("ReceivedDate")
.HasColumnType("datetime(6)");
b.Property<int?>("ReceivedFromId")
.HasColumnType("int");
b.Property<string>("ReceivedFromName")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("varchar(200)");
b.Property<int>("ReceivedFromType")
.HasColumnType("int");
b.Property<int?>("ReferenceId")
.HasColumnType("int");
b.Property<string>("ReferenceType")
.HasColumnType("longtext");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("ChequeNo");
b.HasIndex("FK_DepositBankAccountId");
b.ToTable("ReceivedCheques");
});
modelBuilder.Entity("Distribution.Models.Region", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("Code")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("varchar(50)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("Code")
.IsUnique();
b.ToTable("Regions");
b.HasData(
new
{
Id = new Guid("24000000-0000-0000-0000-000000000001"),
Code = "REG-0001",
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Western Province"
},
new
{
Id = new Guid("24000000-0000-0000-0000-000000000002"),
Code = "REG-0002",
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Central Province"
});
});
modelBuilder.Entity("Distribution.Models.RegionAgencyMap", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_AgencyUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.HasIndex("FK_AgencyUserId");
b.HasIndex("FK_RegionId", "FK_AgencyUserId")
.IsUnique();
b.ToTable("RegionAgencyMaps");
b.HasData(
new
{
Id = new Guid("57000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_AgencyUserId = new Guid("70000000-0000-0000-0000-000000000001"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.RegionalBudget", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal>("BudgetAmount")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Period")
.IsRequired()
.HasColumnType("varchar(255)");
b.HasKey("Id");
b.HasIndex("FK_RegionId", "Period")
.IsUnique();
b.ToTable("RegionalBudgets");
b.HasData(
new
{
Id = new Guid("58000000-0000-0000-0000-000000000001"),
BudgetAmount = 200000m,
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Period = "2026-08"
});
});
modelBuilder.Entity("Distribution.Models.RegionalTarget", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Period")
.IsRequired()
.HasColumnType("varchar(255)");
b.Property<decimal>("TargetValue")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_RegionId", "Period")
.IsUnique();
b.ToTable("RegionalTargets");
b.HasData(
new
{
Id = new Guid("59000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Period = "2026-08",
TargetValue = 500000m
});
});
modelBuilder.Entity("Distribution.Models.RegionalTaxRule", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("RuleConfig")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_RegionId")
.IsUnique();
b.ToTable("RegionalTaxRules");
b.HasData(
new
{
Id = new Guid("60000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
RuleConfig = "{\"rate\": 0.15}"
});
});
modelBuilder.Entity("Distribution.Models.Role", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Level")
.HasColumnType("int");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.ToTable("Roles");
b.HasData(
new
{
Id = new Guid("10000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 10,
Name = "SalesRep"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 20,
Name = "Supervisor"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 30,
Name = "AreaManager"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 40,
Name = "AreaSupervisor"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 50,
Name = "RegionalManager"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000006"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 60,
Name = "RegionalAgency"
},
new
{
Id = new Guid("10000000-0000-0000-0000-000000000007"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Level = 100,
Name = "SuperAdmin"
});
});
modelBuilder.Entity("Distribution.Models.RolePermission", b =>
{
b.Property<Guid>("FK_RoleId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PermissionId")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("Id")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("FK_RoleId", "FK_PermissionId");
b.HasIndex("FK_PermissionId");
b.ToTable("RolePermissions");
b.HasData(
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("8c43c584-0f65-496d-a77c-a7df46bb175d"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("25576a9d-38cb-4ff5-b8ca-08df43d8a5a6"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("e47016c1-a014-476f-ba87-4b3d438de62a"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("a24c0e9e-0194-4f96-823c-bdbdcd122d85"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("e76ef6e2-67ba-462f-a954-b1dbc5a95d8c"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000006"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("bba4fdaa-fd0e-43dc-aedf-331212bd06cd"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000007"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("bc66d450-af6b-426e-9d05-266ceba21fac"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000008"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("9ee2196c-1e4b-452d-aaf6-7c55e3d2be2b"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000009"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("63508590-7a30-4640-9fc9-d3d54978f581"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000010"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("82802a3f-23bc-45db-a531-d7e880dd7970"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000011"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("65ccf5b6-754a-431a-81bf-d8e0587c956e"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000012"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("6c713413-362b-475a-846b-9f3382cf7a35"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000013"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("6dfe68ff-f5a3-41a8-981b-ac108a81408e"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000014"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("09c6b812-dc14-44a2-9362-429dfef3942d"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000015"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("bf29a1bb-234e-47a3-922f-f0fb3a1daba0"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000016"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("0d2f3497-4852-453e-a451-275e945b6c1d"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000017"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("41c13dbc-4f51-4134-891c-b6955f728d65"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000018"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("29bc0291-7a91-4fc5-840b-9420b64b86fc"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000019"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("8ae0c386-d206-4580-890f-c1673c1dfeb2"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000020"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("5db4bd09-9481-4608-9dec-3412ba7f3f69"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000021"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("c1840bd7-88fd-496a-8d88-aef3d886e1ec"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000022"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("af97d659-c040-4fdc-beeb-62fc8334f95c"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000023"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("a6443517-3c2a-4407-a3bd-5497e053b0d6"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000024"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("2f540d56-bff4-41fe-9181-4a423c1da51c"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000025"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("db18cfb8-a56c-46bc-baff-298e6204c455"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000026"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("fe209c12-1189-485b-920e-ce6db3c132b9"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000027"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("fedef395-394d-4237-b5aa-8254603ed304"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000028"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("7cc47626-65b8-44b0-83fb-a5dff96c39f6"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000029"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("cf04aea5-3f47-4717-95aa-8dab547f9cfb"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000030"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("c2906d62-9eea-4d08-b904-86a3f8b04a20"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000031"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("7a546bf9-c2f3-4d23-a38e-a068da53dfeb"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000032"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("19c916c3-7b17-42e0-b4b6-89b8cb6475f4"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000033"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("e6805dbe-a931-4e2a-b08f-83e8760d4968"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000034"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("7d991f5c-16db-46c5-863c-93063c2e7382"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000035"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("513c50d0-5d7b-426d-beef-f14bdea626bc"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000036"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("638a6a60-25da-425c-bdec-683431c26d62"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000037"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("b00bfae6-92bb-48cb-99d9-f2814baae47d"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000038"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("6562c9b4-0673-4ce0-8805-03734bc889ce"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000039"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("6601e0fe-83dd-4307-be91-38dae998cc9c"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000040"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("c4848449-9678-4fa6-8a00-db4e504b57d6"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000041"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("91c02c24-12a3-48d5-9d19-174c8e764152"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000042"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("0f00477f-5120-40ba-a0e6-0406e47d1c80"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000043"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("db135a10-6335-478d-b2f8-3b5934cd142b"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000044"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("5c219dd9-9ff3-4541-a708-cc7e4bd4dd25"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000045"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("086e7b93-079d-49d0-90e9-95899b53be52"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000046"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("f0b3d172-cb32-4606-8272-00feaf4067a2"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000047"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("75a882c0-b2e9-4efa-a64c-b5d530d42194"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000048"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("03540f63-d811-4436-869f-2f76995bbb19"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000049"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("73894d9f-a823-4b5b-b809-5cc0aa716a70"),
IsActive = true
},
new
{
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FK_PermissionId = new Guid("20000000-0000-0000-0000-000000000050"),
CreatedAt = new DateTime(2026, 8, 18, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("1ad4bfb8-cde6-4623-a21d-9a78af0026d6"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.Route", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("EndPoint")
.HasColumnType("longtext");
b.Property<Guid?>("FK_OwnerUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal?>("Length")
.HasColumnType("decimal(65,30)");
b.Property<string>("RouteName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("StartPoint")
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_OwnerUserId");
b.HasIndex("FK_RegionId");
b.ToTable("Routes");
b.HasData(
new
{
Id = new Guid("25000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
EndPoint = "Dehiwala",
FK_OwnerUserId = new Guid("29000000-0000-0000-0000-000000000002"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Length = 18.5m,
RouteName = "Colombo City Route",
StartPoint = "Colombo Fort"
},
new
{
Id = new Guid("25000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
EndPoint = "Negombo",
FK_OwnerUserId = new Guid("29000000-0000-0000-0000-000000000002"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
IsActive = true,
Length = 32.0m,
RouteName = "Negombo Coastal Route",
StartPoint = "Wattala"
},
new
{
Id = new Guid("25000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
EndPoint = "Peradeniya",
FK_OwnerUserId = new Guid("29000000-0000-0000-0000-000000000003"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000002"),
IsActive = true,
Length = 12.0m,
RouteName = "Kandy Town Route",
StartPoint = "Kandy Lake"
},
new
{
Id = new Guid("25000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
EndPoint = "Matale",
FK_OwnerUserId = new Guid("29000000-0000-0000-0000-000000000003"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000002"),
IsActive = true,
Length = 26.0m,
RouteName = "Matale Route",
StartPoint = "Kandy"
});
});
modelBuilder.Entity("Distribution.Models.RouteVisitLog", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CheckInAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("CheckInLatitude")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("CheckInLongitude")
.HasColumnType("decimal(65,30)");
b.Property<DateTime?>("CheckOutAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_RouteId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_StoreId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsDeviationFlagged")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.HasIndex("FK_RouteId");
b.HasIndex("FK_StoreId");
b.HasIndex("FK_UserId");
b.ToTable("RouteVisitLogs");
b.HasData(
new
{
Id = new Guid("66000000-0000-0000-0000-000000000001"),
CheckInAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
CheckInLatitude = 6.9344m,
CheckInLongitude = 79.8428m,
CheckOutAt = new DateTime(2026, 8, 25, 9, 25, 0, 0, DateTimeKind.Unspecified),
CreatedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000001"),
FK_UserId = new Guid("29000000-0000-0000-0000-000000000002"),
IsActive = true,
IsDeviationFlagged = false
},
new
{
Id = new Guid("66000000-0000-0000-0000-000000000002"),
CheckInAt = new DateTime(2026, 8, 25, 10, 0, 0, 0, DateTimeKind.Unspecified),
CheckInLatitude = 6.9000m,
CheckInLongitude = 79.8654m,
CreatedAt = new DateTime(2026, 8, 25, 10, 0, 0, 0, DateTimeKind.Unspecified),
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000002"),
FK_UserId = new Guid("29000000-0000-0000-0000-000000000002"),
IsActive = true,
IsDeviationFlagged = true
});
});
modelBuilder.Entity("Distribution.Models.SaleReturn", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("CreatedByUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Mode")
.HasColumnType("int");
b.Property<decimal>("TotalCreditAmount")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("CreatedByUserId");
b.HasIndex("FK_ShopPOId");
b.ToTable("SaleReturns");
b.HasData(
new
{
Id = new Guid("51000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 26, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreatedByUserId = new Guid("29000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
IsActive = true,
Mode = 0,
TotalCreditAmount = 300m
});
});
modelBuilder.Entity("Distribution.Models.SaleReturnItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SaleReturnId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("Quantity")
.HasColumnType("decimal(65,30)");
b.Property<int>("ReasonCode")
.HasColumnType("int");
b.Property<decimal>("UnitPrice")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_SaleReturnId");
b.ToTable("SaleReturnItems");
b.HasData(
new
{
Id = new Guid("52000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 26, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_SaleReturnId = new Guid("51000000-0000-0000-0000-000000000001"),
IsActive = true,
Quantity = 5m,
ReasonCode = 1,
UnitPrice = 60m
});
});
modelBuilder.Entity("Distribution.Models.SaleRoute", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("Id");
b.ToTable("SaleRoutes");
b.HasData(
new
{
Id = new Guid("69000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true
},
new
{
Id = new Guid("69000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.Scheme", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<bool>("AgentLimitExempt")
.HasColumnType("tinyint(1)");
b.Property<decimal?>("BaselineExpectedSales")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<DateTime>("DateRangeFrom")
.HasColumnType("datetime(6)");
b.Property<DateTime>("DateRangeTo")
.HasColumnType("datetime(6)");
b.Property<string>("EligibleSegment")
.HasColumnType("longtext");
b.Property<Guid?>("FK_FreeItemId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_TriggerItemId")
.HasColumnType("char(36)");
b.Property<decimal?>("FreeQty")
.HasColumnType("decimal(65,30)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<Guid?>("RegionId")
.HasColumnType("char(36)");
b.Property<string>("RuleConfig")
.HasColumnType("longtext");
b.Property<int>("RuleType")
.HasColumnType("int");
b.Property<int?>("TriggerQty")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_FreeItemId");
b.HasIndex("FK_TriggerItemId");
b.HasIndex("RegionId");
b.ToTable("Schemes");
b.HasData(
new
{
Id = new Guid("48000000-0000-0000-0000-000000000001"),
AgentLimitExempt = false,
BaselineExpectedSales = 500000m,
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DateRangeFrom = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DateRangeTo = new DateTime(2026, 12, 31, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_FreeItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
FK_TriggerItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FreeQty = 1m,
IsActive = true,
Name = "Buy 10 Coke Get 1 Free",
RuleType = 0,
TriggerQty = 10
},
new
{
Id = new Guid("48000000-0000-0000-0000-000000000002"),
AgentLimitExempt = false,
CreatedAt = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DateRangeFrom = new DateTime(2026, 8, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DateRangeTo = new DateTime(2026, 12, 31, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_FreeItemId = new Guid("23000000-0000-0000-0000-000000000004"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000002"),
FreeQty = 1m,
IsActive = true,
Name = "Snack Combo Bundle",
RuleType = 3
});
});
modelBuilder.Entity("Distribution.Models.SchemeBundleComponent", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SchemeId")
.HasColumnType("char(36)");
b.Property<int>("Qty")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_SchemeId", "FK_ItemId")
.IsUnique();
b.ToTable("SchemeBundleComponents");
b.HasData(
new
{
Id = new Guid("49000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_SchemeId = new Guid("48000000-0000-0000-0000-000000000002"),
Qty = 5
});
});
modelBuilder.Entity("Distribution.Models.SchemeRedemption", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<decimal?>("DiscountAmount")
.HasColumnType("decimal(65,30)");
b.Property<Guid?>("FK_FreeItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SchemeId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<Guid?>("FieldInvoiceId")
.HasColumnType("char(36)");
b.Property<decimal?>("FreeItemCostValue")
.HasColumnType("decimal(65,30)");
b.Property<decimal?>("FreeQty")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("RedeemedAt")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_FreeItemId");
b.HasIndex("FK_SchemeId");
b.HasIndex("FK_ShopPOId");
b.ToTable("SchemeRedemptions");
b.HasData(
new
{
Id = new Guid("50000000-0000-0000-0000-000000000001"),
DiscountAmount = 0m,
FK_FreeItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_SchemeId = new Guid("48000000-0000-0000-0000-000000000001"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
FreeItemCostValue = 40m,
FreeQty = 1m,
RedeemedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified)
});
});
modelBuilder.Entity("Distribution.Models.ShopPO", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("CancelReason")
.HasColumnType("longtext");
b.Property<DateTime?>("CancelledAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("CancelledBy")
.HasColumnType("char(36)");
b.Property<DateTime?>("ConfirmedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("ConfirmedBy")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_StoreId")
.HasColumnType("char(36)");
b.Property<DateTime?>("FulfilledAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("InvoiceId")
.HasColumnType("char(36)")
.HasColumnName("InvoiceId");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<Guid>("RaisedById")
.HasColumnType("char(36)");
b.Property<int>("Status")
.HasColumnType("int");
b.Property<decimal>("TotalAmount")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_StoreId");
b.ToTable("ShopPOs");
b.HasData(
new
{
Id = new Guid("33000000-0000-0000-0000-000000000001"),
ConfirmedAt = new DateTime(2026, 8, 25, 8, 30, 0, 0, DateTimeKind.Unspecified),
ConfirmedBy = new Guid("29000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000001"),
FulfilledAt = new DateTime(2026, 8, 25, 13, 0, 0, 0, DateTimeKind.Unspecified),
InvoiceId = new Guid("34500000-0000-0000-0000-000000000001"),
IsActive = true,
RaisedById = new Guid("29000000-0000-0000-0000-000000000002"),
Status = 2,
TotalAmount = 3000m
},
new
{
Id = new Guid("33000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 30, 10, 0, 0, 0, DateTimeKind.Unspecified),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000005"),
IsActive = true,
RaisedById = new Guid("29000000-0000-0000-0000-000000000003"),
Status = 0,
TotalAmount = 1200m
},
new
{
Id = new Guid("33000000-0000-0000-0000-000000000003"),
ConfirmedAt = new DateTime(2026, 8, 31, 8, 30, 0, 0, DateTimeKind.Unspecified),
ConfirmedBy = new Guid("29000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 31, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000005"),
FulfilledAt = new DateTime(2026, 8, 31, 13, 0, 0, 0, DateTimeKind.Unspecified),
InvoiceId = new Guid("34500000-0000-0000-0000-000000000002"),
IsActive = true,
RaisedById = new Guid("29000000-0000-0000-0000-000000000003"),
Status = 2,
TotalAmount = 2400m
});
});
modelBuilder.Entity("Distribution.Models.ShopPOItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ShopPOId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("Quantity")
.HasColumnType("int");
b.Property<int>("QuantityFulfilled")
.HasColumnType("int");
b.Property<decimal>("UnitPrice")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_ShopPOId");
b.ToTable("ShopPOItems");
b.HasData(
new
{
Id = new Guid("34000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
IsActive = true,
Quantity = 30,
QuantityFulfilled = 30,
UnitPrice = 60m
},
new
{
Id = new Guid("34000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 25, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000001"),
IsActive = true,
Quantity = 24,
QuantityFulfilled = 24,
UnitPrice = 50m
},
new
{
Id = new Guid("34000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 30, 10, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000002"),
IsActive = true,
Quantity = 10,
QuantityFulfilled = 0,
UnitPrice = 120m
},
new
{
Id = new Guid("34000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 31, 9, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000002"),
FK_ShopPOId = new Guid("33000000-0000-0000-0000-000000000003"),
IsActive = true,
Quantity = 20,
QuantityFulfilled = 20,
UnitPrice = 120m
});
});
modelBuilder.Entity("Distribution.Models.StockBalance", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemBatchId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemSerialNumberId")
.HasColumnType("char(36)");
b.Property<Guid>("LocationId")
.HasColumnType("char(36)");
b.Property<int>("LocationType")
.HasColumnType("int");
b.Property<decimal>("Quantity")
.HasColumnType("decimal(65,30)");
b.Property<DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.HasKey("Id");
b.HasIndex("FK_ItemBatchId");
b.HasIndex("FK_ItemSerialNumberId");
b.HasIndex("FK_ItemId", "LocationId", "FK_ItemBatchId", "FK_ItemSerialNumberId")
.IsUnique();
b.ToTable("StockBalances");
b.HasData(
new
{
Id = new Guid("61000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
LocationId = new Guid("27000000-0000-0000-0000-000000000001"),
LocationType = 0,
Quantity = 150m,
UpdatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified)
},
new
{
Id = new Guid("61000000-0000-0000-0000-000000000002"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000003"),
LocationId = new Guid("27000000-0000-0000-0000-000000000001"),
LocationType = 0,
Quantity = 90m,
UpdatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified)
},
new
{
Id = new Guid("61000000-0000-0000-0000-000000000003"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
LocationId = new Guid("28000000-0000-0000-0000-000000000001"),
LocationType = 1,
Quantity = 20m,
UpdatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified)
});
});
modelBuilder.Entity("Distribution.Models.StockMovement", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("CreatedBy")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemBatchId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid?>("FK_ItemSerialNumberId")
.HasColumnType("char(36)");
b.Property<Guid?>("FromLocationId")
.HasColumnType("char(36)");
b.Property<int?>("FromLocationType")
.HasColumnType("int");
b.Property<decimal>("Quantity")
.HasColumnType("decimal(65,30)");
b.Property<string>("ReasonCode")
.HasColumnType("longtext");
b.Property<Guid?>("ReferenceId")
.HasColumnType("char(36)");
b.Property<Guid?>("ToLocationId")
.HasColumnType("char(36)");
b.Property<int?>("ToLocationType")
.HasColumnType("int");
b.Property<int>("Type")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_ItemBatchId");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_ItemSerialNumberId");
b.ToTable("StockMovements");
b.HasData(
new
{
Id = new Guid("62000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FromLocationId = new Guid("00000000-0000-0000-0000-000000000000"),
FromLocationType = 2,
Quantity = 200m,
ReferenceId = new Guid("43000000-0000-0000-0000-000000000001"),
ToLocationId = new Guid("27000000-0000-0000-0000-000000000001"),
ToLocationType = 0,
Type = 6
},
new
{
Id = new Guid("62000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 25, 7, 30, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FromLocationId = new Guid("27000000-0000-0000-0000-000000000001"),
FromLocationType = 0,
Quantity = 50m,
ReferenceId = new Guid("35000000-0000-0000-0000-000000000001"),
ToLocationId = new Guid("28000000-0000-0000-0000-000000000001"),
ToLocationType = 1,
Type = 5
},
new
{
Id = new Guid("62000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 25, 9, 30, 0, 0, DateTimeKind.Unspecified),
CreatedBy = new Guid("29000000-0000-0000-0000-000000000002"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FromLocationId = new Guid("28000000-0000-0000-0000-000000000001"),
FromLocationType = 1,
Quantity = 30m,
ReferenceId = new Guid("32000000-0000-0000-0000-000000000001"),
ToLocationId = new Guid("00000000-0000-0000-0000-000000000000"),
ToLocationType = 2,
Type = 0
});
});
modelBuilder.Entity("Distribution.Models.Store", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("ContactNumber")
.HasColumnType("longtext");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<decimal>("CreditAmount")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("CreditLimit")
.HasColumnType("decimal(65,30)");
b.Property<Guid>("FK_RouteId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<decimal>("Latitude")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("Longitude")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("OneTimeAmount")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("OutstandingBalance")
.HasColumnType("decimal(65,30)");
b.Property<string>("OwnerName")
.HasColumnType("longtext");
b.Property<string>("Segment")
.HasColumnType("longtext");
b.Property<string>("StoreAddress")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("StoreName")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_RouteId");
b.ToTable("Stores");
b.HasData(
new
{
Id = new Guid("26000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 50000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
IsActive = true,
Latitude = 6.9344m,
Longitude = 79.8428m,
OneTimeAmount = 0m,
OutstandingBalance = 0m,
OwnerName = "Saman Kumara",
Segment = "Gold",
StoreAddress = "12 York Street, Colombo Fort",
StoreName = "Fort Mini Mart"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 30000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
IsActive = true,
Latitude = 6.8508m,
Longitude = 79.8654m,
OneTimeAmount = 0m,
OutstandingBalance = 5000m,
OwnerName = "Nadeesha Silva",
Segment = "Silver",
StoreAddress = "45 Galle Road, Dehiwala",
StoreName = "Dehiwala Grocery"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 40000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000002"),
IsActive = true,
Latitude = 6.9890m,
Longitude = 79.8912m,
OneTimeAmount = 0m,
OutstandingBalance = 1200m,
OwnerName = "Ruwan Gunasekara",
Segment = "Gold",
StoreAddress = "88 Negombo Road, Wattala",
StoreName = "Wattala Supermarket"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 25000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000002"),
IsActive = true,
Latitude = 7.2094m,
Longitude = 79.8380m,
OneTimeAmount = 0m,
OutstandingBalance = 0m,
OwnerName = "Chamari Peiris",
StoreAddress = "5 Beach Road, Negombo",
StoreName = "Negombo Beach Store"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 35000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000003"),
IsActive = true,
Latitude = 7.2906m,
Longitude = 80.6337m,
OneTimeAmount = 0m,
OutstandingBalance = 0m,
OwnerName = "Dinesh Wickramasinghe",
Segment = "Key Account",
StoreAddress = "3 Lake Road, Kandy",
StoreName = "Kandy Lake View Store"
},
new
{
Id = new Guid("26000000-0000-0000-0000-000000000006"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
CreditAmount = 0m,
CreditLimit = 20000m,
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000004"),
IsActive = true,
Latitude = 7.4675m,
Longitude = 80.6234m,
OneTimeAmount = 0m,
OutstandingBalance = 0m,
OwnerName = "Ishara Bandara",
StoreAddress = "20 Main Street, Matale",
StoreName = "Matale Central Store"
});
});
modelBuilder.Entity("Distribution.Models.SubCategory", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int?>("ExternalErpId")
.HasColumnType("int");
b.Property<Guid>("FK_CategoryId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_CategoryId");
b.ToTable("SubCategories");
});
modelBuilder.Entity("Distribution.Models.Supplier", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<string>("ContactInfo")
.HasColumnType("longtext");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<decimal?>("PerformanceScore")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.ToTable("Suppliers");
b.HasData(
new
{
Id = new Guid("38000000-0000-0000-0000-000000000001"),
ContactInfo = "+94 11 234 5678",
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Ceylon Beverages Ltd",
PerformanceScore = 4.2m
},
new
{
Id = new Guid("38000000-0000-0000-0000-000000000002"),
ContactInfo = "+94 11 876 5432",
CreatedAt = new DateTime(2026, 8, 14, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Snack Foods (Pvt) Ltd"
});
});
modelBuilder.Entity("Distribution.Models.SupplierClaim", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Details")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("EvidenceUrl")
.HasColumnType("longtext");
b.Property<Guid?>("FK_GoodsReceiptId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_PurchaseOrderId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<Guid>("RaisedByUserId")
.HasColumnType("char(36)");
b.Property<decimal?>("ResolutionAmount")
.HasColumnType("decimal(65,30)");
b.Property<string>("ResolutionNotes")
.HasColumnType("longtext");
b.Property<int?>("ResolutionType")
.HasColumnType("int");
b.Property<DateTime?>("ResolvedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("ResolvedByUserId")
.HasColumnType("char(36)");
b.Property<int>("Status")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FK_GoodsReceiptId");
b.HasIndex("FK_PurchaseOrderId");
b.HasIndex("RaisedByUserId");
b.HasIndex("ResolvedByUserId");
b.ToTable("SupplierClaims");
b.HasData(
new
{
Id = new Guid("55000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
Details = "2 units of Coke 1.5L received damaged",
FK_GoodsReceiptId = new Guid("43000000-0000-0000-0000-000000000001"),
FK_PurchaseOrderId = new Guid("41000000-0000-0000-0000-000000000001"),
IsActive = true,
RaisedByUserId = new Guid("29000000-0000-0000-0000-000000000001"),
ResolutionAmount = 160m,
ResolutionNotes = "Credited against next invoice",
ResolutionType = 1,
ResolvedAt = new DateTime(2026, 8, 16, 0, 0, 0, 0, DateTimeKind.Unspecified),
ResolvedByUserId = new Guid("29000000-0000-0000-0000-000000000006"),
Status = 1
});
});
modelBuilder.Entity("Distribution.Models.SupplierClaimItem", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_SupplierClaimId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<int>("IssueType")
.HasColumnType("int");
b.Property<decimal>("Quantity")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_SupplierClaimId");
b.ToTable("SupplierClaimItems");
b.HasData(
new
{
Id = new Guid("56000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 15, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000002"),
FK_SupplierClaimId = new Guid("55000000-0000-0000-0000-000000000001"),
IsActive = true,
IssueType = 0,
Quantity = 2m
});
});
modelBuilder.Entity("Distribution.Models.SysConfig", b =>
{
b.Property<string>("Key")
.HasMaxLength(100)
.HasColumnType("varchar(100)");
b.Property<DateTime>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("UpdatedBy")
.HasColumnType("char(36)");
b.Property<string>("Value")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Key");
b.ToTable("SysConfigs");
b.HasData(
new
{
Key = "InvoiceCreationMode",
UpdatedAt = new DateTime(2026, 9, 17, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "ModeB"
},
new
{
Key = "Feature.SerialNumberTracking",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.BatchTracking",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.ExpiryDateTracking",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.WarrantyTracking",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.CustomWarrantyOverride",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "false"
},
new
{
Key = "Feature.DefaultWarrantyPeriodDays",
UpdatedAt = new DateTime(2026, 10, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Value = "0"
});
});
modelBuilder.Entity("Distribution.Models.Uom", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<int?>("ExternalErpId")
.HasColumnType("int");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.ToTable("Uoms");
b.HasData(
new
{
Id = new Guid("22000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Piece"
},
new
{
Id = new Guid("67000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Name = "Case"
});
});
modelBuilder.Entity("Distribution.Models.UomConversion", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<Guid>("FK_FromUomId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ItemId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_ToUomId")
.HasColumnType("char(36)");
b.Property<decimal>("Factor")
.HasColumnType("decimal(65,30)");
b.HasKey("Id");
b.HasIndex("FK_FromUomId");
b.HasIndex("FK_ItemId");
b.HasIndex("FK_ToUomId");
b.ToTable("UomConversions");
b.HasData(
new
{
Id = new Guid("67000000-0000-0000-0000-000000000002"),
FK_FromUomId = new Guid("67000000-0000-0000-0000-000000000001"),
FK_ItemId = new Guid("23000000-0000-0000-0000-000000000001"),
FK_ToUomId = new Guid("22000000-0000-0000-0000-000000000001"),
Factor = 24m
});
});
modelBuilder.Entity("Distribution.Models.User", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("FK_ReportsToUserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RoleId")
.HasColumnType("char(36)");
b.Property<string>("FullName")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<DateTime?>("UpdatedAt")
.HasColumnType("datetime(6)");
b.Property<string>("Username")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("Id");
b.HasIndex("FK_ReportsToUserId");
b.HasIndex("FK_RoleId");
b.ToTable("Users");
b.HasData(
new
{
Id = new Guid("29000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000002"),
FullName = "Sunil Fernando",
IsActive = true,
Username = "sunil.fernando"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ReportsToUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000001"),
FullName = "Nimal Perera",
IsActive = true,
Username = "nimal.perera"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000003"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ReportsToUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000001"),
FullName = "Kamal Silva",
IsActive = true,
Username = "kamal.silva"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000004"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ReportsToUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000001"),
FullName = "Ruwan Jayasuriya",
IsActive = true,
Username = "ruwan.jayasuriya"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_ReportsToUserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000001"),
FullName = "Priyantha Kumara",
IsActive = true,
Username = "priyantha.kumara"
},
new
{
Id = new Guid("29000000-0000-0000-0000-000000000006"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000005"),
FullName = "Priya Rajapaksa",
IsActive = true,
Username = "priya.rajapaksa"
},
new
{
Id = new Guid("70000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000006"),
FullName = "Channa De Silva",
IsActive = true,
Username = "channa.desilva"
},
new
{
Id = new Guid("00000001-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 10, 13, 0, 0, 0, 0, DateTimeKind.Unspecified),
FK_RoleId = new Guid("10000000-0000-0000-0000-000000000007"),
FullName = "Super Admin",
IsActive = true,
Username = "superadmin"
});
});
modelBuilder.Entity("Distribution.Models.UserRegionScope", b =>
{
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RegionId")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("Id")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("FK_UserId", "FK_RegionId");
b.HasIndex("FK_RegionId");
b.ToTable("UserRegionScopes");
b.HasData(
new
{
FK_UserId = new Guid("29000000-0000-0000-0000-000000000006"),
FK_RegionId = new Guid("24000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("68000000-0000-0000-0000-000000000001"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.UserRouteScope", b =>
{
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_RouteId")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("Id")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("FK_UserId", "FK_RouteId");
b.HasIndex("FK_RouteId");
b.ToTable("UserRouteScopes");
b.HasData(
new
{
FK_UserId = new Guid("29000000-0000-0000-0000-000000000001"),
FK_RouteId = new Guid("25000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("68000000-0000-0000-0000-000000000002"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.UserStoreScope", b =>
{
b.Property<Guid>("FK_UserId")
.HasColumnType("char(36)");
b.Property<Guid>("FK_StoreId")
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid>("Id")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.HasKey("FK_UserId", "FK_StoreId");
b.HasIndex("FK_StoreId");
b.ToTable("UserStoreScopes");
b.HasData(
new
{
FK_UserId = new Guid("29000000-0000-0000-0000-000000000003"),
FK_StoreId = new Guid("26000000-0000-0000-0000-000000000005"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
Id = new Guid("68000000-0000-0000-0000-000000000003"),
IsActive = true
});
});
modelBuilder.Entity("Distribution.Models.Vehicle", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<Guid?>("DefaultWarehouseId")
.HasColumnType("char(36)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("NumberPlate")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("RegNumber")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("Type")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("DefaultWarehouseId");
b.ToTable("Vehicles");
b.HasData(
new
{
Id = new Guid("28000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
DefaultWarehouseId = new Guid("27000000-0000-0000-0000-000000000001"),
IsActive = true,
NumberPlate = "CAB-1234",
RegNumber = "WP-CAB-1234",
Type = 2
},
new
{
Id = new Guid("28000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
DefaultWarehouseId = new Guid("27000000-0000-0000-0000-000000000002"),
IsActive = true,
NumberPlate = "KY-5678",
RegNumber = "CP-KY-5678",
Type = 1
});
});
modelBuilder.Entity("Distribution.Models.Warehouse", b =>
{
b.Property<Guid>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("char(36)");
b.Property<DateTime>("CreatedAt")
.HasColumnType("datetime(6)");
b.Property<bool>("IsActive")
.HasColumnType("tinyint(1)");
b.Property<string>("Location")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("Type")
.HasColumnType("int");
b.Property<Guid?>("VehicleId")
.HasColumnType("char(36)");
b.HasKey("Id");
b.HasIndex("VehicleId");
b.ToTable("Warehouses");
b.HasData(
new
{
Id = new Guid("27000000-0000-0000-0000-000000000001"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Location = "Peliyagoda, Colombo",
Name = "Colombo Distribution Center",
Type = 0
},
new
{
Id = new Guid("27000000-0000-0000-0000-000000000002"),
CreatedAt = new DateTime(2026, 8, 20, 0, 0, 0, 0, DateTimeKind.Unspecified),
IsActive = true,
Location = "Katugastota, Kandy",
Name = "Kandy Fulfillment Center",
Type = 1
});
});
modelBuilder.Entity("Distribution.Models.ChequeBook", b =>
{
b.HasOne("Distribution.Models.BankAccount", "BankAccount")
.WithMany()
.HasForeignKey("FK_BankAccountId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("BankAccount");
});
modelBuilder.Entity("Distribution.Models.ChequePage", b =>
{
b.HasOne("Distribution.Models.ChequeBook", "ChequeBook")
.WithMany("Pages")
.HasForeignKey("FK_ChequeBookId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("ChequeBook");
});
modelBuilder.Entity("Distribution.Models.Claim", b =>
{
b.HasOne("Distribution.Models.User", "AgencyUser")
.WithMany()
.HasForeignKey("FK_AgencyUserId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.User", "SettledByUser")
.WithMany()
.HasForeignKey("SettledByUserId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("AgencyUser");
b.Navigation("SettledByUser");
});
modelBuilder.Entity("Distribution.Models.CreditNote", b =>
{
b.HasOne("Distribution.Models.SaleReturn", "SaleReturn")
.WithMany()
.HasForeignKey("FK_SaleReturnId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("SaleReturn");
});
modelBuilder.Entity("Distribution.Models.DeliveryRun", b =>
{
b.HasOne("Distribution.Models.DriverProfile", "DriverProfile")
.WithMany()
.HasForeignKey("FK_DriverProfileId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.Vehicle", "Vehicle")
.WithMany()
.HasForeignKey("FK_VehicleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("DriverProfile");
b.Navigation("Vehicle");
});
modelBuilder.Entity("Distribution.Models.DeliveryTask", b =>
{
b.HasOne("Distribution.Models.DeliveryRun", "Ride")
.WithMany()
.HasForeignKey("FK_RideId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Ride");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.DriverProfile", b =>
{
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.GoodsReceipt", b =>
{
b.HasOne("Distribution.Models.PurchaseOrder", "PurchaseOrder")
.WithMany()
.HasForeignKey("FK_PurchaseOrderId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Supplier", "Supplier")
.WithMany()
.HasForeignKey("FK_SupplierId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Warehouse", "Warehouse")
.WithMany()
.HasForeignKey("FK_WarehouseId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("PurchaseOrder");
b.Navigation("Supplier");
b.Navigation("Warehouse");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItem", b =>
{
b.HasOne("Distribution.Models.GoodsReceipt", "GoodsReceipt")
.WithMany("Items")
.HasForeignKey("FK_GoodsReceiptId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.PurchaseOrderItem", "PurchaseOrderItem")
.WithMany()
.HasForeignKey("FK_PurchaseOrderItemId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("GoodsReceipt");
b.Navigation("Item");
b.Navigation("PurchaseOrderItem");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItemBatch", b =>
{
b.HasOne("Distribution.Models.GoodsReceiptItem", "GoodsReceiptItem")
.WithMany("Batches")
.HasForeignKey("FK_GoodsReceiptItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ItemBatch", "ItemBatch")
.WithMany()
.HasForeignKey("FK_ItemBatchId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("GoodsReceiptItem");
b.Navigation("ItemBatch");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItemSerial", b =>
{
b.HasOne("Distribution.Models.GoodsReceiptItem", "GoodsReceiptItem")
.WithMany("Serials")
.HasForeignKey("FK_GoodsReceiptItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ItemSerialNumber", "ItemSerialNumber")
.WithMany()
.HasForeignKey("FK_ItemSerialNumberId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("GoodsReceiptItem");
b.Navigation("ItemSerialNumber");
});
modelBuilder.Entity("Distribution.Models.Invoice", b =>
{
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.Item", b =>
{
b.HasOne("Distribution.Models.Uom", "BaseUom")
.WithMany()
.HasForeignKey("FK_BaseUomId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Brand", "Brand")
.WithMany()
.HasForeignKey("FK_BrandId");
b.HasOne("Distribution.Models.Category", "Category")
.WithMany()
.HasForeignKey("FK_CategoryId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.SubCategory", "SubCategory")
.WithMany()
.HasForeignKey("FK_SubCategoryId");
b.Navigation("BaseUom");
b.Navigation("Brand");
b.Navigation("Category");
b.Navigation("SubCategory");
});
modelBuilder.Entity("Distribution.Models.ItemBatch", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
});
modelBuilder.Entity("Distribution.Models.ItemSerialNumber", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
});
modelBuilder.Entity("Distribution.Models.LoadingSheet", b =>
{
b.HasOne("Distribution.Models.DeliveryRun", "Ride")
.WithMany()
.HasForeignKey("FK_RideId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Ride");
});
modelBuilder.Entity("Distribution.Models.LoadingSheetItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.LoadingSheet", "LoadingSheet")
.WithMany("Items")
.HasForeignKey("FK_LoadingSheetId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPOItem", "ShopPOItem")
.WithMany()
.HasForeignKey("FK_ShopPOItemId")
.OnDelete(DeleteBehavior.SetNull);
b.HasOne("Distribution.Models.Warehouse", "Warehouse")
.WithMany()
.HasForeignKey("FK_WarehouseId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("LoadingSheet");
b.Navigation("ShopPOItem");
b.Navigation("Warehouse");
});
modelBuilder.Entity("Distribution.Models.LoadingSheetOrder", b =>
{
b.HasOne("Distribution.Models.LoadingSheet", "LoadingSheet")
.WithMany("Orders")
.HasForeignKey("FK_LoadingSheetId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("LoadingSheet");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.Payment", b =>
{
b.HasOne("Distribution.Models.Invoice", "Invoice")
.WithMany("Payments")
.HasForeignKey("FK_InvoiceId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Invoice");
});
modelBuilder.Entity("Distribution.Models.PriceList", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId");
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.PriceListItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.PriceList", "PriceList")
.WithMany("Items")
.HasForeignKey("FK_PriceListId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Item");
b.Navigation("PriceList");
});
modelBuilder.Entity("Distribution.Models.PurchaseOrder", b =>
{
b.HasOne("Distribution.Models.Supplier", "Supplier")
.WithMany()
.HasForeignKey("FK_SupplierId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Supplier");
});
modelBuilder.Entity("Distribution.Models.PurchaseOrderItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.PurchaseOrder", "PurchaseOrder")
.WithMany("Items")
.HasForeignKey("FK_PurchaseOrderId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("PurchaseOrder");
});
modelBuilder.Entity("Distribution.Models.PurchaseReturn", b =>
{
b.HasOne("Distribution.Models.PurchaseOrder", "PurchaseOrder")
.WithMany()
.HasForeignKey("FK_PurchaseOrderId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("PurchaseOrder");
});
modelBuilder.Entity("Distribution.Models.PurchaseReturnItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.PurchaseReturn", "PurchaseReturn")
.WithMany("Items")
.HasForeignKey("FK_PurchaseReturnId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("PurchaseReturn");
});
modelBuilder.Entity("Distribution.Models.ReceivedCheque", b =>
{
b.HasOne("Distribution.Models.BankAccount", "DepositBankAccount")
.WithMany()
.HasForeignKey("FK_DepositBankAccountId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("DepositBankAccount");
});
modelBuilder.Entity("Distribution.Models.RegionAgencyMap", b =>
{
b.HasOne("Distribution.Models.User", "AgencyUser")
.WithMany()
.HasForeignKey("FK_AgencyUserId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("AgencyUser");
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RegionalBudget", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RegionalTarget", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RegionalTaxRule", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RolePermission", b =>
{
b.HasOne("Distribution.Models.Permission", "Permission")
.WithMany()
.HasForeignKey("FK_PermissionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Role", "Role")
.WithMany()
.HasForeignKey("FK_RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Permission");
b.Navigation("Role");
});
modelBuilder.Entity("Distribution.Models.Route", b =>
{
b.HasOne("Distribution.Models.User", "OwnerUser")
.WithMany()
.HasForeignKey("FK_OwnerUserId");
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("OwnerUser");
b.Navigation("Region");
});
modelBuilder.Entity("Distribution.Models.RouteVisitLog", b =>
{
b.HasOne("Distribution.Models.Route", "Route")
.WithMany()
.HasForeignKey("FK_RouteId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Store", "Store")
.WithMany()
.HasForeignKey("FK_StoreId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Route");
b.Navigation("Store");
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.SaleReturn", b =>
{
b.HasOne("Distribution.Models.User", "CreatedByUser")
.WithMany()
.HasForeignKey("CreatedByUserId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("CreatedByUser");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.SaleReturnItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.SaleReturn", "SaleReturn")
.WithMany("Items")
.HasForeignKey("FK_SaleReturnId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("SaleReturn");
});
modelBuilder.Entity("Distribution.Models.Scheme", b =>
{
b.HasOne("Distribution.Models.Item", "FreeItem")
.WithMany()
.HasForeignKey("FK_FreeItemId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Item", "TriggerItem")
.WithMany()
.HasForeignKey("FK_TriggerItemId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("RegionId");
b.Navigation("FreeItem");
b.Navigation("Region");
b.Navigation("TriggerItem");
});
modelBuilder.Entity("Distribution.Models.SchemeBundleComponent", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.Scheme", "Scheme")
.WithMany("BundleComponents")
.HasForeignKey("FK_SchemeId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Item");
b.Navigation("Scheme");
});
modelBuilder.Entity("Distribution.Models.SchemeRedemption", b =>
{
b.HasOne("Distribution.Models.Item", "FreeItem")
.WithMany()
.HasForeignKey("FK_FreeItemId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Scheme", "Scheme")
.WithMany("Redemptions")
.HasForeignKey("FK_SchemeId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany()
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("FreeItem");
b.Navigation("Scheme");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.ShopPO", b =>
{
b.HasOne("Distribution.Models.Store", "Store")
.WithMany()
.HasForeignKey("FK_StoreId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Store");
});
modelBuilder.Entity("Distribution.Models.ShopPOItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.ShopPO", "ShopPO")
.WithMany("Items")
.HasForeignKey("FK_ShopPOId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("ShopPO");
});
modelBuilder.Entity("Distribution.Models.StockBalance", b =>
{
b.HasOne("Distribution.Models.ItemBatch", "ItemBatch")
.WithMany()
.HasForeignKey("FK_ItemBatchId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.ItemSerialNumber", "ItemSerialNumber")
.WithMany()
.HasForeignKey("FK_ItemSerialNumberId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("Item");
b.Navigation("ItemBatch");
b.Navigation("ItemSerialNumber");
});
modelBuilder.Entity("Distribution.Models.StockMovement", b =>
{
b.HasOne("Distribution.Models.ItemBatch", "ItemBatch")
.WithMany()
.HasForeignKey("FK_ItemBatchId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.ItemSerialNumber", "ItemSerialNumber")
.WithMany()
.HasForeignKey("FK_ItemSerialNumberId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("Item");
b.Navigation("ItemBatch");
b.Navigation("ItemSerialNumber");
});
modelBuilder.Entity("Distribution.Models.Store", b =>
{
b.HasOne("Distribution.Models.Route", "Route")
.WithMany()
.HasForeignKey("FK_RouteId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Route");
});
modelBuilder.Entity("Distribution.Models.SubCategory", b =>
{
b.HasOne("Distribution.Models.Category", "Category")
.WithMany()
.HasForeignKey("FK_CategoryId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Category");
});
modelBuilder.Entity("Distribution.Models.SupplierClaim", b =>
{
b.HasOne("Distribution.Models.GoodsReceipt", "GoodsReceipt")
.WithMany()
.HasForeignKey("FK_GoodsReceiptId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.PurchaseOrder", "PurchaseOrder")
.WithMany()
.HasForeignKey("FK_PurchaseOrderId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.User", "RaisedByUser")
.WithMany()
.HasForeignKey("RaisedByUserId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.User", "ResolvedByUser")
.WithMany()
.HasForeignKey("ResolvedByUserId")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("GoodsReceipt");
b.Navigation("PurchaseOrder");
b.Navigation("RaisedByUser");
b.Navigation("ResolvedByUser");
});
modelBuilder.Entity("Distribution.Models.SupplierClaimItem", b =>
{
b.HasOne("Distribution.Models.Item", "Item")
.WithMany()
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("Distribution.Models.SupplierClaim", "SupplierClaim")
.WithMany("Items")
.HasForeignKey("FK_SupplierClaimId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("Item");
b.Navigation("SupplierClaim");
});
modelBuilder.Entity("Distribution.Models.UomConversion", b =>
{
b.HasOne("Distribution.Models.Uom", "FromUom")
.WithMany()
.HasForeignKey("FK_FromUomId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Item", "Item")
.WithMany("Conversions")
.HasForeignKey("FK_ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.Uom", "ToUom")
.WithMany()
.HasForeignKey("FK_ToUomId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("FromUom");
b.Navigation("Item");
b.Navigation("ToUom");
});
modelBuilder.Entity("Distribution.Models.User", b =>
{
b.HasOne("Distribution.Models.User", "ReportsTo")
.WithMany()
.HasForeignKey("FK_ReportsToUserId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("Distribution.Models.Role", "Role")
.WithMany()
.HasForeignKey("FK_RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("ReportsTo");
b.Navigation("Role");
});
modelBuilder.Entity("Distribution.Models.UserRegionScope", b =>
{
b.HasOne("Distribution.Models.Region", "Region")
.WithMany()
.HasForeignKey("FK_RegionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Region");
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.UserRouteScope", b =>
{
b.HasOne("Distribution.Models.Route", "Route")
.WithMany()
.HasForeignKey("FK_RouteId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Route");
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.UserStoreScope", b =>
{
b.HasOne("Distribution.Models.Store", "Store")
.WithMany()
.HasForeignKey("FK_StoreId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Distribution.Models.User", "User")
.WithMany()
.HasForeignKey("FK_UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Store");
b.Navigation("User");
});
modelBuilder.Entity("Distribution.Models.Vehicle", b =>
{
b.HasOne("Distribution.Models.Warehouse", null)
.WithMany()
.HasForeignKey("DefaultWarehouseId")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("Distribution.Models.Warehouse", b =>
{
b.HasOne("Distribution.Models.Vehicle", "Vehicle")
.WithMany()
.HasForeignKey("VehicleId");
b.Navigation("Vehicle");
});
modelBuilder.Entity("Distribution.Models.ChequeBook", b =>
{
b.Navigation("Pages");
});
modelBuilder.Entity("Distribution.Models.GoodsReceipt", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.GoodsReceiptItem", b =>
{
b.Navigation("Batches");
b.Navigation("Serials");
});
modelBuilder.Entity("Distribution.Models.Invoice", b =>
{
b.Navigation("Payments");
});
modelBuilder.Entity("Distribution.Models.Item", b =>
{
b.Navigation("Conversions");
});
modelBuilder.Entity("Distribution.Models.LoadingSheet", b =>
{
b.Navigation("Items");
b.Navigation("Orders");
});
modelBuilder.Entity("Distribution.Models.PriceList", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.PurchaseOrder", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.PurchaseReturn", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.SaleReturn", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.Scheme", b =>
{
b.Navigation("BundleComponents");
b.Navigation("Redemptions");
});
modelBuilder.Entity("Distribution.Models.ShopPO", b =>
{
b.Navigation("Items");
});
modelBuilder.Entity("Distribution.Models.SupplierClaim", b =>
{
b.Navigation("Items");
});
#pragma warning restore 612, 618
}
}
}
Reference in New Issue View Git Blame Copy Permalink