private void AttestationThemeTestSelects()
{
List <AttestationTheme> listActual = dictionaryStorage.AttestationThemeGetAll().Result;
for (int i = 0; i < listAttestationTheme.Count; i++)
{
Assert.Contains(listAttestationTheme[i], listActual);
}
AttestationTheme actualAttestationTheme = dictionaryStorage.AttestationThemeGetByID((int)listAttestationTheme[0].Id).Result;
Assert.AreEqual(listAttestationTheme[0], actualAttestationTheme);
}
private void AttestationThemeSetup()
{
foreach (AttestationTheme item in DictionaryMocks.AttestationThemeMocks)
{
AttestationTheme newAttestationTheme = (AttestationTheme)item.Clone();
newAttestationTheme.Id = null;
listAttestationTheme.Add(newAttestationTheme);
}
for (int i = 0; i < listAttestationTheme.Count; i++)
{
int id = (int)dictionaryStorage.AttestationThemeAddOrUpdate(listAttestationTheme[i]).Result;
listAttestationTheme[i].Id = id;
}
}
private async Task AttestationThemeTestUpdate()
{
AttestationTheme attestationTheme = listAttestationTheme[0];
attestationTheme.Theme = "Вышивание крестиком";
await dictionaryStorage.AttestationThemeAddOrUpdate(attestationTheme);
AttestationTheme attestationTheme1 = dictionaryStorage.AttestationThemeGetByID((int)attestationTheme.Id).Result;
Assert.AreEqual(attestationTheme, attestationTheme1);
AttestationTheme attestationTheme2 = dictionaryStorage.AttestationThemeGetByID((int)listAttestationTheme[1].Id).Result;
Assert.AreEqual(listAttestationTheme[1], attestationTheme2);
}
public async Task <int?> AttestationThemeAddOrUpdate(AttestationTheme model)
{
{
try
{
if (model.Id.HasValue)
{
var result = await connection.QueryAsync <int>(
SpName.AttestationThemeUpdate,
new
{
model.Id,
model.CourseId,
model.Theme
},
dbTransaction,
commandType : CommandType.StoredProcedure);
return(result.FirstOrDefault());
}
else
{
var result = await connection.QueryAsync <int>(
SpName.AttestationThemeInsert,
new
{
model.CourseId,
model.Theme
},
dbTransaction,
commandType : CommandType.StoredProcedure);
return(result.FirstOrDefault());
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}
}