Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

File Name : Sms_send.aspx.cs

using System;
using System.Web;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Net;
using System.IO;
using System.Text;

public partial class Sms_send : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connect"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            pnldirect.Visible = false;          
            pnladd_category.Visible = false;
            pnladd_contact.Visible = false;
            btnsave_phonebook.Visible = false;
            pnl_send_from_phonebook.Visible = false;
            bindgrid();      
            bindcatergory_dropdown();
            bindcategory_gridviw();
            lblmessage_grd.Text = "";
           
          
        }
       
    }

// here we bind category Gridview

private void bindcategory_gridviw()
    {
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
            string query = "sms_doctor_pro";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("option", "bind_category_Gridview".Trim());
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            grdcategory.DataSource = dt;
            grdcategory.DataBind();
            con.Close();

if (dt.Rows.Count == 0)
            {
                lblgrdcategor_Grid.Text = "Have No Category Found";
            }

else
            {
                lblgrdcategor_Grid.Text = "";

}

//foreach (DataRow dr in dt.Rows)
            //{
            //    if(dr.row
            //}

//for (int i = 0; i < dt.Rows.Count; i++)
            //{
            //    Label ddl = (Label)grdcategory.Rows[i].FindControl("lblcategory_Grid");
            //    if (ddl.Text = dt.Rows[0][""].ToString())
            //    {

//    }

//}

//foreach (GridViewRow row in grdcategory.Rows)
            //{
            //    Label cat = (Label)row.FindControl("lblcategory_Grid");
            //    if (dt.Rows[0]["category_"].ToString() == cat.Text)
            //    {
            //        cat.Visible = false;
            //    }
            //}
        }
    }

// here we bind data of dropdown for row created in gridview then is code excute

private void bindcatergory_dropdown()
    {
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
            string query = "sms_doctor_pro";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("option", "bind_ddl_category_dropdown_only".Trim());
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            ddlcategory.DataSource = dt;
            ddlcategory.DataValueField = "Id";
            ddlcategory.DataTextField = "category_";
            //ddlcategory.Items.Add(new ListItem("-----All Category-----", "0", true));
            ddlcategory.DataBind();
            con.Close();
        }
    }

// here we bind data of category

// this is Gridview binding property which name is grdquery

private void bindgrid()
    {
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
            string query = "sms_doctor_pro";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("option", "Select".Trim());
                 DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            grdquery.DataSource = dt;
            grdquery.DataBind();
            con.Close();
        }

}

private void bind_with_selectedindexchange()
    {
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
            string query = "sms_doctor_pro";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("option", "bind_Grid_selected_indexchange".Trim());
            cmd.Parameters.AddWithValue("@id", ddlcategory.SelectedValue);
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            grdquery.DataSource = dt;
            grdquery.DataBind();
            con.Close();
        }
    }

private void bind_in_Row_Created()
    {

for (int i = 0; i < grdadd_phonebook.Rows.Count; i++)
        {
            DropDownList dl_grid = (DropDownList)grdadd_phonebook.Rows[i].FindControl("ddlcategory_gridview");

if (con.State == ConnectionState.Closed)
            {
                con.Open();
                string query = "sms_doctor_pro";
                SqlCommand cmd = new SqlCommand(query, con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("option", "bind_ddl_category".Trim());
                DataTable dt = new DataTable();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);
                dl_grid.DataSource = dt;
                dl_grid.DataValueField = "Id";
                dl_grid.DataTextField = "category_";
                dl_grid.DataBind();
                con.Close();
            }
        }
       
    }
    protected void ddloption_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddloption.SelectedItem.Text == "Send Direct")
        {
            pnldirect.Visible = true;
            pnl_send_from_phonebook.Visible = false;
            pnladd_category.Visible = false;
            pnladd_contact.Visible = false;

}

else if (ddloption.SelectedItem.Text == "Send From Phonebook")
        {
            pnldirect.Visible = false;
            pnl_send_from_phonebook.Visible = true;
            pnladd_category.Visible = false;
            pnladd_contact.Visible = false;
            bindcatergory_dropdown();
      
         
           
           
        }

else if (ddloption.SelectedItem.Text == "Add Contact Category")
        {
            pnldirect.Visible = false;
            pnl_send_from_phonebook.Visible = false;
            pnladd_category.Visible = true;
            pnladd_contact.Visible = false;

}

