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