CallCycleController.cs

using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;

namespace SalesAPI.Controllers;

[ApiController]
[Route("api/[controller]")]
[Authorize]
public class CallCycleController : ControllerBase
{
    private readonly DatabaseHelper _db;

    public CallCycleController(DatabaseHelper db)
    {
        _db = db;
    }

    /// <summary>
    /// Get all call cycle entries
    /// </summary>
    [HttpGet]
    public IActionResult GetAll()
    {
        var cycles = _db.GetAllCallCycles();
        return Ok(cycles);
    }

    /// <summary>
    /// Upload call cycle Excel file (Admin only)
    /// </summary>
    [Authorize(Roles = "Admin")]
    [HttpPost("upload")]
    public async Task<IActionResult> UploadCallCycle(IFormFile file)
    {
        if (file == null || file.Length == 0)
            return BadRequest(new { message = "No file uploaded" });

        var tempPath = Path.GetTempFileName();
        
        try
        {
            using (var stream = new FileStream(tempPath, FileMode.Create))
            {
                await file.CopyToAsync(stream);
            }

            var cycles = ExcelParser.ParseCallCycle(tempPath);
            
            // Clear existing call cycle
            _db.ClearCallCycle();
            
            // Insert new entries
            foreach (var cycle in cycles)
            {
                // Try to match client by name
                var matchedClient = _db.GetAllClients().FirstOrDefault(c => 
                    c.CompanyName.Equals(cycle.ClientName, StringComparison.OrdinalIgnoreCase));
                
                if (matchedClient != null)
                {
                    cycle.ClientId = matchedClient.Id;
                }
                
                _db.UpsertCallCycle(cycle);
            }

            return Ok(new
            {
                message = "Call cycle uploaded successfully",
                total = cycles.Count
            });
        }
        finally
        {
            if (System.IO.File.Exists(tempPath))
                System.IO.File.Delete(tempPath);
        }
    }

    /// <summary>
    /// Get calendar view with actual dates calculated from start date
    /// Starts Monday, January 26, 2026 as Week 1 Day 1
    /// </summary>
    [HttpGet("calendar")]
    public IActionResult GetCalendar([FromQuery] string? startDate = null)
    {
        // Default start date: Monday, January 26, 2026
        DateTime cycleStart = new DateTime(2026, 1, 26);
        
        if (!string.IsNullOrEmpty(startDate) && DateTime.TryParse(startDate, out DateTime customStart))
        {
            cycleStart = customStart;
        }

        var cycles = _db.GetAllCallCycles();
        var appointments = _db.GetAppointmentRequests();
        
        var calendar = new List<CallCycleDay>();
        
        string[] days = { "Monday", "Tuesday", "Wednesday", "Thursday", "Friday" };
        
        for (int week = 1; week <= 4; week++)
        {
            for (int day = 0; day < 5; day++)
            {
                int daysOffset = ((week - 1) * 7) + day;
                DateTime actualDate = cycleStart.AddDays(daysOffset);
                
                var dayData = new CallCycleDay
                {
                    WeekNumber = week,
                    DayOfWeek = days[day],
                    ActualDate = actualDate,
                    Clients = cycles.Where(c => 
                        c.WeekNumber == week && 
                        c.DayOfWeek.Equals(days[day], StringComparison.OrdinalIgnoreCase))
                        .OrderBy(c => c.OrderInDay)
                        .ToList(),
                    Appointments = appointments.Where(a =>
                        a.RequestedDate == actualDate.ToString("yyyy-MM-dd") &&
                        a.Status == "Approved")
                        .ToList()
                };
                
                calendar.Add(dayData);
            }
        }
        
        return Ok(calendar);
    }

    /// <summary>
    /// Get current week number based on start date
    /// </summary>
    [HttpGet("current-week")]
    public IActionResult GetCurrentWeek()
    {
        DateTime cycleStart = new DateTime(2026, 1, 26);
        DateTime today = DateTime.Today;
        
        int daysSinceStart = (today - cycleStart).Days;
        
        if (daysSinceStart < 0)
        {
            return Ok(new { weekNumber = 0, message = "Cycle hasn't started yet" });
        }
        
        // 4-week cycle that repeats
        int weekNumber = ((daysSinceStart / 7) % 4) + 1;
        
        return Ok(new { 
            weekNumber, 
            cycleDay = daysSinceStart % 28,
            startDate = cycleStart.ToString("yyyy-MM-dd")
        });
    }

    /// <summary>
    /// Get appointment requests (pending by default)
    /// </summary>
    [HttpGet("appointments")]
    public IActionResult GetAppointments([FromQuery] string? status = "Pending")
    {
        var appointments = _db.GetAppointmentRequests(status);
        return Ok(appointments);
    }

    /// <summary>
    /// Update appointment request status (Admin only)
    /// </summary>
    [Authorize(Roles = "Admin")]
    [HttpPut("appointments/{id}")]
    public IActionResult UpdateAppointment(int id, [FromBody] UpdateAppointmentRequest request)
    {
        _db.UpdateAppointmentStatus(id, request.Status, request.ResponseNotes);
        return Ok(new { message = "Appointment updated successfully" });
    }
}

public class UpdateAppointmentRequest
{
    public string Status { get; set; } = string.Empty;
    public string? ResponseNotes { get; set; }
}