Esempio n. 1
0
    protected void upd_btn_Click(object sender, EventArgs e)
    {
        con.Open();

        //SqlCommand cmd = new SqlCommand("admin_add_complaint_proc", con);
        //cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@action", "update");
        //cmd.Parameters.AddWithValue("@pk_id", Label_id.Text);
        //cmd.Parameters.AddWithValue("@batch", Batch_dll.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@stream", streamddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@Student_name", student_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@student_rollno", roll_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@date", System.DateTime.Now.ToString());
        //cmd.Parameters.AddWithValue("@complaint", Text_complaint.Text);
        //cmd.ExecuteNonQuery();
        finance.Financeserv obj = new finance.Financeserv();
        int a = obj.addcomplaintupdate(Convert.ToInt32(Label_id.Text), Batch_dll.SelectedItem.ToString(), streamddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), student_ddl.SelectedItem.ToString(),
                                       roll_ddl.SelectedItem.ToString(), System.DateTime.Now.ToString(), Text_complaint.Text);

        if (a > 0)
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true);
            gridshow();
            blank();
            con.Close();

            upd_btn.Visible    = false;
            submit_btn.Visible = true;
        }
    }
Esempio n. 2
0
    protected void submit_btn_Click(object sender, EventArgs e)
    {
        con.Open();

        //SqlCommand cmd = new SqlCommand("addfee_proc", con);
        //cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@action", "insert");
        //cmd.Parameters.AddWithValue("@pk_id", "");
        //cmd.Parameters.AddWithValue("@batch", Batch_dll.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@stream", streamddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@feetype", ddl_type.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@date", (DateTime.ParseExact(deposit_txt.Text,"dd/MM/yyyy",CultureInfo.InvariantCulture)).ToShortDateString());
        //cmd.Parameters.AddWithValue("@fee", fee_txt.Text);

        //cmd.ExecuteNonQuery();

        finance.Financeserv obj = new finance.Financeserv();
        int a = obj.insert(Batch_dll.SelectedItem.ToString(), streamddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), ddl_type.SelectedItem.ToString(), (DateTime.ParseExact(deposit_txt.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture)).ToShortDateString(), fee_txt.Text);

        if (a > 0)
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submitted!!!!');", true);
            gridshow();

            blank();
        }
        con.Close();
    }
Esempio n. 3
0
    protected void upd_btn_Click(object sender, EventArgs e)
    {
        con.Open();

        //SqlCommand cmd = new SqlCommand("addfee_proc", con);
        //cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@action", "update");
        //cmd.Parameters.AddWithValue("@pk_id", Label_id.Text);
        //cmd.Parameters.AddWithValue("@batch", Batch_dll.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@stream", streamddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@feetype", ddl_type.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@date", deposit_txt.Text);
        //cmd.Parameters.AddWithValue("@fee", fee_txt.Text);
        //cmd.ExecuteNonQuery();
        finance.Financeserv obj = new finance.Financeserv();
        int a = obj.update(Convert.ToInt32(Label_id.Text), Batch_dll.SelectedItem.ToString(), streamddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), ddl_type.SelectedItem.ToString(), deposit_txt.Text, fee_txt.Text);

        if (a > 0)
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true);
            gridshow();
            blank();
        }
        con.Close();
        upd_btn.Visible    = false;
        submit_btn.Visible = true;
        batch();
        stream();
        classname();
        section();
    }
Esempio n. 4
0
    protected void submit_btn_Click(object sender, EventArgs e)
    {
        string senderusername;

        senderusername = Label9.Text;
        string senderpassword;

        senderpassword = Label10.Text;
        string senderid;

        senderid = Label11.Text;
        con.Open();
        //SqlCommand cmd = new SqlCommand("admin_add_complaint_proc", con);
        //cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@action", "insert");
        //cmd.Parameters.AddWithValue("@pk_id", "");
        //cmd.Parameters.AddWithValue("@batch", Batch_dll.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@stream", streamddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@Student_name", student_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@student_rollno", roll_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@date", System.DateTime.Now.ToString());
        //cmd.Parameters.AddWithValue("@complaint", Text_complaint.Text);
        //cmd.ExecuteNonQuery();
        finance.Financeserv obj = new finance.Financeserv();
        int a = obj.addcomplaintinsert(Batch_dll.SelectedItem.ToString(), streamddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), student_ddl.SelectedItem.ToString(),
                                       roll_ddl.SelectedItem.ToString(), System.DateTime.Now.ToString(), Text_complaint.Text);

        if (a > 0)
        {
            string       sURL;
            string       message1 = "Hello Sir " + "\n\n" + "Complaint :" + Text_complaint.Text + "\n\n";
            StreamReader objReader;

            sURL = "http://pointsms.in/API/sms.php?username="******"&password="******"&from=" + senderid + "&to=" + father_contact.Text + "&msg=" + message1;

            WebRequest wrGETURL;
            wrGETURL = WebRequest.Create(sURL);
            try
            {
                Stream objStream;
                objStream = wrGETURL.GetResponse().GetResponseStream();
                objReader = new StreamReader(objStream);
                objReader.Close();
            }
            catch (Exception ex)
            {
                ex.ToString();
            }
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submitted!!!!');", true);

            gridshow();
            blank();
        }
        con.Close();
    }