else if (ddloption.SelectedItem.Text == "Add Contact")
        {
            pnldirect.Visible = false;
            pnl_send_from_phonebook.Visible = false;
            pnladd_category.Visible = false;
            pnladd_contact.Visible = true;
            bind_in_Row_Created();
        }

else 
        {
            pnldirect.Visible = false;
            pnl_send_from_phonebook.Visible = false;
            pnladd_category.Visible = false;
            pnladd_contact.Visible = false;
        }
    }

protected void grdquery_RowEditing(object sender, GridViewEditEventArgs e)
    {
        if (ddlcategory.SelectedItem.Text == "-----All Category-----")
        {
            grdquery.EditIndex = e.NewEditIndex;
            bindgrid();

}

else
        {
            grdquery.EditIndex = e.NewEditIndex;
            bind_with_selectedindexchange();
        }

}
    protected void grdquery_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        if (ddlcategory.SelectedItem.Text == "-----All Category-----")
        {
            grdquery.EditIndex = -1;
            bindgrid();

}

else
        {
            grdquery.EditIndex = -1;
            bind_with_selectedindexchange();
        }

}
  
    protected void btnnew_Category_Click(object sender, EventArgs e)
    {
        string lower = txtcategory_new.Text.Trim();
        string upercase = lower.ToUpper();

if (con.State == ConnectionState.Closed)
        {
            con.Open();
            string query_select = "sms_doctor_pro";
            SqlCommand cmd_select = new SqlCommand(query_select, con);
            cmd_select.CommandType = CommandType.StoredProcedure;
            cmd_select.Parameters.AddWithValue("@category_cat", upercase.ToString());
            cmd_select.Parameters.AddWithValue("@option", "Prevent_Duplicate_category".Trim());
            string output = cmd_select.ExecuteScalar().ToString();
            if (output == "1")
            {
                Response.Write("<script>alert('This Category Already Exist! ')</script>");
                con.Close();
            }

else
            {
                string query = "sms_doctor_pro";
                SqlCommand cmd = new SqlCommand(query, con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@category_cat", upercase.ToString());
                cmd.Parameters.AddWithValue("@option", "insert_Category".Trim());
                cmd.ExecuteNonQuery().ToString();
                con.Close();
                bind_with_selectedindexchange();
                bindcatergory_dropdown();
                Response.Write("<script>alert('Record Save Successfully! ')</script>");
                txtcategory_new.Text = "";
                bindcategory_gridviw();
                pnladd_category.Visible = true;
            }
            
        }
    }

protected void btncreate_phonebook_Click(object sender, EventArgs e)
    {
        pnladd_contact.Visible = true;    
        pnldirect.Visible = false;
        DataTable dTab = new DataTable();        
        dTab.Columns.Add("SNO");
        dTab.Columns.Add("Product");
        dTab.Columns.Add("Price");
        dTab.Columns.Add("HProduct");
        dTab.Columns.Add("Description");
        dTab.Columns.Add("HPrice");
        int add = int.Parse(txtnoof_record.Text.Trim());
        DataRow dr = dTab.NewRow();
        for (int i = 0; i<add; i++)
        {
            dr = dTab.NewRow();
            dr["SNO"] = "";
            dr["Product"] = "";
            dr["Price"] = "";
            dr["HProduct"] = "";
            dr["Description"] = "";
            dr["HPrice"] = "";
            dTab.Rows.Add(dr);
                      
        }

grdadd_phonebook.DataSource = dTab;
        grdadd_phonebook.DataBind();
        grdadd_phonebook.Visible = true;
        btnsave_phonebook.Visible = true;

}
    protected void grdadd_phonebook_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {

DropDownList dl_grid = (DropDownList)e.Row.FindControl("ddlcategory_gridview");
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
                string query = "sms_doctor_pro";
                SqlCommand cmd = new SqlCommand(query, con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("option", "bind_ddl_category".Trim());
                DataTable dt = new DataTable();
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);
                dl_grid.DataSource = dt;
                dl_grid.DataValueField = "Id";
                dl_grid.DataTextField = "category_";
                dl_grid.DataBind();
                con.Close();
            }

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

int count = 0;
        foreach (GridViewRow row in grdadd_phonebook.Rows)
        {
            if (row.RowType == DataControlRowType.DataRow)
            {
                TextBox name = (TextBox)row.FindControl("txtname_add_phonebok");
                TextBox mobile = (TextBox)row.FindControl("txtmobile__add_phonebok");
                DropDownList category = (DropDownList)row.FindControl("ddlcategory_gridview");
                if (name.Text != string.Empty && mobile.Text != string.Empty)
                {
                    if (con.State == ConnectionState.Closed)
                    {
                        con.Open();
                        
                        string query = "sms_doctor_pro";
                        SqlCommand cmd = new SqlCommand(query, con);
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@name", name.Text.Trim());
                        cmd.Parameters.AddWithValue("@contact_number", mobile.Text.Trim());
                        cmd.Parameters.AddWithValue("@catagory", category.SelectedValue.Trim());
                        cmd.Parameters.AddWithValue("@option", "Insert".Trim());
                        cmd.ExecuteNonQuery().ToString();
                        count++;
                        con.Close();
                        bindgrid();
                        name.Text = "";
                        mobile.Text = "";
                        category.SelectedItem.Text = "";

}
                }
            }

}

Response.Write("<script>alert('" + count + " Record Save Successfully! ')</script>");
         pnladd_contact.Visible = false;      
        pnldirect.Visible = false;        
        pnladd_category.Visible = false;
        pnladd_contact.Visible = true;
        bind_with_selectedindexchange();
        bindcatergory_dropdown();
        grdadd_phonebook.Visible = false;
        btnsave_phonebook.Visible = false;

}
    protected void grdquery_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {

if (ddlcategory.SelectedItem.Text == "-----All Category-----")
        {
            grdquery.PageIndex = e.NewPageIndex;
            bindgrid();

}

else
        {
            grdquery.PageIndex = e.NewPageIndex;
            bind_with_selectedindexchange();
        }
    }
    protected void grdquery_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow && (e.Row.RowState & DataControlRowState.Edit) > 0)
        {
            DropDownList ddl = (DropDownList)e.Row.FindControl("ddl_phonebook_cate");

string query = "sms_doctor_pro";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("option", "bind_ddl_category".Trim());
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            ddl.DataSource = dt;
            ddl.DataValueField = "Id";
            ddl.DataTextField = "category_";
            ddl.DataBind();
            con.Close();
        }

