protected void btnSave_Click(object sender, EventArgs e)
{
Criminal_Death_InformationObject caiObject = new Criminal_Death_InformationObject();
CriminalInformationService cisObj = new CriminalInformationService();
try
{
caiObject.Address.District = txtDistrict.Text;
caiObject.Address.Upozila = txtUplozila.Text;
caiObject.Address.UnionWard = txtUnion.Text;
caiObject.Address.Village = txtVillage.Text;
caiObject.Address.CreateBy = Membership.GetUser().UserName; ;
caiObject.Address.CreateDate = DateTime.Now;
caiObject.Address.LastUpdateBy = Membership.GetUser().UserName; ;
caiObject.Address.LastUpdateDate = DateTime.Now;
caiObject.RefNo = txtRefNo.Text;
caiObject.Reason = txtReason.Text;
caiObject.DeathDate = txtDate.Text;
caiObject.DeathTime = txtDeathTime.Text;
caiObject.CreateBy = Membership.GetUser().UserName;
caiObject.CreateDate = DateTime.Now;
caiObject.LastUpdateBy = Membership.GetUser().UserName;
caiObject.LastUpdateDate = DateTime.Now;
if (cisObj.InsertDeathInformation(caiObject))
{
Response.Redirect("criminal-travel-information.aspx?refno=" + txtRefNo.Text);
}
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
}
}
/// <summary>
/// Insert Criminal Death Information using this fuction
/// </summary>
/// <returns></returns>
public bool InsertDeathInformation(Criminal_Death_InformationObject cdiObject)
{
string AddressID = Utility.GetNewID("dat-");
bool returnStatus = false;
clsBase baseObj = new clsBase();
string sqlPreAddresstring = "INSERT INTO [AddressTable] ([ID],[District],[Upozila],[UnionWard],[Village]" +
",[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate]) VALUES " +
"(@ID,@District,@Upozila,@UnionWard,@Village,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate)";
List<SqlParameter> parametersPermanentAddressList = new List<SqlParameter>();
parametersPermanentAddressList.Add(new SqlParameter("@ID", AddressID));
parametersPermanentAddressList.Add(new SqlParameter("@District", cdiObject.Address.District));
parametersPermanentAddressList.Add(new SqlParameter("@Upozila", cdiObject.Address.Upozila));
parametersPermanentAddressList.Add(new SqlParameter("@UnionWard", cdiObject.Address.UnionWard));
parametersPermanentAddressList.Add(new SqlParameter("@Village", cdiObject.Address.Village));
parametersPermanentAddressList.Add(new SqlParameter("@CreateBy", cdiObject.Address.CreateBy));
parametersPermanentAddressList.Add(new SqlParameter("@CreateDate", cdiObject.Address.CreateDate));
parametersPermanentAddressList.Add(new SqlParameter("@LastUpdateBy", cdiObject.Address.LastUpdateBy));
parametersPermanentAddressList.Add(new SqlParameter("@LastUpdateDate", cdiObject.Address.LastUpdateDate));
if (baseObj.InsertData(sqlPreAddresstring, parametersPermanentAddressList))
{
string sqlstring = "INSERT INTO [Criminal_Death_Information] ([RefNo],[DeathTime]" +
",[DeathDate],[Reason],[CreateBy],[CreateDate],[LastUpdateDate],[LastUpdateBy]" +
",[AddressID]) VALUES (@RefNo,@DeathTime,@DeathDate,@Reason,@CreateBy,@CreateDate," +
"@LastUpdateDate,@LastUpdateBy, @AddressID)";
List<SqlParameter> parametersList = new List<SqlParameter>();
parametersList.Add(new SqlParameter("@RefNo", cdiObject.RefNo));
parametersList.Add(new SqlParameter("@DeathTime", cdiObject.DeathTime));
parametersList.Add(new SqlParameter("@DeathDate", cdiObject.DeathDate));
parametersList.Add(new SqlParameter("@Reason", cdiObject.Reason));
parametersList.Add(new SqlParameter("@CreateBy", cdiObject.CreateBy));
parametersList.Add(new SqlParameter("@CreateDate", cdiObject.CreateDate));
parametersList.Add(new SqlParameter("@LastUpdateBy", cdiObject.LastUpdateBy));
parametersList.Add(new SqlParameter("@LastUpdateDate", cdiObject.LastUpdateDate));
parametersList.Add(new SqlParameter("@AddressID", AddressID));
if (baseObj.InsertData(sqlstring, parametersList))
{
returnStatus = true;
}
}
return returnStatus;
}
