protected void btnSave_Click(object sender, EventArgs e) { Crime_Case_DetailsObject cbiObject = new Crime_Case_DetailsObject(); CrimeInformationService cisObj = new CrimeInformationService(); try { cbiObject.RefNo = txtRefNo.Text; cbiObject.CaseNo = txtCaseNo.Text; cbiObject.District = txtDistrict.Text; cbiObject.Thana = txtThana.Text; cbiObject.Date = Convert.ToDateTime(txtDate.Text); cbiObject.CreateBy = User.Identity.Name; cbiObject.CreateDate = DateTime.Now; cbiObject.LastUpdateBy = User.Identity.Name; cbiObject.LastUpdateDate = DateTime.Now; if (cisObj.InsertCrimeCaseDetails(cbiObject)) { Response.Redirect("crime-zone-information.aspx?refno=" + txtRefNo.Text); } } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }
/// <summary> /// Insert Crime Case Details using this fuction /// </summary> /// <returns></returns> public bool InsertCrimeCaseDetails(Crime_Case_DetailsObject ccdObject) { clsBase baseObj = new clsBase(); string sqlstring = "INSERT INTO [Crime_Case_Details] ([RefNo],[CaseNo],[District],[Thana]" + ",[Date],[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate]) VALUES" + " (@RefNo,@CaseNo,@District,@Thana,@Date,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate)"; List<SqlParameter> parametersList = new List<SqlParameter>(); parametersList.Add(new SqlParameter("@RefNo", ccdObject.RefNo)); parametersList.Add(new SqlParameter("@CaseNo", ccdObject.CaseNo)); parametersList.Add(new SqlParameter("@District", ccdObject.District)); parametersList.Add(new SqlParameter("@Thana", ccdObject.Thana)); parametersList.Add(new SqlParameter("@Date", ccdObject.Date)); parametersList.Add(new SqlParameter("@CreateBy", ccdObject.CreateBy)); parametersList.Add(new SqlParameter("@CreateDate", ccdObject.CreateDate)); parametersList.Add(new SqlParameter("@LastUpdateBy", ccdObject.LastUpdateBy)); parametersList.Add(new SqlParameter("@LastUpdateDate", ccdObject.LastUpdateDate)); return baseObj.InsertData(sqlstring, parametersList); }