/// <summary>
/// insert profile data
/// </summary>
/// <param name="model">insert data</param>
/// <returns>row id</returns>
internal long Insert(ProfileModel model)
{
var sql = new SqlBuilder();
sql.AppendSql("INSERT INTO profiles")
.AppendSql("(")
.AppendSql(" file_path")
.AppendSql(",display_name")
.AppendSql(",row_order")
.AppendSql(")")
.AppendSql("VALUES")
.AppendSql("(")
.AppendSql(" @file_path")
.AppendSql(",@display_name")
.AppendSql(",@row_order")
.AppendSql(")");
var paramList = new ParameterList();
paramList.Add("@file_path", model.FilePath);
paramList.Add("@display_name", model.DisplayName);
paramList.Add("@row_order", model.RowOrder);
var id = -1L;
using (var database = new SystemDatabase()) {
database.Open();
id = database.Insert(sql, paramList);
}
return(id);
}
/// <summary>
/// delete by id
/// </summary>
/// <param name="id">id</param>
/// <returns>delete record count</returns>
internal int DeleteById(long id)
{
var sql = new SqlBuilder();
sql.AppendSql("DELETE FROM profiles")
.AppendSql("WHERE id = @id");
var paramList = new ParameterList();
paramList.Add("@id", id);
var count = 0;
using (var database = new SystemDatabase()) {
database.Open();
count = database.ExecuteNonQuery(sql, paramList);
}
return(count);
}
/// <summary>
/// update display name by id
/// </summary>
/// <param name="model">profile model</param>
/// <returns>affected record count</returns>
internal int UpdateDisplayNameById(ProfileModel model)
{
var sql = new SqlBuilder();
sql.AppendSql("UPDATE profiles SET")
.AppendSql(" display_name = @display_name")
.AppendSql("WHERE id = @id");
var paramList = new ParameterList();
paramList.Add("@display_name", model.DisplayName)
.Add("@id", model.Id);
var count = 0;
using (var database = new SystemDatabase()) {
database.Open();
count = database.ExecuteNonQuery(sql, paramList);
}
return(count);
}
/// <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);
}