Esempio n. 5
0
 public void gridshow()
 {
     //SqlDataAdapter da = new SqlDataAdapter("admin_add_complaint_dlt_proc", con);
     //da.SelectCommand.CommandType = CommandType.StoredProcedure;
     //da.SelectCommand.Parameters.AddWithValue("@action", "show");
     //da.SelectCommand.Parameters.AddWithValue("@pk_id", "");
     //DataTable dt = new DataTable();
     //da.Fill(dt);
     finance.Financeserv obj = new finance.Financeserv();
     GridView1.DataSource = obj.addcomplaintshow();
     GridView1.DataBind();
 }
Esempio n. 6
0
 public void gridshow()
 {
     //SqlDataAdapter da = new SqlDataAdapter("studentinfo_procevent", con);
     //da.SelectCommand.CommandType = CommandType.StoredProcedure;
     //da.SelectCommand.Parameters.AddWithValue("@action", "show");
     //da.SelectCommand.Parameters.AddWithValue("@student_id", "");
     //DataTable dt = new DataTable();
     //da.Fill(dt);
     finance.Financeserv obj = new finance.Financeserv();
     GridView1.DataSource = obj.studentshow();
     GridView1.DataBind();
 }
Esempio n. 7
0
    protected void btn_delete_Click(object sender, EventArgs e)
    {
        con.Open();
        LinkButton  lnk = (LinkButton)sender;
        GridViewRow row = (GridViewRow)lnk.NamingContainer;
        Label       l1  = (Label)row.FindControl("Lbl_id");

        //SqlCommand cmd = new SqlCommand("parentinfo_procevent", con);
        //cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@action", "delete");
        //cmd.Parameters.AddWithValue("@parent_id", l1.Text);
        //cmd.ExecuteNonQuery();
        finance.Financeserv obj = new finance.Financeserv();
        int a = obj.parentdelete(Convert.ToInt32(l1.Text));

        if (a > 0)
        {
            gridshow();
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Deleted!!!!');", true);
        }
        con.Close();
    }
Esempio n. 8
0
    protected void upd_btn_Click(object sender, EventArgs e)
    {
        con.Open();


        //SqlCommand cmd = new SqlCommand("parentinfo_proc", con);
        //cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@action", "update");
        //cmd.Parameters.AddWithValue("@parent_id", Label_id.Text);
        //cmd.Parameters.AddWithValue("@firstname", Parent_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@student_name", sname_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@relation", relation_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@dob", dob_txt.Text);
        //cmd.Parameters.AddWithValue("@qualification", quali_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@occupation", occupation_txt.Text);
        //cmd.Parameters.AddWithValue("@income", income_txt.Text);
        //cmd.Parameters.AddWithValue("@email", email_txt.Text);
        //cmd.Parameters.AddWithValue("@mobilephone", mob_txt.Text);
        //cmd.Parameters.AddWithValue("@password", lbl_pass.Text);
        //cmd.Parameters.AddWithValue("@type", "parent");
        //cmd.ExecuteNonQuery();
        finance.Financeserv obj = new finance.Financeserv();
        int a = obj.parentupdate(Convert.ToInt32(Label_id.Text), Parent_ddl.SelectedItem.ToString(), sname_ddl.SelectedItem.ToString(), relation_ddl.SelectedItem.ToString(), dob_txt.Text, quali_ddl.SelectedItem.ToString(),
                                 occupation_txt.Text, income_txt.Text, email_txt.Text, mob_txt.Text, lbl_pass.Text, "parent");

        if (a > 0)
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true);

            gridshow();
            blank();
            clr_btn.Visible    = true;
            upd_btn.Visible    = false;
            submit_btn.Visible = true;
        }
        con.Close();
    }
