protected void btnSave_Click(object sender, EventArgs e) { Crime_Arrest_InformationObject cbiObject = new Crime_Arrest_InformationObject(); CrimeInformationService cisObj = new CrimeInformationService(); try { cbiObject.RefNo = txtRefNo.Text; cbiObject.District = txtDistrict.Text; cbiObject.DateofArrest = Convert.ToDateTime(txtDateofArrest.Text); cbiObject.Upozila = txtUpozila.Text; cbiObject.ArrestBy = txtArrestBy.Text; cbiObject.Disposal = txtDisposal.Text; cbiObject.CreateBy = User.Identity.Name; cbiObject.CreateDate = DateTime.Now; cbiObject.LastUpdateBy = User.Identity.Name; cbiObject.LastUpdateDate = DateTime.Now; if (cisObj.InsertCrimeArrestInformation(cbiObject)) { Response.Redirect("crime-criminal-activities.aspx?refno=" + txtRefNo.Text); } } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }
/// <summary> /// Insert Crime arrest information using this fuction /// </summary> /// <returns></returns> public bool InsertCrimeArrestInformation(Crime_Arrest_InformationObject caiObject) { clsBase baseObj = new clsBase(); string sqlstring = "INSERT INTO [Crime_Arrest_Information] ([RefNo],[District],[Upozila],[DateofArrest],[ArrestBy]" + ",[Disposal],[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate]) VALUES (@RefNo,@District," + "@Upozila,@DateofArrest,@ArrestBy,@Disposal,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate)"; List<SqlParameter> parametersList = new List<SqlParameter>(); parametersList.Add(new SqlParameter("@RefNo", caiObject.RefNo)); parametersList.Add(new SqlParameter("@District", caiObject.District)); parametersList.Add(new SqlParameter("@Upozila", caiObject.Upozila)); parametersList.Add(new SqlParameter("@DateofArrest", caiObject.DateofArrest)); parametersList.Add(new SqlParameter("@ArrestBy", caiObject.ArrestBy)); parametersList.Add(new SqlParameter("@Disposal", caiObject.Disposal)); parametersList.Add(new SqlParameter("@CreateBy", caiObject.CreateBy)); parametersList.Add(new SqlParameter("@CreateDate", caiObject.CreateDate)); parametersList.Add(new SqlParameter("@LastUpdateBy", caiObject.LastUpdateBy)); parametersList.Add(new SqlParameter("@LastUpdateDate", caiObject.LastUpdateDate)); return baseObj.InsertData(sqlstring, parametersList); }