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