/// <summary>
/// Only for changing a user's role in the organisation
/// </summary>
/// <param name="organisationMembership"></param>
public void UpdateOrganisationMembership(OrganisationMembership organisationMembership)
{
using (var db = new SqlConnection(_connectionString))
{
var parameters = new
{
organisationMembership.UserType
};
var sql = SqlCrudHelper.GetUpdateStatement(parameters, organisationMembership.GetType().Name);
sql += " WHERE OrganisationMembershipId = @OrganisationMembershipId";
db.Execute(sql, organisationMembership);
}
}
public Guid CreateOrganisationMembership(OrganisationMembership organisationMembership)
{
using (var db = new SqlConnection(_connectionString))
{
var parameters = new
{
organisationMembership.OrganisationId,
organisationMembership.UserAccountId,
organisationMembership.UserType,
organisationMembership.OrganisationInviteId
};
var sql = SqlCrudHelper.GetInsertStatement(parameters, organisationMembership.GetType().Name, "OrganisationMembershipId");
Guid newId = db.ExecuteScalar <Guid>(sql, parameters);
return(newId);
}
}
