private void BindGrid()
        {
            List <CPT_RegionMaster> lstRegion = new List <CPT_RegionMaster>();
            RegionMasterBL          clsRegion = new RegionMasterBL();

            lstRegion = clsRegion.getRegion();

            gvRegion.DataSource = lstRegion;
            gvRegion.DataBind();
        }
        protected void delete(object sender, GridViewDeleteEventArgs e)
        {
            CPT_RegionMaster Regiondetails = new CPT_RegionMaster();
            int id = int.Parse(gvRegion.DataKeys[e.RowIndex].Value.ToString());

            Regiondetails.RegionMasterID = id;

            RegionMasterBL deleteRegion = new RegionMasterBL();

            deleteRegion.Delete(Regiondetails);
            BindGrid();
        }
        protected void SaveRegionButton(object sender, EventArgs e)
        {
            try
            {
                CPT_RegionMaster Regiondetails = new CPT_RegionMaster();
                Regiondetails.RegionName = RegionInput.Text;
                Regiondetails.IsActive   = true;

                RegionMasterBL insertRegion = new RegionMasterBL();
                insertRegion.Insert(Regiondetails);
                BindGrid();
                CleartextBoxes(this);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
 protected void update(object sender, GridViewUpdateEventArgs e)
 {
     try
     {
         CPT_RegionMaster Regiondetails = new CPT_RegionMaster();
         int id = int.Parse(gvRegion.DataKeys[e.RowIndex].Value.ToString());
         Regiondetails.RegionMasterID = id;
         string RegionName = ((TextBox)gvRegion.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
         Regiondetails.RegionName = RegionName;
         RegionMasterBL updateRegion = new RegionMasterBL();
         updateRegion.Update(Regiondetails);
         gvRegion.EditIndex = -1;
         BindGrid();
     }
     catch (Exception ex)
     {
         Console.WriteLine(ex.Message);
     }
 }