public void Femaleworker()
        {
            using (dbfirst_databaseEntities context = new dbfirst_databaseEntities())
            {
                var person_intro = context.Introes.Select(a => new
                {
                    ID          = a.ID,
                    FirstName   = a.FirstName,
                    LastName    = a.LastName,
                    Age         = a.Age,
                    Gender      = a.Gender,
                    Email       = a.Email,
                    PhoneNumber = a.PhoneNumber
                }).Where(d => d.Gender == "Female").OrderBy(b => b.FirstName).ThenBy(c => c.LastName);

                if (person_intro != null)
                {
                    GridView_intro.DataSource = person_intro.ToList();
                    GridView_intro.DataBind();
                }
                else
                {
                }
            }
        }
        protected void RadioButtonList11_SelectedIndexChanged(object sender, EventArgs e)
        {
            dbfirst_databaseEntities context = new dbfirst_databaseEntities();

            switch (RadioButtonList11.SelectedValue)
            {
            case "All":
                BindGrid();
                break;

            case "Male":
                Maleworker();
                break;

            case "Female":
                Femaleworker();
                break;
            }
        }
 protected void intro_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "EDT")
     {
         int rowIndex = Convert.ToInt32(e.CommandArgument);
         GridView_intro.SelectedIndex = rowIndex;
         hdnID.Value         = ((HiddenField)GridView_intro.Rows[rowIndex].FindControl("hdnID")).Value;
         txtfname.Text       = ((Label)GridView_intro.Rows[rowIndex].FindControl("lblFirstName")).Text;
         txtlname.Text       = ((Label)GridView_intro.Rows[rowIndex].FindControl("lblLastName")).Text;
         txtage.Text         = ((Label)GridView_intro.Rows[rowIndex].FindControl("lblAge")).Text;
         txtgender.Text      = ((Label)GridView_intro.Rows[rowIndex].FindControl("lblGender")).Text;
         txtemail.Text       = ((Label)GridView_intro.Rows[rowIndex].FindControl("lblEmail")).Text;
         txtphonenumber.Text = ((Label)GridView_intro.Rows[rowIndex].FindControl("lblPhoneNumber")).Text;
     }
     else if (e.CommandName == "DLT")
     {
         int rowIndex = Convert.ToInt32(e.CommandArgument);
         hdnID.Value = ((HiddenField)GridView_intro.Rows[rowIndex].FindControl("hdnID")).Value;
         using (dbfirst_databaseEntities context = new dbfirst_databaseEntities())
         {
             Int64 ID  = Convert.ToInt64(hdnID.Value);
             Intro abc = context.Introes.Where(m => m.ID == ID).SingleOrDefault();
             context.Introes.Remove(abc);
             if (context.SaveChanges() > 0)
             {
                 GridView_intro.SelectedIndex = -1;
                 BindGrid();
                 ClearControls();
                 Page.ClientScript.RegisterStartupScript(this.GetType(), "Deleted", "<script>alert('Deleted successfully.');</script>");
             }
             else
             {
                 Page.ClientScript.RegisterStartupScript(this.GetType(), "Deleted", "<script>alert('Error while deleting.');</script>");
             }
         }
     }
 }
        protected void btnsave_Click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                using (dbfirst_databaseEntities context = new dbfirst_databaseEntities())
                {
                    Intro obj = new Intro();
                    obj.ID          = Convert.ToInt64(hdnID.Value);
                    obj.FirstName   = txtfname.Text.Trim();
                    obj.LastName    = txtlname.Text.Trim();
                    obj.Age         = Convert.ToInt16(txtage.Text.Trim());
                    obj.Gender      = txtgender.Text.Trim();
                    obj.Email       = txtemail.Text.Trim();
                    obj.PhoneNumber = Convert.ToInt64(txtphonenumber.Text.Trim());

                    if (Convert.ToInt64(hdnID.Value) > 0)
                    {
                        context.Introes.Attach(obj);
                        var entry = context.Entry(obj);
                        context.Configuration.ValidateOnSaveEnabled = false;

                        context.Entry(obj).Property(u => u.FirstName).IsModified   = true;
                        context.Entry(obj).Property(u => u.LastName).IsModified    = true;
                        context.Entry(obj).Property(u => u.Age).IsModified         = true;
                        context.Entry(obj).Property(u => u.Gender).IsModified      = true;
                        context.Entry(obj).Property(u => u.Email).IsModified       = true;
                        context.Entry(obj).Property(u => u.PhoneNumber).IsModified = true;

                        if (context.SaveChanges() > 0)
                        {
                            context.Configuration.ValidateOnSaveEnabled = true;
                            GridView_intro.SelectedIndex = -1;
                            BindGrid();
                            ClearControls();
                            Page.ClientScript.RegisterStartupScript(this.GetType(), "Saved", "<script>alert('Updated successfully.');</script>");
                        }
                        else
                        {
                            Page.ClientScript.RegisterStartupScript(this.GetType(), "Saved", "<script>alert('Error while updating.');</script>");
                        }
                    }

                    else
                    {
                        context.Introes.Add(obj);
                        if (context.SaveChanges() > 0)
                        {
                            var intro_ID = obj.ID;
                            GridView_intro.SelectedIndex = -1;
                            BindGrid();
                            ClearControls();
                            Page.ClientScript.RegisterStartupScript(this.GetType(), "Saved", "<script>alert('Saved successfully.');</script>");
                        }
                        else
                        {
                            Page.ClientScript.RegisterStartupScript(this.GetType(), "Saved", "<script>alert('Error while saving.');</script>");
                        }
                    }
                }
            }
        }