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