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