if ((e.Row.RowState & DataControlRowState.Edit) > 0)
        {
            DropDownList ddl = (DropDownList)e.Row.FindControl("ddl_phonebook_cate");
            HiddenField lbl = (HiddenField)e.Row.FindControl("hfcategory_");
            ddl.SelectedValue = lbl.Value;
        }

}

private void send_sms_direct(string numbers, string sms)
    {
        if (txtmobile_direct.Text == string.Empty)
        {
            Response.Write("Please Enter Numbers");
            return;
        }

if (txtmessage_direct.Text == string.Empty)
        {
            Response.Write("Please Enter Your Message");
            return;
        }

string authKey = "70740A9HJVjbP53e5cee9";
        string mobileNumber = numbers;
        string senderId = "NBCHOS";
        string message = HttpUtility.UrlEncode(sms);
        StringBuilder sbPostData = new StringBuilder();
        sbPostData.AppendFormat("authkey={0}", authKey);
        sbPostData.AppendFormat("&mobiles={0}", mobileNumber);
        sbPostData.AppendFormat("&message={0}", message);
        sbPostData.AppendFormat("&sender={0}", senderId);
        sbPostData.AppendFormat("&route={0}", "4");

try
        {
            string sendSMSUri = "https://control.msg91.com/sendhttp.php";
            HttpWebRequest httpWReq = (HttpWebRequest)WebRequest.Create(sendSMSUri);
            UTF8Encoding encoding = new UTF8Encoding();
            byte[] data = encoding.GetBytes(sbPostData.ToString());
            httpWReq.Method = "POST";
            httpWReq.ContentType = "application/x-www-form-urlencoded";
            httpWReq.ContentLength = data.Length;
            using (Stream stream = httpWReq.GetRequestStream())
            {
                stream.Write(data, 0, data.Length);
            }
            HttpWebResponse response = (HttpWebResponse)httpWReq.GetResponse();
            StreamReader reader = new StreamReader(response.GetResponseStream());
            string responseString = reader.ReadToEnd();
            reader.Close();
            response.Close();
        }
        catch (SystemException ex)
        {
            Response.Write(ex.Message.ToString());
        }

}

