public bool CheckIsOnline(OTHER.Configuration.ColumnNameTableOnline ColumnNameForReturn, string id, OTHER.Configuration.ColumnNameTableOnline ColumnNameForFind)
{
if (_tableOnline.getRow(ColumnNameForReturn, id, ColumnNameForFind) != null)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Возращаем строку из таблицы Онлайн
/// </summary>
/// <param name="ColumnNameForReturn">Колонка, строку которой возратим</param>
/// <param name="value">Значение по которому ищем</param>
/// <param name="ColumnNameForFind">Колонка по значениям которой ищем строку</param>
/// <returns></returns>
public string getRow(OTHER.Configuration.ColumnNameTableOnline ColumnNameForReturn, string value, OTHER.Configuration.ColumnNameTableOnline ColumnNameForFind)
{
//Console.WriteLine("ENUM^ " + ColumnNameForReturn + " " + ColumnNameForFind + " " + ColumnName.Idvk);
int ord;
using (SQLiteConnection connection = new SQLiteConnection(string.Format("Data Source={0};", Directory.GetCurrentDirectory() + OTHER.Configuration.databaseName)))
using (SQLiteCommand command = new SQLiteCommand(connection))
{
connection.Open();
if (ColumnNameForFind == OTHER.Configuration.ColumnNameTableOnline.Idvk)
{
command.CommandText = @"select idvk,lastmsg from online where idvk=" + value + "";
}
if (ColumnNameForFind == OTHER.Configuration.ColumnNameTableOnline.Lastmsg)
{
command.CommandText = @"select idvk,lastmsg from online where lastmsg='" + value + "'";
}
command.ExecuteNonQuery();
using (var reader = command.ExecuteReader())
{
if (reader.Read()) // Don't assume we have any rows.
{
if (ColumnNameForReturn == OTHER.Configuration.ColumnNameTableOnline.Idvk)
{
ord = reader.GetOrdinal("idvk"); result = reader.GetInt32(ord).ToString();
}
if (ColumnNameForReturn == OTHER.Configuration.ColumnNameTableOnline.Lastmsg)
{
ord = reader.GetOrdinal("lastmsg"); result = reader.GetString(ord);
}
return(result);
}
return(null);
}
}
}
public string[] LoadIdOnline(OTHER.Configuration.ColumnNameTableOnline ColumnNameForReturn)
{
DataSet ds = new DataSet();
string sql = "SELECT " + ColumnNameForReturn + " FROM online";
try
{
using (SQLiteConnection conn = new SQLiteConnection(string.Format("Data Source={0};", Directory.GetCurrentDirectory() + OTHER.Configuration.databaseName)))
{
using (SQLiteDataAdapter da = new SQLiteDataAdapter(sql, conn))
{
da.Fill(ds);
string [] load = ds.Tables[0].Rows.OfType <DataRow>().Select(k => k[0].ToString()).ToArray();
return(load);
// string[] arrray = ds.Rows.OfType<DataRow>().Select(k => k[0].ToString()).ToArray();
// return new string[] { ds.Tables[0].DefaultView };
}
}
}
catch (Exception err)
{
return(null);
}
}
public bool CheckIsOnline(IGetInfo getUserData, OTHER.Configuration.ColumnNameTableOnline ColumnNameForReturn, string id, OTHER.Configuration.ColumnNameTableOnline ColumnNameForFind)
{
return(getUserData.CheckIsOnline(ColumnNameForReturn, id, ColumnNameForFind));
}
