public string SelectLogin()
{
string username = SingleTon.GetUser();
//string query = "SELECT * FROM bankusers";
string query = "SELECT username, password FROM bankusers WHERE bankusers.username = '******'";
//List<string>[] list = new List<string>[2];
//list[0] = new List<string>();
//list[1] = new List<string>();
string username1;
string password;
if (this.OpenConnection())
{
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
username1 = Convert.ToString(dataReader["username"] + "");
password = Convert.ToString(dataReader["password"] + "");
//list[0].Add(dataReader["username"] + "");
//list[1].Add(dataReader["password"] + "");
}
dataReader.Close();
this.CloseConnection();
return(username1, password);
}
else
{
return(username1, password);
}
}
public List <string>[] account()
{
accounts = SingleTon.GetID();
List <string>[] list = new List <string> [10];
for (int i = 0; i <= accounts + 1; i++)
{
list[i] = new List <string>();
}
string username = SingleTon.GetUser();
string query = "SELECT username, password FROM bankusers WHERE bankusers.username = '******'";
if (this.OpenConnection())
{
MySqlCommand cmd = new MySqlCommand(query, connection);
/*for (int i = 0; i <= accounts + 1; i++)
* {
* MySqlDataReader dataReader = cmd.ExecuteReader();
* while (dataReader.Read())
* {
* list[i].Add(dataReader["balance" + i] + "");//rediger for at få det rigtige beløb ud når vi trækker balance for lige nu tager den det nummer på rækken og sender ud istedetfor det tal der står på den plads
* }
* dataReader.Close();
* }*/
this.CloseConnection();
return(list);
}
else
{
return(list);
}
}
