webform1

-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Windows.Forms;
using System.Data.SqlClient;
using Test_1.BAL;
using System.Data;



namespace Test_1
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        int chose;
        SqlCommand cmd = new SqlCommand();
        //string a;
        int a = 0;
        protected void Page_Load(object sender, EventArgs e)
        {
          
            if (!IsPostBack)
            {
                Txtbox_name.Focus();

            }
        }

        public void CharacterValidation()
        {
            string text = Txtbox_name.Text;
            var regex = new Regex(@"[^a-zA-Z\s]");
            var SpecialChar = regex.IsMatch(text.ToString());
            if (SpecialChar == true)
            {
                MessageBox.Show("Put only characters A - Z");
                Txtbox_name.Text = "";
                Txtbox_name.Focus();
            }
            //return false;
        }

        public void NumericValidation()
        {
            string age = TxtBox_age.Text;
            if (age.Length <= 3)
            {
                var regex = new Regex(@"[^0-9\s]");
                var SpecialChar = regex.IsMatch(age.ToString());
                if (SpecialChar == true)
                {
                    MessageBox.Show("Put only numeric value");
                    TxtBox_age.Text = "";
                    TxtBox_age.Focus();
                }
                //return false;
            }
            else
            {
                MessageBox.Show("you have entered wrong age");
                TxtBox_age.Text = "";
                TxtBox_age.Focus();
            }
        }

        public void Radiobuttonchecked()
        {
            if (RadioButtonList1.SelectedItem == null)
            {
                MessageBox.Show("Please select Gender");
            }

        }

        public void DroopDownListSlelected()
        {
            if (DropDownList1.SelectedIndex < 1)
            {
                MessageBox.Show("Please Select Profession");
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            CharacterValidation();
            NumericValidation();
            Radiobuttonchecked();
            DroopDownListSlelected();

            ////using bll class  -->

            //BLL_info.getName = Txtbox_name.Text;
            //BLL_info.getAge = TxtBox_age.Text;
            //BLL_info.getGender = RadioButtonList1.SelectedItem.Text;
            //BLL_info.getProfession = DropDownList1.SelectedItem.Text;

           
           
            //using ado.net class -->
            Test_1.Ado_Dot_Net_Class.getName = Txtbox_name.Text;
            Test_1.Ado_Dot_Net_Class.getAge = TxtBox_age.Text;
            Test_1.Ado_Dot_Net_Class.getGender = RadioButtonList1.SelectedItem.Text;
            Test_1.Ado_Dot_Net_Class.getProfession = DropDownList1.SelectedItem.Text;

            //int chr = int.Parse(DropDownList1.SelectedValue.ToString());
            char ch = Convert.ToChar(DropDownList1.SelectedValue.ToString());
            switch (ch)
            {
                case '1' :

                    ////using bll class  -->

                    //BLL_info.insert_into_std();
                    //BLL_info.Std_info_Bind();
                    //GridView1.DataSource=BLL_info.Std_info_Bind();
                    //GridView1.DataBind();              //  <--
                  
                    //using ado.net class -->

                    Test_1.Ado_Dot_Net_Class.insert_into_std();
                    GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Std_info_Bind();
                    GridView1.DataBind();            //<--
                    Session["a"] = "1";
                    Test_1.common.clear_Control(this.Form.Controls);
                    Txtbox_name.Focus();
                    break;
                case '2' :
                    ////using bll class  -->

                    //BLL_info.insert_into_srv();
                    //GridView1.DataSource=BLL_info.Srv_info_Bind();
                    //GridView1.DataBind();
                    // <--
                    //using ado.net class -->

                    Test_1.Ado_Dot_Net_Class.insert_into_srv();
                    GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Srv_info_Bind();
                    GridView1.DataBind();            //<--
                   Session["a"] = "2";
                    Test_1.common.clear_Control(this.Form.Controls);
                    Txtbox_name.Focus();
                    break;
                case '3' :
                    ////using bll class  -->

                    //BLL_info.insert_into_bsn();
                    //GridView1.DataSource=BLL_info.Bsn_info_Bind();
                    //GridView1.DataBind();

                    //using ado.net class -->

                    Test_1.Ado_Dot_Net_Class.insert_into_bsn();
                    GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Bsn_info_Bind();
                    GridView1.DataBind();               //<--
                    Session["a"] = "3";
                    Test_1.common.clear_Control(this.Form.Controls);
                    Txtbox_name.Focus();
                    break;
                default :
                    break;


            }

        }

        protected void TextBox1_TextChanged(object sender, EventArgs e)
        {

          
        
        }

        protected void Std_info_btn_Click(object sender, EventArgs e)
        {
            GridView1.DataSource = BLL_info.Std_info_Bind();
            GridView1.DataBind();
           //  a = get_cell_value().ToString();
            Test_1.common.clear_Control(this.Form.Controls);
            Txtbox_name.Focus();
            Session["a"] = "1";
        }

        protected void Srv_info_btn_Click(object sender, EventArgs e)
        {
            GridView1.DataSource = BLL_info.Srv_info_Bind();
            GridView1.DataBind();
            //a = get_cell_value().ToString();
            Test_1.common.clear_Control(this.Form.Controls);
            Txtbox_name.Focus();
            Session["a"] = "2";
        }

        protected void Bsn_info_btn_Click(object sender, EventArgs e)
        {
            GridView1.DataSource = BLL_info.Bsn_info_Bind();
            GridView1.DataBind();
           // a = get_cell_value().ToString();
            Test_1.common.clear_Control(this.Form.Controls);
            Txtbox_name.Focus();
            Session["a"] = "3";
        }

        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
           
            if (Session["a"].ToString() == "1")
            {
                GridView1.EditIndex = e.NewEditIndex;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Std_info_Bind();
                GridView1.DataBind();
                Test_1.common.Inactive_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = false;
               

            }
            else if (Session["a"].ToString() == "2")
            {
                GridView1.EditIndex = e.NewEditIndex;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Srv_info_Bind();
                GridView1.DataBind();
                Test_1.common.Inactive_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = false;
            }
            else if(Session["a"].ToString() == "3")
            {
                GridView1.EditIndex = e.NewEditIndex;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Bsn_info_Bind();
                GridView1.DataBind();
                Test_1.common.Inactive_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = false;
               
            }
           
          
        }

        protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
        {
           
        }

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            System.Web.UI.WebControls.Label id = (System.Web.UI.WebControls.Label)GridView1.Rows[e.RowIndex].FindControl("id");
            System.Web.UI.WebControls.TextBox name = (System.Web.UI.WebControls.TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");
            System.Web.UI.WebControls.TextBox age = (System.Web.UI.WebControls.TextBox)GridView1.Rows[e.RowIndex].FindControl("txtage");
            System.Web.UI.WebControls.DropDownList gender = (System.Web.UI.WebControls.DropDownList)GridView1.Rows[e.RowIndex].FindControl("dropdowngender");
            System.Web.UI.WebControls.Label profession = (System.Web.UI.WebControls.Label)GridView1.Rows[e.RowIndex].FindControl("profession");
            Test_1.Ado_Dot_Net_Class.getId = (int.Parse(id.Text));
            Test_1.Ado_Dot_Net_Class.getName = name.Text.ToString();
            Test_1.Ado_Dot_Net_Class.getAge = age.Text.ToString();
            Test_1.Ado_Dot_Net_Class.getGender = gender.SelectedItem.Text;
            Test_1.Ado_Dot_Net_Class.getProfession = profession.Text.ToString();

            if (Session["a"].ToString() == "1")
            {
                Test_1.Ado_Dot_Net_Class.UpdateIntoStd();
                GridView1.EditIndex = -1;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Std_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }
            else if (Session["a"].ToString() == "2")
            {
                Test_1.Ado_Dot_Net_Class.UpdateIntoSrv();
                GridView1.EditIndex = -1;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Srv_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }
            else if (Session["a"].ToString() == "3")
            {
                Test_1.Ado_Dot_Net_Class.UpdateIntoBsn();
                GridView1.EditIndex = -1;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Bsn_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
               // ((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }

        }

        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            if (Session["a"].ToString() == "1")
            {
                GridView1.EditIndex = -1;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Std_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
               // ((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }
            else if (Session["a"].ToString() == "2")
            {
                GridView1.EditIndex = -1;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Srv_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }
            else if (Session["a"].ToString() == "3")
            {
                GridView1.EditIndex = -1;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Bsn_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }
        }

        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            System.Web.UI.WebControls.Label id = (System.Web.UI.WebControls.Label)GridView1.Rows[e.RowIndex].FindControl("id");
           
            Test_1.Ado_Dot_Net_Class.getId = (int.Parse(id.Text));
           

            if (Session["a"].ToString() == "1")
            {
                Test_1.Ado_Dot_Net_Class.DeleteFromStd();
               
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Std_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
            }
            else if (Session["a"].ToString() == "2")
            {
                Test_1.Ado_Dot_Net_Class.DeleteFromSrv();
               
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Srv_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
            }
            else if (Session["a"].ToString() == "3")
            {
                Test_1.Ado_Dot_Net_Class.DeleteFromBsn();
               
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Bsn_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
            }
        }

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            if (Session["a"].ToString() == "1")
            {
                GridView1.PageIndex = e.NewPageIndex;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Std_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
                // ((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }
            else if (Session["a"].ToString() == "2")
            {
                GridView1.PageIndex = e.NewPageIndex;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Srv_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }
            else if (Session["a"].ToString() == "3")
            {
                GridView1.PageIndex = e.NewPageIndex;
                GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Bsn_info_Bind();
                GridView1.DataBind();
                Test_1.common.Active_Controls(this.Form.Controls);
                //((System.Web.UI.WebControls.Button)GridView1.FindControl("deletebtn")).Enabled = true;
            }
        }

        protected void txtSearchByName_TextChanged(object sender, EventArgs e)
        {
            if (txtSearchByName.Text == "")
            {
                if (Session["a"].ToString() == "1")
                {
                   
                    GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Std_info_Bind();
                    GridView1.DataBind();
                    return;

                }
                else if (Session["a"].ToString() == "2")
                {
                   
                    GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Srv_info_Bind();
                    GridView1.DataBind();
                    return;
                }
                else if (Session["a"].ToString() == "3")
                {
                  
                    GridView1.DataSource = Test_1.Ado_Dot_Net_Class.Bsn_info_Bind();
                    GridView1.DataBind();
                    return;
                }
            }
            SearchText();
        }

        private void SearchText()
        {
            if (Session["a"].ToString() == "1")
            {

                DataTable dt = Test_1.Ado_Dot_Net_Class.StdInfoBindByDataTable();
                DataView dv = new DataView(dt);
                string SearchExpression = null;
                if (!String.IsNullOrEmpty(txtSearchByName.Text))
                {
                    SearchExpression = string.Format("{0} '%{1}%'",
                     GridView1.SortExpression, txtSearchByName.Text);
                }
                dv.RowFilter = "name like" + SearchExpression;
                GridView1.DataSource = dv;
                GridView1.DataBind();

            }
            else if (Session["a"].ToString() == "2")
            {

                DataTable dt = Test_1.Ado_Dot_Net_Class.SrvInfoBindByDataTable();
                DataView dv = new DataView(dt);
                string SearchExpression = null;
                if (!String.IsNullOrEmpty(txtSearchByName.Text))
                {
                    SearchExpression = string.Format("{0} '%{1}%'",
                     GridView1.SortExpression, txtSearchByName.Text);
                }
                dv.RowFilter = "name like" + SearchExpression;
                GridView1.DataSource = dv;
                GridView1.DataBind();
            }
            else if (Session["a"].ToString() == "3")
            {

                DataTable dt = Test_1.Ado_Dot_Net_Class.BsnInfoBindByDataTable();
                DataView dv = new DataView(dt);
                string SearchExpression = null;
                if (!String.IsNullOrEmpty(txtSearchByName.Text))
                {
                    SearchExpression = string.Format("{0} '%{1}%'",
                     GridView1.SortExpression, txtSearchByName.Text);
                }
                dv.RowFilter = "name like" + SearchExpression;
                GridView1.DataSource = dv;
                GridView1.DataBind();
            }

          
        }

       

       


       
     

       
     
       
       
    }
}

Comments

Post a Comment

Popular posts from this blog

webformaspx

-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Test_1.WebForm1" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title>     <script src="Scripts/jquery.min.js"></script>     <script src="Scripts/JavaScript1.js"></script>     <script type="text/javascript">         function validation() {             //debugger;                         var h = $(".text");             var format = /[ !@#$%^&*()_+\-=\[\]{};':"\\|,.<...
Read more

common.cs

-
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace Test_1 {     public class common     {         public static void clear_Control(ControlCollection controls)         {             foreach(Control ctrl in controls)             {                 if (ctrl is TextBox)                 {                     ((TextBox)ctrl).Text = "";                 } ...
Read more
-
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Configuration; using System.Data; using System.Data.SqlClient; namespace Test_1 {     public class Ado_Dot_Net_Class     {         SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);         static SqlConnection con = new SqlConnection("server=DESKTOP-VH35VBK; database=TestProjectDB; integrated security=true");                     public static string getName         {             get;             set;         }         p...
Read more