private void BindGrid()
        {
            List <CPT_SkillsMaster> lstSkill = new List <CPT_SkillsMaster>();
            SkillsMasterBL          clsSkill = new SkillsMasterBL();

            lstSkill = clsSkill.getSkill();

            gvSkills.DataSource = lstSkill;
            gvSkills.DataBind();
        }
        protected void delete(object sender, GridViewDeleteEventArgs e)
        {
            CPT_SkillsMaster Skillsdetails = new CPT_SkillsMaster();
            int id = int.Parse(gvSkills.DataKeys[e.RowIndex].Value.ToString());

            Skillsdetails.SkillsMasterID = id;

            SkillsMasterBL deleteSkills = new SkillsMasterBL();

            deleteSkills.Delete(Skillsdetails);
            BindGrid();
        }
        protected void SkillsAddButton_Click(object sender, EventArgs e)
        {
            try
            {
                CPT_SkillsMaster Skillsdetails = new CPT_SkillsMaster();
                Skillsdetails.SkillsName = SkillsNameTextBox.Text.Trim();
                Skillsdetails.IsActive   = true;

                SkillsMasterBL insertSkills = new SkillsMasterBL();
                insertSkills.Insert(Skillsdetails);
                BindGrid();
                CleartextBoxes(this);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
 protected void update(object sender, GridViewUpdateEventArgs e)
 {
     try
     {
         CPT_SkillsMaster Skillsdetails = new CPT_SkillsMaster();
         int id = int.Parse(gvSkills.DataKeys[e.RowIndex].Value.ToString());
         Skillsdetails.SkillsMasterID = id;
         string SkillsName = ((TextBox)gvSkills.Rows[e.RowIndex].Cells[1].Controls[0]).Text.Trim();
         Skillsdetails.SkillsName = SkillsName;
         SkillsMasterBL updateSkills = new SkillsMasterBL();
         updateSkills.Update(Skillsdetails);
         gvSkills.EditIndex = -1;
         BindGrid();
     }
     catch (Exception ex)
     {
         Console.WriteLine(ex.Message);
     }
 }