public IActionResult UpdatePc(ProficiencySkills skills) { if (skills != null) { return(Ok(_baseStorage.UpdateSkills(skills))); } else { return(BadRequest()); } }
public bool AddSkills(ProficiencySkills skills) { using (var connection = new SqlConnection(conString)) { connection.Open(); var addSkills = connection.Execute(@"INSERT INTO [dbo].[Proficiency_Skills]([athletics],[acrobatics],[arcana],[animal_Handling] ,[deception],[history],[insight],[intimidation],[investigation],[medicine],[nature],[perception] ,[performance],[persuasion],[religion],[sleight_of_hand],[stealth],[survival],[owner_id]) VALUES(@athletics,@acrobatics,@arcana,@animal_Handling,@deception,@history,@insight ,@intimidation,@investigation,@medicine,@nature,@perception,@performance,@persuasion ,@religion,@sleight_of_hand,@stealth,@survival,@owner_id)", skills); return(addSkills == 1); } }
public ProficiencySkills GetRandomSkills() { using (var connection = new SqlConnection(conString)) { connection.Open(); var skills = connection.Query <ProficiencySkills>(@"select Top(1) * from Proficiency_Skills as p ORDER BY RAND()"); if (skills.Count() > 0) { var pcSkills = skills.ElementAt(0); return(pcSkills); } else { var pcSkills = new ProficiencySkills(); return(pcSkills); } } }
public ProficiencySkills GetSkills(int id) { using (var connection = new SqlConnection(conString)) { connection.Open(); var skills = connection.Query <ProficiencySkills>(@"select * from Proficiency_Skills as p Where p.owner_id = @id", new { id = id }); if (skills.Count() > 0) { var pcSkills = skills.ElementAt(0); return(pcSkills); } else { var pcSkills = new ProficiencySkills(); return(pcSkills); } } }
public bool UpdateSkills(ProficiencySkills skills) { using (var connection = new SqlConnection(conString)) { var result = connection.Execute(@"UPDATE [dbo].[Proficiency_Skills] SET [athletics] = @athletics,[acrobatics] = @acrobatics,[arcana] = @arcana,[animal_Handling] = @animal_Handling, [deception] = @deception,[history] = @history,[insight] = @insight,[intimidation] = @intimidation, [investigation] = @investigation,[medicine] = @medicine,[nature] = @nature,[perception] = @perception, [performance] = @performance,[persuasion] = @persuasion,[religion] = @religion,[sleight_of_hand] = @sleight_of_hand, [stealth] = @stealth,[survival] = @survival WHERE Proficiency_Skills.owner_id = @owner_id", new { owner_id = skills.owner_id, athletics = skills.athletics, acrobatics = skills.acrobatics, arcana = skills.arcana, animal_Handling = skills.animal_handling, deception = skills.deception, history = skills.history, insight = skills.insight, intimidation = skills.intimidation, investigation = skills.investigation, medicine = skills.medicine, nature = skills.nature, perception = skills.perception, performance = skills.performance, persuasion = skills.persuasion, religion = skills.religion, sleight_of_hand = skills.sleight_of_hand, stealth = skills.stealth, survival = skills.survival, }); return(result == 1); } }