protected void btnAddmore_Click(object sender, EventArgs e)
{
Criminal_Bank_Account_DetailsObject cbadObject = new Criminal_Bank_Account_DetailsObject();
CriminalInformationService cisObj = new CriminalInformationService();
try
{
cbadObject.RefNo = txtRefNo.Text;
cbadObject.BankName = txtBankName.Text;
cbadObject.AccountNo = txtAccountNo.Text;
cbadObject.AccountType = txtAccountType.Text;
cbadObject.CreditCardNo = txtCreditCardNo.Text;
cbadObject.DebitCardNo = txtDebitCardNo.Text;
cbadObject.CreateBy = Membership.GetUser().UserName;
cbadObject.CreateDate = DateTime.Now;
cbadObject.LastUpdateBy = Membership.GetUser().UserName;
cbadObject.LastUpdateDate = DateTime.Now;
if (cisObj.InsertTravelInformation(cbadObject))
{
txtRefNo.Text = txtRefNo.Text;
txtBankName.Text = "";
txtAccountNo.Text = "";
txtAccountType.Text = "";
txtCreditCardNo.Text = "";
txtDebitCardNo.Text = "";
SuccessMessage.Text = "One record Added.";
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Criminal_Bank_Account_DetailsObject cbadObject = new Criminal_Bank_Account_DetailsObject();
CriminalInformationService cisObj = new CriminalInformationService();
try
{
cbadObject.RefNo = txtRefNo.Text;
cbadObject.BankName = txtBankName.Text;
cbadObject.AccountNo = txtAccountNo.Text;
cbadObject.AccountType = txtAccountType.Text;
cbadObject.CreditCardNo = txtCreditCardNo.Text;
cbadObject.DebitCardNo = txtDebitCardNo.Text;
cbadObject.CreateBy = Membership.GetUser().UserName;
cbadObject.CreateDate = DateTime.Now;
cbadObject.LastUpdateBy = Membership.GetUser().UserName;
cbadObject.LastUpdateDate = DateTime.Now;
if (cisObj.InsertTravelInformation(cbadObject))
{
Response.Redirect("crime-basic-information.aspx?refno=" + txtRefNo.Text);
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
}
}
/// <summary>
/// Insert Criminal Travel Information using this fuction
/// </summary>
/// <returns></returns>
public bool InsertTravelInformation(Criminal_Bank_Account_DetailsObject cbadObject)
{
clsBase baseObj = new clsBase();
string sqlstring = "INSERT INTO [Criminal_Bank_Account_Information] ([RefNo],[BankName]" +
",[AccountNo],[AccountType],[CreditCardNo],[DebitCardNo],[CreateBy],[CreateDate]" +
",[LastUpdateBy],[LastUpdateDate]) VALUES (@RefNo,@BankName,@AccountNo,@AccountType," +
"@CreditCardNo,@DebitCardNo,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate)";
List<SqlParameter> parametersList = new List<SqlParameter>();
parametersList.Add(new SqlParameter("@RefNo", cbadObject.RefNo));
parametersList.Add(new SqlParameter("@BankName", cbadObject.BankName));
parametersList.Add(new SqlParameter("@AccountNo", cbadObject.AccountNo));
parametersList.Add(new SqlParameter("@AccountType", cbadObject.AccountType));
parametersList.Add(new SqlParameter("@CreditCardNo", cbadObject.CreditCardNo));
parametersList.Add(new SqlParameter("@DebitCardNo", cbadObject.DebitCardNo));
parametersList.Add(new SqlParameter("@CreateBy", cbadObject.CreateBy));
parametersList.Add(new SqlParameter("@CreateDate", cbadObject.CreateDate));
parametersList.Add(new SqlParameter("@LastUpdateBy", cbadObject.LastUpdateBy));
parametersList.Add(new SqlParameter("@LastUpdateDate", cbadObject.LastUpdateDate));
return baseObj.InsertData(sqlstring, parametersList);
}