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++;
}
}
}
