public bool hasDocument(string fileName, int documentType )
{
Int32 count = 0;
String sql = "SELECT count(*) FROM "
+ DocumentBean._TABLE_NAME
+ " WHERE "
+ DocumentBean._DOCUMENT_NAME
+ "=? AND "
+ DocumentBean._DOCUMENT_TYPE_ID
+ "=?";
OleDbParameter[] parameters = { new OleDbParameter(DocumentBean._DOCUMENT_NAME, fileName),
new OleDbParameter(DocumentBean._DOCUMENT_TYPE_ID, documentType) };
OleDbDataReader reader = ExecuteSqlQuery(sql, parameters);
if (reader != null)
{
if (reader.Read())
{
count = reader.GetInt32(0);
}
reader.Close();
reader.Dispose();
}
return count > 0;
}