public string GetString(string tableName, string returnField, List <string> filerList = null)
{
try
{
СonnectToDatabase();
_sqlBuilder.Append($"SELECT * FROM '{ tableName }'");
if (filerList != null)
{
foreach (var filter in filerList)
{
_sqlBuilder.Append($" { WhereOrAnd() } { filter }");
}
}
SQLiteCommand command = new SQLiteCommand(_sqlBuilder.ToString(), m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
reader.Read();
return(reader[returnField].ToString());
}
catch (Exception ex)
{
InformationCollector.Error(tableName, ex.Message);
return(string.Empty);
}
finally
{
DisconnectFromDatabase();
}
}
public void CreateTable(string tableName, List <string> fields)
{
try
{
СonnectToDatabase();
var tableNames = string.Empty;
foreach (var field in fields)
{
tableNames += field;
if (field != fields.Last())
{
tableNames += ", ";
}
}
_sqlBuilder.Append($"CREATE TABLE '{ tableName }' ({ tableNames })");
SQLiteCommand command = new SQLiteCommand(_sqlBuilder.ToString(), m_dbConnection);
command.ExecuteNonQuery();
DisconnectFromDatabase();
}
catch (Exception ex)
{
InformationCollector.Error(tableName, ex.Message);
}
}
public static void WriteStringToFile(string text, string path, bool encoding = false)
{
try
{
StreamWriter fs = new StreamWriter(path, true, (!encoding) ? System.Text.Encoding.GetEncoding(1251) : System.Text.Encoding.GetEncoding(65001));
fs.Write(text);
fs.Close();
}
catch (Exception e) { InformationCollector.Error("ReadFileToArray", e.Message); }
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
try
{
Application.Run(new MainForm());
}
catch (Exception e)
{
InformationCollector.Error(e.Source, e.Message);
}
}
public static string ReadFileToString(string path, bool encoding = false)
{
string result = string.Empty;
try
{
StreamReader fs = new StreamReader(path, (!encoding) ? System.Text.Encoding.GetEncoding(1251) : System.Text.Encoding.GetEncoding(65001));
result = fs.ReadToEnd();
fs.Close();
}
catch (Exception e) { InformationCollector.Error("ReadFileToArray", e.Message); }
return(result);
}
public List <T> GetList <T>(string tableName) where T : new()
{
try
{
var list = new List <T>();
var dict = new Dictionary <string, object>();
var fields = Converters.GetProperties <T>();
СonnectToDatabase();
_sqlBuilder.Append($"SELECT * FROM '{ tableName }'");
SQLiteCommand command = new SQLiteCommand(_sqlBuilder.ToString(), m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
dict.Clear();
foreach (var field in fields)
{
var _data = reader[field];
if (_data.GetType() == typeof(DBNull))
{
continue;
}
if (_data.GetType() == typeof(long))
{
_data = Convert.ToInt32(_data);
}
dict.Add(field, _data);
}
T data = new T();
list.Add(data);
Converters.SetProperties(data, dict);
}
return(list);
}
catch (Exception ex)
{
InformationCollector.Error(tableName, ex.Message);
return(new List <T>());
}
finally
{
DisconnectFromDatabase();
}
}
public void SetString(string tableName, string key, string value)
{
try
{
СonnectToDatabase();
_sqlBuilder.Append($"INSERT INTO '{ tableName }' ({ key }) VALUES ('{ value }')");
SQLiteCommand command = new SQLiteCommand(_sqlBuilder.ToString(), m_dbConnection);
command.ExecuteNonQuery();
DisconnectFromDatabase();
}
catch (Exception ex)
{
InformationCollector.Error(tableName, ex.Message);
}
}
public static List <string> ReadFileToArray(string path, bool encoding = false)
{
List <string> result = new List <string>();
try
{
StreamReader fs = new StreamReader(path, (!encoding) ? System.Text.Encoding.GetEncoding(1251) : System.Text.Encoding.GetEncoding(65001));
string line = fs.ReadLine();
while (line != null)
{
result.Add(line);
line = fs.ReadLine();
}
fs.Close();
}
catch (Exception e) { InformationCollector.Error("ReadFileToArray", e.Message); }
return(result);
}
public List <string> GetTables()
{
try
{
СonnectToDatabase();
DataTable schema = m_dbConnection.GetSchema("Tables");
DisconnectFromDatabase();
List <string> tableNames = new List <string>();
foreach (DataRow row in schema.Rows)
{
tableNames.Add(row[2].ToString());
}
return(tableNames);
}
catch (Exception ex)
{
InformationCollector.Error(string.Empty, ex.Message);
return(new List <string>());
}
}
public string GetBoltunData(Mode mode, string str, string table, string like = null)
{
try
{
СonnectToDatabase();
switch (mode)
{
case Mode.NOLIKE:
_sqlBuilder.Append("SELECT * FROM '" + table + "' WHERE q='" + str + "'");
break;
case Mode.RANDOM:
_sqlBuilder.Append("SELECT * FROM '" + table + "' ORDER BY RANDOM() LIMIT 1");
break;
case Mode.LIKE:
_sqlBuilder.Append("SELECT * FROM '" + table + "' WHERE 'q' LIKE '%" + like + "%'");
break;
default:
break;
}
InformationCollector.Log("ConnectionToSQL\nstr: " + str + "\ntable: " + table + "\nlike: " + like);
SQLiteCommand command = new SQLiteCommand(_sqlBuilder.ToString(), m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
List <string> answers = new List <string>();
int i = 0;
reader.Read();
InformationCollector.Log("ConnectionToSQL\nreader.GetString(1): " + reader.GetString(1));
while (reader.GetString(1) != string.Empty)
{
answers.Add(reader.GetString(1));
i++;
reader.Read();
}
if (i == 1)
{
return(answers[0]);
}
else if (i > 1)
{
return(answers[RNG.Next(0, i)]);
}
else
{
return(string.Empty);
}
}
catch (Exception ex)
{
InformationCollector.Error(table, ex.Message);
return(string.Empty);
}
finally
{
DisconnectFromDatabase();
}
}