public void loadData() { LoanDSTableAdapters.CheckListItemsTableAdapter CheckListItem = new LoanDSTableAdapters.CheckListItemsTableAdapter(); LoanDS.CheckListItemsDataTable tblCheckLstVal = CheckListItem.GetCheckListItems(MySessionManager.AppID, MySessionManager.ClientID); foreach (LoanDS.CheckListItemsRow ch in tblCheckLstVal) { string text; try { if (ch.datAnswer.ToString().Length > 0) { text = ch.datComment.ToString(); TextBox txtcomment = (TextBox)this.FindControl("txtComment" + ch.datQuestion.ToString()); try { txtcomment.Text = text; } catch (Exception ex) { } DropDownList ddl = (DropDownList)this.FindControl("cmb" + ch.datQuestion.ToString()); try { ddl.SelectedIndex = ddl.Items.IndexOf(ddl.Items.FindByValue(ch.datAnswer.ToString())); } catch (Exception ex) { } } } catch (Exception ex) { } } this.editskip.Value = "2"; }
protected void btnSaveCheckList_Click(object sender, EventArgs e) { mainDSTableAdapters.CheckListItemsTableAdapter chklstItem = new mainDSTableAdapters.CheckListItemsTableAdapter(); mainDS.CheckListItemsDataTable tblChklstItem = chklstItem.GetAllCheckListItems(); LoanDSTableAdapters.CheckListItemsTableAdapter chkLst = new LoanDSTableAdapters.CheckListItemsTableAdapter(); chkLst.DeleteCheckListItem(MySessionManager.AppID, MySessionManager.ClientID); if (tblChklstItem.Rows.Count > 0) { int i = 0; foreach (mainDS.CheckListItemsRow c in tblChklstItem) { int? answer = null; int? question = null; string comment = ""; string ddlname = "cmb" + c.datID.ToString(); DropDownList ddl = (DropDownList)this.FindControl(ddlname); try { answer = Convert.ToInt32(ddl.SelectedValue); } catch (Exception ex) { } string txtname = "txtComment" + c.datID.ToString(); TextBox txt3 = (TextBox)this.FindControl(txtname); try { comment = txt3.Text; } catch (Exception ex) { } string labelname = "label" + c.datID.ToString(); Label mylabel1 = (Label)this.FindControl(labelname); try { question = c.datID; } catch (Exception ex) { } if (answer > 0 && question > 0) { chkLst.InsertCheckListItems(MySessionManager.ClientID, MySessionManager.AppID, question, answer, comment); } i++; } } }
public void loadData() { LoanDSTableAdapters.CheckListItemsTableAdapter CheckListItem = new LoanDSTableAdapters.CheckListItemsTableAdapter(); LoanDS.CheckListItemsDataTable tblCheckLstVal = CheckListItem.GetCheckListItems(MySessionManager.AppID, MySessionManager.ClientID); foreach (LoanDS.CheckListItemsRow ch in tblCheckLstVal) { string text; try { if (ch.datAnswer.ToString().Length > 0) { text = ch.datComment.ToString(); TextBox txtcomment = (TextBox)this.FindControl("txtComment" + ch.datQuestion.ToString()); try { txtcomment.Text = text; } catch (Exception ex) { } DropDownList ddl = (DropDownList)this.FindControl("cmb" + ch.datQuestion.ToString()); try { ddl.SelectedIndex = ddl.Items.IndexOf(ddl.Items.FindByValue(ch.datAnswer.ToString())); } catch (Exception ex) { } } } catch (Exception ex) { } } this.editskip.Value = "2"; }
protected void btnSaveCheckList_Click(object sender, EventArgs e) { mainDSTableAdapters.CheckListItemsTableAdapter chklstItem = new mainDSTableAdapters.CheckListItemsTableAdapter(); mainDS.CheckListItemsDataTable tblChklstItem = chklstItem.GetAllCheckListItems(); LoanDSTableAdapters.CheckListItemsTableAdapter chkLst = new LoanDSTableAdapters.CheckListItemsTableAdapter(); chkLst.DeleteCheckListItem(MySessionManager.AppID, MySessionManager.ClientID); if (tblChklstItem.Rows.Count > 0) { int i = 0; foreach(mainDS.CheckListItemsRow c in tblChklstItem ) { int? answer = null; int? question = null; string comment = ""; string ddlname = "cmb" + c.datID.ToString(); DropDownList ddl = (DropDownList)this.FindControl(ddlname); try { answer = Convert.ToInt32(ddl.SelectedValue); } catch (Exception ex) { } string txtname = "txtComment" + c.datID.ToString(); TextBox txt3 = (TextBox)this.FindControl(txtname); try { comment = txt3.Text; } catch (Exception ex) { } string labelname = "label" + c.datID.ToString(); Label mylabel1 = (Label)this.FindControl(labelname); try { question = c.datID; } catch (Exception ex) { } if (answer > 0 && question > 0) { chkLst.InsertCheckListItems(MySessionManager.ClientID, MySessionManager.AppID, question, answer, comment); } i++; } } }