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