Esempio n. 9
0
    protected void submit_btn_Click(object sender, EventArgs e)
    {
        string senderusername;

        senderusername = Label9.Text;
        string senderpassword;

        senderpassword = Label10.Text;
        string senderid;

        senderid = Label11.Text;
        con.Open();
        SqlCommand    com = new SqlCommand("select * from parentinfo where student_name='" + sname_ddl.SelectedItem.ToString() + "' and firstname='" + Parent_ddl.SelectedItem.ToString() + "' and email='" + email_txt.Text + "'", con);
        SqlDataReader dr  = com.ExecuteReader();

        if (dr.Read())
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Record Exist Already!!!!');", true);

            dr.Close();
            blank();
        }
        else
        {
            dr.Close();
            //SqlCommand cmd = new SqlCommand("parentinfo_proc", con);
            //cmd.CommandType = CommandType.StoredProcedure;
            //cmd.Parameters.AddWithValue("@action", "insert");
            //cmd.Parameters.AddWithValue("@parent_id", "");
            //cmd.Parameters.AddWithValue("@firstname", Parent_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@student_name", sname_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@relation", relation_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@dob", dob_txt.Text);
            //cmd.Parameters.AddWithValue("@qualification", quali_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@occupation", occupation_txt.Text);
            //cmd.Parameters.AddWithValue("@income", income_txt.Text);
            //cmd.Parameters.AddWithValue("@email", email_txt.Text);
            //cmd.Parameters.AddWithValue("@mobilephone", mob_txt.Text);
            //cmd.Parameters.AddWithValue("@type", "parent");

            //Random ran = new Random();
            //int i = ran.Next(1, 9);
            //int j = i * 689;
            //pass = "******" + j + "ER";
            //cmd.Parameters.AddWithValue("@password", pass);
            finance.Financeserv obj = new finance.Financeserv();
            int a = obj.parentinsert(Parent_ddl.SelectedItem.ToString(), sname_ddl.SelectedItem.ToString(), relation_ddl.SelectedItem.ToString(), dob_txt.Text, quali_ddl.SelectedItem.ToString(),
                                     occupation_txt.Text, income_txt.Text, email_txt.Text, mob_txt.Text, "parent", pass);
            if (a > 0)
            {
                var smtp = new System.Net.Mail.SmtpClient();
                {
                    smtp.Host        = "smtp.gmail.com";
                    smtp.Port        = 587;
                    smtp.EnableSsl   = true;
                    smtp.Credentials = new NetworkCredential("*****@*****.**".ToString(), "my1234567".ToString());
                }
                smtp.Send("*****@*****.**".ToString(), email_txt.Text, "Message".ToString(), "Your Loginid:-  " + email_txt.Text + "\r\n" + "Your Password:-  " + pass);
                //System.Net.Mail.MailMessage mail = new MailMessage();
                //mail.From = new MailAddress("*****@*****.**");
                //mail.To.Add(email_txt.Text);
                //mail.Subject = "Login Id Details";
                //mail.Body = "<html><head><title>Login Id Details:</title></head><body><div><br/><br/><p>Your Loginid:" + email_txt.Text + "<br/>Your Password:-" + pass + "<br/> </div></body></Html>";
                //mail.IsBodyHtml = true;
                //SmtpClient smtp = new SmtpClient();
                //smtp.Host = "relay-hosting.secureserver.net";
                //smtp.Port = 25;
                //smtp.EnableSsl = false;
                //smtp.Send(mail);
                //cmd.ExecuteNonQuery();

                string       sURL;
                string       message1 = "Thanks For Registration" + "\n\n" + "Email:" + email_txt.Text + "\n\n" + "Password:"******"\n";
                StreamReader objReader;

                sURL = "http://pointsms.in/API/sms.php?username="******"&password="******"&from=" + senderid + "&to=" + mob_txt.Text + "&msg=" + message1;

                WebRequest wrGETURL;
                wrGETURL = WebRequest.Create(sURL);
                try
                {
                    Stream objStream;
                    objStream = wrGETURL.GetResponse().GetResponseStream();
                    objReader = new StreamReader(objStream);
                    objReader.Close();
                }
                catch (Exception ex)
                {
                    ex.ToString();
                }

                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Thanks For Registration!!!!');", true);

                gridshow();
                blank();
            }
        }
        con.Close();
    }
