using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;
using System.Net.Mail;
using System.Net;
using System.Web.UI.HtmlControls;

public partial class school1_MasterPage : System.Web.UI.MasterPage
{
    string hostName;
    int idddd;
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbcon"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Session["sid"] ="9";
           
            gttm(); evtttn();
            evttt();
            ab(); abCCSSS(); aluu();
            acad(); abCCSSSrr();
            gtt();
            if (Session["sid"] == null)
            {
                
            }
            else
            {
                hom.HRef = "default.aspx?id=" + Session["sid"];
                hm22.HRef = "default.aspx?id=" + Session["sid"];
                Label1.Text = Session["sid"].ToString();
                Session["sid"] = "9";
            }
        }
    }
    private void aluu()
    {
        SqlCommand cmd = new SqlCommand("SELECT distinct(spg)  FROM epggs where sid='" + Session["sid"] + "' and pg='" + L7.Text + "'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
       
        alu.DataSource = dt;
        alu.DataBind();
        alu2.DataSource = dt;
        alu2.DataBind();

    }
     private void ab1()
    {
        SqlCommand cmd = new SqlCommand("SELECT distinct(spg)  FROM epggs where sid='" + Session["sid"] + "' and pg='"+L2.Text+"'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        abt.DataSource = dt;
        abt.DataBind();
         
        AB2.DataSource = dt;
        AB2.DataBind();

    }
    private void ab()
    {
        SqlCommand cmd = new SqlCommand("SELECT distinct(Spg)  FROM epggs where sid='" + Session["sid"] + "' and pg='"+L2.Text+"'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        abt.DataSource = dt;
        abt.DataBind();
        
        AB2.DataSource = dt;
        AB2.DataBind();

    }
    private void abCCSSS()
    {
        SqlCommand cmd = new SqlCommand("SELECT distinct(session)  FROM facc where sid='" + Session["sid"] + "' and rem='"+m4.Text+"'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
     //   Session["tpr"] = m4.Text;
        ach.DataSource = dt;
        ach.DataBind();
        AVH2.DataSource = dt;
        AVH2.DataBind();
       

    }
    private void evtttn()
    {
        SqlCommand cmd = new SqlCommand("SELECT distinct(spg)  FROM EIMGG where sid='" + Session["sid"] + "' and pg='" + L6.Text + "'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        evt.DataSource = dt;
        evt.DataBind();
        evt2.DataSource = dt;
        evt2.DataBind();


    }
    private void evttt()
    {
        SqlCommand cmd = new SqlCommand("SELECT distinct(spg) FROM epggs where sid='" + Session["sid"] + "' and pg='" + L4.Text + "'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        ach.DataSource = dt;
        ach.DataBind();
        AVH2.DataSource = dt;
        AVH2.DataBind();


    }
    private void abCCSSSrr()
    {
        SqlCommand cmd = new SqlCommand("SELECT distinct(spg) FROM epggs where sid='" + Session["sid"] + "' and pg='"+l5.Text+"'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        Repeater1.DataSource = dt;
        Repeater1.DataBind();
        Repeater2.DataSource = dt;
        Repeater2.DataBind();
        

    }
    private void acad()
    {
        SqlCommand cmd = new SqlCommand("SELECT distinct(spg) FROM epggs where sid='" + Session["sid"] + "' and pg='" + L3.Text + "'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        acd.DataSource = dt;
        acd.DataBind();
        
        ACD2.DataSource = dt;
        ACD2.DataBind();
    }
    private void gtt()
    {
        SqlCommand cmd = new SqlCommand("SELECT * FROM SchoolInfo WHERE id='"+Session["sid"]+"'", con);

        if (con.State == 0)
            con.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            string aa = dr["Id"].ToString();

            mob.Text = dr["phone"].ToString();
            eml.Text = dr["email"].ToString();
            fb.HRef = dr["fb"].ToString();
            ins.HRef = dr["ins"].ToString();
            lk.HRef = dr["lnk"].ToString();
            yt.HRef = dr["yt"].ToString();
            HtmlLink favicon = new HtmlLink();
            favicon.Attributes["rel"] = "icon";
            favicon.Attributes["type"] = "image/x-icon";
          //  ttl.Text = dr["Schoolname"].ToString();
            // Example: dynamic path from a setting, database, or condition
            favicon.Href = dr["LogoPath"].ToString();  // Or use a dynamic value
           // Page.Title = dr["Schoolname"].ToString()  ;
            Page.Header.Controls.Add(favicon);
            logo.ImageUrl = dr["LogoPath"].ToString();
            wa.HRef = "https://wa.me/91" + dr["phone"].ToString();
            logo.ImageUrl = dr["LogoPath"].ToString();
            Image1.ImageUrl = dr["LogoPath"].ToString();
            logo2.ImageUrl = dr["LogoPath"].ToString();
            logo4.ImageUrl = dr["LogoPath"].ToString();
            logo3.ImageUrl = dr["LogoPath"].ToString();
            eml1.Text = dr["email"].ToString();
            ph.Text = dr["phone"].ToString();
            addr1.Text = dr["address"].ToString();

        }
    }
    private void gttm()
    {
        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter();
        DataRow dr;
        SqlCommand cmd = new SqlCommand("SELECT * from dbo.mnu where sid='" + Session["sid"]+ "'", con);
        da.SelectCommand = cmd;
        dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {

             

           
            m1.Text = dt.Rows[0][1].ToString();
            mm1.Text = dt.Rows[0][1].ToString();
            m2.Text = dt.Rows[1][1].ToString();
            mm2.Text = dt.Rows[1][1].ToString();
            m3.Text = dt.Rows[2][1].ToString();
            mm3.Text = dt.Rows[2][1].ToString();
            m4.Text = dt.Rows[3][1].ToString();
            mm4.Text = dt.Rows[3][1].ToString();
            m5.Text = dt.Rows[4][1].ToString();
            mm5.Text = dt.Rows[4][1].ToString();
            m6.Text = dt.Rows[5][1].ToString();
            mm6.Text = dt.Rows[5][1].ToString();
            m7.Text = dt.Rows[6][1].ToString();
            mm7.Text = dt.Rows[6][1].ToString();
            l1.Text = dt.Rows[0][0].ToString();
            L2.Text = dt.Rows[1][0].ToString();
            L3.Text = dt.Rows[2][0].ToString();
            L4.Text = dt.Rows[3][0].ToString();
            l5.Text = dt.Rows[4][0].ToString();
            L6.Text = dt.Rows[5][0].ToString();
            L7.Text = dt.Rows[6][0].ToString();
          
        }
    }
}