public int MemberTypeMemberMapping_Save(Model.MemberTypeMemberMapping memberTypeMemberMapping)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_MemberTypeMemberMapping_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MemberTypeMemberMappingId", memberTypeMemberMapping.MemberTypeMemberMappingId);
cmd.Parameters.AddWithValue("@MemberId", memberTypeMemberMapping.MemberId);
cmd.Parameters.AddWithValue("@MemberTypeId", memberTypeMemberMapping.MemberTypeId);
cmd.Parameters.AddWithValue("@CreatedBy", memberTypeMemberMapping.CreatedBy);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
private void MemberTypeMemberMapping_Save()
{
if (MemberTypeMemberMappingId != Convert.ToInt32(ddlMemberType.SelectedValue))
{
Model.MemberTypeMemberMapping memberTypeMemberMapping = new Model.MemberTypeMemberMapping()
{
MemberTypeMemberMappingId = MemberTypeMemberMappingId,
MemberId = this.MemberId,
MemberTypeId = Convert.ToInt32(ddlMemberType.SelectedValue),
CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name)
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var MemberTypeMemberMapping = scope.Resolve <IMemberTypeMemberMapping>();
MemberId = MemberTypeMemberMapping.MemberTypeMemberMapping_Save(memberTypeMemberMapping);
}
}
}
public int MemberTypeMemberMapping_Save(Model.MemberTypeMemberMapping memberTypeMemberMapping)
{
return(_MemberTypeMemberMapping.MemberTypeMemberMapping_Save(memberTypeMemberMapping));
}
