/// <summary> /// Insert Crime Basic Information using this fuction /// </summary> /// <returns></returns> public bool InsertCrimeBasicInformation(Crime_Basic_InformationObject cbiObject) { clsBase baseObj = new clsBase(); string sqlstring = "INSERT INTO [Crime_Basic_Information] ([CreminalRef],[CriminalStatus],[GangName]" + ",[CrimeType],[IllegalArmsPossession],[Remarks],[LegalArmsPossession],[PriorityListGovt]" + ",[CaseDetails],[LastState],[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate]) VALUES" + "(@CreminalRef,@CriminalStatus,@GangName,@CrimeType,@IllegalArmsPossession,@Remarks," + "@LegalArmsPossession,@PriorityListGovt,@CaseDetails,@LastState,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate)"; List<SqlParameter> parametersList = new List<SqlParameter>(); parametersList.Add(new SqlParameter("@CreminalRef", cbiObject.CreminalRef)); parametersList.Add(new SqlParameter("@CriminalStatus", cbiObject.CriminalStatus)); parametersList.Add(new SqlParameter("@GangName", cbiObject.GangName)); parametersList.Add(new SqlParameter("@CrimeType", cbiObject.CrimeType)); parametersList.Add(new SqlParameter("@IllegalArmsPossession", cbiObject.IllegalArmsPossession)); parametersList.Add(new SqlParameter("@Remarks", cbiObject.Remarks)); parametersList.Add(new SqlParameter("@LegalArmsPossession", cbiObject.LegalArmsPossession)); parametersList.Add(new SqlParameter("@PriorityListGovt", cbiObject.PriorityListGovt)); parametersList.Add(new SqlParameter("@CaseDetails", cbiObject.CaseDetails)); parametersList.Add(new SqlParameter("@LastState", cbiObject.LastState)); parametersList.Add(new SqlParameter("@CreateBy", cbiObject.CreateBy)); parametersList.Add(new SqlParameter("@CreateDate", cbiObject.CreateDate)); parametersList.Add(new SqlParameter("@LastUpdateBy", cbiObject.LastUpdateBy)); parametersList.Add(new SqlParameter("@LastUpdateDate", cbiObject.LastUpdateDate)); return baseObj.InsertData(sqlstring, parametersList); }
protected void btnSave_Click(object sender, EventArgs e) { Crime_Basic_InformationObject cbiObject = new Crime_Basic_InformationObject(); CrimeInformationService cisObj = new CrimeInformationService(); try { cbiObject.CreminalRef = txtRefNo.Text; cbiObject.CriminalStatus = rblCriminalStatus.SelectedValue; cbiObject.GangName = txtGangName.Text; cbiObject.CrimeType = ddlCrimeType.SelectedValue; cbiObject.IllegalArmsPossession = rblIllegalArmsPossession.SelectedValue; cbiObject.Remarks = txtRemarks.Text; cbiObject.LegalArmsPossession = rbllegalArmsPossession.SelectedValue; cbiObject.PriorityListGovt = txtPriorityListGovt.Text; cbiObject.CaseDetails = txtCaseDetails.Text; cbiObject.LastState = txtLastState.Text; cbiObject.CreateBy = User.Identity.Name; cbiObject.CreateDate = DateTime.Now; cbiObject.LastUpdateBy = User.Identity.Name; cbiObject.LastUpdateDate = DateTime.Now; if (cisObj.InsertCrimeBasicInformation(cbiObject)) { Response.Redirect("crime-history.aspx?refno=" + txtRefNo.Text); } } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }