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