public bool Update(Dto model)
{
bool toReturn = false;
var entity = MapDtoToEntity(model);
var command = SQLiteUtils.UpdateCommand <Entity>(tableName, entity);
OnPreSave?.Invoke(new OnPreSaveArgs <Dto>(model));
var connection = new SQLiteConnection(_connectionString);
try
{
connection.Open();
command.Connection = connection;
command.ExecuteNonQuery();
}
catch (Exception ex)
{
toReturn = false;
OnError?.Invoke(new OnErrorArgs <Dto>(model, ex, OnErrorType.Update));
}
finally
{
connection.Clone();
OnPostSave?.Invoke(new OnPostSaveArgs <Dto>(model, toReturn));
}
return(toReturn);
}
public IEnumerable <Dto> GetAll()
{
var command = new SQLiteCommand($"SELECT * FROM {tableName}");
List <Dto> dtos = new List <Dto>();
var connection = new SQLiteConnection(_connectionString);
try
{
connection.Open();
command.Connection = connection;
var reader = command.ExecuteReader();
List <Entity> entities = SQLiteUtils.ReadEntities <Entity>(reader);
foreach (var e in entities)
{
var dto = MapEntityToDto(e);
dtos.Add(dto);
}
}
catch (Exception ex)
{
OnError?.Invoke(new OnErrorArgs <Dto>(default(Dto), ex, OnErrorType.Get));
}
finally
{
connection.Close();
}
return(dtos);
}
public bool CreateTable()
{
bool toReturn = false;
var command = SQLiteUtils.CreateTableCommant <Entity>(tableName);
var connection = new SQLiteConnection(_connectionString);
connection.Open();
command.Connection = connection;
command.ExecuteNonQuery();
connection.Close();
toReturn = true;
return(toReturn);
}
