FC2_MarksDistribution.aspx.cs

using System;
using System.Activities.Expressions;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text.RegularExpressions;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.IdentityModel.Protocols.WSTrust;

using static System.Collections.Specialized.BitVector32;
public partial class FC2_MarksDistribution : System.Web.UI.Page
{
    static int User_Id;
    protected int Courseid
    {
        get { return (int)(Session["Courseid"] ?? 0); }
        set { Session["Courseid"] = value; }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            User_Id = Convert.ToInt32(Request.QueryString["id"]);
        DropDownList1_SelectedIndexChanged(null, null);
    }
    protected DataTable GetCoursesForInstructor()
    {
        DataTable courseData = new DataTable();

        // Connection string
        string connectionString = ConfigurationManager.ConnectionStrings["FlexConnectionString"].ConnectionString;

        // SQL query to retrieve course ID, course code, and section name for the instructor
        string query = @"
        SELECT DISTINCT O.OfferCourse_Id AS Course_Id, C.Course_Id AS CourseId, CONCAT(C.Course_Code, ' - ' , C.Name , ' - ' , O.OfferCourse_Id) AS CourseDisplay
        FROM OFFEREDCOURSE O
        JOIN COURSE C ON O.Course_Id = C.Course_Id
        JOIN SECTION S ON O.OfferCourse_Id = S.Course_Id
        WHERE S.Instructor_Id = @InstructorId
    ";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            // Create the SQL command
            SqlCommand command = new SqlCommand(query, connection);
            command.Parameters.AddWithValue("@InstructorId", User_Id);

            // Open the connection and execute the query
            connection.Open();

            using (SqlDataAdapter adapter = new SqlDataAdapter(command))
            {
                // Fill the DataTable with the result of the query
                adapter.Fill(courseData);
            }
        }

