public int MemberRelationMapping_Save(Model.MemberRelationMapping memberRelationMapping)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_MemberRelationMapping_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MemberRelationMappingId", memberRelationMapping.MemberRelationMappingId);
cmd.Parameters.AddWithValue("@FirstMemberId", memberRelationMapping.FirstMemberId);
cmd.Parameters.AddWithValue("@SecondMemberId", memberRelationMapping.SecondMemberId);
cmd.Parameters.AddWithValue("@RelationId", memberRelationMapping.RelationId);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
private void MemberRelationMapping_GetAll()
{
DataTable dtRelation;
Model.MemberRelationMapping memberRelationMapping = new Model.MemberRelationMapping()
{
FirstMemberId = this.MemberId
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var MemberRelationMapping = scope.Resolve <IMemberRelationMapping>();
dtRelation = MemberRelationMapping.MemberRelationMapping_GetAll(memberRelationMapping);
}
gvRelation.DataSource = dtRelation;
gvRelation.DataBind();
}
public DataTable MemberRelationMapping_GetAll(Model.MemberRelationMapping memberRelationMapping)
{
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_MemberRelationMapping_GetAll";
if (memberRelationMapping.MemberRelationMappingId == 0)
{
cmd.Parameters.AddWithValue("@MemberRelationMappingId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@MemberRelationMappingId", memberRelationMapping.MemberRelationMappingId);
}
if (memberRelationMapping.FirstMemberId == 0)
{
cmd.Parameters.AddWithValue("@MemberId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@MemberId", memberRelationMapping.FirstMemberId);
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
private void MemberRelationMapping_GetById()
{
DataTable dtRelation;
Model.MemberRelationMapping memberRelationMapping = new Model.MemberRelationMapping()
{
MemberRelationMappingId = this.MemberRelationMappingId,
FirstMemberId = this.MemberId
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var MemberRelationMapping = scope.Resolve <IMemberRelationMapping>();
dtRelation = MemberRelationMapping.MemberRelationMapping_GetAll(memberRelationMapping);
}
if (dtRelation != null && dtRelation.Rows.Count > 0)
{
ddlPerson.SelectedValue = dtRelation.Rows[0]["SecondMemberId"].ToString();
ddlRelation.SelectedValue = dtRelation.Rows[0]["RelationId"].ToString();
}
}
protected void btnRelationSave_Click(object sender, EventArgs e)
{
try
{
if (ValidateRelation())
{
int response = 0;
Model.MemberRelationMapping memberRelationMapping = new Model.MemberRelationMapping()
{
FirstMemberId = MemberId,
MemberRelationMappingId = this.MemberRelationMappingId,
RelationId = int.Parse(ddlRelation.SelectedValue),
SecondMemberId = int.Parse(ddlPerson.SelectedValue)
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var MemberRelationMapping = scope.Resolve <IMemberRelationMapping>();
response = MemberRelationMapping.MemberRelationMapping_Save(memberRelationMapping);
}
if (response > 0)
{
ClearMemberRelationMappingControls();
MemberRelationMapping_GetAll();
MessageRelation.IsSuccess = true;
MessageRelation.Text = "Saved Successfully";
}
else
{
MessageRelation.IsSuccess = false;
MessageRelation.Text = "Not saved.";
}
}
}
catch (Exception ex)
{
MessageRelation.IsSuccess = false;
MessageRelation.Text = ex.Message;
}
finally { ModalPopupExtender1.Show(); }
}
public DataTable MemberRelationMapping_GetAll(Model.MemberRelationMapping memberRelationMapping)
{
return(_MemberRelationMapping.MemberRelationMapping_GetAll(memberRelationMapping));
}
public int MemberRelationMapping_Save(Model.MemberRelationMapping memberRelationMapping)
{
return(_MemberRelationMapping.MemberRelationMapping_Save(memberRelationMapping));
}