protected void btnSave_Click(object sender, EventArgs e)
 {
     int deptId = int.Parse(Request[WebConstants.Request.DEPT_ID]);
     int docId = int.Parse(Request[WebConstants.Request.DOC_ID]);
     foreach (RepeaterItem ri in rptSections.Items)
     {
         int sectionId = int.Parse(((HiddenField)ri.FindControl("hfSectionId")).Value);
         DocumentTemplate.DocumentSectionEntityRow section = DatabaseUtility.GetSection(loggedInUserCoId, deptId, sectionId);
         if (section != null)
         {
             DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter itemTA = new DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter();
             itemTA.DeleteBySecId(loggedInUserCoId, deptId, docId, sectionId);
             if (section.section_type == WebConstants.SectionTypes.FREE_TEXT)
             {
                 TextBox tbItem = (TextBox)ri.FindControl("tbItem");
                 itemTA.Insert(loggedInUserCoId, deptId, sectionId, docId, tbItem.Text, 1, null);
             }
             else
             {
                 CheckBoxList cbItem = (CheckBoxList)ri.FindControl("cbItem");
                 for (int i=0; i < cbItem.Items.Count; i++)
                 {
                     if (cbItem.Items[i].Selected)
                     {
                         itemTA.Insert(loggedInUserCoId, deptId, sectionId, docId, "", byte.Parse((i+1).ToString()), int.Parse(cbItem.Items[i].Value));
                     }
                 }
             }
             SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED);
         }
     }
 }
 protected void Button1_Click(object sender, EventArgs e)
 {
     DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter docItemTA = new DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter();
     DocumentTemplateTableAdapters.DocumentSectionDetailsTableAdapter docSectionTA = new DocumentTemplateTableAdapters.DocumentSectionDetailsTableAdapter();
     byte count = 1;
     foreach (ListItem li in CheckBoxList1.Items)
     {
         if (li.Selected)
         {
             DocumentTemplate.DocumentSectionDetailsEntityRow secDetail = DatabaseUtility.GetSectionDetail(int.Parse(lblCoId.Text),
                 int.Parse(lblDeptId.Text),int.Parse(lblSectionId.Text),li.Text);
             if(secDetail != null)
             {
                 docItemTA.Insert(int.Parse(lblCoId.Text), int.Parse(lblDeptId.Text), int.Parse(lblSectionId.Text), int.Parse(lblDocId.Text), li.Text,
                     count, secDetail.section_detail_id);
             }
         }
         count++;
     }
     //DatabaseUtility.GetSectionDetail(
 }