builder.Services.AddScoped<ITaskFlowTypeService, TaskFlowTypeService>();
builder.Services.AddScoped<ITaskFlowUserService, TaskFlowUserService>();
builder.Services.AddScoped<ITaskFlowPlanService, TaskFlowPlanService>();

builder.Services.AddScoped<ITaskFlowTypeRepository, TaskFlowTypeRepository>();
builder.Services.AddScoped<ITaskFlowUserRepository, TaskFlowUserRepository>();
builder.Services.AddScoped<ITaskFlowPlanRepository, TaskFlowPlanRepository>();

CREATE TABLE TaskFlowType (
    Id INT PRIMARY KEY IDENTITY(1,1),
    TaskTypeCode NVARCHAR(3),
    TaskTypeName NVARCHAR(25),
    IsActive NVARCHAR(1)
);

public class TaskFlowType
{
    public int Id { get; set; }
    public string TaskTypeCode { get; set; } = string.Empty;
    [Required(ErrorMessage = "Task Type Name needs to be filled.")]
    [StringLength(25, ErrorMessage = "Task Type Name can be upto 25 characters only.")]
    public string TaskTypeName { get; set; } = string.Empty;
    public string IsActive { get; set; } = string.Empty;

    // Business Logic: TaskFlowTypeName duplicate not allowed
    // Validation should be implemented in service layer
}

CREATE TABLE  TaskFlowUsers(
    Id INT IDENTITY(1,1) PRIMARY KEY,
    TaskUserId NVARCHAR(3),
    TaskUserName NVARCHAR(25),
    Email NVARCHAR(100),
    ContactNo NVARCHAR(15),
    ErpUserId NVARCHAR(8),
    IsActive NVARCHAR(1)
);

public class TaskFlowUsers
{
    public int Id { get; set; }
    public string TaskUserId { get; set; } = string.Empty;

    // Business Logic: TaskUserFlow username can not be duplicate
    // Unique constraint should be implemented in database and validated in service layer
    [Required(ErrorMessage = "User Name needs to be filled.")]
    [StringLength(25, ErrorMessage = "User Name can be upto 25 characters only.")]
    public string TaskUserName { get; set; } = string.Empty;

    [Required(ErrorMessage = "Email needs to be filled.")]
    [EmailAddress(ErrorMessage = "Please enter a valid email address.")]
    public string Email { get; set; } = string.Empty;
    [Required(ErrorMessage = "Contact No needs to be filled.")]
    [Phone(ErrorMessage = "Please enter a valid contact number.")]
    public string ContactNo { get; set; } = string.Empty;
    public string IsActive { get; set; } = string.Empty;

    // Business Logic: TaskFlowuser will be linked by matching _dbname of user with erpcrystalmfg..users.dbname
    // Linking logic should be implemented in service/repository layer
    public string ErpUserId { get; set; } = string.Empty; // For Insertion
    public string ErpUserId { get; set; } = string.Empty; // For display (Readonly in Modify)
    [Required(ErrorMessage = "ERP User ID needs to be filled.")]
    public string ErpUserNameId { get; set; } = string.Empty; // For MudAutocomplete binding

    // Business Logic: Only Admin will be allowed to create/modify/delete TaskFlowUser
    // Authorization should be implemented in controller/service layer with role-based access
}

CREATE TABLE TaskFlowPlan
(
    Id INT PRIMARY KEY IDENTITY(1,1),
    TaskPlanId NVARCHAR(8),
    TaskPlanName NVARCHAR(50),
    TaskTypeCode NVARCHAR(3),
    RepeatTaskPlanId NVARCHAR(8),
    Description NVARCHAR(500),
    Priority NVARCHAR(10),
    CreatedBy NVARCHAR(3),
    AssignedTo NVARCHAR(3),
    StartDate DATETIME,
    TargetDate DATETIME,
    CommittedDate DATETIME,
    CompletedOn DATETIME,
    PartyId NVARCHAR(6),
    RmItemId NVARCHAR(6),
    FgItemId NVARCHAR(6),
    Qty DECIMAL(12,3),
    IsRepeating NVARCHAR(1),
    RepeatFrequency NVARCHAR(20),
    RepeatUntil DATETIME,
    TaskPlanStatus NVARCHAR(1),
    CreatorRemarks NVARCHAR(500),
    AssigneeRemarks NVARCHAR(500)
);

-- Dummy Data for TaskFlow Tables
-- 5 records each for TaskFlowUsers, TaskFlowType, and TaskFlowPlan

-- TaskFlowUsers dummy data (table name is plural)
INSERT INTO TaskFlowUsers (TaskUserId, TaskUserName, Email, ContactNo, ErpUserId, IsActive) VALUES
('004', 'Rahul Sharma', 'rahul@erpcrystal.in', '9876543210', '00000005', 'Y'),
('005', 'Priya Singh', 'priya@erpcrystal.in', '9876543211', '00000004', 'Y'),
('006', 'Amit Kumar', 'amit@erpcrystal.in', '9876543212', '00000003', 'Y'),
('007', 'Sneha Patel', 'sneha@erpcrystal.in', '9876543213', '00000003', 'Y'),
('008', 'Vikram Joshi', 'vikram@erpcrystal.in', '9876543214', '00000004', 'Y');

