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