private int GetCurrRespondentId()
{
var query = " select Respondents.id " +
" from main.Respondents " +
" where Respondents.FIO = '" + InterView.GetRespondentName() + "'" +
"and Respondents.birthday = '" + InterView.GetBirthDate() + "'";
try
{
var respondentId = DbConnection.SelectScalarFromDb(query);
return(Convert.ToInt32(respondentId));
}
catch (Exception exp)
{
throw new Exception(exp.ToString());
}
}
private int CheckOrInsertRespondentAndGetId()
{
var respondentIdRow = CheckRespondentAndGetId(InterView.GetRespondentName(), InterView.GetBirthDate());
if (respondentIdRow.Rows.Count == 0)
{
var respondentId = GetNewTableIndexId("main.Respondents");
if (respondentId != 0)
{
var query = "insert into main.Respondents(id, FIO, birthday) values( '" + respondentId +
"', '" + InterView.GetRespondentName() + "', '" + InterView.GetBirthDate() + "')";
DbConnection.DmlOperation(query);
return(respondentId);
}
}
return(Convert.ToInt16(respondentIdRow.Rows[0][0]));
}