Exemple #1
0
        public async Task <Quest> Update(Quest Quest)
        {
            var result = await Task.FromResult(_dapper.Update <Quest>($"update Quest set XpReward = {Quest.XpReward}, GoldReward = {Quest.GoldReward}," +
                                                                      $"IsComplete = {(Quest.IsComplete ? 1 : 0)}, NpcId = {Quest.Npc.NpcId} where QuestId = {Quest.QuestId}", null, commandType: CommandType.Text));

            return(result);
        }
Exemple #2
0
        public async Task <Monster> Update(Monster monster)
        {
            var result = await Task.FromResult(_dapper.Update <Monster>($"update Monster set MonsterName = '{monster.MonsterName}', Level = {monster.Level}, Health = {monster.Health}," +
                                                                        $" MaxHealth = {monster.MaxHealth}, ZoneId = {monster.Zone.ZoneId} where MonsterId = {monster.MonsterId}", null, commandType: CommandType.Text));

            return(result);
        }
        public async Task <Event> Update(Event Event)
        {
            var result = await Task.FromResult(_dapper.Update <Event>($"update Event set EventSummary = '{Event.EventSummary}', EventAlreadyEncountered = {(Event.EventAlreadyEncountered ? 1 : 0)}, " +
                                                                      $" EventPassed = {(Event.EventPassed ? 1 : 0)}, MonsterId = {Event.Monster?.MonsterId.ToString() ?? "null"}, ItemId = {Event.Item?.ItemId.ToString() ?? "null"}, " +
                                                                      $"ZoneId = {Event.Zone.ZoneId} where EventId = {Event.EventId}", null, commandType: CommandType.Text));

            return(result);
        }
        public async Task <Npc> Update(Npc Npc)
        {
            var result = await Task.FromResult(_dapper.Update <Npc>($"update Npc set NpcName = '{Npc.NpcName}', IsMerchant = {(Npc.IsMerchant ? 1 : 0)}, " +
                                                                    $"GivesQuests = {(Npc.GivesQuests ? 1 : 0)} where NpcId = {Npc.NpcId}",
                                                                    null, commandType: CommandType.Text));

            return(result);
        }
        public async Task <Item> Update(Item item)
        {
            var result = await Task.FromResult(_dapper.Update <Item>($"update Item set ItemName = '{item.ItemName}', LevelRequirement = {item.LevelRequirement}, ItemType = '{item.ItemType}'," +
                                                                     $" Equipped = {(item.Equipped ? 1 : 0)}, StrengthBonus = {item.StrengthBonus}, DefenseBonus = {item.DefenseBonus}, HealthBonus = {item.HealthBonus}, PlayerId = {item.Player.PlayerId}" +
                                                                     $" where ItemId = {item.ItemId}",
                                                                     null, commandType: CommandType.Text));

            return(result);
        }
        public Task <int> Update(Teams team)
        {
            var dbPara = new DynamicParameters();

            dbPara.Add("TeamId", team.TeamId, DbType.Int32);
            dbPara.Add("Name", team.Name, DbType.String);
            dbPara.Add("Category", team.Category, DbType.String);
            var updateTeam = Task.FromResult(_dapperService.Update <int>("[dbo].[spUpdateTeams]", dbPara, commandType: CommandType.StoredProcedure));

            return(updateTeam);
        }
        public IActionResult SaveChanges(IFormCollection collection)
        {
            if (collection != null)
            {
                foreach (var item in collection)
                {
                    if (!string.IsNullOrWhiteSpace(item.Value) && item.Key != "formId")
                    {
                        _dapperService.Update <Feature, object>("[dbo].[Feature_UpdateClassifierId]", new { featureId = int.Parse(item.Key), classifierId = int.Parse(item.Value) });
                    }
                }
            }

            return(Redirect("RegPoz?regid=1"));
        }
Exemple #8
0
        public Task <int> Update(Player data)
        {
            var dbparams = new DynamicParameters();

            dbparams.Add("PlayerId", data.PlayerId, DbType.Int32);
            dbparams.Add("PlayerName", data.PlayerName, DbType.String);
            dbparams.Add("Level", data.Level, DbType.Int32);
            dbparams.Add("Health", data.Health, DbType.Int32);
            dbparams.Add("MaxHealth", data.MaxHealth, DbType.Int32);
            dbparams.Add("Strength", data.Strength, DbType.Int32);
            dbparams.Add("Defense", data.Defense, DbType.Int32);
            dbparams.Add("Gold", data.PlayerId, DbType.Int32);
            dbparams.Add("Experience", data.Experience, DbType.Int32);
            dbparams.Add("CurrentZoneId", data.CurrentZone.ZoneId, DbType.Int32);

            var updatePlayer = Task.FromResult(_dapper.Update <int>("[dbo].[SP_Update_Player]",
                                                                    dbparams,
                                                                    commandType: CommandType.StoredProcedure));

            return(updatePlayer);
        }
        public ActionResult Index()
        {
            var sb = new StringBuilder("Dapper service\n");

            int usersBefore = _repo.GetUsers().Count;

            sb.Append($"Users before: {usersBefore}\n");

            var user = new User
            {
                Age       = 18,
                Email     = "*****@*****.**",
                IsMarried = false,
                Name      = "some123",
                Sex       = "male"
            };

            _repo.Create(user);
            sb.Append($"Create user: {user.Id}\n");

            int usersAfter = _repo.GetUsers().Count;

            sb.Append($"Users after: {usersAfter}\n");

            user.Name = "Username123";
            _repo.Update(user);

            User dbUser = _repo.Get(user.Id);

            sb.Append($"Update user: {dbUser.Name}\n");

            _repo.Delete(dbUser.Id);
            sb.Append("Delete user\n");

            int usersAfterDel = _repo.GetUsers().Count;

            sb.Append($"Users after delete: {usersAfterDel}\n");

            return(Content(sb.ToString()));
        }
        public async Task <Zone> Update(Zone zone)
        {
            var result = await Task.FromResult(_dapper.Update <Zone>($"update Zone set ZoneName = '{zone.ZoneName}' where ZoneId = {zone.ZoneId}", null, commandType: CommandType.Text));

            return(result);
        }