public void loadGuarantor(int id)
{
LoanDSTableAdapters.GuarantorTableAdapter guarantor = new LoanDSTableAdapters.GuarantorTableAdapter();
LoanDS.GuarantorDataTable tblguarantor = guarantor.GetGuarantorDetails(id);
if (tblguarantor.Rows.Count > 0)
{
txtBirthdate.Text = tblguarantor[0].datDateOfBirth.ToShortDateString();
txtEmail.Text = tblguarantor[0].datEmailAddress.ToString();
txtfullname.Text = tblguarantor[0].datFullName.ToString();
txtHomeTelNo.Text = tblguarantor[0].datHomeTelephoneNumber.ToString();
txtMobile.Text = tblguarantor[0].datMobileNumber.ToString();
txtOfficeAddress.Value = tblguarantor[0].datOfficeAddress.ToString();
txtRelationship.Text = tblguarantor[0].datRelationship.ToString();
txtYrsAcquainted.Text = tblguarantor[0].datNumberOfYears.ToString();
txtOfficeTelNo.Text = tblguarantor[0].datOfficeTelephoneNUmber.ToString();
txtHomeAddress.Value = tblguarantor[0].datResidentialAddress.ToString();
try{
if (tblguarantor[0].datGORR > 0)
{
ddlGORR.SelectedValue = tblguarantor[0].datGORR.ToString();
}
if (tblguarantor[0].datNationalityID > 0)
{
ddlNationality.SelectedValue = tblguarantor[0].datNationalityID.ToString();
}
}catch (Exception ex) {}
this.editskip.Value = "2";
}
}
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 bDate = DateTime.Parse(txtBirthdate.Text, ukCulture.DateTimeFormat);
LoanDSTableAdapters.GuarantorTableAdapter guarantor = new LoanDSTableAdapters.GuarantorTableAdapter();
if (!(type == "update"))
{
guarantor.InsertGuarantor(MySessionManager.ClientID,
MySessionManager.AppID,
Convert.ToInt32(ddlGORR.Text),
txtfullname.Text,
txtRelationship.Text,
Convert.ToInt32(txtYrsAcquainted.Text),
Convert.ToInt32(ddlNationality.Text),
bDate,
txtMobile.Text,
txtHomeTelNo.Text,
txtOfficeTelNo.Text,
txtEmail.Text,
txtHomeAddress.Value.Trim(),
txtOfficeAddress.Value.Trim(),
MySessionManager.CurrentUser.UserID);
}
else if (type == "update")
{
guarantor.UpdateGuarantor(Convert.ToInt32(ddlGORR.Text),
txtfullname.Text,
txtRelationship.Text,
Convert.ToInt32(txtYrsAcquainted.Text),
Convert.ToInt32(ddlNationality.Text),
bDate,
txtMobile.Text,
txtHomeTelNo.Text,
txtOfficeTelNo.Text,
txtEmail.Text,
txtHomeAddress.Value.Trim(),
txtOfficeAddress.Value.Trim(),
id);
}
Utility util = new Utility();
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "gedit"));
}
catch (Exception ex) { }
}
}
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 bDate = DateTime.Parse(txtBirthdate.Text, ukCulture.DateTimeFormat);
LoanDSTableAdapters.GuarantorTableAdapter guarantor = new LoanDSTableAdapters.GuarantorTableAdapter();
if (!(type == "update"))
{
guarantor.InsertGuarantor(MySessionManager.ClientID,
MySessionManager.AppID,
Convert.ToInt32(ddlGORR.Text),
txtfullname.Text,
txtRelationship.Text,
Convert.ToInt32(txtYrsAcquainted.Text),
Convert.ToInt32(ddlNationality.Text),
bDate,
txtMobile.Text,
txtHomeTelNo.Text,
txtOfficeTelNo.Text,
txtEmail.Text,
txtHomeAddress.Value.Trim(),
txtOfficeAddress.Value.Trim(),
MySessionManager.CurrentUser.UserID);
}
else if (type == "update")
{
guarantor.UpdateGuarantor(Convert.ToInt32(ddlGORR.Text),
txtfullname.Text,
txtRelationship.Text,
Convert.ToInt32(txtYrsAcquainted.Text),
Convert.ToInt32(ddlNationality.Text),
bDate,
txtMobile.Text,
txtHomeTelNo.Text,
txtOfficeTelNo.Text,
txtEmail.Text,
txtHomeAddress.Value.Trim(),
txtOfficeAddress.Value.Trim(),
id);
}
Utility util = new Utility();
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "gedit"));
}
catch (Exception ex) { }
}
}
public void loadGuarantor(int id)
{
LoanDSTableAdapters.GuarantorTableAdapter guarantor = new LoanDSTableAdapters.GuarantorTableAdapter();
LoanDS.GuarantorDataTable tblguarantor = guarantor.GetGuarantorDetails (id);
if (tblguarantor.Rows.Count > 0)
{
txtBirthdate.Text = tblguarantor[0].datDateOfBirth.ToShortDateString();
txtEmail.Text = tblguarantor[0].datEmailAddress.ToString();
txtfullname.Text = tblguarantor[0].datFullName.ToString();
txtHomeTelNo .Text =tblguarantor[0].datHomeTelephoneNumber.ToString();
txtMobile.Text = tblguarantor[0].datMobileNumber.ToString();
txtOfficeAddress.Value = tblguarantor[0].datOfficeAddress.ToString();
txtRelationship.Text = tblguarantor[0].datRelationship.ToString();
txtYrsAcquainted.Text =tblguarantor[0].datNumberOfYears.ToString();
txtOfficeTelNo .Text =tblguarantor[0].datOfficeTelephoneNUmber .ToString();
txtHomeAddress.Value = tblguarantor[0].datResidentialAddress.ToString();
try{
if (tblguarantor[0].datGORR > 0) { ddlGORR.SelectedValue = tblguarantor[0].datGORR.ToString(); }
if (tblguarantor[0].datNationalityID > 0) { ddlNationality.SelectedValue = tblguarantor[0].datNationalityID.ToString(); }
}catch(Exception ex){}
this.editskip.Value = "2";
}
}