Esempio n. 10
0
    protected void submit_btn_Click(object sender, EventArgs e)
    {
        string senderusername;

        senderusername = Label9.Text;
        string senderpassword;

        senderpassword = Label10.Text;
        string senderid;

        senderid = Label11.Text;
        con.Open();

        SqlCommand    com = new SqlCommand("select * from studentinfo where student_name='" + name_txt.Text + "' and father_name='" + father_txt.Text + "' and mother_name='" + mother_txt.Text + "' and roll_no='" + rollno_txt.Text + "' and email='" + email_txt.Text + "' and batch='" + batch_ddl.SelectedItem.ToString() + "' and class='" + class_ddl.SelectedItem.ToString() + "'", con);
        SqlDataReader dr  = com.ExecuteReader();

        if (dr.Read())
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Record Exist Already!!!!');", true);
        }
        else
        {
            dr.Close();
            string imgg = "";
            if (student_image.HasFile)
            {
                imgg = ("~/img/" + student_image.FileName);
                student_image.SaveAs(Server.MapPath("~/img/") + student_image.FileName);
            }

            string imgg1 = "";
            if (doc_image.HasFile)
            {
                imgg1 = ("~/img/" + doc_image.FileName);
                doc_image.SaveAs(Server.MapPath("~/img/") + doc_image.FileName);
            }

            //SqlCommand cmd = new SqlCommand("studentinfo_proc", con);
            //cmd.CommandType = CommandType.StoredProcedure;
            //cmd.Parameters.AddWithValue("@action", "insert");
            //cmd.Parameters.AddWithValue("@student_id", "");
            //cmd.Parameters.AddWithValue("@admission_no", admisn_no_txt.Text);
            //cmd.Parameters.AddWithValue("@admissiondate", admismdate_txt.Text);
            //cmd.Parameters.AddWithValue("@bloodgroup", blood_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@student_name", name_txt.Text);
            //cmd.Parameters.AddWithValue("@father_name", father_txt.Text);
            //cmd.Parameters.AddWithValue("@mother_name", mother_txt.Text);
            //cmd.Parameters.AddWithValue("@batch", batch_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@stream", stream_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@roll_no", rollno_txt.Text);
            //cmd.Parameters.AddWithValue("@dob", dob_txt.Text);
            //cmd.Parameters.AddWithValue("@gender", gender_ddl.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@country", ddl_country.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@state", ddl_state.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@city", ddl_city.SelectedItem.ToString());
            //cmd.Parameters.AddWithValue("@address1", addres1_txt.Text);
            //cmd.Parameters.AddWithValue("@phone", mob_txt.Text);
            //cmd.Parameters.AddWithValue("@email", email_txt.Text);


            //Random ran = new Random();
            //int i = ran.Next(1, 9);
            //int j = i * 456;
            //pass = "******" + j + "Ed";
            //cmd.Parameters.AddWithValue("@password", pass);

            //Random ran1 = new Random();
            //int k = ran.Next(1, 5);
            //int l = k * 456;
            //pass1 = "ST" + l + "Ed";
            //cmd.Parameters.AddWithValue("@s_id", pass1);

            //cmd.Parameters.AddWithValue("@image", imgg);
            //cmd.Parameters.AddWithValue("@document_name", docname_txt.Text);
            //cmd.Parameters.AddWithValue("@doc_image", imgg1);
            //cmd.Parameters.AddWithValue("@type", "student");

            finance.Financeserv obj = new finance.Financeserv();
            int a = obj.studentinsert(admisn_no_txt.Text, admismdate_txt.Text, blood_ddl.SelectedItem.ToString(), name_txt.Text, father_txt.Text, mother_txt.Text, batch_ddl.SelectedItem.ToString(),
                                      stream_ddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), rollno_txt.Text, dob_txt.Text, gender_ddl.SelectedItem.ToString(),
                                      ddl_country.SelectedItem.ToString(), ddl_state.SelectedItem.ToString(), ddl_city.SelectedItem.ToString(), addres1_txt.Text, mob_txt.Text, email_txt.Text, pass, pass1, imgg, docname_txt.Text, imgg1, "student");
            if (a > 0)
            {
                var smtp = new System.Net.Mail.SmtpClient();
                {
                    smtp.Host        = "smtp.gmail.com";
                    smtp.Port        = 587;
                    smtp.EnableSsl   = true;
                    smtp.Credentials = new NetworkCredential("*****@*****.**".ToString(), "my1234567".ToString());
                }
                smtp.Send("*****@*****.**".ToString(), email_txt.Text, "Message".ToString(), "Your Loginid:-  " + email_txt.Text + "\r\n" + "Your Password:-  " + pass + "\r\n" + "student id:- " + pass1);
                //System.Net.Mail.MailMessage mail = new MailMessage();
                //mail.From = new MailAddress("*****@*****.**");
                //mail.To.Add(email_txt.Text);
                //mail.Subject = "Login Id Details";
                //mail.Body = "<html><head><title>Login Id Details:</title></head><body><div><br/><br/><p>Your Loginid:" + email_txt.Text + "<br/>Your Password:-" + pass + "<br/>" + "Student id:-" + pass1 + "<br/> </div></body></Html>";
                //mail.IsBodyHtml = true;
                //SmtpClient smtp = new SmtpClient();
                //smtp.Host = "relay-hosting.secureserver.net";
                //smtp.Port = 25;
                //smtp.EnableSsl = false;
                //smtp.Send(mail);


                string       sURL;
                string       message1 = "Thanks For Registration" + "\n\n" + "Email:" + email_txt.Text + "\n\n" + "Password:"******"\n\n" + "Student ID" + pass1 + "\n";
                StreamReader objReader;

                sURL = "http://pointsms.in/API/sms.php?username="******"&password="******"&from=" + senderid + "&to=" + mob_txt.Text + "&msg=" + message1;

                WebRequest wrGETURL;
                wrGETURL = WebRequest.Create(sURL);
                try
                {
                    Stream objStream;
                    objStream = wrGETURL.GetResponse().GetResponseStream();
                    objReader = new StreamReader(objStream);
                    objReader.Close();
                }
                catch (Exception ex)
                {
                    ex.ToString();
                }

                gridshow();
                blank();
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Thanks for Registration!!!!');", true);

                con.Close();
                admisn_no_txt.Text = GetID("select max(admission_no) from studentinfo").ToString();
            }
        }
    }
