public void Insert(Device entity)
{
var sqlInsert = @"
insert into devices(moniker_string,cod_nome,width,height)
values(@MonikerString,@CodNome,@Width,@Height);";
var sqlIdent = @"select last_insert_rowid();";
using (var cnn = _context.NewConnection())
{
cnn.Open();
cnn.Execute(sqlInsert, Bind(entity));
entity.Id = cnn.Query <int>(sqlIdent, null).First();
}
}
public void Insert(Configuration entity)
{
var sqlInsert = @"
insert into configuration(time_interval,
enable_interval,enable_server,enable_compress_video,view_date_time,
path_save_video,frame_rate,bit_rate,legend_align,font_family,font_size,
enable_start,enable_start_minimized,folder_format,separate_registers_cameras)
values(@TimeInterval,@EnableInterval,@EnableServer,@EnableCompressVideo,
@ViewLegend,@PathSaveVideo,@FrameRate,@BitRate,@LegendAlign,@FontFamily,
@FontSize,@EnableStart,@EnableStartMinimized,@FolderFormat,@SeparateRegistersCameras);";
var sqlIdent = @"select last_insert_rowid();";
using (var cnn = _context.NewConnection())
{
using (var command = new SQLiteCommand(sqlInsert, cnn))
{
cnn.Open();
cnn.Execute(sqlInsert, Bind(entity));
entity.Id = cnn.Query <int>(sqlIdent, null).First();
}
}
}
