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;
public partial class Admin_office_certificatemark : System.Web.UI.Page
{
    clsBLSetup obj;
    PRPSetup objprp;
   
    protected void Page_Load(object sender, EventArgs e)
    {
        

        if (Session["OfficeAdmin"] == null)
        {
            Response.Redirect("../../Default.aspx");
        }
        if (!Page.IsPostBack)
        {
            SelectDatail();
        }
        lblMsg.Text = "";

    }


    //---------------manual paging with repearter ---------------------------------------------------
    private void SelectDatail()
    {
        obj = new clsBLSetup();
        objprp = new PRPSetup();


        System.Data.DataTable dt = new System.Data.DataTable();

        dt = obj.View_HomeStudentDetail();

        if (dt.Rows.Count == 0)
        {
            lblMsg.Text = "Record not Find !";

        }
        else
        {
           
            datalist.DataSource = dt;
            datalist.DataBind();
         


        }


    }
    protected void Button1_Click(object sender, EventArgs e)
    {
         
        string querry = "" ;
         
        foreach (RepeaterItem item in datalist.Items)
        {
            
           

            if (((TextBox)item.FindControl("txtTheory")).Text != "")
            {
                querry += "update tblStudentDetail set Total=" + ((TextBox)item.FindControl("txtTheory")).Text + "   where Id=" + ((Label)item.FindControl("lblinvestorId")).Text + " ;";
            }

            

            //}
        }
      
        clsBLSetup obj = new clsBLSetup();
        
        obj.insertquery(querry);
        SelectDatail();
    }

  
}