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