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