private void send_bulk_sms(string numbers, string sms)
    {
        string authKey = "70740A9HJVjbP53e5cee9";
        string mobileNumber = numbers;
        string senderId = "NBCHOS";
        string message = HttpUtility.UrlEncode(sms);
        StringBuilder sbPostData = new StringBuilder();
        sbPostData.AppendFormat("authkey={0}", authKey);
        sbPostData.AppendFormat("&mobiles={0}", mobileNumber);
        sbPostData.AppendFormat("&message={0}", message);
        sbPostData.AppendFormat("&sender={0}", senderId);
        sbPostData.AppendFormat("&route={0}", "4");

protected void btnsend_direct_Click(object sender, EventArgs e)
    {
        int count_no_ = 0;
        string numbers = txtmobile_direct.Text;
        string[] number=numbers.Split(' ');
        foreach (string split in number)
        {
            send_sms_direct(split.ToString(),txtmessage_direct.Text);
            count_no_++;
        }

Response.Write("<script>alert(' You send "+count_no_+ " sms Successfully! ')</script>");
        ddloption.SelectedIndex = 2;
        pnldirect.Visible = true;
        txtmessage_direct.Text = "";
        txtmobile_direct.Text = "";
    }
    
    protected void grdcategory_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {

grdcategory.PageIndex = e.NewPageIndex;
        bindcategory_gridviw();
       
    }
    protected void grdcategory_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        
        grdcategory.EditIndex = -1;
        bindcategory_gridviw();
        grdcategory.Columns[3].Visible = true;
      
        
    }
    protected void grdcategory_RowEditing(object sender, GridViewEditEventArgs e)
    {
        grdcategory.EditIndex = e.NewEditIndex;
        bindcategory_gridviw();
        grdcategory.Columns[3].Visible = false;

//Label cat = (Label)grdcategory.Rows[e.NewEditIndex].FindControl("lblcategory_Grid");

//if (cat.Text == "-----All Category-----")
        //{

//    Response.Write("<script>alert('You Can't Edit It!')</script>");
        //    txtcategory_new.

//}

//else
        //{
            
        //}

}

protected void grdcategory_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        HiddenField hfid_category = (HiddenField)grdcategory.Rows[e.RowIndex].FindControl("hfid_category");
        TextBox txtcategory_gridview = (TextBox)grdcategory.Rows[e.RowIndex].FindControl("txtcategory_gridview");

string text = txtcategory_gridview.Text;
        string capital = text.ToUpper();

if (con.State == ConnectionState.Closed)
        {
            con.Open();
            string query = "sms_doctor_pro";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@id", hfid_category.Value);
            cmd.Parameters.AddWithValue("@category_cat", capital.Trim());
            cmd.Parameters.AddWithValue("@option", "Update_category".Trim());
            cmd.ExecuteNonQuery().ToString();
            con.Close();           
            Response.Write("<script>alert('Update Record Successfully! ')</script>");
            grdcategory.EditIndex = -1;
            bindcategory_gridviw();
            grdcategory.Columns[3].Visible = true;

}

}
    protected void grdcategory_PageIndexChanging1(object sender, GridViewPageEventArgs e)
    {
        grdcategory.PageIndex = e.NewPageIndex;
        bindcategory_gridviw();
    }
 
    protected void grdcategory_RowDeleting(object sender, GridViewDeleteEventArgs e)
    { 
             HiddenField hfid_category_item = (HiddenField)grdcategory.Rows[e.RowIndex].FindControl("hfid_category_item");
             
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
                string query = "sms_doctor_pro";
                SqlCommand cmd = new SqlCommand(query, con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@id", hfid_category_item.Value);
                cmd.Parameters.AddWithValue("@option", "Delete_category".Trim());
                cmd.ExecuteNonQuery().ToString();
                con.Close();
                Response.Write("<script>alert('Delete Record Successfully! ')</script>");
                bindcategory_gridviw();

}
       
    }
  
    protected void grdquery_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {       
            TextBox name = (TextBox)grdquery.Rows[e.RowIndex].FindControl("txtname_grid_");
            TextBox mobile = (TextBox)grdquery.Rows[e.RowIndex].FindControl("txtmobile_no_grid");
            DropDownList category = (DropDownList)grdquery.Rows[e.RowIndex].FindControl("ddl_phonebook_cate");
            HiddenField id = (HiddenField)grdquery.Rows[e.RowIndex].FindControl("hfid_grdquery_edit");
            
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
                string query = "sms_doctor_pro";
                SqlCommand cmd = new SqlCommand(query, con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@id", id.Value);
                cmd.Parameters.AddWithValue("@name", name.Text.Trim());
                cmd.Parameters.AddWithValue("@contact_number", mobile.Text.Trim());
                cmd.Parameters.AddWithValue("@catagory", category.SelectedValue);
                cmd.Parameters.AddWithValue("option", "Update".Trim());
                cmd.ExecuteNonQuery();
                con.Close();
                Response.Write("<script>alert('Update Record Successfully! ')</script>");

if (ddlcategory.SelectedItem.Text == "-----All Category-----")
                {
                    grdquery.EditIndex = -1;
                    bindgrid();

}

else
                {
                    grdquery.EditIndex = -1;
                    bind_with_selectedindexchange();
                }
              
            }

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

int delet_no = 0;   
             foreach (GridViewRow row in grdquery.Rows)
             {
            
                     CheckBox chk = (CheckBox)row.FindControl("chkselect");
                     if (chk.Checked == true)
                     {                     
                         if (con.State == ConnectionState.Closed)
                         {
                             HiddenField hf = (HiddenField)row.FindControl("hfid_grdquery_item");
                             con.Open();
                             string query = "sms_doctor_pro";
                             SqlCommand cmd = new SqlCommand(query, con);
                             cmd.CommandType = CommandType.StoredProcedure;
                             cmd.Parameters.AddWithValue("@id", hf.Value);
                             cmd.Parameters.AddWithValue("@option", "Delete".Trim());
                             cmd.ExecuteNonQuery().ToString();
                             con.Close();
                             bindgrid();
                             delet_no++;

}
                     }
             }
            Response.Write("<script>alert('" + delet_no + " Record Delete Successfully! ')</script>");
            pnl_send_from_phonebook.Visible = true;
            ddloption.SelectedIndex = 1;
    }
    protected void btnreset_Click(object sender, EventArgs e)
    {
        txtMessage.Text = "";
       // Response.Redirect("~/admin/Sms_send.aspx");
    }

