/// <summary>
/// Insert Crime activities information using this fuction
/// </summary>
/// <returns></returns>
public bool InsertCrimeActivitiesInformation(Crime_Criminal_ActivitiesObject ccaiObject)
{
clsBase baseObj = new clsBase();
string sqlstring = "INSERT INTO [Crime_Creminal_Activities] ([RefNo] ,[previousAcitivity],[CurrentActivity]" +
",[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate]) VALUES (@RefNo,@previousAcitivity," +
"@CurrentActivity,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate)";
List<SqlParameter> parametersList = new List<SqlParameter>();
parametersList.Add(new SqlParameter("@RefNo", ccaiObject.RefNo));
parametersList.Add(new SqlParameter("@previousAcitivity", ccaiObject.previousAcitivity));
parametersList.Add(new SqlParameter("@CurrentActivity", ccaiObject.CurrentActivity));
parametersList.Add(new SqlParameter("@CreateBy", ccaiObject.CreateBy));
parametersList.Add(new SqlParameter("@CreateDate", ccaiObject.CreateDate));
parametersList.Add(new SqlParameter("@LastUpdateBy", ccaiObject.LastUpdateBy));
parametersList.Add(new SqlParameter("@LastUpdateDate", ccaiObject.LastUpdateDate));
return baseObj.InsertData(sqlstring, parametersList);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Crime_Criminal_ActivitiesObject cbiObject = new Crime_Criminal_ActivitiesObject();
CrimeInformationService cisObj = new CrimeInformationService();
try
{
cbiObject.RefNo = txtRefNo.Text;
cbiObject.previousAcitivity = txtpreviousAcitivity.Text;
cbiObject.CurrentActivity = txtCurrentActivity.Text;
cbiObject.CreateBy = User.Identity.Name;
cbiObject.CreateDate = DateTime.Now;
cbiObject.LastUpdateBy = User.Identity.Name;
cbiObject.LastUpdateDate = DateTime.Now;
if (cisObj.InsertCrimeActivitiesInformation(cbiObject))
{
Response.Redirect("crime-entry-end.aspx?refno=" + txtRefNo.Text);
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
}
}