Esempio n. 11
0
    protected void upd_btn_Click(object sender, EventArgs e)
    {
        con.Open();

        string imgg = "";

        if (student_image.HasFile)
        {
            imgg = ("~/img/" + student_image.FileName);
            student_image.SaveAs(Server.MapPath("~/img/") + student_image.FileName);
        }
        else
        {
            imgg = Image2.ImageUrl;
        }

        string imgg1 = "";

        if (doc_image.HasFile)
        {
            imgg1 = ("~/img/" + doc_image.FileName);
            doc_image.SaveAs(Server.MapPath("~/img/") + doc_image.FileName);
        }

        //SqlCommand cmd = new SqlCommand("studentinfo_proc", con);
        //cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@action", "update");
        //cmd.Parameters.AddWithValue("@student_id", Label_id.Text);
        //cmd.Parameters.AddWithValue("@admission_no", admisn_no_txt.Text);
        //cmd.Parameters.AddWithValue("@admissiondate", admismdate_txt.Text);
        //cmd.Parameters.AddWithValue("@bloodgroup", blood_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@student_name", name_txt.Text);
        //cmd.Parameters.AddWithValue("@father_name", father_txt.Text);
        //cmd.Parameters.AddWithValue("@mother_name", mother_txt.Text);
        //cmd.Parameters.AddWithValue("@batch", batch_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@stream", stream_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@roll_no", rollno_txt.Text);
        //cmd.Parameters.AddWithValue("@dob", dob_txt.Text);
        //cmd.Parameters.AddWithValue("@gender", gender_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@country", gender_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@state", gender_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@city", gender_ddl.SelectedItem.ToString());
        //cmd.Parameters.AddWithValue("@address1", addres1_txt.Text);
        //cmd.Parameters.AddWithValue("@phone", mob_txt.Text);
        //cmd.Parameters.AddWithValue("@email", email_txt.Text);
        //cmd.Parameters.AddWithValue("@password", lbl_pass.Text);
        //cmd.Parameters.AddWithValue("@s_id", lbl_sid.Text);
        //cmd.Parameters.AddWithValue("@image", imgg);
        //cmd.Parameters.AddWithValue("@document_name", docname_txt.Text);
        //cmd.Parameters.AddWithValue("@doc_image", imgg1);
        //cmd.Parameters.AddWithValue("@type", "student");
        //cmd.ExecuteNonQuery();
        finance.Financeserv obj = new finance.Financeserv();
        int a = obj.studentupdate(Convert.ToInt32(Label_id.Text), admisn_no_txt.Text, admismdate_txt.Text, blood_ddl.SelectedItem.ToString(), name_txt.Text, father_txt.Text, mother_txt.Text, batch_ddl.SelectedItem.ToString(),
                                  stream_ddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), rollno_txt.Text, dob_txt.Text, gender_ddl.SelectedItem.ToString(),
                                  ddl_country.SelectedItem.ToString(), ddl_state.SelectedItem.ToString(), ddl_city.SelectedItem.ToString(), addres1_txt.Text, mob_txt.Text, email_txt.Text, lbl_pass.Text, lbl_sid.Text, imgg, docname_txt.Text, imgg1, "student");

        if (a > 0)
        {
            gridshow();
        }
        blank();
        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true);

        submit_btn.Visible = true;
        upd_btn.Visible    = false;
        Image2.Visible     = false;
        con.Close();
    }