protected void ddlcategory_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
            string query = "sms_doctor_pro";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("option", "bind_Grid_selected_indexchange".Trim());
            cmd.Parameters.AddWithValue("@Id", ddlcategory.SelectedValue);
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            grdquery.DataSource = dt;
            grdquery.DataBind();
            con.Close();
            if (dt.Rows.Count == 0)
            {
                lblmessage_grd.Text = "Have No Record Found in "+ddlcategory.SelectedItem.Text+" category ";
            }
            else
            {
                lblmessage_grd.Text = "";

}

if (ddlcategory.SelectedItem.Text == "-----All Category-----")
            {
                bindgrid();
                lblmessage_grd.Text = "";
            }
        }
    }
    protected void btnSend_phonebook_Click(object sender, EventArgs e)
    {
        int msgcount = 0;
        foreach (GridViewRow row in grdquery.Rows)
        {

CheckBox chk = (CheckBox)row.FindControl("chkselect");
            if (chk.Checked == true)
            {
                if (con.State == ConnectionState.Closed)
                {
                    Label mobile = (Label)row.FindControl("lblcontact_");
                    send_bulk_sms(mobile.Text, txtMessage.Text);
                    msgcount++;
                }
            }
        }

Response.Write("<script>alert('"+msgcount+" Messagge Sent Successfully! ')</script>");
        txtMessage.Text = "";
    }
    protected void grdcategory_PageIndexChanging2(object sender, GridViewPageEventArgs e)
    {
        grdcategory.PageIndex = e.NewPageIndex;
        bindcategory_gridviw();
    }
    protected void grdadd_phonebook_RowDataBound(object sender, GridViewRowEventArgs e)
    {
       
    }
    protected void grdquery_DataBound(object sender, EventArgs e)
    {

//foreach (GridViewRow gr in grdquery.Rows)
        //{
        //    CheckBox all = (CheckBox)gr.FindControl("CheckAll");
        //    CheckBox particular = (CheckBox)gr.FindControl("chkselect");
        //    if (all.Checked == true)
        //    {
        //        particular.Checked = true;
        //    }

//}

//foreach (GridViewRow gr in grdquery.Rows)
        //{

//    DropDownList ddl = (DropDownList)gr.FindControl("ddl_phonebook_cate");
        //    string query = "sms_doctor_pro";
        //    SqlCommand cmd = new SqlCommand(query, con);
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    cmd.Parameters.AddWithValue("option", "bind_ddl_category".Trim());
        //    DataTable dt = new DataTable();
        //    SqlDataAdapter da = new SqlDataAdapter(cmd);
        //    da.Fill(dt);
        //    ddl.DataSource = dt;
        //    ddl.DataValueField = "Id";
        //    ddl.DataTextField = "category_";
        //    ddl.DataBind();
        //    con.Close();
        //}
    }

