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( }
protected void rptSections_ItemDataBound(object sender, RepeaterItemEventArgs e) { int sectionId = int.Parse(((HiddenField)e.Item.FindControl("hfSectionId")).Value); int deptId = int.Parse(Request[WebConstants.Request.DEPT_ID]); int docId = int.Parse(Request[WebConstants.Request.DOC_ID]); DocumentTemplate.DocumentSectionEntityRow section = DatabaseUtility.GetSection(loggedInUserCoId, deptId, sectionId); if (section != null) { if (section.section_type == WebConstants.SectionTypes.FREE_TEXT) { TextBox tbItem = (TextBox)e.Item.FindControl("tbItem"); DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter itemTA = new DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter(); IEnumerator ie = itemTA.GetBySecId(loggedInUserId, deptId, docId, sectionId).GetEnumerator(); while (ie.MoveNext()) { DocumentTemplate.DocumentItemEntityRow itemRow = (DocumentTemplate.DocumentItemEntityRow)ie.Current; tbItem.Text += itemRow.item_name; } } else if (section.section_type == WebConstants.SectionTypes.MULTIPLE_SELECT_LIST) { CheckBoxList cbItem = (CheckBoxList)e.Item.FindControl("cbItem"); DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter itemTA = new DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter(); DataTable itemsDT = itemTA.GetBySecId(loggedInUserId, deptId, docId, sectionId); foreach (ListItem li in cbItem.Items) { foreach (DataRow row in itemsDT.Rows) { if (li.Value == row["section_detail_id"].ToString()) { li.Selected = true; break; } } } } } }
private void SetSectionData(DocumentType docType) { DocumentTemplateTableAdapters.DocumentSectionTableAdapter sectionTA = new DocumentTemplateTableAdapters.DocumentSectionTableAdapter(); DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter itemTA = new DocumentTemplateTableAdapters.DocumentItemEntityTableAdapter(); DocumentTemplateTableAdapters.DocumentSectionDetailsTableAdapter secDetailTA = new DocumentTemplateTableAdapters.DocumentSectionDetailsTableAdapter(); IEnumerator ieSection = sectionTA.GetByDocType(docType.CoId, docType.DeptId, docType.Id).GetEnumerator(); while (ieSection.MoveNext()) { DocumentTemplate.DocumentSectionEntityRow sectionDataRow = (DocumentTemplate.DocumentSectionEntityRow)ieSection.Current; Section section = new Section(); section.Heading = sectionDataRow.section_desc; section.Type = sectionDataRow.section_type; section.SectionId = sectionDataRow.section_id; if (sectionDataRow.Isrepeat_columnsNull() == false) { section.RepeatColumns = sectionDataRow.repeat_columns; } DataTable dtItems = itemTA.GetBySecId(docType.CoId, docType.DeptId, docType.DocId, section.SectionId); if (section.Type == WebConstants.SectionTypes.MULTIPLE_SELECT_LIST) { IEnumerator ieSecDetail = secDetailTA.GetBySecId(docType.CoId, docType.DeptId, section.SectionId).GetEnumerator(); while (ieSecDetail.MoveNext()) { DocumentTemplate.DocumentSectionDetailsEntityRow secDetailDataRow = (DocumentTemplate.DocumentSectionDetailsEntityRow)ieSecDetail.Current; SectionDetail sectionDetail = new SectionDetail(secDetailDataRow.section_detail_id, secDetailDataRow.section_detail_desc, false); foreach (DataRow itemRow in dtItems.Rows) { if (secDetailDataRow.section_detail_id == (int)itemRow["section_detail_id"]) { sectionDetail.Selected = true; break; } } section.Details.Add(sectionDetail); } } if (section.Type == WebConstants.SectionTypes.FREE_TEXT) { foreach(DataRow itemRow in dtItems.Rows) { section.Text += (string)itemRow["item_name"] + "\n"; } } sectionList.Add(section); } }