/// <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 CreatePasswordReset(PasswordReset passwordReset)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    passwordReset.UserAccountId
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, passwordReset.GetType().Name, "PasswordResetId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }
示例#3
0
        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);
            }
        }
示例#4
0
        public Guid CreateLevel(Level level)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    level.Name,
                    level.Description
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, level.GetType().Name, "LevelId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }
示例#5
0
        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);
            }
        }
示例#6
0
        public Guid CreateOrganisation(Organisation organisation)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    organisation.OrganisationName,
                    organisation.CreatedById
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, organisation.GetType().Name, "OrganisationId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }
示例#7
0
        public Guid CreateScoreboard(Scoreboard scoreboard)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    scoreboard.UserAccountId,
                    scoreboard.LevelConfigurationId,
                    scoreboard.Score
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, scoreboard.GetType().Name, "ScoreboardId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }
        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 Guid CreateTargetAppearance(TargetAppearance targetAppearance)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    targetAppearance.TargetId,
                    targetAppearance.ScoreboardId,
                    targetAppearance.TargetUptime,
                    targetAppearance.WasMissed
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, targetAppearance.GetType().Name, "TargetAppearanceId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }
        public Guid CreateTargetZone(TargetZone targetZone)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    targetZone.TargetZoneShape,
                    targetZone.TargetZoneX,
                    targetZone.TargetZoneY,
                    targetZone.TargetZoneZ
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, targetZone.GetType().Name, "TargetZoneId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }
示例#11
0
        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 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);
            }
        }
示例#13
0
        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);
            }
        }
        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 Guid CreateUserAccount(UserAccount userAccount)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    userAccount.UserAccountId,
                    userAccount.Name,
                    userAccount.EmailAddress,
                    userAccount.Salt,
                    userAccount.Hash,
                    userAccount.CreatedDate,
                    userAccount.IsDeleted
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, userAccount.GetType().Name, "UserAccountId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }
示例#16
0
        public Guid CreateTarget(Target target)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    target.LevelConfigurationId,
                    target.TargetShape,
                    target.TargetX,
                    target.TargetY,
                    target.TargetZ,
                    target.OffsetX,
                    target.OffsetY,
                    target.OffsetZ
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, target.GetType().Name, "TargetId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }
示例#17
0
        public Guid CreateLevelConfiguration(LevelConfiguration levelConfiguration)
        {
            using (var db = new SqlConnection(_connectionString))
            {
                var parameters = new
                {
                    levelConfiguration.LevelId,
                    levelConfiguration.OrganisationId,
                    levelConfiguration.CreatedById,
                    levelConfiguration.Name,
                    levelConfiguration.Description,
                    levelConfiguration.TargetSpawnDelay,
                    levelConfiguration.TargetLifespan,
                    levelConfiguration.IsPublic
                };

                var sql = SqlCrudHelper.GetInsertStatement(parameters, levelConfiguration.GetType().Name, "LevelConfigurationId");

                Guid newId = db.ExecuteScalar <Guid>(sql, parameters);

                return(newId);
            }
        }