private void LoadBase()
{
SQLHandler sqlHand = new SQLHandler(_dbFolderPath);
var tableList = sqlHand.GetTables();
foreach (var tableName in tableList)
{
if (tableName.Contains("TEXT"))
{
var textList = sqlHand.GetList(
tableName: tableName,
returnField: "TEXT");
_textList.Add(tableName.Replace("TEXT_", string.Empty), textList);
}
if (tableName.Contains("URL"))
{
var urlList = sqlHand.GetList(
tableName: tableName,
returnField: "URL");
_urlList.Add(tableName.Replace("URL_", string.Empty), urlList);
}
}
}
private void LoadBase(object chatId)
{
SQLHandler sqlHand = new SQLHandler(_dbFolderPath);
_tDataList = sqlHand.GetList <TData>(
tableName: chatId.ToString());
foreach (var tData in _tDataList)
{
tData.DataID = tData.UserID.Length * tData.Words.Length;
}
}
private void LoadBase()
{
SQLHandler sqlHand = new SQLHandler(_dbFolderPath);
var tableList = sqlHand.GetTables();
foreach (var tableName in tableList)
{
var textList = sqlHand.GetList(
tableName: tableName,
returnField: "TEXT");
_textList.Add(tableName, textList);
}
}