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