-- TaskFlowType dummy data
INSERT INTO TaskFlowType (TaskTypeCode, TaskTypeName, IsActive) VALUES
('004', 'PUR', 'Y'),
('005', 'SAL', 'Y'),
('006', 'INV', 'Y'),
('007', 'FIN', 'Y'),
('008', 'HR', 'Y');

-- TaskFlowPlan dummy data
INSERT INTO TaskFlowPlan (TaskPlanId, TaskPlanName, TaskTypeCode, RepeatTaskPlanId, Description, Priority, CreatedBy, AssignedTo, StartDate, TargetDate, CommittedDate, CompletedOn, PartyId, RmItemId, FgItemId, Qty, IsRepeating, RepeatFrequency, RepeatUntil, TaskPlanStatus, CreatorRemarks, AssigneeRemarks) VALUES
('00000004', 'Purchase Order Processing', '004', '', 'Process pending purchase orders for raw materials', 'High', '004', '005', '2024-11-15', '2024-11-25', '2024-11-20', '2024-11-22', '', '', '', NULL, 'N', '', NULL, 'D', 'Orders processed successfully', 'All purchase orders completed'),
('00000005', 'Sales Report Generation', '005', '', 'Generate monthly sales performance report', 'Medium', '005', '006', '2024-11-20', '2024-12-05', '2024-12-01', '2024-12-03', '', '', '', NULL, 'N', '', NULL, 'D', 'Report generated and shared', 'Report looks comprehensive'),
('00000006', 'Inventory Stock Check', '006', '', 'Conduct physical inventory stock verification', 'High', '006', '007', '2024-11-25', '2024-12-10', NULL, NULL, '', '', '', NULL, 'N', '', NULL, 'I', 'Please complete stock check this week', 'Working on the verification'),
('00000007', 'Financial Audit Preparation', '007', '', 'Prepare documents for quarterly financial audit', 'High', '007', '008', '2024-12-01', '2024-12-15', NULL, NULL, '', '', '', NULL, 'N', '', NULL, 'T', 'Critical audit preparation task', ''),
('00000008', 'Employee Onboarding', '008', '', 'Complete onboarding process for new hires', 'Medium', '008', '004', '2024-12-05', '2024-12-20', NULL, NULL, '', '', '', NULL, 'N', '', NULL, 'T', 'Ensure all paperwork is completed', '');

public class TaskFlowPlan
{
    public int Id { get; set; }

    // Task Identification
    public string TaskPlanId { get; set; } = string.Empty;
    [Required(ErrorMessage = "Task Type is required.")]
    public string TaskTypeCode { get; set; } = string.Empty;
    public string RefTaskId { get; set; } = string.Empty;

    // Task Details
    [Required(ErrorMessage = "Task Name is required.")]
    [StringLength(50, ErrorMessage = "Task Name cannot exceed 50 characters.")]
    public string TaskPlanName { get; set; } = string.Empty;

    [StringLength(250, ErrorMessage = "Description cannot exceed 250 characters.")]
    public string Description { get; set; } = string.Empty;

    public string Priority { get; set; } = string.Empty; // Low/Medium/High

    // Assignment
    [Required(ErrorMessage = "Assigned By is required.")]
    public string CreatedBy { get; set; } = string.Empty;

    // Business Logic: Task can be assigned it itself (user can assign to themselves)
    // Validation should allow AssignTo to be same as CreatedBy
    [Required(ErrorMessage = "Assigned To is required.")]
    public string AssignTo { get; set; } = string.Empty;

    public string CreatedByName { get; set; } = string.Empty; // Populated via join from users table
    public string AssignToName { get; set; } = string.Empty; // Populated via join from users table

    // Dates
    [Required(ErrorMessage = "Start Date is required.")]
    public DateTime StartDate { get; set; }

    [Required(ErrorMessage = "Target Date is required.")]
    public DateTime TargetDate { get; set; }

    public DateTime? CommittedDate { get; set; }
    public DateTime? CompletedOn { get; set; }

    // ERP Integration
    public string PartyId { get; set; } = string.Empty;
    public DateTime? RefDate { get; set; }
    public string RmItemId { get; set; } = string.Empty;
    public string FgItemId { get; set; } = string.Empty;
    public decimal Qty { get; set; }

    // Repeating Configuration
    public string IsRepeating { get; set; } = string.Empty;
    public string Frequency { get; set; } = string.Empty; // Daily/Weekly/Monthly/Yearly
    public DateTime? RepeatUntil { get; set; }

    // Status & Tracking
    public string TaskPlanStatus { get; set; } = string.Empty;  // T=ToDo, U=Under Review, R=Rework, D=Done
    public string TaskPlanStatusName { get; set; } = string.Empty;  // T=ToDo, U=Under Review, R=Rework, D=Done

    [StringLength(500, ErrorMessage = "Remarks cannot exceed 500 characters.")]
    public string CreatorRemarks { get; set; } = string.Empty;

    [StringLength(500, ErrorMessage = "Remarks cannot exceed 500 characters.")]
    public string AssigneeRemarks { get; set; } = string.Empty;

    // Note: Computed properties (StatusName, IsOverdue, DaysPending, DaysOverdue) are handled in SQL
}