/VideoQuestions.ascx.cs

Large files files are truncated, but you can click here to view the full file

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class VideoQuestions : System.Web.UI.UserControl
{
    string usercode = "";
    int userid = 0;
    DBManagementClass clsclass = new DBManagementClass();
    AssesmentDataClassesDataContext dataclass = new AssesmentDataClassesDataContext();
   
    DataSet ds;

    int qusid1 = 0;
    int qusid2 = 0;
    int qusid3 = 0;
    int qusid4 = 0;
    int qusid5 = 0;
    int qusid6 = 0;
    int qusid7 = 0;
    int qusid8 = 0;
    int qusid9 = 0;
    int qusid10 = 0;
    int pagecount = 0;
    int quesperPage = 1;//bip 121009
    int testId = 0; int testsectionid = 0;
    double interval = 60; private int test;

    protected void Page_Load(object sender, EventArgs e)
    {
       // PlayVideo("", 1);        return;
        if (Session["UserTestId"] != null)
        {
            /// bip 10052010
            if (Session["timeExpired"] != null)
                if (Session["timeExpired"].ToString() == "True")
                {
                    CheckTime();
                    return;
                }
            ///
            //if (CheckTime() == true) return;//bip 15052010

            FillTitle();
            
            testId = int.Parse(Session["UserTestId"].ToString());
            if (Session["UserID"] != null)
            {
                userid = int.Parse(Session["UserID"].ToString());
                FillQuestion();
            }
        }
    }
    private void FillVideoQuestionInstructions()
    {

        int testSecondVariableId = 0, testFirstVariableId = 0, testSectionID = 0;
        if (Session["CurrentTestSectionId"] != null)
            testSectionID = int.Parse(Session["CurrentTestSectionId"].ToString()); ;
        if (Session["CurrentTestSecondVariableId"] != null)
            testSecondVariableId = int.Parse(Session["CurrentTestSecondVariableId"].ToString());
        if (Session["CurrentTestFirstVariableId"] != null)
            testFirstVariableId = int.Parse(Session["CurrentTestFirstVariableId"].ToString());

        bool valueexists = false;
        DataSet dsInstructiondet = new DataSet();
        string quesrystring = "";
        if (testSecondVariableId > 0)
            quesrystring = "select InstructionDetails,InstructionImage1,InstructionDetails2,InstructionImage2,InstructionDetails3 from TestSectionVariablewiseInstructions where CategoryId =5 and TestId=" + testId + " and TestSectionId =" + testSectionID + " and FirstVariableId=" + testFirstVariableId + " and SecondVariableId =" + testSecondVariableId;
       else if (testFirstVariableId > 0)
            quesrystring = "select InstructionDetails,InstructionImage1,InstructionDetails2,InstructionImage2,InstructionDetails3 from TestSectionVariablewiseInstructions where CategoryId =5 and TestId=" + testId + " and TestSectionId =" + testSectionID + " and FirstVariableId=" + testFirstVariableId;

        dsInstructiondet = clsclass.GetValuesFromDB(quesrystring);

        if (dsInstructiondet != null) if (dsInstructiondet.Tables.Count > 0) if (dsInstructiondet.Tables[0].Rows.Count > 0)
                { 
                    string styleproperties = "padding-left: 40px";        
            HtmlTable tblInstructions = new HtmlTable();
                    HtmlTableRow trInstructions = new HtmlTableRow();
                    HtmlTableCell tcellInstructions = new HtmlTableCell();
                    if (dsInstructiondet.Tables[0].Rows[0]["InstructionDetails"].ToString() != null && dsInstructiondet.Tables[0].Rows[0]["InstructionDetails"].ToString() != "")
                    {
                        tcellInstructions.InnerHtml = dsInstructiondet.Tables[0].Rows[0]["InstructionDetails"].ToString();
                        trInstructions.Cells.Add(tcellInstructions);
                        tblInstructions.Rows.Add(trInstructions);
                        valueexists = true;
                    }
                    if (dsInstructiondet.Tables[0].Rows[0]["InstructionImage1"].ToString() != null && dsInstructiondet.Tables[0].Rows[0]["InstructionImage1"].ToString() != "")
                    {
                        trInstructions = new HtmlTableRow();
                        tcellInstructions = new HtmlTableCell();
                        tcellInstructions.InnerHtml = "<div style='" + styleproperties + "'><img alt='' src='QuestionAnswerFiles/InstructionImages/" + dsInstructiondet.Tables[0].Rows[0]["InstructionImage1"].ToString() + "' /></div>";
                        trInstructions.Cells.Add(tcellInstructions);
                        tblInstructions.Rows.Add(trInstructions);
                        valueexists = true;
                    }
                    if (dsInstructiondet.Tables[0].Rows[0]["InstructionDetails2"].ToString() != null && dsInstructiondet.Tables[0].Rows[0]["InstructionDetails2"].ToString() != "")
                    {
                        trInstructions = new HtmlTableRow();
                        tcellInstructions = new HtmlTableCell();
                        tcellInstructions.InnerHtml = dsInstructiondet.Tables[0].Rows[0]["InstructionDetails2"].ToString();
                        trInstructions.Cells.Add(tcellInstructions);
                        tblInstructions.Rows.Add(trInstructions);
                        valueexists = true;
                    }
                    if (dsInstructiondet.Tables[0].Rows[0]["InstructionImage2"].ToString() != null && dsInstructiondet.Tables[0].Rows[0]["InstructionImage2"].ToString() != "")
                    {
                        trInstructions = new HtmlTableRow();
                        tcellInstructions = new HtmlTableCell();
                        tcellInstructions.InnerHtml = "<div style='" + styleproperties + "'><img alt='' src='QuestionAnswerFiles/InstructionImages/" + dsInstructiondet.Tables[0].Rows[0]["InstructionImage2"].ToString() + "' /></div>";
                        trInstructions.Cells.Add(tcellInstructions);
                        tblInstructions.Rows.Add(trInstructions);
                        valueexists = true;
                    }
                    if (dsInstructiondet.Tables[0].Rows[0]["InstructionDetails3"].ToString() != null && dsInstructiondet.Tables[0].Rows[0]["InstructionDetails3"].ToString() != "")
                    {
                        trInstructions = new HtmlTableRow();
                        tcellInstructions = new HtmlTableCell();
                        tcellInstructions.InnerHtml = dsInstructiondet.Tables[0].Rows[0]["InstructionDetails3"].ToString();
                        trInstructions.Cells.Add(tcellInstructions);
                        tblInstructions.Rows.Add(trInstructions);
                        valueexists = true;
                    }
                    divInstructions.Controls.Clear();
                    divInstructions.Controls.Add(tblInstructions);        
        }
        if (valueexists == false)
            FillCommonInstructions();
       // else FillTitle();
    }
    private void FillTitle()
    {
        var InstructionDetails = from instructiondet in dataclass.TestInstructions
                                 where instructiondet.CategoryId == 5
                                 select instructiondet;
        if (InstructionDetails.Count() > 0)
        {
            if (InstructionDetails.First().Title != null)
                divtitle.InnerHtml = InstructionDetails.First().Title.ToString();            
        }
    }

    private void FillCommonInstructions()
    {
        var InstructionDetails = from instructiondet in dataclass.TestInstructions
                                 where instructiondet.CategoryId == 5
                                 select instructiondet;
        if (InstructionDetails.Count() > 0)
        {            
            if (InstructionDetails.First().InstructionDetails != null)
                divInstructions.InnerHtml = InstructionDetails.First().InstructionDetails.ToString();
        }
    }


    protected void ptnPrevious_Click(object sender, EventArgs e)
    {        
        Session["displaystatus_video"] = null;
        Session["test_video"] = null;

        int curcount = 0;
        int totalcount = 0, totalquesavail = 0;
        if (Session["totalQuesCount_video"] != null)
            totalcount = int.Parse(Session["totalQuesCount_video"].ToString());
        if (Session["totalQuesAvailable_video"] != null)
            totalquesavail = int.Parse(Session["totalQuesAvailable_video"].ToString());
        if (totalcount == totalquesavail)
            curcount = totalcount;
        if (totalcount > totalquesavail)
            curcount = totalquesavail;
        if (Session["pagecount_video"] != null)
            pagecount = int.Parse(Session["pagecount_video"].ToString());

        Session["VideoPrevious"] = "True";

        int curindex = 0;
        curindex = (pagecount - 1) * quesperPage;
        if (curindex >= 0)
        {
            pagecount--;
            Session["pagecount_video"] = pagecount; SetCurrentPageCount();// 230110 bip
        }
        else
        {
            GoToPreviousPage();           
        }
        FillQuestion();
    }

    private void GoToPreviousPage()
    {
        Session["AudioPrevious"] = "True";
        //Session["AudioCurrentpage"] = "0";        

        ClearSessionValues();
        Session["evaldirection"] = "Previous";
        Session["SubCtrl"] = "AudioQuestions.ascx";
        Response.Redirect("FJAHome.aspx");
    }
    private Boolean CheckTime()//bip 10052010 
    {
        Boolean timeExpired = false;//bip 10052010 
        if (CheckTestTimeValidity() == true)
        {
            lblpopup_timer.Text = "The time alloted for your test is completed, <br> If you are interested to take this test again please contact our site admin";
            pnlpopup_timer.Visible = true; btnYes_timer_Test.Visible = true; Timer1.Enabled = false;
            timeExpired = true; pnlMain.Visible = false; Session["timeExpired"] = "True";//bip 10052010
            //return;
        }
        else if (CheckTimeValidity() == true)
        {
            lblpopup_timer.Text = "The time alloted for this Test Section is completed, <br> Do you want to continue with the remaining sections under your Test?";
            pnlpopup_timer.Visible = true; btnYes_timer.Visible = true; btnNo_timer.Visible = true; Timer1.Enabled = false;
            timeExpired = true; pnlMain.Visible = false; Session["timeExpired"] = "True";//bip 10052010
            //return;
        }
        else if (CheckTestSecVarTimeValidity() == true)
        {
            lblpopup_timer.Text = "The time alloted for this Variable under selected Section is completed, <br> Do you want to continue with the remaining Variables under your Test Section?";
            pnlpopup_timer.Visible = true; btnYes_timer_TestVariable.Visible = true; btnNo_timer.Visible = true; Timer1.Enabled = false;
            timeExpired = true; pnlMain.Visible = false; Session["timeExpired"] = "True";//bip 10052010
            //return;
        }
        if (timeExpired == true)
        {
            if (Session["saved"] != null)
                if (Session["saved"].ToString() == "true")
                    return timeExpired;

            SaveAnswer(); Session["saved"] = "true";
        }
        return timeExpired;
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        
        Boolean timeExpired = CheckTime();
        if (timeExpired == false)//bip 10052010
        {
            if (CheckAnswer() == false)
            {
                Timer1.Enabled = false;// 04-03-2010 bip
                pnlpopup.Visible = true;
                return;
            }
            SaveValues();
        }
        //else SaveAnswer();//bip 10052010
        
    }
    private void SaveValues()
    {
        SaveAnswer();

        Session["displaystatus_video"] = null;
        Session["test_video"] = null;

        //usercode = Session["UserCode"].ToString();
        if (Session["UserID"] != null)
            userid = int.Parse(Session["UserID"].ToString());

        int curcount = 0;
        int totalcount = 0, totalquesavail = 0;
        if (Session["totalQuesCount_video"] != null)
            totalcount = int.Parse(Session["totalQuesCount_video"].ToString());
        if (Session["totalQuesAvailable_video"] != null)
            totalquesavail = int.Parse(Session["totalQuesAvailable_video"].ToString());
        if (totalcount == totalquesavail)
            curcount = totalcount;
        if (totalcount > totalquesavail)
            curcount = totalquesavail;
        if (Session["pagecount_video"] != null)
            pagecount = int.Parse(Session["pagecount_video"].ToString());

        int curindex = 0;
        curindex = (pagecount + 1) * quesperPage;
        if (curindex < curcount)
        {
            pagecount++;
            Session["pagecount_video"] = pagecount;SetCurrentPageCount();// 230110 bip
            FillQuestion(); 
        }
        else
        {
            ClearSessionValues();
            GoToNextPage();
        }
    }
    private void SetCurrentPageCount()
    {
        testsectionid = int.Parse(Session["CurrentTestSectionId"].ToString());
        //  //// 220110 ... bip
        int testSecondVariableId = 0, testFirstVariableId = 0;
        if (Session["CurrentTestSecondVariableId"] != null)
            testSecondVariableId = int.Parse(Session["CurrentTestSecondVariableId"].ToString());
        if (Session["CurrentTestFirstVariableId"] != null)
            testFirstVariableId = int.Parse(Session["CurrentTestFirstVariableId"].ToString());
        int questionid = 0; string questiontype = "VideoType";
        dataclass.Procedure_UserTestPageIndex_Temp(userid, testId, testsectionid, testFirstVariableId, testSecondVariableId, pagecount, questiontype);
    }
    private Boolean CheckAnswer()
    {
        Boolean answercompleted = true;

        string answer = "";
        if (rbQues1Answer1.Checked == true)
            answer = rbQues1Answer1.Text;
        else if (rbQues1Answer2.Checked == true)
            answer = rbQues1Answer2.Text;
        else if (rbQues1Answer3.Checked == true)
            answer = rbQues1Answer3.Text;
        else if (rbQues1Answer4.Checked == true)
            answer = rbQues1Answer4.Text;
        else if (rbQues1Answer5.Checked == true)
            answer = rbQues1Answer5.Text;
        if (answer == "")
        {
            lblpopup.Text += "You have missed question No:" + lblNo1.Text.Trim() + " Please, complete all questions before moving to the next page. <br> Do you want to go to next page? ";
            answercompleted = false;
        }
        return answercompleted;
    }
    protected void btnExit_Click(object sender, EventArgs e)
    {
        Session.Clear();
        Session["SubCtrl"] = null;
        Response.Redirect("FJAHome.aspx");
    }

    private DataSet GetQuestionList(int testsectionid)
    { 
        //// bip 07122009
        
        string firstVariableName = ""; string secondVariableName = "";
        if (Session["TestFirstVariableName"] != null)
            firstVariableName = Session["TestFirstVariableName"].ToString();
        if (Session["TestSecondVariableName"] != null)
            secondVariableName = Session["TestSecondVariableName"].ToString();

        //
        DataSet dsQuesCount;
        string querystring = "";
        DataTable dtQuestionList = new DataTable();
        //QuestionID,Question,Answer,Option1,Option2,Option3,Option4,Option5
        dtQuestionList.Columns.Add("QuestionID");
        dtQuestionList.Columns.Add("Question");
        dtQuestionList.Columns.Add("Answer");
        dtQuestionList.Columns.Add("QuestionFileName");
        dtQuestionList.Columns.Add("Option1");
        dtQuestionList.Columns.Add("Option2");
        dtQuestionList.Columns.Add("Option3");
        dtQuestionList.Columns.Add("Option4");
        dtQuestionList.Columns.Add("Option5");

        DataRow drQurstionList;

        // bip 08122009;
        if (secondVariableName != "")
            querystring = "select distinct VideoQuestionCount,SectionId from QuestionCount where VideoQuestionCount>0 and TestId=" + testId + " and TestSectionId=" + testsectionid + " and SectionName='" + firstVariableName + "' and SectionNameSub1='" + secondVariableName + "' order by sectionid";
        else if (firstVariableName != "")
            querystring = "select distinct VideoQuestionCount,SectionId from QuestionCount where VideoQuestionCount>0 and TestId=" + testId + " and TestSectionId=" + testsectionid + " and SectionName='" + firstVariableName + "' order by sectionid";
        if (secondVariableName == "" && firstVariableName == "") return null;
        DataSet dsQuestioncount = new DataSet();
        dsQuestioncount = clsclass.GetValuesFromDB(querystring);
        if (dsQuestioncount != null)
            if (dsQuestioncount.Tables.Count > 0)
                if (dsQuestioncount.Tables[0].Rows.Count > 0)
                    for (int c = 0; c < dsQuestioncount.Tables[0].Rows.Count; c++)//        
        {
            int videoQuescount = int.Parse(dsQuestioncount.Tables[0].Rows[c]["VideoQuestionCount"].ToString());
            int sectionid = int.Parse(dsQuestioncount.Tables[0].Rows[c]["SectionId"].ToString());

            if (videoQuescount > 0)
            {
                querystring = "SELECT TOP (" + videoQuescount + ") QuestionID,Question,Answer,QuestionFileName,Option1,Option2,Option3,Option4,Option5  FROM View_TestBaseQuestionList where Category = 'VideoType' AND TestBaseQuestionStatus=1 AND TestSectionId=" + testsectionid + " AND SectionId=" + sectionid + " AND TestId=" + testId + " ORDER BY RAND((100*QuestionID)*DATEPART(millisecond, GETDATE())) ";
                
                dsQuesCount = new DataSet();
                dsQuesCount = clsclass.GetValuesFromDB(querystring);
                if (dsQuesCount != null)
                    if (dsQuesCount.Tables[0].Rows.Count > 0)
                    {
                        for (int i = 0; i < dsQuesCount.Tables[0].Rows.Count; i++)
                        {
                            drQurstionList = dtQuestionList.NewRow();
                            drQurstionList["QuestionID"] = dsQuesCount.Tables[0].Rows[i]["QuestionID"];
                            drQurstionList["Question"] = dsQuesCount.Tables[0].Rows[i]["Question"];
                            drQurstionList["QuestionFileName"] = dsQuesCount.Tables[0].Rows[i]["QuestionFileName"];
                            drQurstionList["Answer"] = dsQuesCount.Tables[0].Rows[i]["Answer"];
                            drQurstionList["Option1"] = dsQuesCount.Tables[0].Rows[i]["Option1"];
                            drQurstionList["Option2"] = dsQuesCount.Tables[0].Rows[i]["Option2"];
                            drQurstionList["Option3"] = dsQuesCount.Tables[0].Rows[i]["Option3"];
                            drQurstionList["Option4"] = dsQuesCount.Tables[0].Rows[i]["Option4"];
                            drQurstionList["Option5"] = dsQuesCount.Tables[0].Rows[i]["Option5"];
                            dtQuestionList.Rows.Add(drQurstionList);
                        }
                    }
            }
        }
        DataSet dsQuestionList = new DataSet();
        if (dtQuestionList.Rows.Count > 0)
        {
            dsQuestionList.Tables.Add(dtQuestionList); Session["questionColl_video"] = dsQuestionList;
            Session["totalQuesCount_video"] = dsQuestionList.Tables[0].Rows.Count.ToString();
        }
        else { Session["questionColl_video"] = null; dsQuestionList = null; }

        return dsQuestionList;
    }

    private void PlayVideo(string path, int index)
    {
     
        string FilePath = "QuestionAnswerFiles/" + path;        
        if (index == 1)             
           mpPlayer1.MovieURL = FilePath;      
              
    }

    private string GetAnswerOptionOrder(int index)
    {
        string option = "";

        if (index == 1)
            option = "A";
        else if (index == 2)
            option = "B";
        else if (index == 3)
            option = "C";
        else if (index == 4)
            option = "D";
        else if (index == 5)
            option = "E";

        return option;
    }
    private DataSet GetTempData()
    {
        DataSet dsTempData = new DataSet();
        //// 220110 ... bip
        int testSecondVariableId = 0, testFirstVariableId = 0;
        if (Session["CurrentTestSecondVariableId"] != null)
            testSecondVariableId = int.Parse(Session["CurrentTestSecondVariableId"].ToString());
        if (Session["CurrentTestFirstVariableId"] != null)
            testFirstVariableId = int.Parse(Session["CurrentTestFirstVariableId"].ToString());
        int questionid = 0; string questiontype = "VideoType";

        string querystringquesTemp = "select distinct QuestionId from UserTestQuestions_Temp where UserID=" + userid + " and TestId=" + testId + " and TestSectionId=" + testsectionid + " and FirstVariableId=" + testFirstVariableId + " and QuestionType='" + questiontype + "'";
        if (testSecondVariableId > 0)
            querystringquesTemp += " and SecondVariableId = " + testSecondVariableId;
        DataSet dsquestionIdColl = clsclass.GetValuesFromDB(querystringquesTemp);
        if (dsquestionIdColl != null)
            if (dsquestionIdColl.Tables.Count > 0)
                if (dsquestionIdColl.Tables[0].Rows.Count > 0)
                {
                    string questionids = "";
                    for (int index = 0; index < dsquestionIdColl.Tables[0].Rows.Count; index++)
                    {
                        if (questionids != "")
                            questionids += " or ";
                        questionids += " QuestionId=" + dsquestionIdColl.Tables[0].Rows[index]["QuestionId"].ToString();
                    }
                   
                    querystringquesTemp = "SELECT QuestionID,Question,Answer,QuestionFileName,Option1,Option2,Option3,Option4,Option5  FROM View_TestBaseQuestionList where " + questionids;
                    dsTempData = clsclass.GetValuesFromDB(querystringquesTemp);
                    Session["questionColl_Audio"] = dsTempData;

                    var GetPageIndex = from pageindex in dataclass.UserTestPageIndex_Temps
                                       where pageindex.UserId == userid && pageindex.TestId == testId && pageindex.TestSectionId == testsectionid &&
                                       pageindex.FirstVariableId == testFirstVariableId && pageindex.SecondVariableId == testSecondVariableId &&
                                       pageindex.QuestionType == questiontype
                                       select pageindex;
                    if (GetPageIndex.Count() > 0)
                    {
                        if (GetPageIndex.First().PageIndex != null)
                        {
                            pagecount = int.Parse(GetPageIndex.First().PageIndex.ToString());
                            Session["pagecount_video"] = pagecount;
                            Session["displaystatus_video"] = "True";
                            Session["VideoPrevious"]="True";
                            Session["VideoCurrentpage"] = pagecount;
                        }
                    }
                }
                else dsTempData = null;

        return dsTempData;
    }
    private void FillQuestion()
    {
        //try
        //{
            ClearControls();
            string querystring = "";
            //int totalQues = 0;
            int QuestionID = 0;
            
            if (Session["pagecount_video"] != null)
                pagecount = int.Parse(Session["pagecount_video"].ToString());
            
            ds = new DataSet();//int testsectionid = 0;
            if (Session["CurrentTestSectionId"] != null)
                testsectionid = int.Parse(Session["CurrentTestSectionId"].ToString());  
            //da.Fill(ds);
            if (Session["questionColl_video"] != null)
                ds = (DataSet)Session["questionColl_video"];
            else
            {//bip 081009
                //int testsectionid = 0;
                if (Session["CurrentTestSectionId"] != null)
                {
                    testsectionid = int.Parse(Session["CurrentTestSectionId"].ToString());
                    //

                    //  //// 220110 ... bip
                    int testSecondVariableId = 0, testFirstVariableId = 0;
                    if (Session["CurrentTestSecondVariableId"] != null)
                        testSecondVariableId = int.Parse(Session["CurrentTestSecondVariableId"].ToString());
                    if (Session["CurrentTestFirstVariableId"] != null)
                        testFirstVariableId = int.Parse(Session["CurrentTestFirstVariableId"].ToString());
                    int questionid = 0; string questiontype = "VideoType";
                    
                    ds = GetTempData();
                    bool newentry = false;
                    if (ds == null)
                    {
                        newentry = true;
                        ds = GetQuestionList(testsectionid);
                    }
                    else if (ds.Tables.Count <= 0)
                    { newentry = true; ds = GetQuestionList(testsectionid); }
                    ////.......
                    
                    //                 
                    if (ds == null)
                    {

                        string evaldirection = "Next";
                        if (Session["evaldirection"] != null)
                            evaldirection = Session["evaldirection"].ToString();
                        if (evaldirection == "Next")
                            GoToNextPage();
                        else GoToPreviousPage();
                        return;
                    }
                    else // store the questiondetails in a temp table.
                    {
                        if (newentry == true)
                            if (ds.Tables.Count > 0)
                                if (ds.Tables[0].Rows.Count > 0)
                                {
                                    for (int q = 0; q < ds.Tables[0].Rows.Count; q++)
                                    {
                                        questionid = int.Parse(ds.Tables[0].Rows[q]["QuestionID"].ToString());
                                        dataclass.Procedure_UserTestQuestions_Temp(userid, testId, testsectionid, testFirstVariableId, testSecondVariableId, questionid, questiontype);
                                    }
                                }
                    }
                }
            }
            int slno = 0;
            slno = pagecount * quesperPage + 1;
            if (slno < 0)
                slno = 1;

            int pagecnt = 0;
            int curntquescnt = 0;
            int slnos = 0;

            if (ds.Tables[0].Rows.Count > 0)
            {               

                bool previousdisplay = false;
                int returnpage = 0;
                if (Session["VideoPrevious"] != null)
                {
                    if (Session["VideoCurrentpage"] != null)
                    {
                        returnpage = int.Parse(Session["VideoCurrentpage"].ToString());
                        if (pagecount <= returnpage)
                        { previousdisplay = true; mpPlayer1.Visible = false; imgbtnPlay.Visible = false; }
                    }
                }
                if (previousdisplay == false)
                {
                    if (Session["displaystatus_video"] != null)
                    {
                        if (Session["displaystatus_video"].ToString() != "True")
                        {
                            Session["displaystatus_video"] = "False"; //interval = (interval * 1000); UpdateTimer.Interval = int.Parse(interval.ToString()); UpdateTimer.Enabled = true;
                        }
                    }
                    else { Session["displaystatus_video"] = "False"; imgbtnPlay.Visible = true; mpPlayer1.Visible = false; btnSubmit.Enabled = false; FillVideoQuestionInstructions(); } //interval = 1000; UpdateTimer.Interval = int.Parse(interval.ToString()); UpdateTimer.Enabled = true; }
                }
                else Session["displaystatus_video"] = "True";
            }
            if (Session["displaystatus_video"] != null)
                if (Session["displaystatus_video"].ToString() == "True")
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                       // Session["ValueExists"] = "True";

                        Session["totalQuesAvailable_video"] = ds.Tables[0].Rows.Count.ToString();
                        int j = 0;
                        for (int i = slno - 1; i < ds.Tables[0].Rows.Count; i++)
                        {
                            if (j >= quesperPage) break;
                            string Answer = "";
                            Session["CurrentControlCtrl"] = "VideoQuestions.ascx";// bip 08012010
                            Session["ValueExists"] = "True";

                            Timer1.Enabled = true;// 04-03-2010 bip
                            UpdateTimer.Enabled = false;// 15052010 bip

                            switch (j)
                            {
                                case 0:
                                    int optindex = 1;
                                    // slnos = CheckSlNo();
                                    lblNo1.Text = slno.ToString() + ".  ";
                                    // lblQues1.Text = ds.Tables[0].Rows[i]["Question"].ToString();
                                    tcellQues1.InnerHtml = ds.Tables[0].Rows[i]["Question"].ToString();

                                    lblQuesID1.Text = ds.Tables[0].Rows[i]["QuestionID"].ToString();

                                    var Ques1 = from Ques in dataclass.EvaluationResults
                                                where Ques.UserId == userid && Ques.Question == ds.Tables[0].Rows[i]["Question"].ToString() && Ques.QuestionID == int.Parse(ds.Tables[0].Rows[i]["QuestionID"].ToString()) &&
                                                Ques.TestId == testId && Ques.TestSectionId == testsectionid
                                                select Ques;//Ques.UserCode == usercode &&
                                    if (Ques1.Count() > 0)
                                        if (Ques1.First().Answer != null)
                                            Answer = Ques1.First().Answer.ToString();
                                    if (ds.Tables[0].Rows[i]["Option1"].ToString() != "")
                                    {
                                        rbQues1Answer1.Visible = true; lblA1.Visible = true;
                                        rbQues1Answer1.Text = ds.Tables[0].Rows[i]["Option1"].ToString();
                                        if (ds.Tables[0].Rows[i]["Option1"].ToString() == Answer)
                                            rbQues1Answer1.Checked = true;
                                        optindex++;
                                    }
                                    if (ds.Tables[0].Rows[i]["Option2"].ToString() != "")
                                    {
                                        if (optindex != 2)
                                            lblB1.Text = GetAnswerOptionOrder(optindex);
                                        rbQues1Answer2.Visible = true; lblB1.Visible = true;
                                        rbQues1Answer2.Text = ds.Tables[0].Rows[i]["Option2"].ToString();
                                        if (ds.Tables[0].Rows[i]["Option2"].ToString() == Answer)
                                            rbQues1Answer2.Checked = true;
                                        optindex++;
                                    }
                                    if (ds.Tables[0].Rows[i]["Option3"].ToString() != "")
                                    {
                                        if (optindex != 3)
                                            lblC1.Text = GetAnswerOptionOrder(optindex);
                                        rbQues1Answer3.Visible = true; lblC1.Visible = true;
                                        rbQues1Answer3.Text = ds.Tables[0].Rows[i]["Option3"].ToString();
                                        if (ds.Tables[0].Rows[i]["Option3"].ToString() == Answer)
                                            rbQues1Answer3.Checked = true;
                                        optindex++;
                                    }
                                    if (ds.Tables[0].Rows[i]["Option4"].ToString() != "")
                                    {
                                        if (optindex != 4)
                                            lblD1.Text = GetAnswerOptionOrder(optindex);
                                        rbQues1Answer4.Visible = true; lblD1.Visible = true;
                                        rbQues1Answer4.Text = ds.Tables[0].Rows[i]["Option4"].ToString();
                                        if (ds.Tables[0].Rows[i]["Option4"].ToString() == Answer)
                                            rbQues1Answer4.Checked = true;
                                        optindex++;
                                    }
                                    if (ds.Tables[0].Rows[i]["Option5"].ToString() != "")
                                    {
                                        if (optindex != 5)
                                            lblE1.Text = GetAnswerOptionOrder(optindex);
                                        rbQues1Answer5.Visible = true; lblE1.Visible = true;
                                        rbQues1Answer5.Text = ds.Tables[0].Rows[i]["Option5"].ToString();
                                        if (ds.Tables[0].Rows[i]["Option5"].ToString() == Answer)
                                            rbQues1Answer5.Checked = true;
                                    }                                    

                                    btnSubmit.Enabled = true; divInstructions.InnerHtml = "";
                                    pnlQuestion.Visible = true;// 29122009 bip
                                    imgbtnPlay.Visible = false;
                                    curntquescnt++;
                                    j++;
                                    break;

                            }
                        }
                    }
                    else { GoToNextPage(); }
                    Session["curntques"] = curntquescnt;
                }
        //}
        //catch (Exception ex)
        //{
        //    FillQuestion();//bipson 14082010 to avoid arithmetic error... //conn.Close();
        //}
    }

    private void GoToNextPage()
    {
       // ClearSessionValues();
        ClearAllPageCountValues(1);
        Session["evaldirection"] = "Next";
        Session["SubCtrl"] = "RatingQuestions.ascx";
        Response.Redirect("FJAHome.aspx");
    }

    private void SaveAnswer()
    {
        string quescategory = "VideoType";
        int testsectionid = 0;
        if (Session["CurrentTestSectionId"] != null)
            testsectionid = int.Parse(Session["CurrentTestSectionId"].ToString());

        string answer = "";
        

        if (rbQues1Answer1.Checked == true)
            //answer = rbQues1Answer1.Text;
            answer = "1";
        else if (rbQues1Answer2.Checked == true)
            //answer = rbQues1Answer2.Text;
            answer = "2";
        else if (rbQues1Answer3.Checked == true)
            //answer = rbQues1Answer3.Text;
            answer = "3";
        else if (rbQues1Answer4.Checked == true)
            //answer = rbQues1Answer4.Text;
            answer = "4";
        else if (rbQues1Answer5.Checked == true)
            //answer = rbQues1Answer5.Text; 
            answer = "5";

        if (lblQuesID1.Text.Trim() != "")
        {
            qusid1 = int.Parse(lblQuesID1.Text.Trim());
            dataclass.Procedure_QuesAnswers(qusid1, usercode, tcellQues1.InnerHtml, answer, userid, testId, testsectionid,quescategory);
        }
        answer = "";        
    }

    private void ClearControls()
    {
        rbQues1Answer1.Checked = false; rbQues1Answer1.Visible = false;
        rbQues1Answer2.Checked = false; rbQues1Answer2.Visible = false;
        rbQues1Answer3.Checked = false; rbQues1Answer3.Visible = false;
        rbQues1Answer4.Checked = false; rbQues1Answer4.Visible = false;
        rbQues1Answer5.Checked = false; rbQues1Answer5.Visible = false;

        lblA1.Visible = false; lblB1.Visible = false; lblC1.Visible = false; lblD1.Visible = false; lblE1.Visible = false;
        
        lblNo1.Text = ""; 
        lblQues1.Text = ""; 
        tcellVideoQuestion1.InnerHtml = "";
        tcellQues1.InnerHtml = "";
    }

    private void ClearSessionValues()
    {
        //Session["pagecount_video"] = null;
    }
    private void ClearAllPageCountValues(int index)
    {
        if (index == 0)
            Session["pagecount_video"] = null;
        Session["pagecountRating"] = null;        
    }
    private string GetVideoFileName()
    {
        string displayvideo = "";
        if (Session["test_video"] != null)
            test = int.Parse(Session["test_video"].ToString());
        
        if (ds.Tables.Count > 0)
        {
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (Session["pagecount_video"] != null)
                    pagecount = int.Parse(Session["pagecount_video"].ToString());

                int slno = 0;
                slno = pagecount * quesperPage + 1;
                if (slno < 0)
                    slno = 0;
                if (slno > ds.Tables[0].Rows.Count)//
                { Session["displaystatus_video"] = "True"; Session["test_video"] = null; return ""; }
                
                if (test > 1) { Session["displaystatus_video"] = "True"; return ""; }
                displayvideo = ds.Tables[0].Rows[slno - 1]["QuestionFileName"].ToString();                
            }
        }
        return displayvideo;
    }
    protected void UpdateTimer_Tick(object sender, EventArgs e)
    {
        /*
        /// bip 10052010
        if (Session["timeExpired"] != null)
            if (Session["timeExpired"].ToString() == "True")
                return;

        if (CheckTime() == true) {  return; }//SaveAnswer();
        ///
        

        bool countcompleted = false;
        if (Session["test_video"] != null)
            test = int.Parse(Session["test_video"].ToString());
        test = test + 1;
        Session["test_video"] = test.ToString();

        string displayvalue = GetVideoFileName();
        if (displayvalue == "")
            if (Session["displaystatus_video"].ToString() == "True")
            { UpdateTimer.Enabled = false; Session["test_video"] = null; FillQuestion(); }

        PlayVideo(displayvalue, 1);
        // txtmemtypewords.Text = displayword;
        if (Session["pagecount_video"] != null)
            pagecount = int.Parse(Session["pagecount_video"].ToString());

        int slno = 0;
        slno = pagecount * quesperPage + 1;
        if (slno < 0)
            slno = 0;
        
        if (test > 1)
            countcompleted = true;
        
        if (countcompleted == true)
        { UpdateTimer.Enabled = false; Session["displaystatus_video"] = "True"; Session["test_video"] = null; tcellQues1.InnerHtml = ""; FillQuestion(); }
        */
    }
    protected void lbtnPlay_Click(object sender, EventArgs e)
    {
        imgbtnClickHere.Visible = true; lblInstruction_ques.Visible = true;lblInstruction_ques1.Visible = true;
        string displayvalue = GetVideoFileName(); divInstructions.InnerHtml = "";//FillVideoQuestionInstructions();
        PlayVideo(displayvalue, 1);
    }
    protected void lbtnViewQuestion_Click(object sender, EventArgs e)
    {
        
    }
    protected void imgbtnPlay_Click(object sender, ImageClickEventArgs e)
    {
       // PlayVideo("", 1); return;

        mpPlayer1.Visible = true; imgbtnPlay.Visible = false;
        imgbtnClickHere.Visible = true; lblInstruction_ques.Visible = true; lblInstruction_ques1.Visible = true;
        string displayvalue = GetVideoFileName(); divInstructions.InnerHtml = "";//FillVideoQuestionInstructions();
        PlayVideo(displayvalue, 1);
    }
    protected void imgbtnClickHere_Click(object sender, ImageClickEventArgs e)
    {
        if (Session["pagecount_video"] != null)
            pagecount = int.Parse(Session["pagecount_video"].ToString());
        Session["VideoCurrentpage"] = pagecount.ToString();

        Session["displaystatus_video"] = "True"; mpPlayer1.Visible = false;
        imgbtnClickHere.Visible = false; lblInstruction_ques.Visible = false; lblInstruction_ques1.Visible = false;
        UpdateTimer.Enabled = false; Session["test_video"] = null; FillQuestion(); divInstructions.InnerHtml = "";
    }
    protected void btnYes_Click(object sender, EventArgs e)
    {        
        SaveValues(); pnlpopup.Visible = false;
        Timer1.Enabled = true;// 04-03-2010 bip
    }

    // for first level variablewise time setting 24-02-2010 bip
  
    private Boolean CheckTestSecVarTimeValidity()
    {
        if (Session["TestSectionVariableStartTime"] != null)
        {
            if (Session["TestSectionVariableTimeDuration"] != null)
            {
                DateTime dtStart = (DateTime)Session["TestSectionVariableStartTime"];
                DateTime dtNow = DateTime.Now;
                TimeSpan tsNow = dtNow.Subtract(dtStart);
                int hrs = tsNow.Hours;
                int min = tsNow.Minutes;
                int sec = tsNow.Seconds;

                string strDuration = Session["TestSectionVariableTimeDuration"].ToString();
                string[] timeValues = strDuration.Split(new char[] { ':' });
                int setHrs = int.Parse(timeValues[0].ToString());
                int setMin = int.Parse(timeValues[1].ToString());
                int setSec = int.Parse(timeValues[2].ToString());

                TimeSpan tsDuration = new TimeSpan(setHrs, setMin, setSec);//25-02-2010 bip
                bool timeExpired = false;
                if (tsNow > tsDuration)
                    timeExpired = true;
                // return true;
                TimeSpan tsTimeRemains = tsDuration.Subtract(tsNow);

                // 03-02-2010 bip
                int firstvariableid = 0;
                if (Session["CurrentTestFirstVariableId"] != null)
                    firstvariableid = int.Parse(Session["CurrentTestFirstVariableId"].ToString());
                DataTable dtTimeDetails = new DataTable();
                if (Session["FirstvarTimeDet"] == null)
                {
                    dtTimeDetails.Columns.Add("FirstVarID");
                    dtTimeDetails.Columns.Add("TimeUsed");
                    dtTimeDetails.Columns.Add("CompletionStatus");
                    dtTimeDetails.Columns.Add("AssignTime");
                    dtTimeDetails.Columns.Add("AssignStatus");
                }
                else
                {
                    dtTimeDetails = (DataTable)Session["FirstvarTimeDet"];
                }
                bool valueexists = false;
                for (int i = 0; i < dtTimeDetails.Rows.Count; i++)
                {
                    int firstvarid = 0;
                    string competionstatus = "", assigntime = "", timeused = "", assignStatus = "";
                    if (dtTimeDetails.Rows[i]["FirstVarID"] != null)
                        firstvarid = int.Parse(dtTimeDetails.Rows[i]["FirstVarID"].ToString());
                    if (dtTimeDetails.Rows[i]["TimeUsed"] != null)
                        timeused = dtTimeDetails.Rows[i]["TimeUsed"].ToString();
                    if (dtTimeDetails.Rows[i]["CompletionStatus"] != null)
                        competionstatus = dtTimeDetails.Rows[i]["CompletionStatus"].ToString();
                    if (dtTimeDetails.Rows[i]["AssignTime"] != null)
                        assigntime = dtTimeDetails.Rows[i]["AssignTime"].ToString();
                    if (dtTimeDetails.Rows[i]["AssignStatus"] != null)
                        assignStatus = dtTimeDetails.Rows[i]["AssignStatus"].ToString();

                    if (firstvariableid == firstvarid)
                    {
                        valueexists = true;

                        if (dtTimeDetails.Rows[i]["CompletionStatus"].ToString() == "1")
                            return true;

                        dtTimeDetails.Rows[i]["TimeUsed"] = hrs + ":" + min + ":" + sec;

                        if (timeExpired == true)
                        {
                            dtTimeDetails.Rows[i]["CompletionStatus"] = 1;
                            Session["FirstvarTimeDet"] = dtTimeDetails;
                            return true;
                        }
                        Session["FirstvarTimeDet"] = dtTimeDetails;
                        break;
                    }
                }
                if (valueexists == false)
                {
                    // code to assign values from here
                    DataRow drTimedet = dtTimeDetails.NewRow();
                    drTimedet["FirstVarID"] = firstvariableid;
                    //drTimedet["CompletionStatus"] = 0;
                    drTimedet["TimeUsed"] = hrs + ":" + min + ":" + sec;
                    drTimedet["AssignTime"] = setHrs + ":" + setMin + ":" + 0;
                    drTimedet["AssignStatus"] = 1;
                    //dtTimeDetails.Rows.Add(drTimedet);

                    if (timeExpired == true)
                    {
                        drTimedet["CompletionStatus"] = 1;
                        dtTimeDetails.Rows.Add(drTimedet);
                        Session["FirstvarTimeDet"] = dtTimeDetails;
                        return true;
                    }
                    drTimedet["CompletionStatus"] = 0;
                    dtTimeDetails.Rows.Add(drTimedet);
                    Session["FirstvarTimeDet"] = dtTimeDetails;
                }
                ////

            }
            else return CheckTestSecVarGenValidity();

        }
        //else Session["AudioStatrtTime"] = DateTime.Now;

        return false;
    }
    private Boolean CheckTestSecVarGenValidity()
    {
       // if (Session["TestSectionVariableTimeDuration"] == null)
            if (Session["TotalTimeForUnAssgnSecVariables"] != null)
            {
                string[] totaltimeforUnAssgn = Session["TotalTimeForUnAssgnSecVariables"].ToString().Split(new char[] { ':' });
                int totalHrsforUnAssgn = int.Parse(totaltimeforUnAssgn[0]);
                int totalMinforUnAssgn = int.Parse(totaltimeforUnAssgn[1]);
                int totalSecforUnAssgn = int.Parse(totaltimeforUnAssgn[2]);

                TimeSpan tsUnAssgn = new TimeSpan(totalHrsforUnAssgn, totalMinforUnAssgn, totalSecforUnAssgn);
                int genHrs = 0, genMin = 0, genSec = 0;
                if (Session["GeneralVariableTimeUsed"] != null)
                {
                    string[] genTimeUsed = Session["GeneralVariableTimeUsed"].ToString().Split(new char[] { ':' });
                    genHrs = int.Parse(genTimeUsed[0]);
                    genMin = int.Parse(genTimeUsed[1]);
                    genSec = int.Parse(genTimeUsed[2]);
                    TimeSpan tsGeneral = new TimeSpan(genHrs, genMin, genSec);

                    if (tsGeneral > tsUnAssgn)
                        return true;
                }

                //

                if (Session["TestSectionVariableStartTime"] != null)
                {
                    DateTime dtStartTime = (DateTime)Session["TestSectionVariableStartTime"];
                    DateTime dtendTime = DateTime.Now;
                    TimeSpan tsUsed = dtendTime.Subtract(dtStartTime);

                    genHrs += tsUsed.Hours;
                    genMin += tsUsed.Minutes;
                    genSec += tsUsed.Seconds;

                    if (genSec >= 60)
                    {
                        double getMin = float.Parse(genSec.ToString()) / 60;
                        string[] newMin = getMin.ToString().Split(new char[] { '.' });
                        if (newMin.Length > 1)
                        {
                            int newminutes = int.Parse(newMin[0]);
                            genMin += newminutes;

                            float newSec = float.Parse(getMin.ToString().Substring(1)) * 60;
                            string[] newSeconds = newSec.ToString().Split(new char[] { '.' });
                            int seconds = int.Parse(newSeconds[0]);
                            genSec = seconds;
                        }
                    }

                    if (genMin >= 60)
                    {
                        double getHrs = float.Parse(genMin.ToString()) / 60;
                        string[] newHrs = getHrs.ToString().Split(new char[] { '.' });
                        if (newHrs.Length > 1)
                        {
                            int newhours = int.Parse(newHrs[0]);
                            genHrs += newhours;

                            float newMin = float.Parse(getHrs.ToString().Substring(1)) * 60;
                            string[] newMinutes = newMin.ToString().Split(new char[] { '.' });
                            int minutes = int.Parse(newMinutes[0]);
                          …