public int MemberAddress_Save(Model.MemberAddress memberAddress) { int rowsAffacted = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_MemberAddress_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MemberAddressDetailsId", memberAddress.MemberAddressDetailsId); cmd.Parameters.AddWithValue("@MemberId", memberAddress.MemberId); cmd.Parameters.AddWithValue("@ResidentialAddress", memberAddress.ResidentialAddress); cmd.Parameters.AddWithValue("@LocalityId", memberAddress.LocalityId); cmd.Parameters.AddWithValue("@Emirates", memberAddress.Emirates); cmd.Parameters.AddWithValue("@CreatedBy", memberAddress.CreatedBy); if (con.State == ConnectionState.Closed) { con.Open(); } rowsAffacted = cmd.ExecuteNonQuery(); con.Close(); } } return(rowsAffacted); }
private void MemberAddress_GetAll() { DataTable dtMemberAddress; Model.MemberAddress memberAddress = new Model.MemberAddress() { MemberId = this.MemberId }; using (var scope = Startup.Container.BeginLifetimeScope()) { var MemberAddress = scope.Resolve <IMemberAddress>(); dtMemberAddress = MemberAddress.MemberAddress_GetAll(memberAddress); } gvAddress.DataSource = dtMemberAddress; gvAddress.DataBind(); }
public DataTable MemberAddress_GetAll(Model.MemberAddress memberAddress) { using (DataTable dt = new DataTable()) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_MemberAddress_GetAll"; if (memberAddress.MemberAddressDetailsId == 0) { cmd.Parameters.AddWithValue("@MemberAddressDetailsId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@MemberAddressDetailsId", memberAddress.MemberAddressDetailsId); } if (memberAddress.MemberId == 0) { cmd.Parameters.AddWithValue("@MemberId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@MemberId", memberAddress.MemberId); } if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
protected void btnAddressSave_Click(object sender, EventArgs e) { try { if (ValidateAddress()) { int response = 0; Model.MemberAddress memberAddress = new Model.MemberAddress() { MemberAddressDetailsId = this.MemberAddressDetailsId, MemberId = this.MemberId, Emirates = txtEmirates.Text.Trim(), LocalityId = int.Parse(ddlLocality.SelectedValue), ResidentialAddress = txtResidentialAddress.Text.Trim(), CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name), }; using (var scope = Startup.Container.BeginLifetimeScope()) { var MemberAddress = scope.Resolve <IMemberAddress>(); response = MemberAddress.MemberAddress_Save(memberAddress); } if (response > 0) { ClearAddressControls(); MemberAddress_GetAll(); MessageAddress.IsSuccess = true; MessageAddress.Text = "Saved Successfully"; } else { MessageAddress.IsSuccess = false; MessageAddress.Text = "Not saved."; } } } catch (Exception ex) { MessageAddress.IsSuccess = false; MessageAddress.Text = ex.Message; } finally { ModalPopupExtender1.Show(); } }
private void MemberAddress_GetById() { DataTable dtMemberAddress; Model.MemberAddress memberAddress = new Model.MemberAddress() { MemberAddressDetailsId = this.MemberAddressDetailsId, MemberId = this.MemberId }; using (var scope = Startup.Container.BeginLifetimeScope()) { var MemberAddress = scope.Resolve <IMemberAddress>(); dtMemberAddress = MemberAddress.MemberAddress_GetAll(memberAddress); } if (dtMemberAddress != null && dtMemberAddress.Rows.Count > 0) { txtResidentialAddress.Text = dtMemberAddress.Rows[0]["ResidentialAddress"].ToString(); txtEmirates.Text = dtMemberAddress.Rows[0]["Emirates"].ToString(); ddlLocality.SelectedValue = (dtMemberAddress.Rows[0]["LocalityId"] == DBNull.Value) ? "0" : dtMemberAddress.Rows[0]["LocalityId"].ToString(); } }
public DataTable MemberAddress_GetAll(Model.MemberAddress memberAddress) { return(_MemberAddress.MemberAddress_GetAll(memberAddress)); }
public int MemberAddress_Save(Model.MemberAddress memberAddress) { return(_MemberAddress.MemberAddress_Save(memberAddress)); }