public NormalQueue getNormalQueue(int id)
{
NormalQueue client = null;
try
{
SqlDataReader userData = runOperation("select * from [NormalQueue] where id=" + id);
userData.Read();
string s = userData.GetString(2);
client = new NormalQueue((int)userData[0], (int)userData[1], (int)userData[2], (double)userData[3], (double)userData[4]);
//client = new User((int)userData[0], userData[1].ToString(), userData[2].ToString(), userData[3].ToString(), userData[4].ToString());
}
catch (Exception e)
{
Console.Write(e.ToString());
}
finally
{
if (con.getSQLConnection().State == System.Data.ConnectionState.Open)
{
con.getSQLConnection().Close();
}
}
return(client);
}
public bool updateDatabase(NormalQueue u)
{
try
{
SqlDataReader userData = runOperation(queueUpdateString(u));
userData.Read();
}
catch (Exception e)
{
Console.Write(e.ToString());
return(false);
}
finally
{
if (con.getSQLConnection().State == System.Data.ConnectionState.Open)
{
con.getSQLConnection().Close();
}
}
return(true);
}
