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)); }