using System;
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.IO;
using System.Configuration;
using System.Data.SqlClient;
using System.ServiceModel;
using nmsSetup;
using KMASchoolERP;

public partial class Default : System.Web.UI.Page
{
    static Int32 gType = 0;
    static string meCoursID = "";
    static string meCourse = "";
    string stuid = "";
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {



            if (Session["officeWebUser"] != null)
            {
                try
                {
                    string getlist = Session["officeWebUser"] as string;
                    string[] getval = getlist.Split(',');

                    gType = Convert.ToInt32(getval[7]);
                    stuid = getval[1];
                    string welcome = "Welcome";
                    if (welcome != "")
                    {
                        // return "<span style='color:red'>some text</span>";
                    }
                    mprofile.InnerText = getval[2];
                    getcourseid(getval[1]);
                    bindCourse();
                }
                catch(Exception ex)
                {
                    Response.Redirect("../loginstu.aspx?log=student");
                }
            }



        //    ExamDetail();
            //if (Session["WebSess"] == null)
            //{
            //    bind_Theory();
            //    bind_Video();
            //}

        }
    }

    public void bindCourse()
    {
        if (gType <= 0)
        {
            mCourse.InnerText = "No Course Assigned Yet!";
            string getlist = Session["WebSess"] as string; ;
            string[] getval = getlist.Split(',');
            string[] getphoto = getval[6].Split('.');
            if (getphoto[2] == "/icon/default_img")
            {
                //Image1.ImageUrl = "assets/images/user.png";
            }
            //meData.Visible = false;
        }
        else
        {
            mCourse.InnerText = "My Course : " + meCourse;
            string getlist = Session["officeWebUser"] as string; ;
            string[] getval = getlist.Split(',');
            //string[] getphoto = getval[6].Split('.');
            //if(getphoto[2]!=null && getphoto[2]!="")
            //{ 
            //if (getphoto[2] == "/icon/default_img")
            //{
            //    Image1.ImageUrl = "assets/images/user.png";
            //}
            //}
            //Image1.ImageUrl = "assets/images/user.png";
            //meData.Visible = true;
            //bind_Theory();
           // bind_Video();
        }
    }
    //-----------Getting All Data----------------//
    public void getcourseid(string UserCode)
    {
        SqlDataAdapter adp = new SqlDataAdapter("select*from studentdetail where studentcode=" + UserCode + "", con);
        adp.SelectCommand.CommandType = CommandType.Text;
        DataTable dt = new DataTable();
        adp.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            meCoursID = dt.Rows[0]["courseId"].ToString();
            meCourse = dt.Rows[0]["courseName"].ToString();
        }
    }

    public class clsprp
    {
        public string id { get; set; }
        public string title { get; set; }
        public string description { get; set; }
        public string urlPath { get; set; }
        public string subtitle { get; set; }
        public string name { get; set; }
        public string catID { get; set; }
        public string courseName { get; set; }
        public string courseId { get; set; }


    }
    public List<clsprp> ViewData(clsprp p)
    {
        if (con.State == ConnectionState.Closed)
            con.Open();
        List<clsprp> lst = new List<clsprp>();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "View_TopicFileDetail";
        cmd.Connection = con;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@topicid", p.catID);
        cmd.Parameters.AddWithValue("@id", p.id);
        SqlDataReader dr = cmd.ExecuteReader();
        clsprp obj;
        if (dr.HasRows)
        {
            while (dr.Read())
            {
                obj = new clsprp();
                obj.id = dr["mtfid"].ToString();
                obj.title = dr["mtftitles"].ToString();
                obj.description = dr["mtfDescription"].ToString();
                obj.urlPath = dr["mtfFilePath"].ToString();
                obj.subtitle = dr["mtfExtenstion"].ToString();
                obj.name = dr["mftName"].ToString();
                obj.catID = dr["mtfType"].ToString();
                obj.courseName = dr["courseName"].ToString();
                obj.courseId = dr["mtfTopicid"].ToString();
                lst.Add(obj);
            }
        }
        dr.Close();
        cmd.Dispose();
        con.Close();
        return lst;

    }

    public void bind_Theory()
    {
        List<clsprp> lst = new List<clsprp>();
        clsprp obj = new clsprp();
        obj.catID = meCoursID;
        obj.id = "";
        lst = ViewData(obj);
        string str = "";
        if (lst.Count > 0)
        {
            str += "<div class='panel-group' id='accordion'>";
            foreach (clsprp p in lst)
            {
                if (p.catID == "1")
                {

                    str += "<div class='panel panel-default'>";


                    if (p.urlPath != null && p.urlPath != "")
                    {
                        str += "<div class='panel-heading' style='background-color: sandybrown;color:seagreen'>";
                        str += "<h4 class='panel-title'>";
                        str += "<a data-toggle='collapse' data-parent='#accordion' href='#collapse" + p.id + "' style='color: white;font-weight: bold;'>" + p.title + "</a>";
                        str += "</h4>";
                        str += "</div>";
                        //-------Now Content-----------//
                        str += "<div id='collapse" + p.id + "' class='panel-collapse collapse in'>";
                        str += "<div class='panel-body'>" + p.description + "</br><i class='fa fa-file' style='color:darkslategrey;'></i>&nbsp<a href='http://missiontopper.com/" + p.urlPath + "' target='_blanks' style='color: darkgreen;text-decoration: none;'>View Full Detail</a></div>";
                        str += "</div>";
                        str += "</div>";
                    }
                    else
                    {
                        str += "<div class='panel-heading' style='background-color: sandybrown;color:seagreen'>";
                        str += "<h4 class='panel-title'>";
                        str += "<a data-toggle='collapse' data-parent='#accordion' href='#collapse" + p.id + "' style='color: white;font-weight: bold;'>" + p.title + "</a>";
                        str += "</h4>";
                        str += "</div>";
                        //-------Now Content-----------//
                        str += "<div id='collapse" + p.id + "' class='panel-collapse collapse in'>";
                        str += "<div class='panel-body'>" + p.description + "</div>";
                        str += "</div>";
                        str += "</div>";
                    }
                }
            }
            str += "</div>";
            //get_Theory.InnerHtml = str;
        }
        else
        {
           // get_Theory.InnerHtml = "<strong style='color:red;font-weight:bold'>No Results Founds!</strong>";
        }


        //else
        //{
        //    get_home.InnerHtml = "<strong style='color:red;font-weight:bold'>No Results Founds!</strong>";
        //}
    }
    //-----------Bind Video--------------//
    public void bind_Video()
    {
        List<clsprp> lst = new List<clsprp>();
        clsprp obj = new clsprp();
        obj.catID = meCoursID;
        obj.id = "";
        lst = ViewData(obj);
        string str = "";
        if (lst.Count > 0)
        {

            foreach (clsprp p in lst)
            {
                if (p.catID == "3")
                {

                    str += "<div class='col-md-6 col-xl-6'>";
                    str += "<div class='card counter-card-1'>";
                    str += "<iframe class='embed-responsive-item' src='" + p.subtitle + "&showinfo=0' frameborder='0' allowfullscreen=''></iframe>";
                    str += "<h5>" + p.title + "</h5>";
                    str += "</div>";
                    str += "</div>";


                }
            }

            //get_video.InnerHtml = str;
        }
        else
        {
           // get_video.InnerHtml = "<strong style='color:red;font-weight:bold'>No Results Founds!</strong>";
        }


        //else
        //{
        //    get_home.InnerHtml = "<strong style='color:red;font-weight:bold'>No Results Founds!</strong>";
        //}
    }
    //-------------------Getting Test Detail--------------------//
    public void ExamDetail()
    {
        Service b = new Service();
        System.Web.Script.Serialization.JavaScriptSerializer srl1 = new System.Web.Script.Serialization.JavaScriptSerializer();
        List<clsExam> lst1 = new List<clsExam>();
        //------------for Getting User Test Type------------//

        //if (Session["WebSess"] != null)
        //{
        //    string getstr = Request.QueryString["log"].ToString();//Session["WebSess"].ToString();
        //string[] getval = getstr.Split(',');
        //stuid = Request.QueryString["log"].ToString();//getval[1];
        //Session["officeWebUser"] = stuid;
        string data1 = b.viewTestDetail(stuid);
        lst1 = srl1.Deserialize<List<clsExam>>(data1);
        string str = ""; string testStatus = "";
        testActive.InnerText = "Test Not Assigned";
        if (lst1.Count > 0)
        {

            foreach (clsExam p in lst1)
            {
                var tmint = p.mint;
                var zero = "0";
                if(tmint.Length < 10 )
                {
                    tmint = zero.ToString() + tmint.ToString();
                }
                else
                {
                    tmint = 0+tmint;
                }
                cName.InnerText = p.name;
                tName.InnerText = p.testname;
                toQuestion.InnerText = p.totle_Quest;
                toTime.InnerText = p.testSdate;//p.hour  + " : " + tmint + " " + p.accountId;
              //  testStatus = p.isactive;
                DateTime now = DateTime.Now;
                string todate = now.ToString();
                if (p.status == "0" && testStatus=="0")
                {
                    testActive.InnerText = "Enabled";
                    str += "<input type='button' value='Start Test' onclick='NewPop(" + p.id + ");' class='btn btn-primary center-block' style='margin-bottom: 10px;'/>";
                }
                else
                {
                    testActive.InnerText = "Completed";
                    str += "<input type='button' value='Start Test' disabled='disabled' onclick='NewPop(" + p.id + ");' class='btn btn-primary center-block' style='margin-bottom: 10px;'/>";
                }
            }
            STest.InnerHtml = str;

            //}
        }



    }
}