protected void btnAddmore_Click(object sender, EventArgs e)
{
Criminal_Travel_InformationObject ctiObject = new Criminal_Travel_InformationObject();
CriminalInformationService cisObj = new CriminalInformationService();
try
{
ctiObject.RefNo = txtRefNo.Text;
ctiObject.CountryVisited = txtCountryVisited.Text;
ctiObject.ArrivalDate = Convert.ToDateTime(txtArrivalDate.Text);
ctiObject.DepartureDate = Convert.ToDateTime(txtDepartureDate.Text);
ctiObject.Duration = txtDuration.Text;
ctiObject.AddressAbroad = txtAddressAbroad.Text;
ctiObject.CreateBy = Membership.GetUser().UserName;
ctiObject.CreateDate = DateTime.Now;
ctiObject.LastUpdateBy = Membership.GetUser().UserName;
ctiObject.LastUpdateDate = DateTime.Now;
if (cisObj.InsertTravelInformation(ctiObject))
{
txtCountryVisited.Text = "";
txtArrivalDate.Text = "";
txtDepartureDate.Text = "";
txtDuration.Text = "";
txtAddressAbroad.Text = "";
SuccessMessage.Text = "One record Added.";
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Criminal_Travel_InformationObject ctiObject = new Criminal_Travel_InformationObject();
CriminalInformationService cisObj = new CriminalInformationService();
try
{
ctiObject.RefNo = txtRefNo.Text;
ctiObject.CountryVisited = txtCountryVisited.Text;
ctiObject.ArrivalDate = Convert.ToDateTime(txtArrivalDate.Text);
ctiObject.DepartureDate = Convert.ToDateTime(txtDepartureDate.Text);
ctiObject.Duration = txtDuration.Text;
ctiObject.AddressAbroad = txtAddressAbroad.Text;
ctiObject.CreateBy = Membership.GetUser().UserName;
ctiObject.CreateDate = DateTime.Now;
ctiObject.LastUpdateBy = Membership.GetUser().UserName;
ctiObject.LastUpdateDate = DateTime.Now;
if (cisObj.InsertTravelInformation(ctiObject))
{
Response.Redirect("creminal-bank-account-details.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_Travel_InformationObject ctiObject)
{
clsBase baseObj = new clsBase();
string sqlstring = "INSERT INTO [Criminal_Travel_Information] ([RefNo],[CountryVisited],[ArrivalDate]" +
",[DepartureDate],[Duration],[AddressAbroad],[CreateBy],[CreateDate],[LastUpdateDate],[LastUpdateBy])" +
"VALUES (@RefNo,@CountryVisited,@ArrivalDate,@DepartureDate,@Duration,@AddressAbroad,@CreateBy," +
"@CreateDate,@LastUpdateDate,@LastUpdateBy)";
List<SqlParameter> parametersList = new List<SqlParameter>();
parametersList.Add(new SqlParameter("@RefNo", ctiObject.RefNo));
parametersList.Add(new SqlParameter("@CountryVisited", ctiObject.CountryVisited));
parametersList.Add(new SqlParameter("@ArrivalDate", ctiObject.ArrivalDate));
parametersList.Add(new SqlParameter("@DepartureDate", ctiObject.DepartureDate));
parametersList.Add(new SqlParameter("@Duration", ctiObject.Duration));
parametersList.Add(new SqlParameter("@AddressAbroad", ctiObject.AddressAbroad));
parametersList.Add(new SqlParameter("@CreateBy", ctiObject.CreateBy));
parametersList.Add(new SqlParameter("@CreateDate", ctiObject.CreateDate));
parametersList.Add(new SqlParameter("@LastUpdateBy", ctiObject.LastUpdateBy));
parametersList.Add(new SqlParameter("@LastUpdateDate", ctiObject.LastUpdateDate));
return baseObj.InsertData(sqlstring, parametersList);
}
