public bool ExecuteCommands_Insert <T>(DataModelFactory <T> dataModelFactory, List <T> dataModels) where T : DataModel
{
if (!dataModels.Any())
{
return(false);
}
var sqliteCommands = new List <SqliteCommand>();
for (int i = 0; i < dataModels.Count; i++)
{
sqliteCommands.Add(dataModelFactory.GetCommand_Insert(dataModels[i] as T));
}
ExecuteCommands_Insert(sqliteCommands);
return(true);
}
public bool CreateAndPopulateTableIfNotExists <T>(DataModelFactory <T> dataModelFactory, List <T> dataModels) where T : DataModel
// public bool CreateAndPopulateTableIfNotExists(IDataModelFactory dataModelFactory, List<IDataModel> dataModels)
{
if (DoesExist_Table(dataModelFactory.TableName))
{
return(false);
}
CreateTableIfNotExists(dataModelFactory);
if (dataModels != null)
{
LogInDebugMode($"Generated {dataModels.Count} Rows");
return(ExecuteCommands_Insert(dataModelFactory, dataModels));
}
return(true);
}
/*
* public void ExecuteReader_BasicSelect<T>(DataModelFactory<T> modelFactory, bool selectAll = true, int pageSize = 0, int startIndex = 0) where T : DataModel
* {
* modelFactory.DataModels.Clear();
*
* var query = modelFactory.GetCommandText_BasicSelect(selectAll, pageSize, startIndex);
*
* try
* {
* using (var dbConnection = new SqliteConnection(Connection))
* {
* dbConnection.Open();
*
* using (var dbCmd = dbConnection.CreateCommand())
* {
* dbCmd.CommandText = query;
*
* using (var reader = dbCmd.ExecuteReader())
* {
* int index;
* while (reader.Read())
* {
* index = 0;
* modelFactory.GenerateAndGetDataModel(reader, ref index);
* }
* reader.Close();
* }
* }
*
* dbConnection.Close();
* }
* }
* catch (Exception ex)
* {
* LogSQLQueryErrorInDebugMode(query, ex);
* }
* }
*/
public virtual List <T> ExecuteReader_Select <T>(DataModelFactory <T> modelFactory, List <DataModel.IDataModelColumn> parameters = null, int pageSize = 0, int startIndex = 0) where T : DataModel
{
var result = new List <T>();
var query = modelFactory.GetCommandText_Select(parameters, pageSize, startIndex);
try
{
using (var dbConnection = new SqliteConnection(Connection))
{
dbConnection.Open();
using (var dbCmd = dbConnection.CreateCommand())
{
dbCmd.CommandText = query;
if (parameters != null)
{
for (int i = 0; i < parameters.Count; i++)
{
dbCmd.Parameters.Add(parameters[i].ToParameter());
}
}
using (var reader = dbCmd.ExecuteReader())
{
int index;
while (reader.Read())
{
index = 0;
result.Add(modelFactory.GenerateAndGetDataModel(reader, ref index));
}
reader.Close();
}
}
dbConnection.Close();
}
}
catch (Exception ex)
{
LogSQLQueryErrorInDebugMode(query, ex);
}
return(result);
}
public bool ExecuteCommands_Insert <T>(DataModelFactory <T> dataModelFactory, T dataModel) where T : DataModel
{
return(ExecuteCommands_Insert <T>(dataModelFactory, new List <T> {
dataModel
}));
}
public void ExecuteCommand_Insert <T>(DataModelFactory <T> dataModelFactory, T dataModel) where T : DataModel
{
ExecuteCommand_Insert(dataModelFactory.GetCommand_Insert(dataModel));
}
public bool CreateAndPopulateTableIfNotExists <T>(DataModelFactory <T> dataModelFactory) where T : DataModel
{
var presets = dataModelFactory.GeneratePresets();
return(CreateAndPopulateTableIfNotExists(dataModelFactory, presets));
}