protected void grdcategory_RowDataBound(object sender, GridViewRowEventArgs e)
    {
       
        //if (e.Row.RowType==DataControlRowType.DataRow)
        //{
        //    Label ddl = (Label)e.Row.FindControl("lblcategory_Grid");
        //    Button delete = (Button)e.Row.FindControl("btndeleter_grid_category");
        //    Button edit = (Button)e.Row.FindControl("btnedit");
        //    if (ddl.Text == "-----All Category-----")
        //    {

//        delete.Visible = false;
        //        edit.Enabled = false;

//    }
        //}

//foreach (GridViewRow gr in grdcategory.Rows)
        //{
        //    Button delete = (Button)gr.FindControl("btndeleter_grid_category");
        //    Button edit = (Button)gr.FindControl("btnedit");
        //    if (grdcategory.Rows.Count == 1)
        //    {
        //        delete.Enabled = false;
        //        edit.Enabled = false;
        //    }
        //}

}
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2021-04-16 10:30:53
..	dir	-	0/0	0777	2023-11-26 01:13:11
css	dir	-	0/0	0777	2021-04-16 10:30:53
imges	dir	-	0/0	0777	2021-04-16 10:30:53
Default.aspx	text/html	3.03 KB	0/0	0666	2016-07-30 05:11:43
Default.aspx.cs	text/html	1.91 KB	0/0	0666	2016-07-30 05:11:43
Default2.aspx	text/html	2.07 KB	0/0	0666	2016-07-30 05:11:44
Default2.aspx.cs	text/plain	1.31 KB	0/0	0666	2016-07-30 05:11:44
MasterPage.master	text/html	2.68 KB	0/0	0666	2016-07-30 05:11:51
MasterPage.master.cs	text/plain	699 B	0/0	0666	2016-07-30 05:11:51
Sms_send.aspx	text/html	17.12 KB	0/0	0666	2016-07-30 05:11:55
Sms_send.aspx.cs	text/plain	30.64 KB	0/0	0666	2016-07-30 05:11:56
_facilities.aspx	text/html	5.62 KB	0/0	0666	2016-07-30 05:11:57
_facilities.aspx.cs	text/html	8.51 KB	0/0	0666	2016-07-30 05:11:57
advice.aspx	text/plain	2.51 KB	0/0	0666	2016-07-30 05:11:38
advice.aspx.cs	text/plain	3.68 KB	0/0	0666	2016-07-30 05:11:39
appoinment.aspx	text/plain	7.94 KB	0/0	0666	2016-07-30 05:11:39
appoinment.aspx.cs	text/html	5.68 KB	0/0	0666	2016-07-30 05:11:40
change_pass.aspx	text/html	3.15 KB	0/0	0666	2016-07-30 05:11:42
change_pass.aspx.cs	text/html	2.47 KB	0/0	0666	2016-07-30 05:11:42
changepassword.aspx	text/plain	2.25 KB	0/0	0666	2016-07-30 05:11:40
changepassword.aspx.cs	text/plain	1.71 KB	0/0	0666	2016-07-30 05:11:41
facilities.aspx	text/html	7.81 KB	0/0	0666	2016-07-30 05:11:46
facilities.aspx.cs	text/html	10.48 KB	0/0	0666	2016-07-30 05:11:46
gallery.aspx	text/html	4.7 KB	0/0	0666	2016-07-30 05:11:47
gallery.aspx.cs	text/html	6.63 KB	0/0	0666	2016-07-30 05:11:48
home.aspx	text/plain	545 B	0/0	0666	2016-07-30 05:11:48
home.aspx.cs	text/plain	515 B	0/0	0666	2016-07-30 05:11:49
mail_sending_admin.aspx	text/html	6.56 KB	0/0	0666	2016-07-30 05:11:50
mail_sending_admin.aspx.cs	text/html	5.9 KB	0/0	0666	2016-07-30 05:11:50
sms.aspx	text/html	12.48 KB	0/0	0666	2016-07-30 05:11:53
sms.aspx.cs	text/plain	18.07 KB	0/0	0666	2016-07-30 05:11:53

Team Anon Force

https://t.me/Professor6T9x