/// <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 void UpdateLevel(Level level)
{
using (var db = new SqlConnection(_connectionString))
{
var parameters = new
{
level.Name,
level.Description
};
var sql = SqlCrudHelper.GetUpdateStatement(parameters, level.GetType().Name);
sql += " WHERE LevelId = @LevelId";
db.Execute(sql, level);
}
}
public bool UpdateOrganisation(Organisation organisation)
{
using (var db = new SqlConnection(_connectionString))
{
var parameters = new
{
organisation.OrganisationName
};
var sql = SqlCrudHelper.GetUpdateStatement(parameters, organisation.GetType().Name);
sql += " WHERE OrganisationId = @OrganisationId";
var result = db.Execute(sql, parameters);
var boolResult = result == 1 ? true : false;
return(boolResult);
}
}
public void UpdateTargetZone(TargetZone targetZone)
{
using (var db = new SqlConnection(_connectionString))
{
var parameters = new
{
targetZone.TargetZoneShape,
targetZone.TargetZoneX,
targetZone.TargetZoneY,
targetZone.TargetZoneZ
};
var sql = SqlCrudHelper.GetUpdateStatement(parameters, targetZone.GetType().Name);
sql += " WHERE TargetZoneId = @TargetZoneId";
db.Execute(sql, targetZone);
}
}
public void UpdateLevelConfiguration(LevelConfiguration levelConfiguration)
{
using (var db = new SqlConnection(_connectionString))
{
var parameters = new
{
levelConfiguration.Name,
levelConfiguration.Description,
levelConfiguration.TargetSpawnDelay,
levelConfiguration.TargetLifespan,
levelConfiguration.IsPublic
};
var sql = SqlCrudHelper.GetUpdateStatement(parameters, levelConfiguration.GetType().Name);
sql += " WHERE LevelConfigurationId = @LevelConfigurationId";
db.Execute(sql, levelConfiguration);
}
}
public bool UpdateUserAccount(UserAccount userAccount)
{
using (var db = new SqlConnection(_connectionString))
{
var parameters = new
{
userAccount.Name,
userAccount.EmailAddress,
userAccount.Salt,
userAccount.Hash
};
var sql = SqlCrudHelper.GetUpdateStatement(parameters, userAccount.GetType().Name);
sql += " WHERE UserAccountId = @UserAccountId";
var result = db.Execute(sql, userAccount);
var boolResult = result == 1 ? true : false;
return(boolResult);
}
}
public void UpdateTarget(Target target)
{
using (var db = new SqlConnection(_connectionString))
{
var parameters = new
{
target.TargetShape,
target.TargetX,
target.TargetY,
target.TargetZ,
target.OffsetX,
target.OffsetY,
target.OffsetZ
};
var sql = SqlCrudHelper.GetUpdateStatement(parameters, target.GetType().Name);
sql += " WHERE TargetId = @TargetId";
db.Execute(sql, target);
}
}
