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