protected void btnSave_Click(object sender, EventArgs e) { Criminal_Address_InformationObject caiObject = new Criminal_Address_InformationObject(); CriminalInformationService cisObj = new CriminalInformationService(); try { caiObject.PermanentAddress.District = txtperDistrict.Text; caiObject.PermanentAddress.Upozila = txtPerUplozila.Text; caiObject.PermanentAddress.UnionWard = txtPerUnion.Text; caiObject.PermanentAddress.Village = txtPerVillage.Text; caiObject.PermanentAddress.CreateBy = Membership.GetUser().UserName; ; caiObject.PermanentAddress.CreateDate = DateTime.Now; caiObject.PermanentAddress.LastUpdateBy = Membership.GetUser().UserName; ; caiObject.PermanentAddress.LastUpdateDate = DateTime.Now; caiObject.PresentAddress.District = txtPreDistrict.Text; caiObject.PresentAddress.Upozila = txtPreUpozila.Text; caiObject.PresentAddress.UnionWard = txtPreUnion.Text; caiObject.PresentAddress.Village = txtPreVillage.Text; caiObject.PresentAddress.CreateBy = Membership.GetUser().UserName; ; caiObject.PresentAddress.CreateDate = DateTime.Now; caiObject.PresentAddress.LastUpdateBy = Membership.GetUser().UserName; ; caiObject.PresentAddress.LastUpdateDate = DateTime.Now; caiObject.RefNo = txtRefNo.Text; caiObject.LastAddressRegion = txtLastAddressRegion.Text; caiObject.DurationofStay = txtDurationofStay.Text; caiObject.Remarks = txtRemarks.Text; caiObject.WorkingArea = txtWorkingArea.Text; caiObject.PhoneNo = txtPhoneNo.Text; caiObject.MobileNo = txtMobileNo.Text; caiObject.email = txtEmail.Text; caiObject.CreateBy = Membership.GetUser().UserName; ; caiObject.CreateDate = DateTime.Now; caiObject.LastUpdateBy = Membership.GetUser().UserName; ; caiObject.LastUpdateDate = DateTime.Now; if (cisObj.InsertAddressInformation(caiObject)) { Response.Redirect("criminal-education-information.aspx?refno=" + txtRefNo.Text); } } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }
/// <summary> /// Insert Criminal Address Information using this fuction /// </summary> /// <returns></returns> public bool InsertAddressInformation(Criminal_Address_InformationObject caiObject) { string PreAddressID = Utility.GetNewID("Pre-"); string PerAddressID = Utility.GetNewID("Per-"); 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", PerAddressID)); parametersPermanentAddressList.Add(new SqlParameter("@District", caiObject.PermanentAddress.District)); parametersPermanentAddressList.Add(new SqlParameter("@Upozila", caiObject.PermanentAddress.Upozila)); parametersPermanentAddressList.Add(new SqlParameter("@UnionWard", caiObject.PermanentAddress.UnionWard)); parametersPermanentAddressList.Add(new SqlParameter("@Village", caiObject.PermanentAddress.Village)); parametersPermanentAddressList.Add(new SqlParameter("@CreateBy", caiObject.PermanentAddress.CreateBy)); parametersPermanentAddressList.Add(new SqlParameter("@CreateDate", caiObject.PermanentAddress.CreateDate)); parametersPermanentAddressList.Add(new SqlParameter("@LastUpdateBy", caiObject.PermanentAddress.LastUpdateBy)); parametersPermanentAddressList.Add(new SqlParameter("@LastUpdateDate", caiObject.PermanentAddress.LastUpdateDate)); if (baseObj.InsertData(sqlPreAddresstring, parametersPermanentAddressList)) { string sqlPerAddresstring = "INSERT INTO [AddressTable] ([ID],[District],[Upozila],[UnionWard],[Village]" + ",[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate]) VALUES " + "(@ID,@District,@Upozila,@UnionWard,@Village,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate)"; List<SqlParameter> parametersPresentAddressList = new List<SqlParameter>(); parametersPresentAddressList.Add(new SqlParameter("@ID", PreAddressID)); parametersPresentAddressList.Add(new SqlParameter("@District", caiObject.PresentAddress.District)); parametersPresentAddressList.Add(new SqlParameter("@Upozila", caiObject.PresentAddress.Upozila)); parametersPresentAddressList.Add(new SqlParameter("@UnionWard", caiObject.PresentAddress.UnionWard)); parametersPresentAddressList.Add(new SqlParameter("@Village", caiObject.PresentAddress.Village)); parametersPresentAddressList.Add(new SqlParameter("@CreateBy", caiObject.PresentAddress.CreateBy)); parametersPresentAddressList.Add(new SqlParameter("@CreateDate", caiObject.PresentAddress.CreateDate)); parametersPresentAddressList.Add(new SqlParameter("@LastUpdateBy", caiObject.PresentAddress.LastUpdateBy)); parametersPresentAddressList.Add(new SqlParameter("@LastUpdateDate", caiObject.PresentAddress.LastUpdateDate)); if (baseObj.InsertData(sqlPreAddresstring, parametersPresentAddressList)) { string sqlstring = "INSERT INTO [Criminal_Address_Information] ([RefNo],[PermanentAddressID],[PresentAddressID]" + ",[LastAddressRegion],[DurationofStay],[Remarks],[WorkingArea],[PhoneNo],[MobileNo],[email]" + ",[CreateBy],[CreateDate],[LastUpdateBy],[LastUpdateDate]) VALUES (@RefNo,@PermanentAddressID," + "@PresentAddressID,@LastAddressRegion,@DurationofStay,@Remarks,@WorkingArea,@PhoneNo,@MobileNo," + "@email,@CreateBy,@CreateDate,@LastUpdateBy,@LastUpdateDate)"; List<SqlParameter> parametersList = new List<SqlParameter>(); parametersList.Add(new SqlParameter("@RefNo", caiObject.RefNo)); parametersList.Add(new SqlParameter("@PermanentAddressID", PerAddressID)); parametersList.Add(new SqlParameter("@PresentAddressID", PreAddressID)); parametersList.Add(new SqlParameter("@LastAddressRegion", caiObject.LastAddressRegion)); parametersList.Add(new SqlParameter("@DurationofStay", caiObject.DurationofStay)); parametersList.Add(new SqlParameter("@Remarks", caiObject.Remarks)); parametersList.Add(new SqlParameter("@WorkingArea", caiObject.WorkingArea)); parametersList.Add(new SqlParameter("@PhoneNo", caiObject.PhoneNo)); parametersList.Add(new SqlParameter("@MobileNo", caiObject.MobileNo)); parametersList.Add(new SqlParameter("@email", caiObject.email)); 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)); if (baseObj.InsertData(sqlstring, parametersList)) { returnStatus = true; } } } return returnStatus; }