protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime dt = DateTime.Parse(txtDateMarried.Text, ukCulture.DateTimeFormat);
LoanDSTableAdapters.GetSpouseTableAdapter spouse = new LoanDSTableAdapters.GetSpouseTableAdapter();
int ID = getSpouseID();
if (ID > 0)
{
spouse.UpdateSpouse(txtFullName.Value.Trim(),
telno.Value.Trim(),
Convert.ToInt32(ddlNo1.SelectedValue),
txtidNo.Value.Trim(),
Convert.ToInt32(txtNameOfDependents.Value.Trim()),
dt,
txtNameOfEmployer.Value.Trim(),
txtTelNo.Value.Trim(),
txtPhysicalAddress.Value.Trim(),
txtIndustry.Value.Trim(),
txtEmpNo.Value.Trim(),
txtPosition.Value.Trim(),
txtContactPersion.Value.Trim(),
Convert.ToDecimal(txtMonthly.Value.Trim()),
ID);
this.editskip.Value = "1";
}
else
{
spouse.InsertSpouse(MySessionManager.AppID,
MySessionManager.ClientID,
txtFullName.Value.Trim(),
telno.Value.Trim(),
Convert.ToInt32(ddlNo1.SelectedValue),
txtidNo.Value.Trim(),
Convert.ToInt32(txtNameOfDependents.Value.Trim()),
dt,
txtNameOfEmployer.Value.Trim(),
txtTelNo.Value.Trim(),
txtPhysicalAddress.Value,
txtIndustry.Value.Trim(),
txtEmpNo.Value.Trim(),
txtPosition.Value.Trim(),
txtContactPersion.Value.Trim(),
Convert.ToDecimal(txtMonthly.Value.Trim())
);
this.editskip.Value = "1";
}
}
catch (Exception ex) { }
}
}
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();
}
}
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();
}
}
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;
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime dt = DateTime.Parse(txtDateMarried.Text, ukCulture.DateTimeFormat);
LoanDSTableAdapters.GetSpouseTableAdapter spouse = new LoanDSTableAdapters.GetSpouseTableAdapter();
int ID = getSpouseID();
if (ID > 0)
{
spouse.UpdateSpouse(txtFullName.Value.Trim(),
telno.Value.Trim(),
Convert.ToInt32(ddlNo1.SelectedValue),
txtidNo.Value.Trim(),
Convert.ToInt32(txtNameOfDependents.Value.Trim()),
dt,
txtNameOfEmployer.Value.Trim(),
txtTelNo.Value.Trim(),
txtPhysicalAddress.Value.Trim(),
txtIndustry.Value.Trim(),
txtEmpNo.Value.Trim(),
txtPosition.Value.Trim(),
txtContactPersion.Value.Trim(),
Convert.ToDecimal(txtMonthly.Value.Trim()),
ID);
this.editskip.Value = "1";
}
else
{
spouse.InsertSpouse(MySessionManager.AppID,
MySessionManager.ClientID,
txtFullName.Value.Trim(),
telno.Value.Trim(),
Convert.ToInt32(ddlNo1.SelectedValue),
txtidNo.Value.Trim(),
Convert.ToInt32(txtNameOfDependents.Value.Trim()),
dt,
txtNameOfEmployer.Value.Trim(),
txtTelNo.Value.Trim(),
txtPhysicalAddress.Value,
txtIndustry.Value.Trim(),
txtEmpNo.Value.Trim(),
txtPosition.Value.Trim(),
txtContactPersion.Value.Trim(),
Convert.ToDecimal(txtMonthly.Value.Trim())
);
this.editskip.Value = "1";
}
}
catch (Exception ex) { }
}
}
