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;
using System.Collections.Generic;
using nmsSetup;
using nmsDropDown;
public partial class adminblock_setquestionpapertoStudent : System.Web.UI.Page
{
    clsBLSetup obj;
    PRPSetup objprp, objparm;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
            bindOrg();
          //  viewCourse(); 
            questionpapername();
        bindState();
        BindDll();
         //   studentbatch();
        }
    }

    private void bindOrg()
    {
        clsBLdropDown objdrp = new clsBLdropDown();
        clsPRPdropdown objprpdrp = new clsPRPdropdown();
        objprpdrp.controlList = ddlOrg;
        objprpdrp.spName = "viewOrgname";
        objdrp.bindDropDown(objprpdrp);
    }

    private void viewCourse()
    {
        clsBLdropDown objdrp = new clsBLdropDown();
        clsPRPdropdown objprpdrp = new clsPRPdropdown();
        objprpdrp.controlList = ddlmaincategory;
        if (ddlOrg.SelectedIndex > 0)
        {
            objprpdrp.id = Convert.ToInt32(ddlOrg.SelectedValue);
        }
        objprpdrp.spName = "viewCourseNameUniWise";
        objdrp.bindDropDown(objprpdrp);
    }
    private void questionpapername()
    {
        clsBLdropDown drp = new clsBLdropDown();
        clsPRPdropdown drpprp = new clsPRPdropdown();
        drpprp.controlList = ddlquestionpaper;
        if (ddlmaincategory.SelectedIndex > 0)
        {
            drpprp.id = Convert.ToInt32(ddlmaincategory.SelectedValue);
        }
        
        drpprp.spName = "viewquestionpapername";

        drp.bindDropDown(drpprp);
        
    }

    private void BindDll()
    {
       clsPRPdropdown objprpD = new clsPRPdropdown();
       clsBLdropDown objD = new clsBLdropDown();
       objprpD.id =Convert.ToInt32(ddlState.SelectedValue);
        objprpD.spName = "viewBranch";
        objprpD.controlList = ddlBranch;
        objD.bindDropDown(objprpD);
    }    
    protected void btnSubmit_Click(object sender, EventArgs e)
    {

    }
    protected void ddlstudentbatch_SelectedIndexChanged(object sender, EventArgs e)
    {
        bindlist();
    }
   
    private void bindlist()
    {
        objprp = new PRPSetup();
        obj = new clsBLSetup();
        List<PRPSetup> obj1 = new List<PRPSetup>();

        objprp.catID = ddlmaincategory.SelectedValue;
        objprp.uniID = ddlBranch.SelectedValue;

        obj1 = obj.viewStudentCourseBranchWise(objprp);
        chkstudentlist.DataSource = obj1;
        chkstudentlist.DataTextField ="name";
        chkstudentlist.DataValueField ="id";
        chkstudentlist.DataBind();    
    }

    protected void btnSubmit_Click1(object sender, EventArgs e)
    {
        string st = "";
        foreach (ListItem lt in chkstudentlist.Items)
        { if(lt.Selected==true)
       
         { st += "insert into tblviewstudentquestionpaper (studentid,questionpaperid,TestHeldDate,Testtime,Testhour,TestMinute,subjectId)values(" + lt.Value + "," + ddlquestionpaper.SelectedValue + ",DATEADD(HH," + Convert.ToString(Convert.ToInt32(ddlHour.SelectedValue) + 12) + ",DATEADD(MINUTE," + ddlMinute.SelectedValue + ",'" + txtheldon.Text + "')),'" + ddlTime.SelectedValue + "'," + ddlHour.SelectedValue + "," + ddlMinute.SelectedValue + "," + ddlmaincategory.SelectedValue + ") ; "; 
         }
        }
      
        objprp = new PRPSetup();
        obj = new clsBLSetup();
           objprp.Query = st;
           //objprp.description = ViewState["query"].ToString();
           string sts = obj.setquestionpapertostudent(objprp);
  
       }

    private void bindState()
    {
        clsBLdropDown drp = new clsBLdropDown();
        clsPRPdropdown drpprp = new clsPRPdropdown();
        drpprp.controlList = ddlState;
        drpprp.spName = "viewState";
        drp.bindDropDown(drpprp);
        // ddlState.SelectedIndex = 1;
    }
    protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlState.SelectedIndex > 0)
            BindDll();
    }
    protected void ddlmaincategory_SelectedIndexChanged(object sender, EventArgs e)
    {
        questionpapername();
        bindlist();
      
    }

    protected void ddlOrg_SelectedIndexChanged(object sender, EventArgs e)
    {
        viewCourse();
    }
}