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