protected void btnSave_Click(object sender, EventArgs e) { Criminal_Basic_InformationObject cbiObject = new Criminal_Basic_InformationObject(); CriminalInformationService cisObj = new CriminalInformationService(); try { cbiObject.refNo = txtRefNo.Text; cbiObject.fullName = txtFullName.Text; cbiObject.nickName = txtNickName.Text; cbiObject.criminalName = txtCriminalName.Text; cbiObject.gender = ddlGender.SelectedValue; cbiObject.bloodGroup = ddlBloodGroup.SelectedValue; cbiObject.dob = Convert.ToDateTime(txtDOB.Text); cbiObject.regionofBirth = txtRegionofBirth.Text; cbiObject.usualDressUp = txtUsualDressUp.Text; cbiObject.maritalStatus = txtMaritalStatus.Text; cbiObject.dialectAccent = txtDialectAccent.Text; cbiObject.drivingLicenseNo = txtDrivingLicenseNo.Text; cbiObject.nationalID = txtNationalID.Text; cbiObject.passport = txtPassportNo.Text; cbiObject.createdate = DateTime.Now; cbiObject.createby = Membership.GetUser().UserName; ; cbiObject.updateDate = DateTime.Now; cbiObject.updateby = Membership.GetUser().UserName; ; if (cisObj.InsertBasicInformation(cbiObject)) { Response.Redirect("criminal-physical-information.aspx?refno=" + cbiObject.refNo); } } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }
/// <summary> /// Insert Criminal Basic Information using this fuction /// </summary> /// <returns></returns> public bool InsertBasicInformation(Criminal_Basic_InformationObject cbiObject) { clsBase baseObj = new clsBase(); string sqlstring = "INSERT INTO [Criminal_Basic_Information] ([RefNo],[FullName],[NickName],[CriminalName],[Gender]" + ",[BloodGroup],[DOB],[RegionOfBirth],[UsualDressUp],[MaritalStatus],[DialectAccent],[DrivingLicenseNo]" + ",[NationalID],[PassportNo],[CreationDate],[CreateBy],[LastUpdate],[LastUpdateBy])VALUES (@RefNo," + " @FullName,@NickName,@CriminalName,@Gender,@BloodGroup,@DOB,@RegionOfBirth,@UsualDressUp,@MaritalStatus," + "@DialectAccent,@DrivingLicenseNo,@NationalID,@PassportNo, @CreationDate,@CreateBy,@LastUpdate,@LastUpdateBy)"; List<SqlParameter> parametersList = new List<SqlParameter>(); parametersList.Add(new SqlParameter("@RefNo", cbiObject.refNo)); parametersList.Add(new SqlParameter("@FullName", cbiObject.fullName)); parametersList.Add(new SqlParameter("@NickName", cbiObject.nickName)); parametersList.Add(new SqlParameter("@CriminalName", cbiObject.criminalName)); parametersList.Add(new SqlParameter("@Gender", cbiObject.gender)); parametersList.Add(new SqlParameter("@BloodGroup", cbiObject.bloodGroup)); parametersList.Add(new SqlParameter("@DOB", cbiObject.dob)); parametersList.Add(new SqlParameter("@RegionOfBirth", cbiObject.regionofBirth)); parametersList.Add(new SqlParameter("@UsualDressUp", cbiObject.usualDressUp)); parametersList.Add(new SqlParameter("@MaritalStatus", cbiObject.maritalStatus)); parametersList.Add(new SqlParameter("@DialectAccent", cbiObject.dialectAccent)); parametersList.Add(new SqlParameter("@DrivingLicenseNo", cbiObject.drivingLicenseNo)); parametersList.Add(new SqlParameter("@NationalID", cbiObject.nationalID)); parametersList.Add(new SqlParameter("@PassportNo", cbiObject.passport)); parametersList.Add(new SqlParameter("@CreationDate", cbiObject.createdate)); parametersList.Add(new SqlParameter("@CreateBy", cbiObject.createby)); parametersList.Add(new SqlParameter("@LastUpdate", cbiObject.updateDate)); parametersList.Add(new SqlParameter("@LastUpdateBy", cbiObject.updateby)); return baseObj.InsertData(sqlstring, parametersList); }