/// <summary>
/// get record count by filePath
/// </summary>
/// <param name="filePath">file path</param>
/// <returns>count of record</returns>
internal int SelectCountByFilePath(string filePath)
{
int count = 0;
var sql = new SqlBuilder();
sql.AppendSql(" SELECT COUNT(id) FROM profiles")
.AppendSql("WHERE file_path = @file_path");
var paramList = new ParameterList();
paramList.Add("@file_path", filePath);
using (var database = new SystemDatabase()) {
database.Open();
using (var record = database.OpenRecordset(sql, paramList)) {
if (record.Read())
{
count = record.GetInt(0);
}
}
}
return(count);
}
/// <summary>
/// select id by file path
/// </summary>
/// <param name="filePath">file path</param>
/// <returns>profile id</returns>
internal int SelectIdByFilePath(string filePath)
{
var sql = new SqlBuilder();
sql.AppendSql(" SELECT id FROM profiles")
.AppendSql("WHERE file_path = @file_path");
var paramList = new ParameterList();
paramList.Add("@file_path", filePath);
int id = -1;
using (var database = new SystemDatabase()) {
database.Open();
using (var record = database.OpenRecordset(sql, paramList)) {
if (record.Read())
{
id = record.GetInt("id");
}
}
}
return(id);
}
