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