public void loadCollateral(int id)
{
LoanDSTableAdapters.CollateralTableAdapter collateral = new LoanDSTableAdapters.CollateralTableAdapter();
LoanDS.CollateralDataTable tblcol = collateral.GetCollateralDetails(id);
if (tblcol.Rows.Count > 0)
{
txtContactPerson.Value = tblcol[0].datContactPerson.ToString();
txtLocation.Value = tblcol[0].datLocation.ToString();
txtDescription.Value = tblcol[0].datDescription;
txtContactTel.Value = tblcol[0].datContactPersonTelephoneNumber.ToString();
txtPhysicalAddress.Value = tblcol[0].datPhysicalAddress.ToString();
txtvalue.Value = tblcol[0].datValue.ToString();
try
{
ddlCollateralType.SelectedValue = tblcol[0].datCollateralTypeID.ToString();
ddlCollateralType.SelectedIndex = ddlCollateralType.Items.IndexOf(ddlCollateralType.Items.FindByValue(tblcol[0].datCollateralTypeID.ToString()));
if (Convert.ToInt32(tblcol[0].datConfirmed) > 0)
{
ddlConfirmed.SelectedValue = tblcol[0].datConfirmed.ToString();
}
ddlSurity.ClearSelection();
if (Convert.ToInt32(tblcol[0].datConfirmed) > 0)
{
ddlSurity.SelectedValue = tblcol[0].datSurety.ToString();
}
//ddlSurity.SelectedIndex = ddlSurity.Items.IndexOf(ddlSurity.Items.FindByValue(tblcol[0].datSurety.ToString()));
}
catch (Exception ex) { }
this.editskip.Value = "2";
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
int isConfirmed = -1;
if (ddlConfirmed.Text == "1" || ddlConfirmed.Text == "2")
{
isConfirmed = Convert.ToInt32(ddlConfirmed.SelectedValue);
}
LoanDSTableAdapters.CollateralTableAdapter collateral = new LoanDSTableAdapters.CollateralTableAdapter();
if (!(type == "update"))
{
collateral.InsertCollateral(MySessionManager.ClientID,
MySessionManager.AppID,
Convert.ToInt32(ddlCollateralType.Text),
txtDescription.Value,
txtLocation.Value,
Convert.ToDecimal(txtvalue.Value),
Convert.ToInt32(ddlSurity.SelectedValue),
txtContactPerson.Value,
txtContactTel.Value,
txtPhysicalAddress.Value,
Convert.ToInt32(isConfirmed),
null);
}
else if (type == "update")
{
collateral.updateCollateral(Convert.ToInt32(ddlCollateralType.Text),
txtDescription.Value,
txtLocation.Value,
Convert.ToDecimal(txtvalue.Value),
Convert.ToInt32(ddlSurity.SelectedValue),
txtContactPerson.Value,
txtContactTel.Value,
txtPhysicalAddress.Value,
Convert.ToInt32(isConfirmed),
null,
id);
}
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "coledit"));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
int isConfirmed = -1;
if (ddlConfirmed.Text == "1" || ddlConfirmed.Text == "2")
{
isConfirmed = Convert.ToInt32(ddlConfirmed.SelectedValue);
}
LoanDSTableAdapters.CollateralTableAdapter collateral = new LoanDSTableAdapters.CollateralTableAdapter();
if (!(type == "update"))
{
collateral.InsertCollateral(MySessionManager.ClientID,
MySessionManager.AppID,
Convert.ToInt32(ddlCollateralType.Text),
txtDescription.Value,
txtLocation.Value,
Convert.ToDecimal(txtvalue.Value),
Convert.ToInt32(ddlSurity.SelectedValue),
txtContactPerson.Value,
txtContactTel.Value,
txtPhysicalAddress.Value,
Convert.ToInt32(isConfirmed),
null);
}
else if (type == "update")
{
collateral.updateCollateral(Convert.ToInt32(ddlCollateralType.Text),
txtDescription.Value,
txtLocation.Value,
Convert.ToDecimal(txtvalue.Value),
Convert.ToInt32(ddlSurity.SelectedValue),
txtContactPerson.Value,
txtContactTel.Value,
txtPhysicalAddress.Value,
Convert.ToInt32(isConfirmed),
null,
id);
}
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "coledit"));
}
}
public void loadCollateral(int id)
{
LoanDSTableAdapters.CollateralTableAdapter collateral = new LoanDSTableAdapters.CollateralTableAdapter();
LoanDS.CollateralDataTable tblcol = collateral.GetCollateralDetails(id);
if (tblcol.Rows.Count > 0)
{
txtContactPerson.Value = tblcol[0].datContactPerson.ToString();
txtLocation.Value = tblcol[0].datLocation.ToString();
txtDescription.Value = tblcol[0].datDescription;
txtContactTel.Value = tblcol[0].datContactPersonTelephoneNumber.ToString();
txtPhysicalAddress.Value = tblcol[0].datPhysicalAddress.ToString();
txtvalue.Value = tblcol[0].datValue.ToString();
try
{
ddlCollateralType.SelectedValue = tblcol[0].datCollateralTypeID.ToString();
ddlCollateralType.SelectedIndex = ddlCollateralType.Items.IndexOf(ddlCollateralType.Items.FindByValue(tblcol[0].datCollateralTypeID.ToString()));
if (Convert.ToInt32(tblcol[0].datConfirmed) > 0) { ddlConfirmed.SelectedValue = tblcol[0].datConfirmed.ToString(); }
ddlSurity.ClearSelection();
if(Convert.ToInt32(tblcol[0].datConfirmed)>0) ddlSurity.SelectedValue = tblcol[0].datSurety.ToString();
//ddlSurity.SelectedIndex = ddlSurity.Items.IndexOf(ddlSurity.Items.FindByValue(tblcol[0].datSurety.ToString()));
}
catch (Exception ex) { }
this.editskip.Value = "2";
}
}