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