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); }