/// <summary> /// Intoarce istoricul comenzilor pentru utilizatorul cu id-ul id_user /// </summary> public static IstoricComenzi getIstoric(int user) { IstoricComenzi istoric = new IstoricComenzi(user); SqlConnection istoric_user_connection = new SqlConnection(connection_string_); istoric_user_connection.Open(); SqlCommand istoric_user_command = new SqlCommand( @"select id_comanda, data, valoare from comenzi where id_user = @user", istoric_user_connection); istoric_user_command.Parameters.Add(new SqlParameter("@user", user)); SqlDataReader istoric_user_reader = istoric_user_command.ExecuteReader(); while (istoric_user_reader.Read()) { int id_comanda = istoric_user_reader.GetInt32(0); Comanda comanda = getComanda(id_comanda); comanda.IdUser = user; comanda.Pret = istoric_user_reader.GetDouble(2); comanda.Data = istoric_user_reader.GetDateTime(1); istoric.addComanda(comanda); } istoric_user_reader.Close(); istoric_user_connection.Close(); return istoric; }
public void addComanda(Comanda comanda) { lista_comenzi_.Add(comanda); }