protected void btnSave_Click(object sender, EventArgs e)
{
Criminal_Physical_InformationObject cpiObject = new Criminal_Physical_InformationObject();
CriminalInformationService cisObj = new CriminalInformationService();
try
{
cpiObject.RefNo = txtRefNo.Text;
cpiObject.HeightInch = txtheight.Text;
cpiObject.WeightKg = txtWeight.Text;
cpiObject.EyeColor = txtEyeColor.Text;
cpiObject.EyeImage = fuEyeIamge.FileBytes;
cpiObject.lips = txtLips.Text;
cpiObject.IrregularitiesOnEye = txtIrregularitiesOnEye.Text;
cpiObject.SkinColor = txtSkinColor.Text;
cpiObject.Nose = txtNose.Text;
cpiObject.ShapeOfBody = txtShapeOfBody.Text;
cpiObject.ShapeOfHead = txtShapeOfHead.Text;
cpiObject.Teeth = txtTeeth.Text;
cpiObject.HairColor = txtHairColor.Text;
cpiObject.TypeOfHair = txtTypeOfHair.Text;
cpiObject.Tattoo = txtTattoo.Text;
cpiObject.Ear = txtEar.Text;
cpiObject.TypeOfFace = txtTypeOfFace.Text;
cpiObject.ScarsAndHandicap = txtScarsAndHandicap.Text;
cpiObject.Forehead = txtForehead.Text;
cpiObject.IdentificationMark = txtIdentificationMark.Text;
cpiObject.Picture = fuPicture.FileBytes;
cpiObject.CreateDate = DateTime.Now;
cpiObject.CreateBy = Membership.GetUser().UserName; ;
cpiObject.LastUpdateDate = DateTime.Now;
cpiObject.LastUpdateBy = Membership.GetUser().UserName; ;
if (cisObj.InsertPhysicalInformation(cpiObject))
{
Response.Redirect("criminal-address-information.aspx?refno=" + cpiObject.RefNo);
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
}
}
/// <summary>
/// Insert Criminal Physical Information using this fuction
/// </summary>
/// <returns></returns>
public bool InsertPhysicalInformation(Criminal_Physical_InformationObject cpiObject)
{
clsBase baseObj = new clsBase();
string sqlstring = "INSERT INTO [Criminal_Physical_Information] ([RefNo],[HeightInch],[WeightKg]" +
",[EyeColor],[EyeImage],[lips],[IrregularitiesOnEye],[SkinColor],[Nose],[ShapeOfBody]" +
",[ShapeOfHead],[Teeth],[HairColor],[TypeOfHair],[Tattoo],[Ear],[TypeOfFace],[ScarsAndHandicap]" +
",[Forehead],[IdentificationMark],[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate],[Picture])" +
"VALUES (@RefNo,@HeightInch,@WeightKg,@EyeColor,@EyeImage,@lips,@IrregularitiesOnEye,@SkinColor,@Nose," +
"@ShapeOfBody,@ShapeOfHead,@Teeth,@HairColor,@TypeOfHair,@Tattoo,@Ear,@TypeOfFace,@ScarsAndHandicap," +
"@Forehead,@IdentificationMark,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate,@Picture)";
List<SqlParameter> parametersList = new List<SqlParameter>();
parametersList.Add(new SqlParameter("@RefNo", cpiObject.RefNo));
parametersList.Add(new SqlParameter("@HeightInch", cpiObject.HeightInch));
parametersList.Add(new SqlParameter("@WeightKg", cpiObject.WeightKg));
parametersList.Add(new SqlParameter("@EyeColor", cpiObject.EyeColor));
parametersList.Add(new SqlParameter("@EyeImage", cpiObject.EyeImage));
parametersList.Add(new SqlParameter("@Picture", cpiObject.Picture));
parametersList.Add(new SqlParameter("@lips", cpiObject.lips));
parametersList.Add(new SqlParameter("@IrregularitiesOnEye", cpiObject.IrregularitiesOnEye));
parametersList.Add(new SqlParameter("@SkinColor", cpiObject.SkinColor));
parametersList.Add(new SqlParameter("@Nose", cpiObject.Nose));
parametersList.Add(new SqlParameter("@ShapeOfBody", cpiObject.ShapeOfBody));
parametersList.Add(new SqlParameter("@ShapeOfHead", cpiObject.ShapeOfHead));
parametersList.Add(new SqlParameter("@Teeth", cpiObject.Teeth));
parametersList.Add(new SqlParameter("@HairColor", cpiObject.HairColor));
parametersList.Add(new SqlParameter("@TypeOfHair", cpiObject.TypeOfHair));
parametersList.Add(new SqlParameter("@Tattoo", cpiObject.Tattoo));
parametersList.Add(new SqlParameter("@Ear", cpiObject.Ear));
parametersList.Add(new SqlParameter("@TypeOfFace", cpiObject.TypeOfFace));
parametersList.Add(new SqlParameter("@ScarsAndHandicap", cpiObject.ScarsAndHandicap));
parametersList.Add(new SqlParameter("@Forehead", cpiObject.Forehead));
parametersList.Add(new SqlParameter("@IdentificationMark", cpiObject.IdentificationMark));
parametersList.Add(new SqlParameter("@CreateDate", cpiObject.CreateDate));
parametersList.Add(new SqlParameter("@CreateBy", cpiObject.CreateBy));
parametersList.Add(new SqlParameter("@LastUpdateDate", cpiObject.LastUpdateDate));
parametersList.Add(new SqlParameter("@LastUpdateBy", cpiObject.LastUpdateBy));
return baseObj.InsertData(sqlstring, parametersList);
}
