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 issueDate = DateTime.Parse(txtIssueDate.Text, ukCulture.DateTimeFormat);
DateTime expiryDate = DateTime.Parse(txtExpiryDate.Text, ukCulture.DateTimeFormat);
LoanDSTableAdapters.CreditInformationTableAdapter creditinfo = new LoanDSTableAdapters.CreditInformationTableAdapter();
if (!(type == "update"))
{
creditinfo.InsertCreditInformation(MySessionManager.ClientID,
MySessionManager.AppID,
txtcreditor.Value.Trim(),
txtDescription.Value.Trim(),
Convert.ToDecimal(txtcreditvalue.Value.Trim()),
Convert.ToDecimal(txtMonthlyRepayment.Value.Trim()),
Convert.ToDecimal(txtOutstandingamt.Value.Trim()),
issueDate,
expiryDate
);
}
else
{
creditinfo.updateCreditInformation(txtcreditor.Value.Trim(),
txtDescription.Value.Trim(),
Convert.ToDecimal(txtcreditvalue.Value.Trim()),
Convert.ToDecimal(txtMonthlyRepayment.Value.Trim()),
Convert.ToDecimal(txtOutstandingamt.Value.Trim()),
issueDate,
expiryDate,
1,
id);
}
}
catch (Exception ex) { }
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ctedit"));
}
}
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 issueDate = DateTime.Parse(txtIssueDate.Text, ukCulture.DateTimeFormat);
DateTime expiryDate = DateTime.Parse(txtExpiryDate.Text, ukCulture.DateTimeFormat);
LoanDSTableAdapters.CreditInformationTableAdapter creditinfo = new LoanDSTableAdapters.CreditInformationTableAdapter();
if (!(type == "update"))
{
creditinfo.InsertCreditInformation(MySessionManager.ClientID,
MySessionManager.AppID,
txtcreditor.Value.Trim(),
txtDescription.Value.Trim(),
Convert.ToDecimal(txtcreditvalue.Value.Trim()),
Convert.ToDecimal(txtMonthlyRepayment.Value.Trim()),
Convert.ToDecimal(txtOutstandingamt.Value.Trim()),
issueDate,
expiryDate
);
}
else
{
creditinfo.updateCreditInformation(txtcreditor.Value.Trim(),
txtDescription.Value.Trim(),
Convert.ToDecimal(txtcreditvalue.Value.Trim()),
Convert.ToDecimal(txtMonthlyRepayment.Value.Trim()),
Convert.ToDecimal(txtOutstandingamt.Value.Trim()),
issueDate,
expiryDate,
1,
id);
}
}
catch (Exception ex) { }
Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ctedit"));
}
}
public void loadCreditinfo(int id)
{
LoanDSTableAdapters.CreditInformationTableAdapter creditinfo = new LoanDSTableAdapters.CreditInformationTableAdapter();
LoanDS.CreditInformationDataTable tblcreditinfo = creditinfo.GetCreditInformationDetails(id);
this.editskip.Value = "2";
if (tblcreditinfo.Rows.Count > 0)
{
try
{
txtcreditor.Value = tblcreditinfo[0].datCreditor.ToString();
txtcreditvalue.Value = tblcreditinfo[0].datCreditValue.ToString();
txtDescription.Value = tblcreditinfo[0].datDescription.ToString();
txtExpiryDate.Text = tblcreditinfo[0].datExpiryDate.ToString("dd-MM-yyyy");
txtIssueDate.Text = tblcreditinfo[0].datIssueDate.ToString("dd-MM-yyyy");
txtMonthlyRepayment.Value = tblcreditinfo[0].datMonthlyObligation.ToString();
txtOutstandingamt.Value = tblcreditinfo[0].datOutstanding.ToString();
}
catch (Exception ex)
{}
}
}
public void loadCreditinfo(int id)
{
LoanDSTableAdapters.CreditInformationTableAdapter creditinfo = new LoanDSTableAdapters.CreditInformationTableAdapter();
LoanDS.CreditInformationDataTable tblcreditinfo = creditinfo.GetCreditInformationDetails(id);
this.editskip.Value = "2";
if (tblcreditinfo.Rows.Count > 0)
{
try
{
txtcreditor.Value = tblcreditinfo[0].datCreditor.ToString();
txtcreditvalue.Value = tblcreditinfo[0].datCreditValue.ToString();
txtDescription.Value = tblcreditinfo[0].datDescription.ToString();
txtExpiryDate.Text = tblcreditinfo[0].datExpiryDate.ToString("dd-MM-yyyy");
txtIssueDate.Text = tblcreditinfo[0].datIssueDate.ToString("dd-MM-yyyy");
txtMonthlyRepayment.Value = tblcreditinfo[0].datMonthlyObligation.ToString();
txtOutstandingamt.Value = tblcreditinfo[0].datOutstanding.ToString();
}
catch (Exception ex)
{}
}
}
