public static UserSkillsOutputModel ToOutputModel(CourseProgramSkill skill)
{
return(new UserSkillsOutputModel
{
SkillId = (int)skill.Id,
Name = skill.Name
});
}
private async Task CourseProgramSkillTestDelete(CourseProgramSkill CourseProgramSkillToDelete)
{
List <CourseProgramSkill> actualCPS1 = await courseStorage.CourseProgramSkillsGetAll();
await courseStorage.CourseProgramSkillDelete(CourseProgramSkillToDelete);
List <CourseProgramSkill> actualCPS2 = await courseStorage.CourseProgramSkillsGetAll();
Assert.AreEqual(actualCPS1.Count() - 1, actualCPS2.Count());
Assert.False(actualCPS2.Contains(CourseProgramSkillToDelete));
}
private async Task TestSelects()
{
List <CourseProgramSkill> actualList = await courseStorage.CourseProgramSkillsGetAll();
for (int i = 0; i < listCourseProgramSkill.Count; i++)
{
Assert.Contains(listCourseProgramSkill[i], actualList);
}
CourseProgramSkill actual = await courseStorage.CourseProgramSkillGetById((int)listCourseProgramSkill[0].Id);
Assert.AreEqual(listCourseProgramSkill[0], actual);
}
public async Task <int> CourseProgramSkillAddOrUpdate(CourseProgramSkill newSkill)
{
try
{
if (newSkill.Id.HasValue)
{
var result = await connection.QueryAsync <decimal>(
SpName.CourseProgramSkillUpdate,
new
{
newSkill.Id,
newSkill.CourseProgramId,
newSkill.Name
},
dbTransaction,
commandType : CommandType.StoredProcedure
);
return(Convert.ToInt32(result.FirstOrDefault()));
}
else
{
var result = await connection.QueryAsync <decimal>(
SpName.CourseProgramSkillInsert,
new
{
newSkill.CourseProgramId,
newSkill.Name
},
dbTransaction,
commandType : CommandType.StoredProcedure
);
return(Convert.ToInt32(result.FirstOrDefault()));
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}
public async Task <int?> CourseProgramSkillDelete(CourseProgramSkill skill)
{
try
{
var result = await connection.QueryAsync <decimal>(
SpName.CourseProgramSkillDelete,
new
{
skill.CourseProgramId,
skill.Name
},
dbTransaction,
commandType : CommandType.StoredProcedure
);
return(Convert.ToInt32(result.FirstOrDefault()));
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}
//Удалить CourseProgramSkill
public async Task <int?> CourseProgramSkillDelete([FromBody] CourseProgramSkill model)
{
return(await courseStorage.CourseProgramSkillDelete(model));
}
