/// <summary>
/// list top 1 user => used for Shamia connect
/// </summary>
/// <returns></returns>
public List <TemplateUserDataBase> EnumUserDataBase()
{
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed)
{
Connection.Close();
}
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
List <TemplateUserDataBase> t = new List <TemplateUserDataBase>();
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = @"SELECT *FROM users TOP1";
DataReader = C.ExecuteReader();
while (DataReader.Read())
{
TemplateUserDataBase temp = new TemplateUserDataBase()
{
Nick = DataReader["nick"].ToString(),
Password = DataReader["password"].ToString(),
Auth = DataReader["auth"].ToString(),
Owner = DataReader["owner"].ToString(),
Port = Convert.ToInt32(DataReader["port"].ToString())
};
t.Add(temp);
}
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.ToString());
}
finally
{
if (Connection.State != ConnectionState.Closed)
{
Connection.Close();
}
}
return(t);
}
/// <summary>
/// list top 1 user => used for Shamia connect
/// </summary>
/// <returns></returns>
public List<TemplateUserDataBase> EnumUserDataBase()
{
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
List<TemplateUserDataBase> t = new List<TemplateUserDataBase>();
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = @"SELECT *FROM users TOP1";
DataReader = C.ExecuteReader();
while (DataReader.Read())
{
TemplateUserDataBase temp = new TemplateUserDataBase()
{
Nick = DataReader["nick"].ToString(),
Password = DataReader["password"].ToString(),
Auth = DataReader["auth"].ToString(),
Owner = DataReader["owner"].ToString(),
Port = Convert.ToInt32(DataReader["port"].ToString())
};
t.Add(temp);
}
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.ToString());
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
return t;
}