public int getSpouseID()
{
int ID;
LoanDSTableAdapters.GetSpouseTableAdapter spouse = new LoanDSTableAdapters.GetSpouseTableAdapter();
LoanDS.GetSpouseDataTable tblSpouse = spouse.GetSpouse(MySessionManager.AppID, MySessionManager.ClientID);
if (tblSpouse.Rows.Count > 0)
{
ID = int.Parse(tblSpouse[0].datID.ToString());
}
else
{
ID = 0;
}
return(ID);
}
public void loadSpouseDetails()
{
LoanDSTableAdapters.GetSpouseTableAdapter spouse = new LoanDSTableAdapters.GetSpouseTableAdapter();
LoanDS.GetSpouseDataTable tblSpouse = spouse.GetSpouse(MySessionManager.AppID, MySessionManager.ClientID);
if (tblSpouse.Rows.Count > 0)
{
txtContactPersion.Value = tblSpouse[0].datContactPerson.ToString();
txtDateMarried.Text = tblSpouse[0].datDateMarried.ToString("dd-MM-yyyy");
txtNameOfDependents.Value = tblSpouse[0].datNumberOfDependents.ToString();
txtEmpNo.Value = tblSpouse[0].datEmployeeNumber.ToString();
txtFullName.Value = tblSpouse[0].datFullName.ToString();
txtMonthly.Value = tblSpouse[0].datMonthlyIncome.ToString();
txtPhysicalAddress.Value = tblSpouse[0].datEmployerAddress.ToString();
txtidNo.Value = tblSpouse[0].datIdentificationNumber.ToString();
//ddlNo1.SelectedIndex = ddlNo1.Items.IndexOf(ddlNo1.Items.FindByText(tblSpouse[0].idtype.ToString()));
telno.Value = tblSpouse[0].datTelephoneNumber.ToString();
txtPosition.Value = tblSpouse[0].datPosition.ToString();
}
}