        return courseData;
    }
    protected void Page_Init(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            // Fetch the course ID, course name, and section name for the instructor
            DataTable courseData = GetCoursesForInstructor();

            // Bind the course data to the dropdown list
            DropDownList1.DataSource = courseData;
            DropDownList1.DataTextField = "CourseDisplay"; // Replace "CourseDisplay" with the desired column name for displaying course ID and section name
            DropDownList1.DataValueField = "Course_Id"; // Replace "Course_Id" with the actual column name for the course ID in your DataTable
            DropDownList1.DataBind();
        }
    }
    private int GetSumOfWeightage(string courseid)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["FlexConnectionString"].ConnectionString); //Connection String
        conn.Open();
        string sql = "SELECT SUM(Weightage) AS TotalWeightage FROM FLEX.DBO.EVALUATION WHERE Course_Id = '" + courseid + "' GROUP BY Course_Id;";
        SqlCommand cmd = new SqlCommand(sql, conn);
        int i = Convert.ToInt32(cmd.ExecuteScalar());
            cmd.Dispose();
        conn.Close();
        return i; 
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (DropDownList1.Items.Count == 0) return;

        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["FlexConnectionString"].ConnectionString); //Connection String
        conn.Open();
        SqlCommand cm;
        string name = TextBox1.Text;
        string Weightage = TextBox3.Text;
        string Range = TextBox4.Text;
        int current = GetSumOfWeightage(Convert.ToString(Courseid));
        if (Range != string.Empty && Weightage != string.Empty && Convert.ToString(Courseid) != string.Empty && name!=string.Empty && current + Convert.ToInt16(Weightage) <= 100)
        {
            string query = "Insert into dbo.EVALUATION (name,course_id,weightage,range) values ('" + name + "','" + Convert.ToString(Courseid) + "','" + Weightage + "','" + Range + "')";
            cm = new SqlCommand(query, conn);
            cm.ExecuteNonQuery();
        cm.Dispose();
        }
        conn.Close();
        DataTable update = GetDataFromDatabase(String.Empty, Convert.ToString(Courseid));
        GridView1.DataSource = update;
        GridView1.DataBind();
        LogEvent("Viewed Added an Evaluation");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        if (DropDownList1.Items.Count == 0) return;

        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["FlexConnectionString"].ConnectionString); //Connection String
        conn.Open();
        SqlCommand cm;
        string name = TextBox1.Text;
        string query = "DELETE FROM dbo.EVALUATION WHERE name = '" + name + "' and course_id = '"+ Convert.ToString(Courseid) +"'";
        cm = new SqlCommand(query, conn);
        cm.ExecuteNonQuery();
        cm.Dispose();
        conn.Close();
        DataTable update = GetDataFromDatabase(String.Empty, Convert.ToString(Courseid));
        GridView1.DataSource = update;
        GridView1.DataBind();
        LogEvent("Deleted an Evaluation") ;
    }

    private DataTable GetDataFromDatabase(string filter,string Course)
    {
        DataTable dt = new DataTable();

        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["FlexConnectionString"].ConnectionString))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT Name,Weightage,Range FROM dbo.EVALUATION Where course_id = '"+ Course + "' ORDER BY Name", con))
            {
                cmd.Parameters.AddWithValue("@Filter", "%" + filter + "%");
                con.Open();

                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    da.Fill(dt);
                }
            }
        }

        return dt;
    }
    private int GetLastNumberAfterDash(string input)
    {
        // Split the string by '-' delimiter
        string[] parts = input.Split('-');

        // Get the last part of the split string
        string lastPart = parts[parts.Length - 1];

        // Remove any leading or trailing whitespace
        lastPart = lastPart.Trim();

        // Parse the last part as an integer
        if (int.TryParse(lastPart, out int result))
        {
            return result;
        }
        else
        {
            // Return a default value or throw an exception, depending on your requirements
            throw new InvalidOperationException("Invalid format. Unable to parse the last number.");
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (DropDownList1.Items.Count == 0) return;
        string selectedText = DropDownList1.SelectedItem.Text;

        Courseid = GetLastNumberAfterDash(selectedText);
        string course = Convert.ToString(Courseid);
        DataTable update = GetDataFromDatabase(String.Empty, course);
        GridView1.DataSource = update;
        GridView1.DataBind();

    }
    protected void Unnamed_Click(object sender, EventArgs e)
    {
        if (!Menu1.Visible)
            Menu1.Visible = true;
        else Menu1.Visible = false;
    }
    protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
    {
        if (e.Item.Text == "Home")
            e.Item.NavigateUrl = "~/FacultyMain.aspx?id=" + User_Id;
        else if (e.Item.Text == "Mark Attendence")
            e.Item.NavigateUrl = "~/FC1_MarkAttendence.aspx?id=" + User_Id;
        else if (e.Item.Text == "Set Marks Distribution")
            e.Item.NavigateUrl = "~/FC2_MarksDistribution.aspx?id=" + User_Id;
        else if (e.Item.Text == "Mark Evaluations")
            e.Item.NavigateUrl = "~/FC3_MarkEvaluations.aspx?id=" + User_Id;
        else if (e.Item.Text == "Finalize Grades")
            e.Item.NavigateUrl = "~/FC4_FinalizeGrades.aspx?id=" + User_Id;
        else if (e.Item.Text == "Grade Report")
            e.Item.NavigateUrl = "~/FC5_GradeReport.aspx?id=" + User_Id;
        else if (e.Item.Text == "Feedback Report")
            e.Item.NavigateUrl = "~/FC6_FeedbackReport.aspx?id=" + User_Id;
        else if (e.Item.Text == "Transcript Report")
            e.Item.NavigateUrl = "~/FC7_TranscriptReport.aspx?id=" + User_Id;
        else if (e.Item.Text == "Log out")
            e.Item.NavigateUrl = "~/Default.aspx";
        Response.Redirect(e.Item.NavigateUrl);
    }
    public static void LogEvent(string action)
    {
        int userId = Convert.ToInt32(User_Id);
        using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["FlexConnectionString"].ConnectionString))
        {
            connection.Open();
            SqlCommand command = new SqlCommand("INSERT INTO AUDITTRAIL (User_Id, Activity) VALUES (@UserId, @Action)", connection);
            command.Parameters.AddWithValue("@UserId", userId);
            command.Parameters.AddWithValue("@Action", action);
            command.ExecuteNonQuery();
        }
    }
}