ModuleManagement.aspx.cs

using LearnSphere.Models;
using Microsoft.AspNet.Identity;
using System;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace LearnSphere
{
    public partial class ModuleManagement : Page
    {
        private const int LowContentThreshold = 3;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Request.IsAuthenticated)
            {
                Response.Redirect("~/Login.aspx", true);
                return;
            }

            if (!User.IsInRole("Admin"))
            {
                Response.Redirect("~/Default.aspx", true);
                return;
            }

            if (!IsPostBack)
            {
                ApplyFilterState();
                BindModules();
            }
        }

        private void ApplyFilterState()
        {
            string filter = (Request.QueryString["filter"] ?? "all").Trim().ToLower();

            lnkAll.CssClass = "filter-btn";
            lnkPublished.CssClass = "filter-btn";
            lnkUnpublished.CssClass = "filter-btn";
            lnkLowContent.CssClass = "filter-btn";

            switch (filter)
            {
                case "published":
                    lnkPublished.CssClass += " active";
                    break;
                case "unpublished":
                    lnkUnpublished.CssClass += " active";
                    break;
                case "lowcontent":
                    lnkLowContent.CssClass += " active";
                    break;
                default:
                    lnkAll.CssClass += " active";
                    break;
            }
        }

        private void BindModules()
        {
            string filter = (Request.QueryString["filter"] ?? "all").Trim().ToLower();

            using (var context = new ApplicationDbContext())
            {
                var modules = context.Modules
                    .Select(m => new ModuleRow
                    {
                        ModuleID = m.ModuleID,
                        ModuleCode = m.ModuleCode,
                        ModuleName = m.ModuleName,
                        TeacherName = m.TeacherUser.FullName ?? m.TeacherUser.Email,
                        Semester = m.Semester,
                        AcademicYear = m.AcademicYear,
                        IsPublished = m.IsPublished,
                        ContentCount = m.ModuleContents.Count()
                    });

                switch (filter)
                {
                    case "published":
                        modules = modules.Where(m => m.IsPublished);
                        break;

                    case "unpublished":
                        modules = modules.Where(m => !m.IsPublished);
                        break;

                    case "lowcontent":
                        modules = modules.Where(m => m.ContentCount < LowContentThreshold);
                        break;
                }

                gvModules.DataSource = modules
                    .OrderBy(m => m.ModuleName)
                    .ToList();

                gvModules.DataBind();
            }
        }
        protected void btnConfirmTogglePublish_Click(object sender, EventArgs e)
        {
            if (!int.TryParse(hfSelectedModuleId.Value, out int moduleId))
            {
                ShowAlert("Invalid module selection.", "error");
                return;
            }

            using (var context = new ApplicationDbContext())
            {
                var module = context.Modules.FirstOrDefault(m => m.ModuleID == moduleId);

                if (module == null)
                {
                    ShowAlert("Module not found.", "error");
                    BindModules();
                    return;
                }

                module.IsPublished = !module.IsPublished;
                context.SaveChanges();

                ShowAlert(
                    $"Module <strong>{HttpUtility.HtmlEncode(module.ModuleName)}</strong> is now <strong>{(module.IsPublished ? "Published" : "Unpublished")}</strong>.",
                    "success"
                );
            }

            BindModules();
        }
        private void ShowAlert(string message, string type)
        {
            pnlAlert.Visible = true;
            pnlAlert.CssClass = "module-alert " + type;
            litAlert.Text = message;
        }

        private class ModuleRow
        {
            public int ModuleID { get; set; }
            public string ModuleCode { get; set; }
            public string ModuleName { get; set; }
            public string TeacherName { get; set; }
            public string Semester { get; set; }
            public string AcademicYear { get; set; }
            public bool IsPublished { get; set; }
            public int ContentCount { get; set; }
        }
    }
}