protected void btnSave_Click(object sender, EventArgs e)
{
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime dt = DateTime.Parse(txtBirthdate.Value, ukCulture.DateTimeFormat);
InvestmentDSTableAdapters.GetBeneficiariesTableAdapter ben_ = new InvestmentDSTableAdapters.GetBeneficiariesTableAdapter();
if (!(type == "update"))
{
ben_.InsertBeneficiaries(Convert.ToInt32(ddlTitle.SelectedValue),
txtfirstname.Value.Trim(),
txtmiddlename.Value.Trim(),
txtsurname.Value.Trim(),
dt,
txtOccupation.Value,
Convert.ToInt32(ddlNo1.SelectedValue),
txtidNo1.Value,
Convert.ToInt32(txtpercentageshare.Value.Trim()),
txtHomeTel.Value.Trim(),
txtOffTel.Value.Trim(),
txtMobile.Value.Trim(),
txtEmail.Value.Trim(),
txtPostalAddress.Value.Trim(),
txtResAddress.Value.Trim(),
MySessionManager.ClientID,
MySessionManager.InvAppID);
}
else if (type == "update")
{
ben_.UpdateBeneficiaries(Convert.ToInt32(ddlTitle.SelectedValue),
txtfirstname.Value.Trim(),
txtmiddlename.Value.Trim(),
txtsurname.Value.Trim(),
dt,
txtOccupation.Value,
txtidNo1.Value,
Convert.ToInt32(ddlNo1.SelectedValue),
Convert.ToInt32(txtpercentageshare.Value.Trim()),
txtHomeTel.Value.Trim(),
txtOffTel.Value.Trim(),
txtMobile.Value.Trim(),
txtEmail.Value.Trim(),
txtPostalAddress.Value.Trim(),
txtResAddress.Value.Trim(),
id);
}
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "bedit"));
}
protected void btnSave_Click(object sender, EventArgs e)
{
// fetch the en-GB culture
CultureInfo ukCulture = new CultureInfo("en-GB");
// pass the DateTimeFormat information to DateTime.Parse
DateTime dt = DateTime.Parse(txtBirthdate.Value, ukCulture.DateTimeFormat);
InvestmentDSTableAdapters.GetBeneficiariesTableAdapter ben_ = new InvestmentDSTableAdapters.GetBeneficiariesTableAdapter();
if (!(type == "update"))
{
ben_.InsertBeneficiaries(Convert.ToInt32(ddlTitle.SelectedValue),
txtfirstname.Value.Trim(),
txtmiddlename.Value.Trim(),
txtsurname.Value.Trim(),
dt,
txtOccupation.Value,
Convert.ToInt32(ddlNo1.SelectedValue),
txtidNo1.Value,
Convert.ToInt32(txtpercentageshare.Value.Trim()),
txtHomeTel.Value.Trim(),
txtOffTel.Value.Trim(),
txtMobile.Value.Trim(),
txtEmail.Value.Trim(),
txtPostalAddress.Value.Trim(),
txtResAddress.Value.Trim(),
MySessionManager.ClientID,
MySessionManager.InvAppID);
}
else if (type == "update")
{
ben_.UpdateBeneficiaries(Convert.ToInt32(ddlTitle.SelectedValue),
txtfirstname.Value.Trim(),
txtmiddlename.Value.Trim(),
txtsurname.Value.Trim(),
dt,
txtOccupation.Value,
txtidNo1.Value,
Convert.ToInt32(ddlNo1.SelectedValue),
Convert.ToInt32(txtpercentageshare.Value.Trim()),
txtHomeTel.Value.Trim(),
txtOffTel.Value.Trim(),
txtMobile.Value.Trim(),
txtEmail.Value.Trim(),
txtPostalAddress.Value.Trim(),
txtResAddress.Value.Trim(),
id);
}
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "bedit"));
}
public void loadPersonalInformation(int id)
{
try
{
InvestmentDSTableAdapters.GetBeneficiariesTableAdapter Ben_ = new InvestmentDSTableAdapters.GetBeneficiariesTableAdapter();
InvestmentDS.GetBeneficiariesDataTable tblBen_ = Ben_.GetBeneficiariesDetail(id);
if (tblBen_.Rows.Count > 0)
{
this.editskip.Value = "2";
if (tblBen_[0].IsdatTitleNull() == false)
{
ddlTitle.SelectedValue = tblBen_[0].datTitle.ToString();
}
if (tblBen_[0].IsdatFirstnameNull() == false)
{
txtfirstname.Value = tblBen_[0].datFirstname.ToString();
}
if (tblBen_[0].IsdatSurnameNull() == false)
{
txtsurname.Value = tblBen_[0].datSurname.ToString();
}
if (tblBen_[0].IsdatMiddleNameNull() == false)
{
txtmiddlename.Value = tblBen_[0].datMiddleName.ToString();
}
if (tblBen_[0].IsdatIDTypeNull() == false)
{
ddlNo1.SelectedValue = tblBen_[0].datIDType.ToString();
}
if (tblBen_[0].IsdatIDValueNull() == false)
{
txtidNo1.Value = tblBen_[0].datIDValue.ToString();
}
if (tblBen_[0].IsdatDateOfBirthNull() == false)
{
txtBirthdate.Value = Convert.ToDateTime(tblBen_[0].datDateOfBirth.ToString()).ToString("dd-MM-yyyy");
}
if (tblBen_[0].IsdatMobileNumberNull() == false)
{
txtMobile.Value = tblBen_[0].datMobileNumber.ToString();
}
if (tblBen_[0].IsdatEmailAddressNull() == false)
{
txtEmail.Value = tblBen_[0].datEmailAddress.ToString();
}
if (tblBen_[0].IsdatPostalAddressNull() == false)
{
txtPostalAddress.Value = tblBen_[0].datPostalAddress.ToString();
}
if (tblBen_[0].IsdatResidentialAddressNull() == false)
{
txtResAddress.Value = tblBen_[0].datResidentialAddress.ToString();
}
if (tblBen_[0].IsdatTelephoneResNull() == false)
{
txtHomeTel.Value = tblBen_[0].datTelephoneRes.ToString();
}
if (tblBen_[0].IsdatTelephoneOffNull() == false)
{
txtOffTel.Value = tblBen_[0].datTelephoneOff.ToString();
}
if (tblBen_[0].IsdatPercentageShareNull() == false)
{
txtpercentageshare.Value = tblBen_[0].datPercentageShare.ToString();
}
if (tblBen_[0].IsdatOccupationNull() == false)
{
txtOccupation.Value = tblBen_[0].datOccupation.ToString();
}
}
}
catch (Exception ex)
{
}
}
public void loadPersonalInformation(int id)
{
try
{
InvestmentDSTableAdapters.GetBeneficiariesTableAdapter Ben_ = new InvestmentDSTableAdapters.GetBeneficiariesTableAdapter();
InvestmentDS.GetBeneficiariesDataTable tblBen_ = Ben_.GetBeneficiariesDetail(id);
if (tblBen_.Rows.Count > 0)
{
this.editskip.Value = "2";
if (tblBen_[0].IsdatTitleNull() == false) { ddlTitle.SelectedValue = tblBen_[0].datTitle.ToString(); }
if (tblBen_[0].IsdatFirstnameNull() == false) { txtfirstname.Value = tblBen_[0].datFirstname.ToString(); }
if (tblBen_[0].IsdatSurnameNull() == false) { txtsurname.Value = tblBen_[0].datSurname.ToString(); }
if (tblBen_[0].IsdatMiddleNameNull() == false) { txtmiddlename.Value = tblBen_[0].datMiddleName.ToString(); }
if (tblBen_[0].IsdatIDTypeNull() == false) { ddlNo1.SelectedValue = tblBen_[0].datIDType.ToString();}
if (tblBen_[0].IsdatIDValueNull() == false) { txtidNo1.Value = tblBen_[0].datIDValue.ToString(); }
if (tblBen_[0].IsdatDateOfBirthNull() == false) { txtBirthdate.Value = Convert.ToDateTime(tblBen_[0].datDateOfBirth.ToString()).ToString("dd-MM-yyyy"); }
if (tblBen_[0].IsdatMobileNumberNull() == false) { txtMobile.Value = tblBen_[0].datMobileNumber.ToString(); }
if (tblBen_[0].IsdatEmailAddressNull() == false) { txtEmail.Value = tblBen_[0].datEmailAddress.ToString(); }
if (tblBen_[0].IsdatPostalAddressNull() == false) { txtPostalAddress.Value = tblBen_[0].datPostalAddress.ToString(); }
if (tblBen_[0].IsdatResidentialAddressNull() == false) { txtResAddress.Value = tblBen_[0].datResidentialAddress.ToString(); }
if (tblBen_[0].IsdatTelephoneResNull() == false) { txtHomeTel.Value = tblBen_[0].datTelephoneRes.ToString(); }
if (tblBen_[0].IsdatTelephoneOffNull() == false) { txtOffTel.Value = tblBen_[0].datTelephoneOff.ToString(); }
if (tblBen_[0].IsdatPercentageShareNull() == false) { txtpercentageshare.Value = tblBen_[0].datPercentageShare.ToString(); }
if (tblBen_[0].IsdatOccupationNull() == false) { txtOccupation.Value = tblBen_[0].datOccupation.ToString(); }
}
}
catch(Exception ex)
{
}
}
